TalkPHP - Connecting To access with php

TalkPHP (http://www.talkphp.com/forums.php)

- Advanced PHP Programming (http://www.talkphp.com/advanced-php-programming/)

- - Connecting To access with php (http://www.talkphp.com/advanced-php-programming/4027-connecting-access-php.html)

digitak

03-08-2009 10:22 AM

Connecting To access with php

hi !

how can i connect to access database and select,insert,update,delete from that ?

help me please

Sakakuchi

03-08-2009 07:16 PM

Not that I ever tried it, cause I think access simply sucks :-P , but as far as I know you must make and dsn ->pointing to the db.

then you connect like:

PHP Code:


		
			
$connect = odbc_connect('DSN-NAME','USERNAME','PASSWORD');

think thats a way....

digitak

03-09-2009 06:40 AM

what is dsn ? :D
and how about select ,insert and ... ?

Sakakuchi

03-09-2009 08:23 AM

DSN:
http://en.wikipedia.org/wiki/Database_Source_Name

Creating a DSN under Windows XP:
Create a DSN under Windows...
(just google for other M$ Versions.)

Then you can use normal SQL-queries, maybe they differ from Mysql a little (Think to have heard something like this??!). Just google a bit for that syntax, should be pretty much the same ^^

All times are GMT. The time now is 07:10 AM.