Re: access database on linux

I've never did this but I heard from a friend that he succeeded to connect from PHP to Access with ODBC. If you use PHP under windows there is no need of recompile just edit your php.ini to enable the extension by default for odbc. Otherwise you have to use dl() function to load the odbs module in the head of your script. RTFM. It is good. -- Andrey Hristov Web Developer IcyGEN Corporation BALANCED SOLUTIONS http://www.icygen.com On Tuesday 09 October 2001 17:21, you wrote: > Is the answer to this iodbc? Does it mean that I have to recompile php > and apache? > > Ajdin > > On Tue, 9 Oct 2001, Andrey Hristov wrote: > > I think that the only way to access Access from PHP you have to use ODBC. > > The loop is easy > > select * from the_table; > > > > after than > > $num_rows=mysql_num_rows($result); > > $showed = 0; > > for ($counter=0;$counter<=$num_rows;$counter++){ > > $ar=mysql_fetch_assoc($result); > > foreach ($ar as $key=>$value){ > > echo $value; > > } > > } > > > > -- > > Andrey Hristov > > Web Developer > > IcyGEN Corporation > > BALANCED SOLUTIONS > > http://www.icygen.com > > > > On Tuesday 09 October 2001 16:49, you wrote: > > > Hi > > > > > > I have a few msaccess dbs (.mdb files) that I need to open, extract and > > > join data then update a MySQL database. I want to open MsAccess files > > > (.mdb) using PHP, loop through results and create a .csv filethe just > > > lod content into a MySQL table. > > > > > > Say my file is called first.mdb > > > I am running RH6.2 and PHP4 > > > > > > How do I open a .mdb file? Do I need to use ODBC? > > > Any tutorials or example scripts. > > > > > > Regards > > > > > > Ajdin > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net