php fuel 42000 error
- by ryanc1256
I don't get whats wrong. So this is the full error I get...
Fuel\Core\Database_Exception [ 42000 ]: SQLSTATE[42000]: Syntax error or access violation:
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 'to, from, message, checked) VALUES ('1',
'freddy', 'bob', 'message', '1')' at line 1 with query: "INSERT INTO chatmes (id, to, from,
message, checked) VALUES ('1', 'freddy', 'bob', 'message', '1')"
and this my php code which is supposably giving me the error
<?php
define('DOCROOT', __DIR__.DIRECTORY_SEPARATOR);
define('APPPATH', realpath('/var/www/vhosts/grubber.co.nz/httpdocs/fuel/app/').DIRECTORY_SEPARATOR);
define('PKGPATH', realpath('/var/www/vhosts/grubber.co.nz/httpdocs/fuel/packages/').DIRECTORY_SEPARATOR);
define('COREPATH', realpath('/var/www/vhosts/grubber.co.nz/httpdocs/fuel/core/').DIRECTORY_SEPARATOR);
require APPPATH.'bootstrap.php';
error_reporting(-1);
ini_set('display_errors', 1);
$to = $_GET['to'];
$from = $_GET['from'];
$message = $_GET['message'];
$dquotes = '"';
$squotes = "'";
$message = str_replace($dquotes, """, $message);
$message = str_replace($squotes, "'", $message);
DB::insert('chatmes')->set(array('id' => '1', 'to' => 'freddy', 'from' => 'bob', 'message' => 'message', 'checked' => '1'))->execute();
?>
I dont know what I am doing wrong??
Also the connection im using is PDO
At the moment the only line thats giving me a error is, the db update query
