douzhengzuo7283
2014-02-09 18:17 阅读 528
已采纳

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);
?>
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    duanduanxi9441 duanduanxi9441 2014-02-09 18:31

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

    点赞 评论 复制链接分享
  • dongyi1777 dongyi1777 2014-02-09 18:18

    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')";
    
    点赞 评论 复制链接分享

相关推荐