2 回答

TA貢獻(xiàn)1865條經(jīng)驗(yàn) 獲得超7個(gè)贊
修復(fù)了問(wèn)題,但我不確定問(wèn)題是什么。我現(xiàn)在正在連接但沒(méi)有選擇數(shù)據(jù)庫(kù),然后我將 SQL 命令更新為
"CREATE TABLE `test`.`$tablename` ( `id` INT(10) NOT NULL , `title` VARCHAR(120) NOT NULL , `description` TEXT NOT NULL , `position_order` INT(11) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB";

TA貢獻(xiàn)1813條經(jīng)驗(yàn) 獲得超2個(gè)贊
嘗試如下。如果它不能正常工作,請(qǐng)確保您的數(shù)據(jù)庫(kù)連接正常工作。
<?php
session_start();
require_once('config.php');
$con = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
$name = $_POST['user'];
$league = $_POST['league'];
$delim = '_';
$tablename = $name . $delim . $league;
$s = "CREATE TABLE IF NOT EXISTS '$tablename'
(id int(10) NOT NULL ,
title VARCHAR(120) NOT NULL ,
description TEXT NOT NULL ,
position_order INT(11) NOT NULL ,
PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARSET=utf8";
$result = mysqli_query($con, $s);
echo $result;
?>
- 2 回答
- 0 關(guān)注
- 170 瀏覽
添加回答
舉報(bào)