MySQL与PHP的基础与应用专题之创建数据库表

<?php

# 创建链接
$conn = mysqli_connect("localhost", "root", "admin");

# 查看是否连接成功
if ($conn) {
    echo "服务器连接成功!";
} else {
    echo mysqli_connect_error();
}

# SQL语句
$sql = "Create Database study";

# 执行SQL语句
$result = mysqli_query($conn, $sql);

# 查看是否执行成功
if ($result) {
    echo "SQL语句执行成功!";
} else {
    echo mysqli_error($conn);
}

# 关闭连接
mysqli_close($conn);

?>

<?php

# 创建连接
$conn = mysqli_connect("localhost", "root", "admin", "study");

# 查看是否连接成功
if ($conn) {
    echo "服务器连接成功!";
} else {
    echo mysqli_connect_error();
}

# SQL语句
$SQL = "CREATE TABLE user (
    id INT(8) AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    passWord VARCHAR(255) NOT NULL
)";

# 执行SQL语句
$result = mysqli_query($conn, $SQL);

# 查看是否执行成功
if ($result) {
    echo "SQL语句执行成功!";
} else {
    echo mysqli_error($conn);
}

# 关闭连接
mysqli_close($conn);

?>