PHP Classes

File: example.php

Recommend this page to a friend!
  Classes of Julien PACHET  >  MySQL Abstract  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: How to use the class
Class: MySQL Abstract
MySQL access wrapper to simplify queries
Author: By
Last change:
Date: 17 years ago
Size: 1,085 bytes
 

Contents

Class file image Download
<?
 
require("class_mysql.inc.php");
 
 
// opening connection
 
$mysql=new mysql("test","localhost","test","password_for_test");
 
 
// creating table
 
$sql="CREATE TABLE `table_test` (
`id` BIGINT NOT NULL ,
`field1` VARCHAR( 50 ) NOT NULL ,
`field2` VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( `id` )
);"
;
 
$mysql->query($sql);
 
 
// inserting some datas
 
for ($i=0;$i<5;$i++) {
   
$mysql->insert("table_test",array('id','field1','field2'),array("data ".$i,"other data ".$i));
   
 
// display content of table
 
print_r($mysql->query("SELECT * FROM table_test ORDER BY field1"));
 
 
// an update to the table, for id=3
 
$mysql->update("table_test",array('field1','field2'),array('aaa','bbb'),"id=3");
 
 
// display a field for id=4, if SELECT return no line, "none" return
 
echo $mysql->select_value("SELECT field2 FROM table_test WHERE (id=4)","none");
 
 
// delete a line, for id=2
 
$mysql->delete("table_test","id=2");
 
 
// display content of table
 
print_r($mysql->query("SELECT * FROM table_test ORDER BY field1"));
 
?>

For more information send a message to info at phpclasses dot org.