PHP MySQL ???
WHERE ?? ???? ????? ? ?????. ?? ??? ??? ?? ???? ???? ????
??
< table width=" -642">| 類型 | 詳細(xì)解釋 |
| 基本語法 | select 字段 from 表 where where條件; |
| 示例 | select * from money where age = 29; |
| 示例說明 | 查詢MyGuests表中年齡為29的所有結(jié)果 |
?? ?? ???????.
?
?? ?? "MyGuests" ????? ?? FirstName? ????? =' Mary' ?:
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
$con=mysqli_connect($servername, $username, $password, $dbname);
// 檢測(cè)連接
if (mysqli_connect_errno())
{
echo "連接失敗: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM MyGuests
WHERE FirstName='Mary'");
while($row = mysqli_fetch_array($result))
{
echo $row['firstname'] . "----" . $row['lastname'] ."----".$row['email'];
echo "<br>";
}
?>???? ?? ??:
??? ??? ???? FirstName='Mary'? ?? ???? ???? ????.
?? phpadmin? ???? MyGuests ???? Age ??? ?????.
?? ???? ???? ??? ????.
?
?? where ?? ???? Age? 25? ??? ???? ?????.
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
$con=mysqli_connect($servername, $username, $password, $dbname);
// 檢測(cè)連接
if (mysqli_connect_errno())
{
echo "連接失敗: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM MyGuests
WHERE Age<25 ");
while($row = mysqli_fetch_array($result))
{
echo $row['firstname'] . "----" . $row['lastname'] ."----".$row['email']."----".$row['Age'];
echo "<br>";
}
?>???? ?? ??:
?? ??? ??? ?? ????
| ?? | ||||||||||
| > | ?? ? | ||||||||||
| < | ?? | < /tr>||||||||||
| > = | ??? ?? | ||||||||||
| <= | ??? ?? |
| != | 不等于 |
| = | 等于 |
?? ???
?? | ?? | ||||||
| ?? | ?? | ||||||
| ??? |
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
$con=mysqli_connect($servername, $username, $password, $dbname);
// 檢測(cè)連接
if (mysqli_connect_errno())
{
echo "連接失敗: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM MyGuests
WHERE Firstname='Julie' AND Age=24 ");
while($row = mysqli_fetch_array($result))
{
echo $row['firstname'] . "----" . $row['lastname'] ."----".$row['email']."----".$row['Age'];
echo "<br>";
}
?>???? ?? ??: 
