PHP? ??????? ??? ???? ???? ??? ?? ?? ???? ?????.
?? book??? ??? ?? ?? ??????? ????.
<?php // 創(chuàng)建連接 $conn = new mysqli("localhost", "uesename", "password"); // 檢測連接 if ($conn->connect_error) { die("連接失敗: " . $conn->connect_error);} // 創(chuàng)建數(shù)據(jù)庫 $sql = "CREATE DATABASE book"; if ($conn->query($sql) === TRUE) { echo "數(shù)據(jù)庫創(chuàng)建成功"; } else { echo "Error creating database: " . $conn->error; } $conn->close(); ?>
??? ?? ? ???? ???? ?? user?? ??? ??????? ???? ????.
?? ??? ?????.
id: ???? int? ???? ?? ?? ?????.
name: ??? ??, ??? varchar, ??? 100???.
password: ????, ??? varchar, ??? 100???.
email: ???, ??? varchar, ??? 100???.
tel: ??, ??? varchar, ??? 100???.
??: ??, ??? varchar, ??? 200???.
<?php $SQL = " CREATE TABLE IF NOT EXISTS `user` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `password` varchar(100) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `tel` varchar(100) DEFAULT NULL, `address` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 "; ?>
?? phpMyAdmin?? ?? ??? ?? ????.
??? ?????? ???? config.php ??? ???? ??? ?? ????? ?????? ???? ??? ? ????.
<?php ob_start(); session_start(); //開啟緩存 header("Content-type:text/html;charset=utf-8"); $link = mysqli_connect('localhost','root','root','book'); mysqli_set_charset($link, "utf8"); if (!$link) { die("連接失敗:".mysqli_connect_error()); } ?>