By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,216 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,216 IT Pros & Developers. It's quick & easy.

PHP and databases

P: n/a
I am completely new to PHP and have a couple questions.

Can PHP access Microsoft Access databases?

Are there any basic scripts, any good sites out there? I just want to
extract simple data from a table and display it on a webpage...as basic as
can be to start.

Thanks, Craig
Jul 16 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Craig" <ca******@golden.net> wrote in message news:<lD********************@mantis.golden.net>...
I am completely new to PHP and have a couple questions.

Can PHP access Microsoft Access databases?

Are there any basic scripts, any good sites out there? I just want to
extract simple data from a table and display it on a webpage...as basic as
can be to start.

Thanks, Craig


you can have a look at adodb .
Jul 16 '05 #2

P: n/a
"Craig" <ca******@golden.net> wrote in message
news:<lD********************@mantis.golden.net>...

Can PHP access Microsoft Access databases?


Yes, but you have to define your Access database as an ODBC source.
Then you can use PHP's ODBC functions to work with Access databases:

http://www.php.net/odbc

Cheers,
NC
Jul 16 '05 #3

P: n/a
http://www.php.net/manual/en/faq.dat...tabases.access

--
/**
* @author Jochen Buennagel <zang at buennagel dot com>
* @see http://www.sourceforge.net/projects/zang
*/

Jul 16 '05 #4

P: n/a
Not to flame you craig but why to so many new people not even use
google or do a book search first? When I learned all this stuff I did
a lot of research on my own and only posted questions on items I just
couldn't find the answer to. Stop being lazy newbies! What would you
do if this forum wasn't here?

I think google can answer your question:

google search: php Microsoft Access

hey what do you know, here is what the first item is based on that
search:

PHP: Microsoft Access Database ODBC and PHP Tutorial - PHP Freaks
Microsoft Access Database ODBC and PHP Tutorial. php tutorials php ...
Microsoft
Access Database ODBC and PHP. Author: phpfreak Tutorial ...
www.phpfreaks.com/tutorials/61/0.php - 37k - Cached - Similar pages

That took about 2 seconds!

Wes
"Craig" <ca******@golden.net> wrote in message
news:<lD********************@mantis.golden.net>...
I am completely new to PHP and have a couple questions.

Can PHP access Microsoft Access databases?

Are there any basic scripts, any good sites out there? I just want to
extract simple data from a table and display it on a webpage...as basic as
can be to start.

Thanks, Craig

Jul 16 '05 #5

P: n/a
I also highly, highly recommend ADODB.

http://php.weblogs.com/adodb

example code to connecting to the access database is simple as

$db = NewADOConnection('access');
$db->Connect($_host, $_user, $_pass, $_db);

the rest of adodb wrapper functions are very easy and the manual is concise.

furthermore if you ever plan on porting your application you needn't
ever have to worry about what database the client intends on using since
adodb supports a wide range of them.

hope this is helpful :)

-jpdr
TTG
Craig wrote:
I am completely new to PHP and have a couple questions.

Can PHP access Microsoft Access databases?

Are there any basic scripts, any good sites out there? I just want to
extract simple data from a table and display it on a webpage...as basic as
can be to start.

Thanks, Craig


Jul 16 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.