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(); ?>
? ?????. ?? ? ????? ?? ??? ???? ??????
?? ??? ? ????. >