我已经编写了这段代码,但是仍然无法在数据库中创建表。只是输出是:


  “数据库已创建。...未创建对不起的表”。


<?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"; }
?>


php - 表格无法建立-LMLPHP

最佳答案

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/

10-12 14:36
查看更多