通知设置 新通知
代码 5-5 用于创建数据库和数据表的 PHP 代码
教材代码 • 韩林涛 发表了文章 • 0 个评论 • 1195 次浏览 • 2020-07-06 15:19
<?php include "shared/conn.php"; ?> &nb ...查看全部
<?php include "shared/conn.php"; ?>
<?php
$database = "
CREATE DATABASE myterm
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
";
if(!mysqli_query($conn,$database))
{
echo "数据库创建失败，请检查原因。".mysqli_error($conn). "<br>";
}
else
{
echo "数据库创建成功！" . "<br>";
}
mysqli_select_db($conn,"myterm");
$table = "
CREATE TABLE `TermData`
(
`ID` INT(5) NOT NULL AUTO_INCREMENT ,
`zh_CN` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`en_US` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`ID`)
)
ENGINE = InnoDB
CHARSET=utf8
COLLATE utf8_general_ci;
";
if(!mysqli_query($conn,$table))
{
echo "数据表创建失败，请检查原因。".mysqli_error($conn). "<br>";
}
else
{
echo "数据表创建成功！" . "<br>";
}
?>
代码 5-4 用于删除数据库 myterm 的SQL语句
教材代码 • 韩林涛 发表了文章 • 0 个评论 • 963 次浏览 • 2020-07-06 15:18
DROP DATABASE myterm ...查看全部
DROP DATABASE myterm
代码 5-3 为数据库添加新数据表 TermData
教材代码 • 韩林涛 发表了文章 • 0 个评论 • 1107 次浏览 • 2020-07-06 15:17
CREATE TABLE `TermData`
( ...查看全部
CREATE TABLE `TermData`
(
`ID` INT(5) NOT NULL AUTO_INCREMENT ,
`zh_CN` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`en_US` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`ID`)
)
ENGINE = InnoDB
CHARSET=utf8
COLLATE utf8_general_ci;