PHP? ??? MySql ??????? ??? ?? ???(1)
?? ????? 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();
?>?? ?? 3?? ??? ID, ?? ?? ? ?? ??? ??? ??? ?????? img ???? ???? ???.
?? ??? ?????.
id: ???? int ???? ?? ?? ?????.
title: ??, ??? varchar, ??? 100???.
pic: ??? ?? ??, ??? varchar, ??? 100???.
<?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 img (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(100) NOT NULL,
pic VARCHAR(200) 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();
?>?? phpMyAdmin? ?? ??????? ???? ?? ??? ?? ????.
??? ??? ?????? ? ??? ??? ?? PHP ?? ??? ??? ?? ????? ?????.
