Home > Backend Development > PHP Tutorial > PHP instance source code to obtain all rows and columns in the mysql table

PHP instance source code to obtain all rows and columns in the mysql table

高洛峰
Release: 2016-10-29 13:05:06
Original
1352 people have browsed it

This article introduces you to the source code of PHP to obtain all rows and columns in the mysql table. It mainly uses PHP database operation functions such as mysql_num_rows and mysql_fetch_row. This example will help you familiarize yourself with the relevant knowledge of PHP mysql database programming. Friends who need it can just for reference.

php The source code to get all rows and columns in the mysql table is as follows:

<?php
$user = "root";
$pass = "";
$db = "test";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
  die( "Couldn&#39;t connect to MySQL: ".mysql_error() );
}
// 作者:码农教程 http://www.manongjc.com/article/1236.html
mysql_select_db( $db, $link ) or die ( "Couldn&#39;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 );
?>
Copy after login


Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template