这是在 php 数据库中创建表的正确函数吗?

Question

初始化变量

<? php
$host = 'localhost';
$user = 'root';
$pword = '';
$dbname = 'mydb';
$tablename = 'userdata';
$con = mysqli_connect($host, $user, $pword); 

这是表创建函数的正确代码吗？(假设我们已经连接到数据库(

 function createtable($tablename) {
    $con = mysqli_connect($host, $user, $pword); 
    $sql = "CREATE TABLE IF NOT EXISTS
        $tablename(uid int(10) unsigned NOT NULL AUTO_INCREMENT,
      firstname char(60),
      lastname char(60),
      username varchar(60),
      password varchar(60),
      gender enum('male','female') NOT NULL,
      course set('PHP','HTML','CSS','Javascript'),
      comments longtext,
      PRIMARY KEY(uid)
      )";
 if (mysqli_query($con,$sql))
{
 echo "Table created.";
}
else 
{
echo "Error in creating table.";
}       
} 

？>

Answer 1

变化不大。只是建议将$con&$tablename参数传递给createtable()，最后调用createtable()函数。

$host = 'localhost';
$user = 'root';
$pword = '';
$dbname = 'mydb';
$tablename = 'userdata';
$con = mysqli_connect($host, $user, $pword, $dbname);
function createtable($con, $tablename) {
//mysqli_connect($host, $user, $pword);
$sql = "CREATE TABLE IF NOT EXISTS
  $tablename(uid int(10) unsigned NOT NULL AUTO_INCREMENT,
  firstname char(60),
  lastname char(60),
  username varchar(60),
  password varchar(60),
  gender enum('male','female') NOT NULL,
  course set('PHP','HTML','CSS','Javascript'),
  comments longtext,
  PRIMARY KEY(uid)
  )";
$result = mysqli_query($con,$sql);
if($result){echo "Table created.";}
else{echo mysqli_error($con);}
}
createtable($con, $tablename);