Home > Backend Development > PHP Tutorial > PHP generate table example code_PHP tutorial

PHP generate table example code_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-13 17:41:05
Original
1634 people have browsed it

The following code PHP generates a form example, which is posted after being tested by the Programming Home of this site and running normally.

  1. $link=mysql_connect("localhost","root","123456");
  2. $ db=mysql_select_db("bustest",$link);
  3. $sql1="select name from info group by name order by id asc";
  4. print("
  5. $res1=mysql_query($sql1);
  6. while($row1=mysql_fetch_array($res1)){
  7. $name=$row1[" name"];
  8. $sql2="select id from info where name =$name order by id asc";
  9. $res2=mysql_query($sql2);
  10. while($row2=mysql_fetch_array($res2)){
  11. print("
  12. ");
  13. $id=$row2["id"];
  14. print("
  15. ");
  16. $sql3="select count(*),id from info where name =$name group by name order by id asc";
  17. $res3=mysql_query($sql3);
  18. while($row3=mysql_fetch_array($res3)){
  19. $id1=$row3["id"];
  20. if($id1==$id){
  21. $num=$row3[0];
  22. print("
  23. ");
  24. }
  25. print("
  26. $id " );
  27.                                                                                                                                              print("");
  28. }
  29. }
  30. }
  31. print("
  32. ");
  33. mysql_close($link);
  34. ?>
  35. http://www.bkjia.com/PHPjc/486157.html
  36. www.bkjia.com
true
http: //www.bkjia.com/PHPjc/486157.html

TechArticle

Statement of this Website
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
Latest Issues
php data acquisition?
From 1970-01-01 08:00:00
0
0
0
PHP extension intl
From 1970-01-01 08:00:00
0
0
0
How to learn php well
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template