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

时间：2023-03-09 00:56:03
php实例源码之获取mysql表中所有行和列

本文章向大家介绍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 );

?>

相关文章