v5:reference:connection:param
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
v5:reference:connection:param [2020/01/24 23:48] – [Description] document param(false) call to reset counter dregad | v5:reference:connection:param [2020/01/25 00:30] – [Usage] full section rewrite with cleaner layout and more realistic example. dregad | ||
---|---|---|---|
Line 18: | Line 18: | ||
------------------------------ | ------------------------------ | ||
===== Usage ===== | ===== Usage ===== | ||
+ | |||
+ | This is an example of how to use param() to build SQL queries: | ||
+ | |||
<code php> | <code php> | ||
- | /* | + | $sql1 = ' |
- | * Connection to Oracle database | + | $db-> |
- | */ | + | $sql2 = ' |
- | print $db-> | + | |
- | /* | + | |
- | * prints | + | |
- | */ | + | |
</ | </ | ||
- | <code php> | + | |
- | /* | + | See below for the code's output with various database drivers. |
- | * Connection to IBM DB2 database | + | |
- | */ | + | ==== MySQL, |
- | print $db-> | + | < |
- | /* | + | $sql1: SELECT |
- | * prints | + | $sql2: SELECT |
- | */ | + | |
</ | </ | ||
- | < | + | |
- | /* | + | ==== Oracle (oci8) ==== |
- | * Connection to Postgres database | + | < |
- | */ | + | $sql1: SELECT |
- | print $db-> | + | $sql2: SELECT |
- | /* | + | |
- | * prints | + | |
- | */ | + | |
</ | </ | ||
+ | ==== PostgreSQL ==== | ||
+ | < | ||
+ | $sql1: SELECT * FROM accounts WHERE name = $1 AND total = $2 | ||
+ | $sql2: SELECT * FROM accounts WHERE id = $1 | ||
+ | </ | ||
v5/reference/connection/param.txt · Last modified: 2021/02/26 01:35 by dregad