note 2069 modified in function.odbc-exec by yannick
| From: | yannick@php.net | Date: | Fri, 25 Jul 2008 16:57:05 +0000 |
| Subject: | note 2069 modified in function.odbc-exec by yannick | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-142708@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:
<?php
$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.
--was--
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://php.net/manual/en/function.odbc-exec.php