note 9930 deleted from function.ibase-execute by didou
| From: | didou@php.net | Date: | Sun, 27 Jul 2003 18:46:13 +0000 |
| Subject: | note 9930 deleted from function.ibase-execute by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-52781@lists.php.net to get a copy of this message | ||
Note Submitter: anthony@n.o.s.p.a.m.trams.com
----
Here's a way to SELECT with prepare/execute, thereby avoiding the need to use magic quotes or
such kludges.
$dbh = ibase_connect ( $host, $username, $password ) ;
$stmt = 'SELECT * FROM "EMPLOYEE" WHERE "SALARY" = ? AND
"DEPT_CD" = ? ;' ;
$prep = ibase_prepare ( $dbh, $stmt ) ;
$salary = Array ( "10000", "25000", "33000", "48000" ) ;
$dept_cd = 'SALES' ;
foreach ( $salary as $val ) {
$taxForm[$val] = ibase_execute ( $prep, $val, $dept_cd ) ;
}