MySql Database report

Closed

Currently use an online Web form to update a MySql database and submit data to multiple email accounts based on the user drop down list. The Database works for the admin to review using MySql Browser, but I would like users via the web, based upon their username and password, the ability to look at the data and view or print it out based on select criteria and a few relationships.

Approximately 85 users need the ability to view/print the data. 72 users (clubs) would only be able to look/print their data. 10 users would be able to look at between 5 - 10 clubs (region/zone), and 3 users would be able to look at all clubs.

The data is currently organized with the above relationships, i.e, each record in the database contains the club and region/zone field and it is required when they submit the data via the web. The MySql Database is updated with the information they submitted via the online reporting form.

I would envision the online link to send the user to a reporting page that requires the user to log in. Based on the username and password, for example, a club person, would only have access to their club's data. They could select a time period for which they want to review/print. A region/zone person would be able to look at all the club's they are responsible for. ( The username could be their club or region/zone and a password we assign each year).

The online web report would need to be username/password protected. Have the ability to select records based on date range, for a single club or multiple clubs (based on the above explanation), and then be viewed on the screen or printed to either an HTML form or PDF form.

Skills: MySQL, Website Design

See more: mysql data access, drop down list web design, online mysql database, report example, web report design, the period club, report design, period club, pdf report, mysql report, mysql database , mysql database design, field reporting, design report, html email mysql, database design record, web based database browser, pdf submit email, pdf form drop list, drop list database, web design data reporting, mysql view update, html form submit link, access database web based form, database example

About the Employer:
( 0 reviews ) United States

Project ID: #1521098

19 freelancers are bidding on average $239 for this job

toinnisfree

pls chk pmb

$435 USD in 5 days
(344 Reviews)
7.5
neoconcepts

we like to do this project . let's start.

$450 USD in 10 days
(67 Reviews)
6.9
canlan318

Dear sir. I sent you a private message. Please check it. Regards.

$250 USD in 3 days
(68 Reviews)
6.8
natgeo

Please see PM.

$230 USD in 10 days
(79 Reviews)
6.7
eperfections

Details in pmb

$525 USD in 7 days
(84 Reviews)
6.4
mikesteve

Hi, Expert Developer Here..Can provide efficient solution in less time..

$200 USD in 5 days
(47 Reviews)
6.1
udanaudayanga

Hello Ready to start. For more information please check inbox.

$180 USD in 3 days
(39 Reviews)
5.8
mike25

Hi, some remarks in your inbox. Regards, Mike

$250 USD in 20 days
(15 Reviews)
4.2
consc198

Please refer to our PM.

$150 USD in 10 days
(30 Reviews)
3.8
devloperIT

Mysql/php expeirienced

$250 USD in 3 days
(9 Reviews)
3.6
tomson1234

Please check PMB. Thanks.

$250 USD in 11 days
(1 Review)
1.0
crystallinehills

sir, i will really apprecaite if this job is giving to me. Please the money is not the issue but to bult a career and job experience

$100 USD in 5 days
(0 Reviews)
0.0
Y7LIB45sm

Check PMB please.

$250 USD in 1 day
(0 Reviews)
0.0
vimkgt

I can help implement this project in several different ways based on your system design. You mentioned the data is from MySQL but no mention of the website based around it, such as if it's a CMS system like Wordpress/J More

$200 USD in 4 days
(0 Reviews)
0.0
sahur

Hi, I am able to do this task as i have done same task earlier this year.

$65 USD in 6 days
(0 Reviews)
0.0
RinuBudhbhatti

Hello, As we say, time is money, lets get started :))

$100 USD in 5 days
(0 Reviews)
0.0
WsCubeTech

Hello bmpaccount, If you find some time to have a look at our bid and private message, we are keen to work with you in this project

$150 USD in 3 days
(0 Reviews)
2.6
ronakwm

pls check p_m

$249 USD in 7 days
(0 Reviews)
0.0
DJG13

Hello Sir, My job is creating templates for online store OpenCart.

$250 USD in 10 days
(0 Reviews)
0.0