?????? ? ???? ???? PHP ?? ??? ?? ??
??? ???? phpMyAdmin? ???? MySql ??????? ???? ?????.
??? ??? ??? ??????? ???? ???? ??? ??? ??????.
???? ??? ???? ???? ?? ???? ???? ?? ? ?? ??? ???? ???.
??? ?????? ?? ??? ???? ?? ????? ??? ??? ??????.
?? ??? ?????.
id: ???? ??? int?? ?? ?? ?????.
uesrname: ??? ??, ??? varchar, ??? 30???.
password: ????, ??? varchar, ??? 30???.
confirm: ???? ??, ??? varchar, ??? 30???.
email: ???, ??? varchar, ??? 30???.
<?php
// 創(chuàng)建連接
$conn = new mysqli("localhost", "uesename", "password","test");
// 檢測連接
if ($conn->connect_error)
{
die("連接失敗: " . $conn->connect_error);
}
// 使用 sql 創(chuàng)建數(shù)據(jù)表
$sql = "CREATE TABLE login (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
password VARCHAR(30) NOT NULL,
confirm VARCHAR(30) NOT NULL,
email VARCHAR(30) NOT NULL,
)ENGINE=InnoDB DEFAULT CHARSET=utf8 ";
if ($conn->query($sql) === TRUE)
{
echo "Table MyGuests created successfully";
} else {
echo "創(chuàng)建數(shù)據(jù)表錯誤: " . $conn->error;
}
$conn->close();
?>phpMyAdmin? ?? ??????? ???? ?? ???? ??? ?? ??? ?? ????
?? ? ??? ??? ??? ????.
??? ??????? ???? ??????.
