On 21 Jul 2017 at 09:58, Simon Slavin <slav...@bigfraud.org> wrote:
> On 21 Jul 2017, at 7:33am, Edmondo Borasio <edmondobora...@gmail.com> wrote:
>
>> $db->exec('UPDATE Movies SET name = "new movie" WHERE ID="4"');
>
> Those are the wrong quotes. SQLite requires single quotes around literal
> strings, and expects no quote around numbers. And PHP doesn’t care which
> quotes you use as long as they match.
Actually PHP does care. It will not look inside single quoted strings for
special escaped characters or variables for which to substitute values. It
*will* do so for double-quoted strings.
So:
echo 'Hello\n';
will not do the same thing as:
echo "Hello\n";
The latter will put out a newline at the end of Hello whereas the former will
put out two characters (\ and n).
Similarly, variable substitution will not happen here:
$sql = 'UPDATE Movies SET name = $newname where id=$newid';
but will do here:
$sql = "UPDATE Movies SET name = $newname where id=$newid";
So PHP is happy, but SQLite is not - you'd need:
$sql = "UPDATE Movies SET name = '$newname' where id=$newid";
Personally I don't like forcing PHP to scan strings so I tend to use
concatentation, rewriting the last of these as:
$sql = 'UPDATE Movies SET name = \'' . $newname . '\' where id=' . $newid;
but that's just a personal style preference.
--
Cheers -- Tim
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
