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

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

<?php
$user = \"root\";
$pass = \"\";
$db = \"test\";
$  = mysql_connect( \"localhost\", $user, $pass );
if ( ! $  ) {
  die( \"Couldn\'t connect to MySQL: \".mysql_error() );
}

mysql_select_db( $db, $  ) or die ( \"Couldn\'t open $db: \".mysql_error() );
/* http://www.manongjc.com/article/1236.html */
$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( $  );
?>

大家可以在本地机器上创建一个数据库，然后将数据库连接修改一下，把源代码放在本地运行并查看一下结果，这样也有利于大家学习php mysql数据库编程。