PHP mysql資料庫操作執行個體學習

1，擷取表資料01 mysql_connect("localhost","dev","mysql"); mysql_select_db("dev"); $result=mysql_query("select id,name from tb_test"); while($row=mysql_fetch_array($result,MYSQL_ASSOC)){ print_r($row);echo " \n"; } ?> 複製代碼 輸出結果: 2，擷取表資料02 mysql_connect("localhost","dev","mysql"); mysql_select_db("dev"); $result=mysql_query("select id,name from tb_test"); while($row=mysql_fetch_object($result)){ echo "ID:" .$row->id." text: ".$row->name." \n"; } ?> 複製代碼 輸出結果： 3，擷取表資料03 mysql_connect("localhost","dev","mysql"); mysql_select_db("dev"); $result=mysql_query("select id,name from tb_test"); print " print " print " print " print " } "; "; "; while ($row = mysql_fetch_array($result)) { print " "; "; "; print " 編碼 名字 {$row["id"]} {$row["name"]} "; ?> 複製代碼 輸出結果： 4，擷取資料分頁04 $page=isset($_GET['page'])?intval($_GET['page']):1; $num=3; //每頁顯示3條資料 $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; //擷取limit的第一個參數的值，假如第一頁則為(1-1)*10=0,第二頁為(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 " "; "; "; "; print " 編碼 名字 {$row["id"]} {$row["name"]} "; For($i=1;$i<=$pagenum;$i++){ $show=($i!=$page)?"$i":"$i"; Echo $show." "; } ?> 複製代碼 輸出結果：

