IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    php实例源码之获取mysql表中所有行和列

    summer发表于 2016-10-28 08:32:56
    love 0

    本文章向大家介绍php获取mysql表中所有行和列的源码,主要使用到mysql_num_rows和mysql_fetch_row等php的数据库操作函数,该实例有助于大家熟悉PHP mysql数据库编程的相关知识,需要的朋友可以参考一下。

    php获取mysql表中所有行和列的源代码如下:

    <?php
    user = "root";
    pass = "";
    db = "test";
    link = mysql_connect( "localhost", user, pass );
    if ( ! link ) {
    die( "Couldn't connect to MySQL: ".mysql_error() );
    }
    // 作者:码农教程 http://www.manongjc.com/article/1236.html
    mysql_select_db( db, link ) or die ( "Couldn't open db: ".mysql_error() );

    result = mysql_query( "SELECT * FROM student" );
    num_rows = mysql_num_rows( result );

    print "<p>num_rows women have added data to the table</p>\n";

    print "<table>";
    while ( a_row = mysql_fetch_row( result ) ) {
    print "<tr>";
    foreach ( a_row as field ) {
    print "<td>".stripslashes(field)."</td>";
    }
    print "</tr>";
    }
    print "</table>";
    mysql_close( link );
    ?>

     



沪ICP备19023445号-2号
友情链接