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.
PHP & Access
Moderator: General Moderators
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).
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).
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.

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.
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 outInclude 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
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
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..
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..
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.
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.