PHP MySQL ?? ???
?? ??????? ??? ??? ??? ?? ????? ? ????? ???? ???? ???? ??? ?? ?????.
??? ? ?? ?? ?????.
· SQL ?? ? PHP ???? ???? ???
· SQL ???? ??? ?? ???? ??? ???
· ?? ?? ???? ???? ????
· NULL ?? ???? ??? ??? ?? ??
INSERT INTO ?? ????? MySQL ???? ? ???? ???? ? ?????.
??
INSERT INTO table_name(?1, ?2, ?3,...)VALUES (?1, ?2 , value3,...)
table_name : ???? ????? ???? ??
column1 column2 : id firstname
value1, value2? ?? ???? ??: ????? ??????
??
1. ??? ?? ??? ??? ???... ? ?? ??? ??? ??? ??? ???? ???. . user(username,sex) ?('Liu Qi',1);
2. ???? ?? ??? ??? ??? ??? ???? ???.
3. ????? null ?? ??? ?? ?? ?? ???? ???? ?? null? ? ? ????.
SQL? ?? ??? ????? SQL ????? ?????.
?? ?? ???????.
????
?? ? ?? ? ???? "id", "firstname", "lastname", "email" ? "reg_date" ??? ???? "MyGuests" ???? ??????. ?? ???? ???? ?? ?????.
??: ?? AUTO_INCREMENT(?: "id" ?) ?? TIMESTAMP(?: "reg_date" ?)? ??? ?? ?? ??? ??? ????. SQL ?? ??? MySQL? ???? ?? ?? ?????.
AUTO_INCREMENT? ???? ???? ????? ?????
<?php
header("Content-type:text/html;charset=utf-8"); //設置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
// 創(chuàng)建連接
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 檢測連接
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if (mysqli_query($conn, $sql)) {
echo "新記錄插入成功";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>???? ?? ??:
? ???? ????? ???????
PHPadmin? ?? ??? ???? ??? ?????.
? ? ????. ??? ???? ???? ????? ?????
