Workshop Forum -------------------------- data table createtableguest (idintnotnullauto_increment, Prima (the most complete virtual host Management System) rykey (id), titlevarchar (50), emailvar Workshop Forum workshop --------------------------
Data table
Create table guest (id int not null auto_increment, Prima (the most complete VM Management System) ry key (id), title varchar (50), email varchar (30 ), homepage varchar (30), name varchar (30), text, relay int, r_time date)
Create table relay (id int not null auto_increment, Prima (the most complete VM Management System) ry key (id), title int, email varchar (30 ), name varchar (30), text)
----------------------- Index. php (as the current mainstream development language )--------------------------
Website full manual
$ Db = MySQL (the best combination with PHP) _ connect ("localhost ","****","****");
MySQL (the best combination with PHP) _ select_db ("*****", $ db );
@ $ Result = MySQL (the best combination with PHP) _ query ("SELECT * FROM guest order by id desc", $ db );
$ I = 0;
While ($ myrow = MySQL (the best combination with PHP) _ fetch_row ($ result )){
$ Guestbook [$ I] [0] = $ myrow [0];
$ Guestbook [$ I] [1] = $ myrow [1];
$ Guestbook [$ I] [2] = $ myrow [2];
$ Guestbook [$ I] [3] = $ myrow [4];
$ Guestbook [$ I] [4] = $ myrow [6];
$ Guestbook [$ I] [5] = $ myrow [7];
$ I ++;
} // Read the array
MySQL (the best combination with PHP) _ close ($ db );
Echo [";
If ($ q! = ""){
$ Page = $ q;
} Else {
$ Page = 0;
}
$ I = count ($ guestbook );
$ Msgnum = 20; // 20 pens per page
$ Start = $ page * $ msgnum;
$ End = $ start + $ msgnum;
If ($ end> $ I) $ end = $ I;
$ Totalpage = $ I/$ msgnum;
For ($ I = 0; $ I <$ totalpage; $ I ++ ){
If ($ I! = $ Page ){
Echo "(as the mainstream development language )? Q = $ I> $ I ";
} Else {
Echo "$ I ";
}
}
Echo "] page -----------------------------
"; Printf ("(As the current mainstream development language)> add topic
");
Echo"
";
Echo"
";Echo"
"; Echo"
| Topic | ";Echo"
Email | ";Echo"
Name | ";Echo"
Reply | ";