PHP and MySQL syntax: Difference between revisions

Jump to navigation Jump to search
m
Line 343: Line 343:


== List of binary safe functions ==
== List of binary safe functions ==
{| class="wikitable sortable"
[[List of PHP binary safe functions]]
|-
! 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]
|-
| "Replace all occurrences of the search string with the replacement string" || [https://www.php.net/manual/en/function.str-replace.php str_replace] ||
|-
| "Find the position of the first occurrence of a substring in a string" || [https://php.net/manual/en/function.strpos.php strpos] ||
|-
| "Replace text within a portion of a string" || [https://www.php.net/manual/en/function.substr-replace.php substr_replace] ||
|-
| 範例 || 範例 || 範例
|}


== trigger to make backup of deleted data before deleting them ==
== trigger to make backup of deleted data before deleting them ==

Navigation menu