PHP ?? ?????? ? ?? ??
?? ?????? ???? ??? CREATE DATABASE ??????? ?????. ??? regedit:
<?php
// 創(chuàng)建連接
$conn = new mysqli("localhost", "root", "root");
// 檢測(cè)連接
if ($conn->connect_error)
{
die("連接失敗: " . $conn->connect_error);}
// 創(chuàng)建數(shù)據(jù)庫
$sql = "CREATE DATABASE regedit";
if ($conn->query($sql) === TRUE)
{
echo "數(shù)據(jù)庫創(chuàng)建成功";
} else {
echo "Error creating database: " . $conn->error;
}
$conn->close();
?>??? ??, regedit ?????? form??? ?? ?????. ???? ??? ??? ????.
??? ??: form
| ?? ?? | id | username | password |
| ?? ?? | int | varchar | varchar |
| ?? ?? | 5 | 100 | 100 |
| ?? ?? | ??? ID | ??? ?? | ??? ???? |
<?php
// 創(chuàng)建連接
$conn = new mysqli("localhost", "root", "root","regedit");
// 檢測(cè)連接
if ($conn->connect_error)
{
die("連接失敗: " . $conn->connect_error);
}
// 使用 sql 創(chuàng)建數(shù)據(jù)表
$sql = "CREATE TABLE form (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
password 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ù)表錯(cuò)誤: " . $conn->error;
}
$conn->close();
?>?? ??? ??????? ????, ??? ???? ????, ???? ???? ??? ? ????.
??, ?? ??? ???? ??? ?? ???, ? ??? ? ????.
phpStudy? ?? ?????:
![1I`05H5O_6~S50G]%I99[4H.png](https://img.php.cn/upload/image/839/105/697/1478156758887332.png "1478156758887332.png")
??? ???? phpMyStudy? ??? ? ?????? ??? ???? ?????. ?? ????? root???.
?? ?? ??? ??? ?? ? ???? ???? "??????"? ?????.
?? ?? ? ???? ???? ???? ???? ?????? ??? ???? ???? ???? ???. ?????.
???? ??? ???? ???, ??? ??? ????, ?? ?? ??? ? ????. ?? ? ??? ??? ??? ?? ????. ???? ??? ?????.
