PHP? ??????? ???? ???? ??? ?? ??? ???? ?????.

phpmyadmin? ?? ??????? ??? ? ????. ?? test?? ??????? ?????.

? ?????? ??? new?? ??? ??? ???? ????.

?? ??? ?? ??? ??? ??? ??? ??? ????.

??? ??????

???? ???? ??? ??? ???? ???? ?????.

" id ": " id " ??? ????? ???? ?????. ?? ?? ??? ??? ??? ? ??? ? ??? 1?? ???? ???? ???? ?????. ? ??? ??? ? ?? ?, ???, ?? ? ?? ??? ?????. ? ?? ??? ?? ??? ?????. ?? ??? ???? ???? ? ??? ???? 1? ?????. ?, ?? ??? 1, 2, 0 27? ?? ?? ID? ?????...

?? ?? ??.

1.id: ??? ? ??? ???? ???? ??? int?? "Extra"?? ?? ??? ???? ?? ?? ?????.

2. ???: ??? ???(?? ???), ??? varchar, ??? 20????

3. ??: ??? ?? ??, ??? varchar ???. , ??? 100 ???

4 . content: ??? ?? ???, ??? ??????. ??? ?? ??? ?? ??? ???? ??? ??? ? ????. ??? ???? ????? SQL ? ??? ?????.

5.created_at: ??? ?? ???? ??? datetime?? ??? ??? ??? ????

??? ?? ??? ??? ???? ?????.

PHP ??? ?? ?????? ???? ??? ?? ????

?? ??? ??????? ?????:

<?php
// 創(chuàng)建連接
$conn = new mysqli("localhost", "uesename", "password");
// 檢測(cè)連接
if ($conn->connect_error) 
{    
    die("連接失敗: " . $conn->connect_error);} 
    // 創(chuàng)建數(shù)據(jù)庫(kù)
    $sql = "CREATE DATABASE test";
        if ($conn->query($sql) === TRUE) 
        {    
            echo "數(shù)據(jù)庫(kù)創(chuàng)建成功";
        } else {    
            echo "Error creating database: " . $conn->error;
        }
    $conn->close();
?>

?? ?? ??? ??????? ? ???? ?????:

rr ?? ??

???? ??

??? ??

<?php // 創(chuàng)建連接 $conn = new mysqli("localhost", "uesename", "password","test"); // 檢測(cè)連接 if ($conn->connect_error) { die("連接失敗: " . $conn->connect_error); } // 使用 sql 創(chuàng)建數(shù)據(jù)表 $sql = "CREATE TABLE new ( id int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, title varchar(100) NOT NULL, author varchar(20) NOT NULL, content text NOT NULL, created_at datetime NOT NULL, )ENGINE=InnoDB DEFAULT CHARSET=utf8 "; if ($conn->query($sql) === TRUE) { echo "Table MyGuests created successfully"; } else { echo "創(chuàng)建數(shù)據(jù)表錯(cuò)誤: " . $conn->error; } $conn->close(); ?>

?????? ???

????