Find Jobs
Hire Freelancers

A single php script to return html table/CSV file from mySQL database with user name/password verification

$30-250 AUD

In Progress
Posted almost 11 years ago

$30-250 AUD

Paid on delivery
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
Project ID: 4452046

About the project

10 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $81 AUD for this job
User Avatar
I can get this done by tomorrow morning. Ready to start now.
$128 AUD in 1 day
5.0 (181 reviews)
6.8
6.8
User Avatar
Being a Professional !
$60 AUD in 1 day
4.9 (528 reviews)
7.0
7.0
User Avatar
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
$78 AUD in 3 days
5.0 (95 reviews)
6.9
6.9
User Avatar
Ready for this now and will be completing it 4 hours from now.
$99 AUD in 1 day
4.9 (83 reviews)
7.0
7.0
User Avatar
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.
$89 AUD in 1 day
4.9 (113 reviews)
6.6
6.6
User Avatar
Hello, Can make this. I complete many php project(including project with mysql/css). Can start right now. Regards. Dima
$54 AUD in 1 day
5.0 (71 reviews)
5.9
5.9
User Avatar
Let me complete it first, then we will mark this project as complete. Thanks.
$45 AUD in 1 day
5.0 (16 reviews)
5.3
5.3
User Avatar
Hi - I'd love to work with you on this and would get it done quickly ! Thanks Martin
$99 AUD in 1 day
5.0 (22 reviews)
4.3
4.3
User Avatar
senior web developer , let's get started now
$110 AUD in 0 day
4.9 (7 reviews)
3.4
3.4
User Avatar
Hi sir, please check your inbox.
$50 AUD in 1 day
4.6 (10 reviews)
3.2
3.2

About the client

Flag of AUSTRALIA
Malaga, Australia
5.0
3
Payment method verified
Member since Mar 13, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.