[56K WARN] PHP, MySQL and dynamic HTML
Posted: Tue Apr 11, 2006 11:15 am
This might sound a little confusing, but I'll try to explain it as best as possible. At FedEx, my job is to do loader evaluations weekly to give the loader feedback. It's an annoyance to go through every week and fill out 25 different papers of evaluations. So, I've been looking to make things easier. What I did for now was I scanned the evaluation paper and imported it into a Word document. I added special fields over top of the image that allows me to type in text in the specific locations above the image. Basically like this:

In that document, every time I open it, the date updates itself. That's nifty and all, but I'm interested in a more productive way of doing things rather than have the 25 different images load up in this 400MB Word document.
Here is my idea. I would like to create a PHP script that posts into my MySQL database. There will be 4 fields: name, date, sort, comments. I'd like to be able to post that information into a databse and then create another page that will get the information from the database and place it over the image in absolute positions using dynamic HTML. If someone can thing of a better way other than HTML, excellent. I'd be glad to try it.
I'm sure this sounds a little confusing so ask questions if you need. I'm not looking for someone to do the scripts for me because I want to learn how to do this on my own. I just kind of need a starting point and understand how to put and get information from a database.

In that document, every time I open it, the date updates itself. That's nifty and all, but I'm interested in a more productive way of doing things rather than have the 25 different images load up in this 400MB Word document.
Here is my idea. I would like to create a PHP script that posts into my MySQL database. There will be 4 fields: name, date, sort, comments. I'd like to be able to post that information into a databse and then create another page that will get the information from the database and place it over the image in absolute positions using dynamic HTML. If someone can thing of a better way other than HTML, excellent. I'd be glad to try it.
I'm sure this sounds a little confusing so ask questions if you need. I'm not looking for someone to do the scripts for me because I want to learn how to do this on my own. I just kind of need a starting point and understand how to put and get information from a database.