| Bind
Values ( cont. ) |
|
|
|
|
|
|
|
|
|
|
|
| • | Multiple
bind values can also be specified, e.g.: |
|||||||||
| $sth = $dbh->prepare( " |
||||||||||
| SELECT name, location |
||||||||||
| FROM megaliths |
||||||||||
| WHERE name = ? |
||||||||||
| AND mapref = ? |
||||||||||
| AND type LIKE ? |
||||||||||
| " ); |
||||||||||
| $sth->bind_param( 1,
$dbh->quote( "Avebury” ) ); |
||||||||||
| $sth->bind_param( 2,
$dbh->quote( $mapreference ) ); |
||||||||||
| $sth->bind_param( 3,
$dbh->quote( "%Stone Circle%” ) ); |
||||||||||
| DBI:
The Neophyte's Guide |
| 56 |