MS-ACCESS and PHP myAdmin?

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.

drew22299 posted this at 20:01—17th January 2008.

He has: 107 posts

Joined: Mar 2006

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!

www.hotlista.co.uk

Web Database Development

JeevesBond posted this at 20:59—17th January 2008.

He has: 3,465 posts

Joined: Jun 2002

drew wrote: Is it actually possible to use PHP myadmin with an Access database?

I very, very, very much doubt it. It's called PHPMyAdmin for a reason. Smiling 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.

drew wrote: Also, has anyone got any advice on how to structure a database that stores student attendances?

Sounds like a many-to-many relationship and a one-to-many storing class names. Four tables:

student
- sid
- student_name
- ... Other fields ...
student_classes
- sid
- cid
- attended
classes
- cid
- nid
- class_time
- ... Other fields ...
class_info
- nid
- class_name
- ... Other fields ...

This is just off the top of my head, your schema will be different depending on the project requirements. Smiling 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.