looking for simple php script language: php must be php>>>>> i can not use an other...
TRANSCRIPT
Looking for simple php scriptLanguage: PHP Must be php>>>>> I can not use an other language Budget: $30.0If more than $30.0 Please do not bid
Login pageUpdate page
I need to have configuration file where I can setupMySQL IP Address:MySQL Username:MySQL Password:Database Name:
Send me demo I’ll Escrow the moneySend me the source code I’ll release the money
the perform the following actions
1.Login page: User will login
2.Update page:I need to be able to A.Load a file that has the following format xls
Teacher NameId number1Id number1Id number1Id number1ENDTeacher NameId number1Id number1Id number1Id number1ENDTeacher NameId number1Id number1Id number1Id number1Id number1End
B. Select the teacher name from the drop boxThen hit update buttonAction: find all StudentID and set the teacher name on those records to the selected teacher nameSQL: Update wasfall set Teacher = “the selected name from Drop Box” where StudentID = “to the typed or
imported ones”;Condition: only update the matching records (Studentid) that have the same userid as the logged in userIf userid = 0 means the Administrator allow the update else display no records found at your site
If the Browse is selected (to load the file) disable the manually type section
Load a file that has the following format xls
Teacher NameId number1Id number1Id number1Id number1ENDTeacher Name1Id number1Id number1Id number1Id number1ENDTeacher Name2Id number1Id number1Id number1Id number1Id number1End
The file can have multiple teacher names or just one teacher name not multiple
Teacher NameId number1Id number1Id number1Id number1END
See graphic next page
Logged in user
Get it from users table where username in the table = to the logged in user
Get it from users table where username in the table = to the logged in user
Link this drop box to teachers TableWhere I can select the teacher
Click on Upload to select the MS Excel fileThat will have the dataOnce the file is selectedDisplay it in the box below and lookup in wasfallFirstnameSurnamesitename Then display all the data in the grid
To clear the data from the grid
Update: to update the recordsSQL: Update WASFALL Set Teacher = “Selected from the list” where StudentID = “loaded from the file “ and userid of the records = userid of the logged in user;
Manually type the Students ID Numbers
Teacher
When Updated the records Setting up the teacher nameUpdate 4 more fields
My_Students: 1Updated_By: Logged in userUpdated_On: Now()Updated_By_IP: $_SERVER[‘REMOTE_ADDR’]Updated_By_Hostname: $hostname = gethostbyaddr($_SERVER[‘REMOTE_ADDR’]);
Please do not hesitate to message me
Thank you Donnie