????? ??? ???? ?? ?????? ? ??? ??
????? ??? ??? ??? ?? ??? ?????. ???? ???? ?????. ???? "admin"??? ??? ??? ?? ??? ??? ??????.
?? vidoe?? ??? ?? ??? ????? ?? ?????? ??? ???????. ?? ??? ??? ????.
<?php // 創(chuàng)建連接 $conn = new mysqli("localhost", "uesename", "password"); // 檢測連接 if ($conn->connect_error) { die("連接失敗: " . $conn->connect_error);} // 創(chuàng)建數據庫 $sql = "CREATE DATABASE vidoe"; if ($conn->query($sql) === TRUE) { echo "數據庫創(chuàng)建成功"; } else { echo "Error creating database: " . $conn->error; } $conn->close(); ?>
admin??? ??? ??????? ??? ???? ?????.
?? ??? ?????.
id: ???? ??? int?? ?? ?? ?????.
??? ??: ??? ??, ??? varchar, ??? 50???.
password: ????, ??? varchar, ??? 50???.
<?php $SQL = " CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `password` varchar(50) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 "; ?>
??? ??? ?? ? ???? ??:
<?php $SQL = "INSERT INTO admin (id , username, password) VALUES ('1', 'admin', '12345');" ?>
??????? ?? ?? ??: