PHP MySQL ????
PHP MySQL ????
UPDATE ?? ?????? ???? ???? ???? ? ?????.
??????? ??? ????
UPDATE ?? ?????? ???? ?? ???? ?????? ? ?????.
??
UPDATE table_name SET ??1=?, ??2=?2,... WHERE some_column=some_value
??: UPDATE ??? WHERE ?? ?????. WHERE ?? ?????? ?? ???? ?????. WHERE ?? ???? ?? ??? ???????!
PHP? ? ???? ????? mysqli_query() ??? ???? ???. ? ??? MySQL ??? ??? ??? ??? ? ?????.
?
? ????? ?? ???? ??? ?? "Persons"?? ???? ??????.
?? ???? "Persons" ???? ?? ???? ???????.
<?php
$con=mysqli_connect("localhost","username","password","database");
// 檢測連接
if (mysqli_connect_errno())
{
echo "連接失敗: " . mysqli_connect_error();
}
mysqli_query($con,"UPDATE Persons SET Age=36
WHERE FirstName='Peter' AND LastName='Griffin'");
mysqli_close($con);
?>? ???? ? "Persons" ???? ??? ????.
