选择指定条件的数据，并显示出来（select）

最新推荐文章于 2023-12-18 11:01:12 发布

weixin_30295091

最新推荐文章于 2023-12-18 11:01:12 发布

阅读量329

点赞数

原文链接：http://www.cnblogs.com/lovening/archive/2010/09/18/1829844.html

版权

<? php
$con = mysql_connect ( " localhost " , " root " , "" );
if ( ! $con )
{
die ( ' Could not connect: ' . mysql_error ());
}

mysql_select_db ( " my_db " , $con ); // 选取数据库

// ///查询指定name的数据
$result = mysql_query ( " SELECT * FROM world WHERE Name=' $_POST [Name]' " );
echo " <table border='1'>
<tr>
<th>id</th>
<th>name</th>
<th>location</th>
</tr> " ;

while ( $row = mysql_fetch_array ( $result ))
{
echo " <tr> " ;
echo " <td> " . $row [ ' Id ' ] . " </td> " ;
echo " <td> " . $row [ ' Name ' ] . " </td> " ;
echo " <td> " . $row [ ' Location ' ] . " </td> " ;
echo " </tr> " ;
}
echo " </table> " ;

// ///关闭连接
mysql_close ( $con );
?>

转载于:https://www.cnblogs.com/lovening/archive/2010/09/18/1829844.html