本文实例讲述了php列出mysql表所有行和列的方法。分享给大家供大家参考。具体实现方法如下:
复制代码 代码如下:
selecting data
$user = root;
$pass = ;
$db = mydatabase;
$link = mysql_connect( localhost, $user, $pass );
if ( ! $link ) {
die( couldn't connect to mysql: .mysql_error() );
}mysql_select_db( $db, $link ) or die ( couldn't open $db: .mysql_error() );$result = mysql_query( select * from domains where sex='f' );
$num_rows = mysql_num_rows( $result );print $num_rows women have added data to the table
\n;print ;
while ( $a_row = mysql_fetch_row( $result ) ) {
print ;
foreach ( $a_row as $field ) {
print .stripslashes($field). ;
}
print
;
}
print
;
mysql_close( $link );
?>
希望本文所述对大家的php程序设计有所帮助。