Hi, I'm trying to find solution for my problem, searched archive but no
results so posting here:
When I try to insert text containg single quotes via php it gives me syntax
error:
$db = new SQLiteDatabase("notebook.sdb");
$query = "INSERT INTO version (date,active,category,entry) VALUES
('".$date."','".$_POST['active']."','".$_POST['category']."','".$_POST['entry']."');";
$query = stripslashes($query);
$db->query($query);
// so query looks like:
INSERT INTO version (date,active,category,entry) VALUES ('2007-05-31
18:50','x','NOTE','test 'test' test');
Is there any simple way to come around this? There is no such problem with
mysql :(
Regards
--
View this message in context:
http://www.nabble.com/Inserting-text-string-with-quotes-gives-an-error---php-tf3848232.html#a10899753
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
