欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

PHP生成表格实例代码_PHP教程

程序员文章站 2022-05-05 08:01:21
...
下面代码PHP生成表格实例,经过本站编程之家测试正常运行后贴出来的。

  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. }else{
  25. print("
  26. ");
  27. }
  28. }
  29. }
  30. print("");
  31. }
  32. print("
  33. $id ");
  34. print $name;
  35. print("
  36. ");
  37. mysql_close($link);
  38. ?>

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/486157.htmlTechArticle下面代码PHP生成表格实例,经过本站编程之家测试正常运行后贴出来的。 ?php $link=mysql_connect("localhost","root","123456"); $db=mysql_select_db("bustest"...