(资料图)

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中文网其它相关文章！

推荐内容