Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Access Databse --> MySql or Parsed into PHP
Old 10-08-2004, 07:30 PM Access Databse --> MySql or Parsed into PHP
theblt's Avatar
Super Talker

Posts: 119
Trades: 0
Ok, here's a real doozy. I work for a privately owned daycare center doing general tech support around the center. I'm also starting to develope their website. I have much experience in both PHP and MYSQL. But I've never done this before. Ok, here goes:

They have 2 databases updated every now and then. 1 for clients, 1 for employees. Then, they have the punch in/out databases that are created once a month (e.g. 0804.mdb , 0904.mdb) but they are updated daily with the times the parents/employees are clocked in and out. The software they use was custom made to fit their needs. So uploading databases wasn't originally an option. So my first problem is, how can I upload these automatically, say at 7:00pm (an hour after they close). Second, how can I take the Access database files, and be able to read them with PHP OR convert them into MYSQL automatically. I want to be able to show client/employee information and be able to show the times both clocked in and clocked out online instead of only on their computers. Anybody have any idea on how to go about doing this?
theblt is offline
Reply With Quote
View Public Profile Visit theblt's homepage!
 
 
Register now for full access!
Old 10-08-2004, 07:36 PM
sfackler's Avatar
Novice Talker

Posts: 13
Location: La Jolla
Trades: 0
Cron jobs might help with the schedualed (sp?) db uploads.
__________________

Please login or register to view this content. Registration is FREE

Go there. Now.
sfackler is offline
Reply With Quote
View Public Profile Visit sfackler's homepage!
 
Old 10-08-2004, 07:42 PM
theblt's Avatar
Super Talker

Posts: 119
Trades: 0
Yea, I figured something like that would, though I've never dealt with Cron jobs before. But I still have to somehow show the information that's inside an Access mdb database.
theblt is offline
Reply With Quote
View Public Profile Visit theblt's homepage!
 
Reply     « Reply to Access Databse --> MySql or Parsed into PHP
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.34054 seconds with 12 queries