Good day PHP masters!
Im new in programming and loves to learn PHP.
I want to create a DB driven site.. where you could manage a list (edit, add, delete) records.
I did check this tutorial
http://www.killersites.com/community/index.php?/topic/1969-basic-php-system-vieweditdeleteadd-records/
Its really helpful but for a beginner like me, surely its not so easy.
I wanted the OutPut to be in a column form (not a row form) on the TUT above , the output is on a row form.
I did try editing the script but its not working! its just making the site messy. Really messy.
I also wanted to add a Username and Password function but I am not sure .. how to do it.
The username and password function I wanted to include in the site works like this:
1. I did create a table for students.
2. Table has the information : First Name, Middle Name, Last Name , Address , ID number, Age, Birth Date
3. I wanted each "user" to have there own login: Username is there ID number and a Unique static password
4. My question is.. should I include the password information on the table? and set it to MD5?
5. Can you please give me a sample login script for this?
----------------
6. Is it possible for me to put grades on the Students Table? If yes, how to I do it? I am not just referring on adding a row for the "grades" I wanted to put there grades for "preliminary" , "quarterly" , "final grade".
OR ITS POSSIBLE IF I WILL JUST PUT THE GRADES ON A SEPARATE TABLE? AND USE THERE ID NUMBER (on the grades DB) TO SYNC THERE PERSONAL INFORMATION once they will have login to there account.
--if you could let me see some sample script for this, I will really appreciate it!
7. Can the DB table "students" accommodate 2000+ information for each (ex. First Name, Middle Name, Last Name , Address , ID number, Age, Birth Date)
I am just using a free shared hosting site for this test project.
Hope to hear from all of you. More Power to all!
Thanks
Jack