v5:userguide:learn_bind:portability
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
v5:userguide:learn_bind:portability [2018/07/14 01:00] – [Hardening SQL Statements Against Injection Attacks] mnewnham | v5:userguide:learn_bind:portability [2020/12/30 21:29] (current) – fix variables peterdd | ||
---|---|---|---|
Line 14: | Line 14: | ||
$sql = " | $sql = " | ||
WHERE col1=$col1Ph | WHERE col1=$col1Ph | ||
- | AND col2=$col2ph | + | AND col2=$col2Ph |
AND col3=$col3Ph"; | AND col3=$col3Ph"; | ||
- | $result = $db-> | + | $result = $db-> |
</ | </ | ||
Line 49: | Line 49: | ||
$sql = " | $sql = " | ||
WHERE col1=$col1Ph | WHERE col1=$col1Ph | ||
- | AND col2=$col2ph | + | AND col2=$col2Ph |
AND col3=$col3Ph"; | AND col3=$col3Ph"; | ||
- | $result = $db-> | + | $result = $db-> |
</ | </ | ||
Note that the order of the bind variables in $bindVars must match the order of insertion into the SQL statement. Some databases use $bindVars as an associative array, but some discard the indexes and use $bindVars as a numeric array. | Note that the order of the bind variables in $bindVars must match the order of insertion into the SQL statement. Some databases use $bindVars as an associative array, but some discard the indexes and use $bindVars as a numeric array. |
v5/userguide/learn_bind/portability.txt · Last modified: 2020/12/30 21:29 by peterdd