Digitry Designs Posted January 23, 2010 Share Posted January 23, 2010 Hello, I am new here to this site and not new but very novice to php and ignorant to mysql. I am a business owner and trying to create a simple site where employees can simply login and fill out a form. The form then submits to mysql. At this point I would like to have a link that can allow me to access data as a .xls file, but maybe divided into individual weeks. Can this even be done with just php and mysql? If so, how do I go about figuring out how to do it. I know I can read a book or pay someone, but I am stubborn and think I can figure it out with assistance. Besides, do I really need to thoroughly learn php coding to solve my problem. Can anyone help me please. I am not looking for a personal aide to hold my hand for free, just throw me a bone. lol Quote Link to comment https://forums.phpfreaks.com/topic/189512-form-to-mysql-then-time-incrimented-mysql-to-xls/ Share on other sites More sharing options...
PFMaBiSmAd Posted January 23, 2010 Share Posted January 23, 2010 Can this even be done with just php and mysql? Yes, the creation or input of data, manipulation or processing of that data, storage and retrieval of that data, and display or output of that data is WHAT computers, programming languages, and databases were created to do, even php and mysql. how do I go about figuring out how to do it. You define the steps that need to occur to accomplish the stated task (i.e. log in system, data entry form, form processing and storage in the database, admin page with menu/links/form to select data to view or output, database retrieval and display code...) You then iterate through each step, adding more and more details, such as the data needed (i.e. what data will be entered on the form, what fields will there be in the database), what the user interface will be in each step (i.e. what menus/links/form fields will be on the page), what error messages will be produced and where and how will they be displayed, what will the code do if there is a fatal database error... Once you have all the details sufficiently defined, you can then start designing, writing, and testing the code for each step. Quote Link to comment https://forums.phpfreaks.com/topic/189512-form-to-mysql-then-time-incrimented-mysql-to-xls/#findComment-1000428 Share on other sites More sharing options...
Digitry Designs Posted January 23, 2010 Author Share Posted January 23, 2010 Thank you. That makes a good bit of sense. I know the steps I need to take but then interpreting that into code for php form to mysql db and then to xls. Is my problem. I am figuring this part out so far except the to xls part. I fear I am going to struggle a bit with the outputting info for timed increments though. I have managed to write the form code and use php to store it into a mysql data base. I need to under stand mysql a bit more to make it exactly what I want, however I am definately on the correct path. If you know of any simple or lamens term type tutorials on mysql or php's ability to output mysql table info that would be much appreciated. I thank you much for your assistance as of thus far and any you may choose to offer in the future! Quote Link to comment https://forums.phpfreaks.com/topic/189512-form-to-mysql-then-time-incrimented-mysql-to-xls/#findComment-1000474 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.