I gave a page to display the MySQL record class, but did not give an example of the use, now, I have just written an online auction system framework program to illustrate the use of this class, but also on the online auction implementation method with everyone to discuss.
First of all, I am not a master, is not a connoisseur, just a fans, so this program must have a lot of loopholes, but I dare to take out, because I very much hope to be free to share with you the joy of PHP to us. (actually want to add more points to get a support for MySQL space ^_^)
I think the auction system and the general supply and demand information distribution system, the biggest difference there are two points, one is the bidder to open the new price to be reflected in the price of goods in a timely manner, another point is the time limit, after the end of the bidding, will stop bidding. And give the final bidder.
I have not thought of the other, some experts to introduce it.
So, I want to put a supply and demand information release system into a bidding system should be not difficult to do it.
Let's start with the new Tviewpage class and database structure.
<?php
/*********************************************
Tviewpage v 1.2
Classes that display MySQL database records in pagination
Author: sharetop
E-mail:ycshowtop@21cn.com
Date: 2000-8-31
[2000-9-6] 1.2
Fixed a bug in ReadList () that would verify that offset was placed in the class.
Added Add () Delete () modify () three basic operation functions.
This class does not provide the ability to connect to a database, so you need to open the appropriate database externally.
This class also does not provide the ability to display records, just paging through the records into the result of the two-dimensional array.
You need to customize the data display format externally.
***********************************************/
Class Tviewpage {
var $Table; Table name
var $MaxLine; Number of rows displayed per page
var $Offset; Record offset
var $Total; Total Records
var $Number; Number of records read on this page
var $Result; The results read out
var $TPages; Total pages
var $CPages; Current page
var $Condition; Display conditions such as: where id= ' $id ' ORDER by id DESC
var $PageQuery; Pagination shows the parameters to pass
Constructor *************
Parameters: Table name, maximum number of rows, offset
function Tviewpage ($TB, $ML) {
Global $offset;
$this->table= $TB;
$this->maxline= $ML;
if (Isset ($offset)) $this->offset= $offset;
else $this->offset=0;
$this->condition= "";
}
Set Display Criteria *********
Example: where id= ' $id ' ORDER by id DESC
The requirement is a string that conforms to the SQL syntax (this string will be added after the SQL statement)
function Setcondition ($s) {
$this->condition= $s;
}
Set the pass parameter ************
Key parameter name value of the value parameter
such as: Setpagequery ("id", $id), if you have more than one parameter to pass, you can call this function multiple times.
function Setpagequery ($key, $value) {
$tmp [key]= $key; $tmp [value]= $value;
$this->pagequery[]= $tmp;
}
Reading Records ***************
The main work function that reads the corresponding records from the table according to the given conditions
The return value is a two-dimensional array, result[the record number [field name]
function ReadList () {
$SQL = "Select Count (*) as total from". $this->table. " ". $this->condition;
$result =mysql_query ($SQL) or Die (Mysql_error ());
$row =mysql_fetch_array ($result);
$this->total= $row [total];
if ($this->total>0) {//Condition by condition
$SQL = "SELECT * from". $this->table. " ". $this->condition.
"LIMIT". $this->offset. ",". $this->maxline;
$result =mysql_query ($SQL) or Die (Mysql_error ());
$this->number=mysql_num_rows ($result);
$i = 0;
while ($row =mysql_fetch_array ($result)) {
$this->result[$i]= $row;
$i + +;
}
}
return $this->result;
}
Add a new record **********
$str for added values such as "' $id ', ' $name ', ' $class '" etc.
function Add ($STR) {
$SQL = "INSERT into". $this->table. " VALUES (". $str.") ";
mysql_query ($SQL) or Die (Mysql_error ());
}
Deleting Records **********
First call Setcondition () to determine the condition.
function Delete () {
$SQL = "DELETE from". $this->table. " ". $this->condition;
mysql_query ($SQL) or Die (Mysql_error ());
}
Modify Record ************
$field Field name $value new value
To modify multiple fields you can repeat the function.
function Modify ($field, $value) {
$SQL = "UPDATE from". $this->table. " SET ". $field." = ". $value." ". $this->condition;
mysql_query ($SQL) or Die (Mysql_error ());
}
Show Pages *************
Show current page and total pages
Function thepage () {
$this->tpages=ceil ($this->total/$this->maxline);
$this->cpages= $this->offset/$this->maxline+1;
echo "First". $this->cpages. " Page/Total ". $this->tpages." Page ";
}
Show page Flip Button *************
This function is to be called after the thepage () Function!!!
Display the first page, next page, previous pages, and no pages, plus the parameters to pass
function Page () {
$first = 0;
$next = $this->offset+ $this->maxline;
$prev = $this->offset-$this->maxline;
$last = ($this->tpages-1) * $this->maxline;
$k =count ($this->pagequery);
$strQuery = ""; Generate a string to pass the parameter number
for ($i =0; $i $k; $i + +) {
$strQuery. = "&". $this->pagequery[$i][key]. " = ". $this->pagequery[$i][value];
}
if ($this->offset>= $this->maxline)
echo "<a Href= $PHP _self?offset=". $first. $strQuery. " > Home </a>| ";
if ($prev >=0)
echo "<a Href= $PHP _self?offset=". $prev. $strQuery. " > previous page </a>| ";
if ($next $this->total)
echo "<a Href= $PHP _self?offset=". $next. $strQuery. " > next page </a>| ";
if ($this->tpages!=0 && $this->cpages< $this->tpages)
echo "<a Href= $PHP _self?offset=". $last. $strQuery. " > Last </a> ";
}
End Class
}
?>
//************************
Ebid.sql file (I exported it with phpMyAdmin)
# phpMyAdmin Mysql-dump
# http://www.htmlwizard.net/phpMyAdmin/
#
# Host:localhost Database:ebid
# --------------------------------------------------------
# Table structure for table ' reply '
# ID, item ID, bidder, bidder's email, bid.
CREATE TABLE Reply (
ID varchar (+) is not NULL,
ParentID varchar (+) not NULL,
Buyer varchar () not NULL,
Email varchar (+) not NULL,
Price Float (10,2) The DEFAULT ' 0.00 ' not NULL,
PRIMARY KEY (ID, price)
);
# --------------------------------------------------------
# Table structure for table ' shop '
# ID, product name, Introduction, original price, markup unit, end time, bid number, current price, whether there is a photo
CREATE TABLE Shop (
ID varchar (+) is not NULL,
Name varchar (not NULL),
Description text,
Price Float (10,2) The DEFAULT ' 0.00 ' not NULL,
Unit tinyint (2) unsigned not NULL,
Endtime varchar (+) DEFAULT ' 0000-00-00 00:00 ' not NULL,
Reply INT (4) unsigned not NULL,
Curprice float (10,2) DEFAULT ' 0.00 ' not NULL,
Photo tinyint (1) unsigned not NULL,
PRIMARY KEY (ID),
KEY kreply (Reply)
);
The configuration file is as follows:
//**************
config.inc.php
<?php
$HOST = "localhost"; Host Name
$DATABASE = "ebid"; Database name
$WARE _table= "Shop"; Product List
$BID _table= "Reply"; Response Form
$USER = "root"; User
$PASSWD = "9999"; Password
$PAGE _max_line=20; Number of rows displayed per page
Open Database
$LinkID =mysql_connect ($HOST, $USER, $PASSWD);
mysql_select_db ($DATABASE, $LinkID) or Die (Mysql_error ());
?>
Here are the functions for displaying goods and TOP10 goods
//*****************
//
<?php
Include "config.inc.php";
Include "tview.class.php"; class file
Show Product List ********
function Printlist () {
Global $view;
$ct =time ();
Set conditions for the sentence! To satisfy the SQL syntax Oh. Show only items that have not finished bidding
$view->setcondition ("Where endtime> ' $ct ' ORDER by id DESC");
Call member functions to read records
The result $result[record number [field name] is a two-dimensional array.
$result = $view->readlist ();
if ($view->number==0) {echo "<tr><td colspan=4> </td></tr>"; return;}
for ($i =0; $i $view->number; $i +) {
if (Ceil ($i/2) *2== $i) $BGC = "#ffffff";
else $BGC = "#f3f3f3";
echo "<tr bgcolor= $BGC ><td width=60% >";
echo "<a Href=" Javascript:showdetail (' detail.php?id= '. $result [$i][id]. "')" > ". $result [$i][name]." </a> ";
echo "</TD><TD width=15% >";
echo Date ("Y-m-j 24:00:00", $result [$i][endtime]);
echo "</TD><TD width=15% Align=right>￥";
echo $result [$i][curprice];
echo "</TD><TD width=10% align=right>";
echo $result [$i][reply];
echo "</td></tr>";
}
}
Show the hottest 10 records **********
function Listtophot () {
Global $view;
Also set the conditions first
$view->setcondition ("Order by reply Desc");
Read the Record
$result = $view->readlist ();
$k = (count ($result) >10)? ' Ten ':(Count ($result));
for ($i =0; $i $k; $i + +) {
echo "<tr><td>";
echo "<a Href=" Javascript:showdetail (' detail.php?id= '. $result [$i][id]. "')" > ". $result [$i][name]." </a> ";
echo "</td></tr>";
}
}
Show the latest 10 records ***********
function Listtopnew () {
Global $view;
$view->setcondition ("ORDER by id DESC");
$result = $view->readlist ();
$k = (count ($result) >10)? ' Ten ':(Count ($result));
for ($i =0; $i $k; $i + +) {
echo "<tr><td>";
echo "<a Href=" Javascript:showdetail (' detail.php?id= '. $result [$i][id]. "')" > ". $result [$i][name]." </a> ";
echo "</td></tr>";
}
}
//********** <结束函数定义，主程序体*************
The End function definition, the main program body *************
//Constructs this viewpage class, gives the commodity table and shows the number of rows per page
$view =new tviewpage ($WARE _table, $PAGE _max_ line);
?>
Given a JS function, it is simple to open a new window:
Function ShowDetail (str) {
WINDOW.O Pen (str, "Newwin", "top=20,left=20,width=600,height=400,
Location=no,toolbar=no,status=no,resizable=no, Scrollbars=yes ");
}
http://www.bkjia.com/phpjc/3 14261.html www.bkjia.com true http://www.bkjia.com/phpjc/314261.html techarticle front I gave a pagination display of MySQL record classes, But I did not give an example of the use, now, I have just written an online auction system framework program to illustrate the use of this class ...
