我已经编写了这段代码,但是仍然无法在数据库中创建表。只是输出是:
“数据库已创建。...未创建对不起的表”。
<?php
include 'connection.php';
//Creating database
$creatingdatabase = "CREATE DATABASE IF NOT EXISTS quest";
$query1 = mysqli_query($con, $creatingdatabase);
if($query1){
echo "database created....";
//creating tables
$creatingtable = "CREATE TABLE quiz (
id INT(6) AUTO_INCREMENT PRIMARY KEY,
questions VARCHAR(255) NOT NULL,
optiona VARCHAR(255) NOT NULL,
optionb VARCHAR(255) NOT NULL,
optionc VARCHAR(255) NOT NULL,
optiond VARCHAR(255) NOT NULL,
answer VARCHAR(50) NOT NULL
)";
$query2 = mysqli_query($con, $creatingtable);
if($query2){echo "table created...";}
else { echo "sorry... table not created"; }
}
else { echo "database can not be created"; }
?>
最佳答案
CREATE TABLE
语句需要指定要使用的数据库,或者您需要使用mysqli_select_db()
设置默认数据库。
$creatingdatabase = "CREATE DATABASE IF NOT EXISTS quest";
$query1 = mysqli_query($con, $creatingdatabase);
mysqli_select_db($con, "quest");
关于php - 表格无法建立,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/38490733/