MS-ACCESS and PHP myAdmin?

They have: 105 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!

JeevesBond's picture

He has: 3,956 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:

  1. student
    • sid
    • student_name
    • ... Other fields ...
  2. student_classes
    • sid
    • cid
    • attended
  3. classes
    • cid
    • nid
    • class_time
    • ... Other fields ...
  4. 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's picture

He has: 2,102 posts

Joined: Sep 2003

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

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.