PHP? ??????? ???? ???? ?? ??? ???? ?????.
?? mysql?? "test" ??????? ??? ??, ?? ??????? "ly" ?????? ???? ?????.
?? ??? ??????? ????:
<?php // 創(chuàng)建連接 $conn = new mysqli("localhost", "uesename", "password"); // 檢測連接 if ($conn->connect_error) { die("連接失敗: " . $conn->connect_error);} // 創(chuàng)建數(shù)據(jù)庫 $sql = "CREATE DATABASE test"; if ($conn->query($sql) === TRUE) { echo "數(shù)據(jù)庫創(chuàng)建成功"; } else { echo "Error creating database: " . $conn->error; } $conn->close(); ?>
?? ??? ?????:
id: ???? ??? int?? ?? ?? ?????.
nackname: ??? ???, ??? varchar, ??? 30???.
???: ??? ??, ??? ??????. ??? ?? ??? ?? ??? ???? ??? ??? ? ????.
lytime: ??? ?? ?? ??, ??? ??/??, ??? ??? ??? ????.
??: ?? ???? ??, ??? ??????.
retime: ???? ???? ??, ??? datetime?? ??? ??? ??? ????.
?????? ???? ???? SQL?:
<?php $SQL = " CREATE TABLE IF NOT EXISTS `ly` ( `id` int(10) NOT NULL AUTO_INCREMENT, `nickname` varchar(30) CHARACTER SET utf8 NOT NULL, `message` text CHARACTER SET utf8 NOT NULL, `avatar` varchar(50) CHARACTER SET utf8 NOT NULL, `lytime` datetime NOT NULL, `reply` text CHARACTER SET utf8 NOT NULL, `retime` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 "; ?>
??? ?? ?????? ??? ??? ???????.