A single php script to return html table/CSV file from mySQL database with user name/password verification
$30-250 AUD
W trakcie realizacji
Opublikowano prawie 11 lat temu
$30-250 AUD
Płatne przy odbiorze
Hello,
This is a very simple php coding job that I need ASAP.
I urgently need a SINGLE php script to take the data from a html form that I have already created and display the results in a html table sorted by a field. I will place the code on the server - it does not need any HTML attributes. (eg. you don't have to worry about the background color or fonts etc)
I have used this format: [table/[login to view URL]] eg. [[login to view URL]] means the password field on the form and [[login to view URL]] means the uid field in the user table.
The form fields are:
- email_uid (the user's email address OR user id)
- password
- start_date
- end_date
The mySQL database has three tables - 'user', 'work_det' and 'type'
The code needs to do the following:
- access my existing mySQL database (use 'dbname', 'dbusername', 'dbpassword' and 'dbserver' in your code)
- confirm that the user's email address OR user id [form.email_uid] exist in either the [[login to view URL]] or [[login to view URL]] fields
- confirm that the user's password [[login to view URL]] matches with the [[login to view URL]] field in the same record in the [user] table
- if either is incorrect or not found display a message "Incorrect email/password. Please try again" and return user to this page.
- search the [work_det] table for all records that have a [[login to view URL]] = [[login to view URL]] within the date range of [form.start_date] - [form.end_date]
- display the results in a html table with the following columns:
- "User ID" [uid]
- "Work type" [[login to view URL]] where [type.type_id] = [[login to view URL]]
- "Start location" [work_det.start_loc]
- "End location" [work_det.end_loc]
- "Start time" [work_det.start_time]
- "End time" [work_det.end_time]
- "Total time" [work_det.end_time] - [work_det.start_time]
- The table should have a title of "[[login to view URL]] work summary for [form.start_date] - [form.end_date]"
- The table should be grouped by [[login to view URL]] and sorted by [work_det.start_time]
- The last line in each group should be empty other than a subtotal of the "Total time" column
- The last line of the table should be empty other than a final total of the "Total time" column
Here's a quick text mock up of what the table should look like (sort of):
[[login to view URL]] work summary for [form.start_date] - [form.end_date]
| User ID | Work type | Start location | End location | Start time | End time | Total time |
| 12345 | Admin | XYZ | XYZ | 2013-04-15 18:34:42 | 2013-04-15 19:54:42 | 0 days 1 hours 20 minutes 00 seconds |
| 12345 | Admin | XYZ | XYZ | 2013-04-17 14:24:10 | 2013-04-17 18:34:10 | 0 days 4 hours 10 minutes 00 seconds |
| | | | | | Subtotal | 0 days 5 hours 30 minutes 00 seconds |
| | | | | | | |
| 12345 | Travel | ABC | XYZ | 2013-04-15 17:24:30 | 2013-04-15 18:34:41 | 0 days 1 hours 10 minutes 11 seconds |
| 12345 | Travel | ABC | XYZ | 2013-04-16 17:24:30 | 2013-04-16 18:34:41 | 0 days 1 hours 10 minutes 11 seconds |
| 12345 | Travel | ABC | XYZ | 2013-04-17 17:24:30 | 2013-04-17 18:34:41 | 0 days 1 hours 10 minutes 11 seconds |
| | | | | | Subtotal | 0 days 3 hours 30 minutes 33 seconds |
| | | | | | Total | 0 days 9 hours 00 minutes 33 seconds |
As I said, this is urgent so please only bid if you're able to ASAP
i'm a professional web developer , i can write the script that will take the data from your form , get all the data from the db and displays it as you want , kindly check PM
Need 1 day to implement this functionality to site with Php/Mysql as I'm Expert Php/Mysql Programmer and always get positive feedback from Client. Thank you.