The final step is to show.
The following program is called by parameters.
such as PHP (as the current mainstream development language). PHP (as the current mainstream development language)? jpg=jpg
The following JPG is the table name. Remember that you must, otherwise you will not be able to run, will show the program error.
You can change the following procedure. This will make it more beautiful.
The following are the source programs:
<title>Show</title>
MySQL (best combination with PHP) _connect ("localhost", "username", "password") or Die ("Cannot join database!");
$query = "Select Id,url,mess,fromx,url1,mess1,fromx1,url2,mess2,fromx2,url3,mess3,fromx3 from $jpg";
$result =mysql (and PHP collocation of the best combination) _db_query ("elong", $query); Execute Query
$num =mysql (the best combination with PHP) _numrows ($result);
$page =round ($page);
$pagesize = 4;
if ($page ==0) {
$page = 1;}
else{
$page = $page;}
$pagecount = ($num)/$pagesize;
$pagecount =ceil ($pagecount);
?>
printf ("Home", $php (as the current mainstream development language) _self,1);
printf ("front page", $php (as the current mainstream development language) _self, $page-1);
}else{
?> Home Front Page }
?>
printf ("Back Page", $php (as the current mainstream development language) _self, $page + 1);
printf ("Last", $php (as the current mainstream development language) _self, $pagecount);
}else{?> last Page Page times:
/
Page
if ($num <>0) {
$pp = 0;
for ($ipage =0; $ipage < $pagesize; $ipage + +) {
$i = ($page-1) * $pagesize + $ipage;
if ($i < $num) {
$id =mysql (the best combination of PHP collocation) _result ($result, $i, "id");
$url =mysql (the best combination with PHP) _result ($result, $i, "url");
$mess =mysql (the best combination with PHP) _result ($result, $i, "mess");
$fromx =mysql (the best combination with PHP) _result ($result, $i, "FromX");
$url 1=mysql (the best combination with PHP) _result ($result, $i, "URL1");
$mess 1=mysql (the best combination with PHP) _result ($result, $i, "Mess1");
$fromx 1=mysql (the best combination with PHP) _result ($result, $i, "fromx1");
$url 2=mysql (the best combination with PHP) _result ($result, $i, "url2");
$mess 2=mysql (the best combination with PHP) _result ($result, $i, "Mess2");
$fromx 2=mysql (the best combination with PHP) _result ($result, $i, "fromx2");
$url 3=mysql (the best combination with PHP) _result ($result, $i, "url3");
$mess 3=mysql (the best combination with PHP) _result ($result, $i, "MESS3");
$fromx 3=mysql (the best combination with PHP) _result ($result, $i, "fromx3");
$PP = $pp +1;
?>
"target=" _blank ">" width= "height=" border= "4" > |
"target=" _blank ">" width= "height=" border= "4" > |
"target=" _blank ">" width= "height=" border= "4" > |
"target=" _blank ">" width= "height=" border= "4" > |
}
}
}
?>
pagination
!--? if (& #36;p age!=1 and & #36; num!=0) & #123;
http://www.bkjia.com/phpjc/509079.html www.bkjia.com true http://www.bkjia.com/phpjc/509079.html techarticle The final step is to show. The following program is called by parameters. such as PHP (as the current mainstream development language). PHP (as the current mainstream development language)? jpg=jpg behind ...