PHP pembangunan post komen fungsi tutorial pembinaan pangkalan data
Kami perlu menyerahkan pendapat kami ke pangkalan data dan menyimpannya, dan menyerahkannya ke halaman dalam masa nyata
Kini kami mencipta pangkalan data bernama 'komen'
The kod adalah seperti berikut
<?php
//建立'comments'數(shù)據(jù)庫(kù)
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 comments";
if (mysqli_query($conn, $sql)) {
echo "數(shù)據(jù)庫(kù)創(chuàng)建成功";
} else {
echo "數(shù)據(jù)庫(kù)創(chuàng)建失敗: " . mysqli_error($conn);
}
mysqli_close($conn);
?>Kami sedang mencipta jadual data bernama 'komen'
| 字段名 | id | user | comment | addtime |
| 字段類(lèi)型 | int | varchar | varchar | datetime |
| 字段長(zhǎng)度 | 11 | 30 | 200 | |
| 字段描述 | id | 評(píng)論人的昵稱(chēng) | 評(píng)論內(nèi)容 | 評(píng)論的時(shí)間 |
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "comments";
// 創(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 `comments` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(30) NOT NULL,
`comment` varchar(200) NOT NULL,
`addtime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM; " ;
if (mysqli_query($conn, $sql)) {
echo "數(shù)據(jù)表 comments 創(chuàng)建成功";
} else {
echo "創(chuàng)建數(shù)據(jù)表錯(cuò)誤: " . mysqli_error($conn);
}
mysqli_close($conn);
?> Buat fail index.html halaman utama kami di bawah
