note 2069 modified in odbc_exec by ronabop
| From: | ronabop@php.net | Date: | Fri, 06 Oct 2000 15:03:50 +0000 |
| Subject: | note 2069 modified in odbc_exec by ronabop | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-6174@lists.php.net to get a copy of this message | ||
If you're running NT/IIS with PHP 3.0.11 and want to use MS Access dbs with "stored
procedures" you can send an ODBC SQL query like:
$conn_id = odbc_connect( "odbc_test_db", "", "", SQL_CUR_USE_DRIVER );
$qry_id = odbc_do( $conn_id, "{CALL MyQuery}" );
This way you don't need to integrate query strings like
SELECT * FROM TblObject WHERE (((TblObject.something) Like "blahblahblah"));
in the php file. You directly call the query "MyQuery" that was generated by MS Access.
http://www.php.net/manual/function.odbc-exec.php