PHP mysql数据库操作实例学习

1，获取表数据01

2. mysql_connect("localhost","dev","mysql");
3. mysql_select_db("dev");
4. $result=mysql_query("select id,name from tb_test");
5. while($row=mysql_fetch_array($result,MYSQL_ASSOC)){
6. print_r($row);echo "
   \n";
7. }
8. ?>

复制代码

输出结果:

2，获取表数据02

2. mysql_connect("localhost","dev","mysql");
3. mysql_select_db("dev");
4. $result=mysql_query("select id,name from tb_test");
5. while($row=mysql_fetch_object($result)){
6. echo "ID:" .$row->id." text: ".$row->name."
   \n";
7. }
8. ?>

复制代码

输出结果：

3，获取表数据03

2. mysql_connect("localhost","dev","mysql");
3. mysql_select_db("dev");
5. $result=mysql_query("select id,name from tb_test");
6. print "";
7. print "
";
8. print "
";
10. while ($row = mysql_fetch_array($result))
11. {
12. print "
";
13. print "
";
14. print "
";
15. }
16. print "

编码	名字
{$row["id"]}	{$row["name"]}

";
17. ?>

复制代码

输出结果： 4，获取数据分页04

2. $page=isset($_GET['page'])?intval($_GET['page']):1;
3. $num=3; //每页显示3条数据
4. $db=mysql_connect("localhost","dev","mysql");
5. $select=mysql_select_db("dev",$db);
6. $total=mysql_num_rows(mysql_query("select id,name from tb_test"));
7. $pagenum=ceil($total/$num);
8. If($page>$pagenum || $page == 0){
9. Echo "Error : Can Not Found The page .";
10. Exit;
11. }
12. $offset=($page-1)*$num; //获取limit的第一个参数的值，假如第一页则为(1-1)*10=0,第二页为(2-1)*10=10。
13. $info=mysql_query("select id,name from tb_test limit $offset,$num");
14. print "";
15. print "
";
16. print "
";
17. While($row=mysql_fetch_array($info)){
18. print "
";
19. print "
";
20. print "
";
21. print "
";
22. }//显示数据
23. print "

编码	名字
{$row["id"]}	{$row["name"]}

";
24. For($i=1;$i $show=($i!=$page)?"$i":"$i";
25. Echo $show." ";
26. }
27. ?>

复制代码

输出结果：