PHP & Access

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ast3r3x
Forum Commoner
Posts: 95
Joined: Thu Aug 19, 2004 8:36 pm

PHP & Access

Post by ast3r3x »

I have to make a project using an Access database for my computer science class, and I'd like to make it accessible by PHP so I can use it for a website.

I was wondering if anyone could point me in the direction of a tutorial on how to access an Access database remotely...is this even possible? I'd rather not install PHP and apache onto the one crappy PC at my house, I'd much rather use the web hosts I regularly use.

I found this tutorial on how to use PHP to talk to an Access database, but it seems to be only for local connections.

If this isn't possible, are there any free, or cheap web hosts that have PHP and Access available that I can use for a month or two?

Thanks for the help with any of my questions, I guess I'm not much use if I'm not using mysql.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

all you need is odbc drivers.. (there is also a unix odbc driver :))

but once you start using access for more than a few users, things will go slooooooow. meaby you could choose more or less generic datatypes and use a mysql database... And if you need it, export/convert the data to a access file (via the mentionned odbc driver).
ast3r3x
Forum Commoner
Posts: 95
Joined: Thu Aug 19, 2004 8:36 pm

Post by ast3r3x »

Oh...this can be the crappiest crap that ever was crapped out.

I am just going to make a simple movie database...maybe ~50 movies or so. I just want to access them as a informative display, and show the ability to input things, with maybe a couple users...nothing really big or complicated.
Include a minimum of 3 tables. Explain table structure of each tableUse primary key in at least 1 of the tables Define relationship between two tablesMinimum of 4 queries:
1 query must include a calculated field
1 query must include a primary and a secondary sort key
1 query must use logical operators (And and Or)
1 query must use aggregate functions.
Explain and show how you filter data using filter and form .
Create forms and reports (at least 1 customized form and rep
See, not too complicated for anything. Heh, I was thinking of just using a MySQL database, but putting the same information into an Access database...I don't think my teacher is smart enough to figure it out :lol:
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

There are built-in ODBC functions in PHP. All you need is a host that supports ODBC. It's not too hard - I used to do it because it was easy to just take a copy of the .mdb file and use it on another PC. I'd prefer MySQL however.
User avatar
apek
Forum Commoner
Posts: 96
Joined: Tue Jan 06, 2004 11:19 pm
Location: Holiday Plaza Johor Bahru

Post by apek »

i also prefer MySQL as the database for php program.
However, my company only allowed i use php only. The server must be IIS and the database must be MSSQL Server.
This is really frustrated.
Can PHP run at it best performance on IIS with MSSQL Server as the database?
Is anyone here know any URL which can give guide how to do that?
Anyone has reference?Please share...thanks..
User avatar
apek
Forum Commoner
Posts: 96
Joined: Tue Jan 06, 2004 11:19 pm
Location: Holiday Plaza Johor Bahru

Post by apek »

Anyone?Hello?
User avatar
Jean-Yves
Forum Contributor
Posts: 148
Joined: Wed Jul 02, 2003 2:13 pm
Location: West Country, UK

Post by Jean-Yves »

PHP and IIS are fine (I use that combination for most of my development).

SQL Server is supported with it's own set of functions (see php.net SQL Server functions) for further details. Or you could use PEAR::DB to provide an abstraction layer between your code and the underlying database. That way your code should be portable between SQL Server, MySQL ,etc.
User avatar
apek
Forum Commoner
Posts: 96
Joined: Tue Jan 06, 2004 11:19 pm
Location: Holiday Plaza Johor Bahru

Post by apek »

what is Pear DB?
what is abstraction layer?
and how to configure PHP in IIS?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

google them. There's lots of explanations out there for those.... and this is getting a bit off topic.. :?
Post Reply