php查询数据信息,php使用select语句查询数据信息

Finding User

Finding users from mysql database.

Select gender:

man

woman

User found

User found from mysql database.

$gender = $_POST['gender'];

if(!$gender){

echo "Error: There is no data passed.";

exit;

}

if(!get_magic_quotes_gpc()){

$gender = addslashes($gender);

}

@ $db = mysqli_connect('localhost','root','12345678');

mysqli_select_db($db,'testphp');

if(mysqli_connect_errno()){

echo "Error: Could not connect to mysql database.";

exit;

}

$q = "SELECT * FROM user WHERE gender = '".$gender."'";

$result = mysqli_query($db,$q);

$rownum = mysqli_num_rows($result);

for($i=0; $i

$row = mysqli_fetch_assoc($result);

echo "Id:".$row['id']."
";

echo "Name:".$row['name']."
";

echo "Age:".$row['age']."
";

echo "Gender:".$row['gender']."
";

echo "Info:".$row['info']."
";

}

mysqli_free_result($result);

mysqli_close($db);

?>