PHP mysql database operation example learning-PHP Tutorial-php.cn

PHP mysql database operation example learning

WBOY

Release： 2016-07-25 09:13:13

Original

1128 people have browsed it

1, get table data 01

Copy code

Output result: PHP mysql database operation example learning

2, get table data 02

Copy the code

output result: PHP mysql database operation example learning

3, Get table data 03

Copy the code

output result: PHP mysql database operation example learning 4. Get data paging 04

$page=isset($_GET['page'])?intval($_GET['page']):1;
$num=3; //Display 3 per page Piece of data
$db=mysql_connect("localhost","dev","mysql");
$select=mysql_select_db("dev",$db);
$total=mysql_num_rows(mysql_query("select id,name from tb_test "));
$pagenum=ceil($total/$num);
If($page>$pagenum || $page == 0){
Echo "Error : Can Not Found The page .";
Exit;
}
$offset=($page-1)*$num; //Get the value of the first parameter of limit. If the first page is (1-1)*10=0, the second page is (2 -1)*10=10.
$info=mysql_query("select id,name from tb_test limit $offset,$num");
print "";
print "
";
print "
";
While($row=mysql_fetch_array($info)){
print "
" ;
print "
";
print "
";
print "
";
}//Display data
print "
Encoding Name
{$row["id"]} {$row["name"]}

";
For($i=1;$i $show=($i!=$page)?"$i":"";
Echo $show." ";