CodeIgniter未正确执行sql查询。

Question

在Ci中，我得到以下错误：

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '', '1f37540fc54292b018a9e993da38cb5647dc5587', NOW(), '0')' at line 1

INSERT INTO users (userpid, Email, Password, dateTimeRegistered, isLeader) VALUES ('147344f0e33367f9e6', erf', '1f37540fc54292b018a9e993da38cb5647dc5587', NOW(), '0')

Filename: C:\Workspace\htdocs\Misc-2\DruvlaCi-1\system\database\DB_driver.php

Line Number: 330

但是在SQL查询中似乎一切都是正确的。下面是我的问题，有什么想法吗？

$query = $this->db->query("INSERT IGNORE INTO users (userpid, Email, Password, dateTimeRegistered, isLeader) VALUES ('{$idgen}', {$postedEmail}', '{$hashedPass}', NOW(), '0')");

Answer 1

您忘记了电子邮件列的左单引号

试试这个吧

$query = $this->db->query("INSERT IGNORE INTO users (userpid, Email, Password, dateTimeRegistered, isLeader) VALUES ('{$idgen}', '{$postedEmail}', '{$hashedPass}', NOW(), '0')");

Answer 2

嗯，还有，请使用以下语法来插入：

http://codeigniter.com/user_guide/database/active_record.html#insert

安全多了。