Page 1 of 1
PHP & Access
Posted: Fri Apr 08, 2005 11:06 pm
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.
Posted: Sat Apr 09, 2005 2:48 am
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).
Posted: Sat Apr 09, 2005 8:17 am
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

Posted: Sat Apr 09, 2005 12:04 pm
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.
Posted: Tue Apr 12, 2005 8:38 pm
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..
Posted: Wed Apr 13, 2005 2:20 am
by apek
Anyone?Hello?
Posted: Wed Apr 13, 2005 4:38 am
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.
Posted: Thu Apr 14, 2005 6:39 am
by apek
what is Pear DB?
what is abstraction layer?
and how to configure PHP in IIS?
Posted: Thu Apr 14, 2005 4:02 pm
by feyd
google them. There's lots of explanations out there for those.... and this is getting a bit off topic..
