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