14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
+ List of binary safe functions
(+ List of binary safe functions) |
|||
| Line 341: | Line 341: | ||
* {{Gd}} [http://php.net/manual/en/pdo.prepare.php PHP: PDO::prepare] + [http://php.net/manual/en/pdostatement.bindparam.php PDOStatement::bindParam] | * {{Gd}} [http://php.net/manual/en/pdo.prepare.php PHP: PDO::prepare] + [http://php.net/manual/en/pdostatement.bindparam.php PDOStatement::bindParam] | ||
* [http://www.php.net/manual/en/mysqli.real-escape-string.php PHP: mysqli::real_escape_string] | * [http://www.php.net/manual/en/mysqli.real-escape-string.php PHP: mysqli::real_escape_string] | ||
== List of binary safe functions == | |||
{| class="wikitable" | |||
|- | |||
! Goal !! Binary safe function !! Binary NOT safe | |||
|- | |||
| "Return part of a string" || [https://www.php.net/manual/en/function.mb-substr.php mb_substr] || [https://www.php.net/manual/en/function.substr.php substr] | |||
|- | |||
| Get string length || [https://www.php.net/manual/en/function.mb-strlen.php mb_strlen] || [https://www.php.net/manual/en/function.strlen.php strlen] | |||
|- | |||
| 範例 || 範例 || 範例 | |||
|} | |||
== trigger to make backup of deleted data before deleting them == | == trigger to make backup of deleted data before deleting them == | ||