Devam Ediyor

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

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

Beceriler: MySQL, PHP, Yazılım Mimarisi

Daha fazlasını gör: php form search mysql database, php code search mysql database, password please, mysql database software, mysql database server, look php id, incorrect from address, incorrect email address, html 5 table, html 5 date, html 5 color, email address is incorrect, background color html 5 table, abc color, id verification, 1.5 hours in minutes, summary table, single line, Return, need a quick mysql script

İşveren Hakkında:
( 3 değerlendirme ) Malaga, Australia

Proje NO: #4452046

Bu iş için 10 freelancer ortalamada $81 teklif veriyor

cheapexcell

I can get this done by tomorrow morning. Ready to start now.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(181 Değerlendirme)
6.8
PhungTran

Being a Professional !

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(528 Değerlendirme)
7.0
SiliconMind

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 gün içinde
(95 Değerlendirme)
6.9
ZenithTechnoSol

Ready for this now and will be completing it 4 hours from now.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(83 Değerlendirme)
7.0
Creativeartbd

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(113 Değerlendirme)
6.6
dzmitrij

Hello, Can make this. I complete many php project(including project with mysql/css). Can start right now. Regards. Dima

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(71 Değerlendirme)
5.9
rubyonrailsdev21

Let me complete it first, then we will mark this project as complete. Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(16 Değerlendirme)
5.3
martinlynas

Hi - I'd love to work with you on this and would get it done quickly ! Thanks Martin

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(22 Değerlendirme)
4.3
hadelnasr

senior web developer , let's get started now

$110 AUD in 0 gün içinde
(7 Değerlendirme)
3.4
benny34

Hi sir, please check your inbox.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(10 Değerlendirme)
3.2