php - 尽管正确构建了查询，但 mysqli_query 无法在 php 中工作

Question

我正在尝试使用 php 将示例数据插入到表中，否则应该很简单，但有些东西却没有。

表定义:

CREATE TABLE IF NOT EXISTS teams ( 
     token varchar(12) COLLATE utf8_unicode_ci NOT NULL, 
     tname varchar(48) COLLATE utf8_unicode_ci NOT NULL, 
     captain varchar(64) COLLATE utf8_unicode_ci NOT NULL, 
     email varchar(64) COLLATE utf8_unicode_ci NOT NULL, 
     phone varchar(14) COLLATE utf8_unicode_ci NOT NULL, 
          PRIMARY KEY (token), 
          UNIQUE KEY name (tname), 
          KEY id (token) 
     )  
     ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

代码:

$con = mysqli_connect("localhost","username","password","database");

$tname = "Big Bang";
$cname = "Mike";
$cemail = "test@gmail.com";
$cphone = "123-456-7898";

$teamToken = strtoupper(bin2hex(mcrypt_create_iv(6, MCRYPT_DEV_URANDOM)));

$query = "INSERT INTO teams (token, tname, captain, email, phone) VALUES ('" . $teamToken . "', '" . $tname . "', '" . $cname . "', '" . $cemail . "', '" . $cphone . "')";

if (mysqli_query($con, $query))
{
    echo "Pass!";
}
else
{
    echo $query;
}

mysqli_close($con);

奇怪的是 php 回显了查询，因为 mysqli_query 结果为假，但是回显的查询在复制并粘贴到 phpMyAdmin 的终端时工作正常。

我快结束了。

Answer 1

您的代码:

$con = mysqli_connect("localhost","username","password","database");

编辑后的代码:

$con = mysqli_connect("localhost","root","","database");
if(!$con):
die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
endif;

它在我的本地主机上运行良好