PHP? ??? ???? ?????? ??
??? ?? ?????? ??
?? ??? ??? ????? ??? ? ???? ???? ?? ??? ?? ??? ?????
? ??? ?? ??, ??? ? ??? ??? ??????? ????? ??? ???? ?? ? ????? ??? ???? ??????? ?? ??? ?????. ??? ??????? ??? ??? ????
?? name
??? ???
??? ?? ??
??? ?? ressage_time
??? ??? ??? ?, ? ???? PHP ??? ???? ??????? ??? ? ????. ??? ??? ????
?????? ??
<?php header("Content-type:text/html;charset=utf-8"); //設置編碼 $servername = "localhost"; $username = "root"; $password = "root"; // 創(chuàng)建連接 $conn = mysqli_connect($servername, $username, $password); mysqli_set_charset($conn,'utf8'); //設定字符集 // 檢測連接 if (!$conn) { die("連接失敗: " . mysqli_connect_error()); } // 創(chuàng)建數(shù)據(jù)庫 $sql = "CREATE DATABASE message"; if (mysqli_query($conn, $sql)) { echo "數(shù)據(jù)庫創(chuàng)建成功"; } else { echo "數(shù)據(jù)庫創(chuàng)建失敗: " . mysqli_error($conn); } mysqli_close($conn); ?>
?? ??? message?? ??? ??????? ?????. ??? ???
??? ??? ???
??? ?? Ressage_user
?? ?? | id ~ ~????????? ? | content | ressage_time?? ?? | INT | |
VARCHAR | VARCHAR | DATE | | ?? ??6 | |
50 | 200 | ?? ?? | ??? ID | ||
??? ???? ??? ??? ?? | ???? ?? | ???? ?? | <?php header("Content-type:text/html;charset=utf-8"); //設置編碼 $servername = "localhost"; $username = "root"; $password = "root"; $dbname = "ressage"; // 創(chuàng)建連接 $conn = mysqli_connect($servername, $username, $password, $dbname); mysqli_set_charset($conn,'utf8'); //設定字符集 // 檢測連接 if (!$conn) { die("連接失敗: " . mysqli_connect_error()); } // 使用 sql 創(chuàng)建數(shù)據(jù)表 $sql = "CREATE TABLE Ressage_user ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, email VARCHAR(50) NOT NULL, content VARCHAR(200) NOT NULL, ressage_time DATE );"; if (mysqli_query($conn, $sql)) { echo "數(shù)據(jù)表 user 創(chuàng)建成功"; } else { echo "創(chuàng)建數(shù)據(jù)表錯誤: " . mysqli_error($conn); } mysqli_close($conn); ?> | ?? ??????? ???????. ?? ??????? ???? ??? ? ????. ?? ??? ????? |