note 96695 deleted from security.database.sql-injection by cmb
| From: | cmb@php.net | Date: | Fri, 09 Dec 2016 09:51:25 +0000 |
| Subject: | note 96695 deleted from security.database.sql-injection by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-208291@lists.php.net to get a copy of this message | ||
Note Submitter: wang dot liang dot com at gmail dot com
----
another way to stop sql injection when you odbc_*: create two users,
one has only select permission,
the other has only delete, update, and insert permission,
so you can use select-only user to call odbc_exec while you don't have to check the sql
injection; and you use d/u/i only user to update database by calling odbc_prepare and odbc_execute.