php - php mysql 没有选择数据库错误

Question

我已经在 phpmyadmin 中创建了一个数据库。当我提交表单时，脚本应该将数据插入数据库。但是，我收到错误“未选择数据库”。您能看一下我的代码，看看是否能找到我出错的地方。谢谢

    $dbc = mysqli_connect('localhost','aliendatabase') or die('Error connecting to MySQL      server.');
    $query = "INSERT INTO aliens_abduction (first_name, last_name, when_it_happened, how_long, ".
   "how_many, alien_description, what_they_did, fang_spotted, other, email) " .
   "VALUES ('$first_name', '$last_name', '$when_it_happened', '$how_long', '$how_many', " .
   "'$alien_description', '$what_they_did', '$fang_spotted', '$other', '$email')";


   $result = mysqli_query($dbc, $query)
   or die(mysqli_error($dbc));

   mysqli_close($dbc);

Answer 1

正确的语法是

mysqli_connect('host','username', 'password', 'database_name');

阅读手册:- http://in2.php.net/manual/en/function.mysqli-connect.php

对于没有密码的本地主机

mysqli_connect('localhost','root', '', 'database_name');