Hello All!
I am new to the forum and relatively new to php and mySQL. I have programmed for years in C++ and Java and now and trying to pick up php on the job. I am starting a new project in which I need to analyze attendance information and make it so that an idiot can go into a website and it will spit back out the analysis. I have tons of data and new data needs to be entered every time an event occurs to add to the averages. I want to throw it all into a mySQL database and have phpMyAdmin installed and ready to go. I guess my problem is that I do not know how to go about designing the database so that I can access all. Each event has an entry for each person entering, including time of access, gate entered, type of ticket, and a few other random things. Any ideas? Or can someone point me to a resource that may help. I have a few books, but none have examples that help much in such a large project.
Thanks
newbie lost in mySQL
Moderator: General Moderators
Have a look at our starter pack: viewtopic.php?t=21400
Just had a look at the starter pack, nice resource!
You may also want to have a look at an all-in one package. If you are developing on a windows box, sokkit has a decent installer that gives you apache, php, and mysql. If you go the hosted route, you can probably setup with any decent virtual host and get the same thing.
If you're a C++ guy, you might like the OO approach of the ezsql abstraction layer. It made my life much easier when starting with mysql, and am still using it today. ezsql homepage, ezsql documentation.
You may also want to have a look at an all-in one package. If you are developing on a windows box, sokkit has a decent installer that gives you apache, php, and mysql. If you go the hosted route, you can probably setup with any decent virtual host and get the same thing.
If you're a C++ guy, you might like the OO approach of the ezsql abstraction layer. It made my life much easier when starting with mysql, and am still using it today. ezsql homepage, ezsql documentation.