Login   Register  
PHP Classes
elePHPant
Icontem

File: testdb.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of ZAY  >  MySQL API  >  testdb.php  >  Download  
File: testdb.php
Role: Example script
Content type: text/plain
Description: Test file for API
Class: MySQL API
MySQL database access wrapper
Author: By
Last change: Clearing some testing code that no longer be used
Date: 2010-05-23 11:04
Size: 1,424 bytes
 

Contents

Class file image Download
<?php
  include_once("./api/Database.php");

  $connection = Database::dbConnection
      (
        "127.0.0.1",
        "username",
        "password",
        "schema_name"
      );
  
  $table = "user_ip_addr";
  
  $columnList =
      array(
        array('column'=>"ip_addr"),
        array('name'=>"new", 'column'=>'ip_addr', 'calc'=>"MAX")
      );
  
  $conditionList =
      array(
        array('column'=>"id", 'operator'=>" > ", 'value'=>"999", 'linking'=>""), 
        array('value'=>"1", 'linking'=>"AND")
      );
      
  $groupList = array('ip_addr');
  
  $orderList = array('ip_addr');
  
  $limit =
    array(
      array('min'=>"1", 'max'=>"100")
    );

  Database::selectData($connection, $table, $columnList, $conditionList, $groupList, $orderList, $limit);
  
  $columnList = null;
  
  $dataList =
      array(
        "null", "192.168.0.1", "0"
      );

  Database::insertData($connection, $table, $columnList, $dataList);

  $id = Database::mysql_insert_id($connection);
  
  $columnList = array("status");
  
  $dataList = array("1");
  
  $conditionList =
    array(
      array('column'=>"id", 'operator'=>"=", 'value'=>$id, 'linking'=>"")
    );

  Database::updateData($connection, $table, $columnList, $dataList, $conditionList, $limit);
  
  $limit = "1";

  Database::deleteData($connection, $table, $conditionList, $limit);
?>