简单的插入语句不能在PHP代码中工作。适用于MySQL Workbench

I have a simple script which I have included here. the select query works fine but the insert query fails. I am running php, apache and mysql on my macbook.

我有一个简单的脚本,我在这里包含。 select查询工作正常但插入查询失败。我在我的macbook上运行php,apache和mysql。

The table city_profile has ID as a auto increment primary key. And name is a non-null.

表city_profile具有ID作为自动增量主键。并且名称是非空的。

function testMySQL()    {
  $db = new mysqli('localhost', 'root', NULL, 'citee');
  //$query = "select * from city_profile"; //this query works
  $query = "insert into city_profile ('name','state','country') values ('charlotte','north  carolina','usa')"; 
  //whereas the above one fails..
  $results = $db->query($query); 
  if($results)  {
    echo '<p>The query is successful.</p>';
  }else {
    echo '<p>The query is NOT successful.</p>';
  } 

  //close the connection
 $db->close();
}

1 个解决方案

#1

try to change this line:

尝试更改此行:

$query = "insert into city_profile ('name','state','country') values ('charlotte','north  carolina','usa')";

into this:

$query = "insert into `city_profile` (`name`,`state`,`country`) values ('charlotte','north  carolina','usa')";

1 个解决方案

#1

更多相关文章

随机推荐