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