?????? ? ???? ???? PHP ?? ??? ??? ??
????? phpMyAdmin? ???? MySql ??????? ???? ?????.
CREATE DATABASE ?? MySQL?? ??????? ???? ? ?????.
?? ??? ??????? ????.
<?php
// 創(chuàng)建連接
$conn = new mysqli("localhost", "uesename", "password");
// 檢測連接
if ($conn->connect_error)
{
die("連接失敗: " . $conn->connect_error);}
// 創(chuàng)建數(shù)據(jù)庫
$sql = "CREATE DATABASE test";
if ($conn->query($sql) === TRUE)
{
echo "數(shù)據(jù)庫創(chuàng)建成功";
} else {
echo "Error creating database: " . $conn->error;
}
$conn->close();
?>CREATE TABLE ?? MySQL ???? ??? ? ?????.
?? ??? ?????.
id: ???? ??? int?? ?? ?? ?????.
uesrname: ??? ??, ??? varchar, ??? 30???.
password: ????, ??? varchar, ??? 30???.
?? ?? ??? ??????? ??? ???? ?????:
<?php
// 創(chuàng)建連接
$conn = new mysqli("localhost", "uesename", "password","test");
// 檢測連接
if ($conn->connect_error)
{
die("連接失敗: " . $conn->connect_error);
}
// 使用 sql 創(chuàng)建數(shù)據(jù)表
$sql = "CREATE TABLE login (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
password VARCHAR(30) NOT NULL,)ENGINE=InnoDB DEFAULT CHARSET=utf8 ";
if ($conn->query($sql) === TRUE)
{
echo "Table MyGuests created successfully";
} else {
echo "創(chuàng)建數(shù)據(jù)表錯誤: " . $conn->error;
}
$conn->close();
?>???? ??? ??? ???? ??
<?php
$SQL = "INSERT INTO login ('id','username','password') VALUES ('7', 'tom', '12345');"
?>?? phpMyAdmin? ?? ??????? ???? ?? ??? ?? ????
??? ????? ??? ??? ?? ?????? ??(??? ????? ?)? ??? ?? ???? ??? ??? ???? ?? ?????.
??? ??? ??? ???? ???? ? ?????? ??? ???? ????, ??? ??? ??? ??? ??? ??? ?(??? ??? ??????) ??? ?????.
????? ?? ??? ?? ???? ??? ???? ?????.
??? ?????? ???? ????? ??? ??? ?? ??? ?????.
?? ???? ??? ???? ???? ??? ? ????? ???? ??? ???? ?????.
??? ??? tom?? ??????. ????? 12345???.
