note 73788 added to function.mysql-query
| From: | x_terminat_or_3 at yahoo dot fr | Date: | Sat, 10 Mar 2007 11:27:50 +0000 |
| Subject: | note 73788 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-124299@lists.php.net to get a copy of this message | ||
It says in the manual:
The query string should not end with a semicolon.
However, I read somewhere that it is good practice to add a semicolon at the end of your query, and
that it increases security against SQL-injection attacks. Therefore I have issued a requirement that
all my developers end queries with semicolons.
So far, PHP & MySQL have happily accepted those queries, with only one exception:
If you use more then one query in the same call to mysql_query, MySQL sometimes only executes the
first query and fails on the others.
----
Server IP: 194.145.210.4
Probable Submitter: 84.67.151.5
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit -- https://master.php.net/note/edit/73788
Del: integrated -- https://master.php.net/note/delete/73788/integrated
Del: useless -- https://master.php.net/note/delete/73788/useless
Del: bad code -- https://master.php.net/note/delete/73788/bad+code
Del: spam -- https://master.php.net/note/delete/73788/spam
Del: non-english -- https://master.php.net/note/delete/73788/non-english
Del: in docs -- https://master.php.net/note/delete/73788/in+docs
Del: other reasons-- https://master.php.net/note/delete/73788
Reject -- https://master.php.net/note/reject/73788
Search -- https://master.php.net/manage/user-notes.php