PHP MySQL ???
???? MySQL ??? ??? ?? ?????.
SQL ??? ? ?? ??? SQL ??? ????? ??? ???? ??? ??? ?? ?? ???? ???? ????? ??? ?? ?? SQL ??? ????? ?? ????.
??? ?? ???? ????
??? ?? ?? ?? ????? ??? ?? ?? SQL ?? ???? ? ?????.
Prepared ?? ?? ??? ??? ????.
1. ???: SQL ? ???? ???? ??????? ????. ??? ?? "?"?? ????? ?????. ?:
INSERT INTO MyGuests(??, ?, ???) VALUES(?, ?, ?)
2. ?????? ?? ??, ???, SQL ? ???? ?? ?? ??? ?? ? ??? ???? ?? ?????. ???? ?? ?? ?? ??????? ?? ???? ?? ? ??? ? ????.
3. ??: ????? ?????? ???? ?? ????("?" ??)? ???? ??????? ?? ???? ?????.
SQL ?? ?? ???? ?? ?? ??? ?? ? ?? ??? ????.
· ??? ?? ?? ??? ?? ?????, ? ?? ??? ?????(?? ?? ? ??????).
· ?? ??? ????? ?? ???? ????? ?? ? ?? ?? ?? ??? ??? ???.
· ??? ?? SQL ??? ?? ?????. ???? ?? ??? ? ?? ????? ???? ???? ???? ???? ?????.
MySQLi ?? ???
?? MySQLi? ??? ?? ???? ?? ????? ??????.
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
// 創(chuàng)建連接
$conn = new mysqli($servername, $username, $password, $dbname);
// 檢測連接
if ($conn->connect_error) {
die("連接失敗: " . $conn->connect_error);
}
// 預(yù)處理及綁定
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, email) VALUES(?, ?, ?)");
$stmt->bind_param("sss", $firstname, $lastname, $email);
// 設(shè)置參數(shù)并執(zhí)行
$firstname = "John";
$lastname = "Doe";
$email = "john@example.com";
$stmt->execute();
$firstname = "Mary";
$lastname = "Moe";
$email = "mary@example.com";
$stmt->execute();
$firstname = "Julie";
$lastname = "Dooley";
$email = "julie@example.com";
$stmt->execute();
echo "新記錄插入成功";
$stmt->close();
$conn->close();
?>?? ?? ? ?? ?? ?? ?????.
"INSERT INTO MyGuests (??, ?, ???) VALUES(?, ?, ?)"
SQL ???? ???(?)? ?????. ??? ???? ??? ?? ? ????. , ???, ?? ? ??.
???? bind_param() ??? ???????.
$stmt->bind_param("sss", $firstname, $lastname, $email );
? ??? SQL ????? ????? ??????? ????? ?? ?????. "sss" ???? ?? ??? ????? ??? ??? ?????. ??? ?? ??(?) ??? ??? ?? s ??? ????? ????? ??????? ?????.
?????? ?? ? ?? ??? ????.
· i - ??(???)
· d - double(???? ?? ????)
· s - ???(???)
· b - BLOB(???? ?? ??: ???? ?? ??)
? ?????? ??? ???? ???.
??? ??? ???? ??? ?? ???? ??????.
??????? ????? ??? ??? ?????? SQL ??? ??? ?? ? ????.
? ?? ?? ??:
? ??? ?? ??
???? ??? ?? ?? ?????
?
??? ?? ???? ??????? ??? ?????.
?? HTML ???
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>PHP中文網(wǎng)</title> </head> <body> <form action="insert.php" method="post"> Firstname: <input type="text" name="firstname" /><br/> Lastname: <input type="text" name="lastname" /><br/> email: <input type="text" name="email" /><br/> <input type="submit" /> </form> </body> </html>
? PHP ???
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
// 創(chuàng)建連接
$conn = new mysqli($servername, $username, $password, $dbname);
// 檢測連接
if ($conn->connect_error) {
die("連接失敗: " . $conn->connect_error);
}
// 預(yù)處理及綁定
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, email) VALUES(?, ?, ?)");
$stmt->bind_param("sss", $firstname, $lastname, $email);
// 設(shè)置參數(shù)并執(zhí)行
$firstname = $_POST['firstname'];
$lastname =$_POST['lastname'];
$email = $_POST['email'];
$stmt->execute();
echo "新記錄插入成功";
$stmt->close();
$conn->close();
?>? ?????. ?? ? ????? ?? ??? ???? ??????
