search

Home >Backend Development >PHP Tutorial >PHP mysql database operation example learning

PHP mysql database operation example learning

WBOY
WBOYOriginal
2016-07-25 09:13:131151browse

1, get table data 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. ?>
Copy code

Output result: PHP mysql database operation example learning

2, get table data 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. ?>
Copy the code

output result: PHP mysql database operation example learning

3, Get table data 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. ";
  8. print "
    9. ";
  10. while ($row = mysql_fetch_array($result))
  11. {
  12. print "
    13. ";
  13. print "
    14. ";
  14. print "
    15. ";
  15. }
  16. print "
    17. encoding Name
    {$row[" id"]} {$row["name"]}
    ";
  17. ?>
Copy the code

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

  2. $page=isset($_GET['page'])?intval($_GET['page']):1;
  3. $num=3; //Display 3 per page Piece of data
  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; //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.
  13. $info=mysql_query("select id,name from tb_test limit $offset,$num");
  14. print "";
  15. print "
    16. ";
  16. print "
    17. ";
  17. While($row=mysql_fetch_array($info)){
  18. print "
    19. " ;
  19. print "
    20. ";
  20. print "
    21. ";
  21. print "
    22. ";
  22. }//Display data
  23. print "
    24. Encoding Name
    {$row["id"]} {$row["name"]}
    ";
  24. For($i=1;$i $show=($i!=$page)?"$i":"";
  25. Echo $show." ";
  26. }
  27. ?>
    28.
Copy the code

output result: PHP mysql database operation example learning



Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to remove newlines when reading files line by line in PHPNext article：How to remove newlines when reading files line by line in PHP

Related articles

See more