mysqli_query返回错误

问题描述：

Hi I'm very new to php and my query to my mysql database is returning an error. My connection is fine, but there's something wrong with my query. I've run it through php validators but they can't find any errors. Any help would be appreciated. Thanks in advance. Here's my code.

<?php
$dbc=mysqli_connect('url','username','password')
or die('error connecting');

$query = "INSERT INTO mailing_list (first_name, last_name, email_address)" . 
"VALUES ('one','two','three')";

$answer = mysqli_query($dbc,$query)
or die('error querying');


mysqli_close($dbc);
?>

您好我是php的新手，我对mysql数据库的查询返回错误。我的连接很好，但我的查询有问题。我通过php验证器运行它，但他们找不到任何错误。任何帮助，将不胜感激。提前致谢。这是我的代码。 p>

 ＆lt;？php 
 $ dbc = mysqli_connect（'url'，'username'，'password'）
ot die（'error connecting'）  ; 
 
 $ query =“INSERT INTO mailing_list（first_name，last_name，email_address）”。  
“VALUES（'one'，'two'，'three'）”; 
 
 $ answer = mysqli_query（$ dbc，$ query）
ot die（'error querying'）; 
 
 
mysqli_close  （$ dbc）; 
？＆gt; 
  code>  pre> 
  div>

答

you have the connection almost right but where is your database selector,also check your php extension whether it is mysql or mysqli

答

You have no space in between (first_name, last_name, email_address) and VALUES. MySQL would recognize that as one word rather than two. So add that in and it should work, like this:

$query = "INSERT INTO mailing_list (first_name, last_name, email_address) " . 
"VALUES ('one','two','three')";

mysqli_query返回错误

相关推荐