MS-ACCESS and PHP myAdmin?
Hi,
Is it actually possible to use PHP myadmin with an Access database?
Also, has anyone got any advice on how to structure a database that stores student attendances? I'm guessing I would use a separate attendance table and student table - but to record attendances wouldn't the table be very large because of all the dates?
Any suggestions will be very much appresiated!
JeevesBond posted this at 20:59 — 17th January 2008.
He has: 3,956 posts
Joined: Jun 2002
I very, very, very much doubt it. It's called PHPMyAdmin for a reason.
You should check their documentation, or ask on their forums though. You never know. The biggest problem is that it's difficult to use more than one database system in PHP, without making a special effort.
Sounds like a many-to-many relationship and a one-to-many storing class names. Four tables:
This is just off the top of my head, your schema will be different depending on the project requirements.
Speaking of requirements: wouldn't it be easier to use one of the existing course management systems out there? There are a few good Free software ones (Moodle for example).
a Padded Cell our articles site!
teammatt3 posted this at 16:33 — 18th January 2008.
He has: 2,102 posts
Joined: Sep 2003
Probably not. But you can use MS Access to control a MySQL database, which can be controlled by PHPMyAdmin too.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.