(资料图)
php入门到就业线上直播课：进入学习Apipost = Postman + Swagger + Mock + Jmeter 超好用的API调试工具：点击使用
本教程操作环境：Windows7系统、PHP8.1版、Dell G3电脑。
怎么用php做一个查询语句？
php使用select语句查询数据信息
<html><head> <title>Finding User</title></head><body> <h2>Finding users from mysql database.</h2> <form action="selectformhandler.php" method="post"> Select gender: <select name="gender"> <option value="male">man</option> <option value="female">woman</option> </select><br /> <input name="submit" type="submit" value="Find"/> </form></body></html>
<html><head> <title>User found</title></head><body> <h2>User found from mysql database.</h2><?php $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<$rownum; $i++){ $row = mysqli_fetch_assoc($result); echo "Id:".$row["id"]."<br />"; echo "Name:".$row["name"]."<br />"; echo "Age:".$row["age"]."<br />"; echo "Gender:".$row["gender"]."<br />"; echo "Info:".$row["info"]."<br />"; } mysqli_free_result($result); mysqli_close($db);?></body></html>推荐学习：《PHP视频教程》
以上就是怎么用php做一个查询语句的详细内容，更多请关注php中文网其它相关文章！
关键词：
营业执照公示信息