<?php
#####################################################################
# File Name : demo.php
# Author : Henry Chen
# Last Modify : May 08,2003 (GMT+8)
# License : GPL
# Contact Info
# E-Mail : henryi@wowphp.net
# ICQ : 55490755
# AIM : wowphp
# YIM : henryi_chen@yahoo.com
#####################################################################
# This script include two parts
# 1. Create Table
# 2. Class demo
#####################################################################
# Variables
$tb_name = "demo";
include("setting.inc.php");
$sql = new mod_db();
# Create Table
$string = "CREATE TABLE IF NOT EXISTS `$tb_name`(";
$string .= "`student_id` INT( 8 ) NOT NULL AUTO_INCREMENT,";
$string .= "`student_name` VARCHAR( 8 ) NOT NULL ,";
$string .= "`student_score` INT( 3 ) NOT NULL ,";
$string .= "PRIMARY KEY ( `student_id` ) ";
$string .= ");";
$sql->query("$string");
# Insert data to table
# function insert($tb_name,$cols,$val,$astriction)
# Data 1
$ins_string = "'','Henry','99'";
$sql->insert("$tb_name","","$ins_string","");
# Data 2
$ins_string = "'','Frank','50'";
$sql->insert("$tb_name","","$ins_string","");
# Data 3
$ins_string = "'','Derek','80'";
$sql->insert("$tb_name","","$ins_string","");
# Data Count
# function nums($string="",$qid="")
# function query($string)
// Method 1 : String
$numb1 = $sql->nums("select * from $tb_name");
echo "Count : String<br>------------------------------------------<br>";
echo "Method 1 = ".$numb1."<br><br><br>";
// Method 2 :
$numb_query = $sql->query("select * from $tb_name");
$numb2 = $sql->nums('',$numb_query);
echo "Count : Query + Num<br>------------------------------------------<br>";
echo "Method 2 = ".$numb2."<br><br><br>";
# Get data detail information
# function nums($string="",$qid="")
# function objects($string="",$qid="")
// Method 1 : String
$obj1 = $sql->objects("select * from $tb_name where student_name='Henry'");
echo "Get data : String<br>------------------------------------------<br>";
echo "Student ID = ".$obj1->student_id."<br>";
echo "Student Name = ".$obj1->student_name."<br>";
echo "Student Scroe = ".$obj1->student_score."<br><br><br>";
// Method 2
$obj_query = $sql->query("select * from $tb_name where student_name='Henry'");
$obj2 = $sql->objects('',$obj_query);
echo "Get data : Query + Object<br>------------------------------------------<br>";
echo "Student ID = ".$obj2->student_id."<br>";
echo "Student Name = ".$obj2->student_name."<br>";
echo "Student Scroe = ".$obj2->student_score."<br><br><br>";
// Method 3 : Loop
$obj_query = $sql->query("select * from $tb_name");
echo "Get data : Loop<br>------------------------------------------<br>";
while($obj3 = $sql->objects('',$obj_query)){
echo "Student ID = ".$obj3->student_id." ";
echo "Student Name = ".$obj3->student_name." ";
echo "Student Scroe = ".$obj3->student_score."<br>";
}
echo "<br><br><br>";
# Update data
# function update($tb_name,$string,$astriction)
// Data before update
$bu = $sql->objects("select * from $tb_name where student_name='Frank'");
echo "Data before update<br>------------------------------------------<br>";
echo "Student ID = ".$bu->student_id." ";
echo "Student name = ".$bu->student_name." ";
echo "Student score = ".$bu->student_score."<br><br><br>";
// Update data
$update_str = "student_score='70'";
$sql->update("$tb_name","$update_str","student_name='Frank'");
// Data after update
$au = $sql->objects("select * from $tb_name where student_name='Frank'");
echo "Data after update<br>------------------------------------------<br>";
echo "Student ID = ".$au->student_id." ";
echo "Student name = ".$au->student_name." ";
echo "Student score = ".$au->student_score."<br><br><br>";
# Delete data
# function del($tb_name,$astriction)
// Data before delete
$bd_query = $sql->query("select * from $tb_name");
echo "Data before delete<br>------------------------------------------<br>";
while($bd = $sql->objects('',$bd_query)){
echo "Student ID = ".$bd->student_id." ";
echo "Student Name = ".$bd->student_name." ";
echo "Student Scroe = ".$bd->student_score."<br>";
}
echo "<br><br><br>";
// Delete Data
$sql->del("$tb_name","student_name='Frank'");
// Data after delete
$ad_query = $sql->query("select * from $tb_name");
echo "Data after delete<br>------------------------------------------<br>";
while($ad = $sql->objects('',$ad_query)){
echo "Student ID = ".$ad->student_id." ";
echo "Student Name = ".$ad->student_name." ";
echo "Student Scroe = ".$ad->student_score."<br><br><br>";
}
echo "<br><br><br>";
# Page cute
// Query
$list_string = "select * from $tb_name";
$list_query = $sql->query($sql->page_cut($list_string,$nowpage));
// Count
$list_num = $sql->nums("$list_string");
// Show pagecut
echo($sql->show_page_cut('',$list_num,"num=$num"));
?>
|