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/[url removed, login to view]] eg. [[url removed, login to view]] means the password field on the form and [[url removed, login to view]] 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 [[url removed, login to view]] or [[url removed, login to view]] fields

- confirm that the user's password [[url removed, login to view]] matches with the [[url removed, login to view]] 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 [[url removed, login to view]] = [[url removed, login to view]] 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" [[url removed, login to view]] where [type.type_id] = [[url removed, login to view]]

- "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 "[[url removed, login to view]] work summary for [form.start_date] - [form.end_date]"

- The table should be grouped by [[url removed, login to view]] 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):

[[url removed, login to view]] 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ün: 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, name start-up, name format, html table, html mock up, email form php script

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

Proje NO: #4452046

Seçilen:

novaemp

Hi,dear. I am interested in your job and I can finish it soon and can start right now.

0 gün içinde 43$ AUD
(3 Değerlendirme)
3.1

11 freelancer bu iş için ortalamada 78$ teklif veriyor

ZenithTechnoSol

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

1 gün içinde 99$ AUD
(48 Değerlendirme)
6.9
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

in 3 gün içinde78$ AUD
(62 Değerlendirme)
6.3
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 54$ AUD
(67 Değerlendirme)
5.7
cheapexcell

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

1 gün içinde 128$ AUD
(108 Değerlendirme)
5.7
PhungTran

Being a Professional !

1 gün içinde 60$ AUD
(69 Değerlendirme)
5.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 89$ AUD
(21 Değerlendirme)
4.5
martinlynas

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

1 gün içinde 99$ AUD
(17 Değerlendirme)
4.0
benny34

Hi sir, please check your inbox.

1 gün içinde 50$ AUD
(8 Değerlendirme)
2.4
rubyonrailsdev21

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

1 gün içinde 45$ AUD
(3 Değerlendirme)
2.4
sjain449

We can do the project as you require. Kindly have a look at our past work done in your PMB Awaiting your kind response Thanks & Regards Personalive Services

in 2 gün içinde157$ AUD
(2 Değerlendirme)
2.3
hadelnasr

senior web developer , let's get started now

in 0 gün içinde110$ AUD
(0 Değerlendirme)
0.0