Obtain all rows and columns in the mysql table by using the php instance source code.

Obtain all rows and columns in the mysql table by using the php instance source code.

This article introduces php to obtain the source code of all rows and columns in the mysql table, mainly using php database operation functions such as mysql_num_rows and mysql_fetch_row, this instance helps you to familiarize yourself with the related knowledge of PHP mysql database programming. For more information, see.

Php obtains the source code of all rows and columns in the mysql table as follows:

<? Php $ user = "root"; $ pass = ""; $ db = "test"; $ link = mysql_connect ("localhost", $ user, $ pass); if (! $ Link) {die ("Couldn't connect to MySQL :". mysql_error ();} // Author: codenong tutorial http://www.manongjc.com/article/1236.htmlmysql_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);?>