note 90698 added to function.odbc-columns
| From: | antcampos1 at iol dot pt | Date: | Tue, 05 May 2009 12:18:25 +0000 |
| Subject: | note 90698 added to function.odbc-columns | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-154219@lists.php.net to get a copy of this message | ||
having a file in excel i wanted to read it without the use of ,say excelreader for exemple. so i
build an odbc and with a short php program i had read it. however when i tried to put a condition in
the sql ( where.....) i did not knew the names of the columns.... the odbc_columns is quite complex
and take me a while to set up it!!!
(where $table_name is the name of the sheet with a $ at the end!)
for someone that will need it:
$filen="C:\mydocuments\zka1.xls";
$colis=odbc_columns($acesso,$filen,NULL,$table_name);
odbc_fetch_row($colis);
echo odbc_result_all($colis);
----
Server IP: 69.147.83.197
Probable Submitter: 81.193.61.86
----
Manual Page -- http://www.php.net/manual/en/function.odbc-columns.php
Edit -- https://master.php.net/note/edit/90698
Del: integrated -- https://master.php.net/note/delete/90698/integrated
Del: useless -- https://master.php.net/note/delete/90698/useless
Del: bad code -- https://master.php.net/note/delete/90698/bad+code
Del: spam -- https://master.php.net/note/delete/90698/spam
Del: non-english -- https://master.php.net/note/delete/90698/non-english
Del: in docs -- https://master.php.net/note/delete/90698/in+docs
Del: other reasons-- https://master.php.net/note/delete/90698
Reject -- https://master.php.net/note/reject/90698
Search -- https://master.php.net/manage/user-notes.php