Find Jobs
Hire Freelancers

Technosurveillance - MySQL simple database and PHP routines for webpages

$30-5000 USD

Opravljeno
Objavljeno pred skoraj 13 leti

$30-5000 USD

Plačilo ob dostavi
It is project about MySQL DB connection, independent from user interface (user interface design is not included in the scope). Includes several scripts in PHP. 1. Build a simple database in MySQL (about 7 tables with total 45 fields), according to access DB provided. 2. Provide a way to populate the MySQL DB from a web page (Provided). For final users. 3. Provide a way to see details of registers configured by users in point 2 with the same format used in 2. (web page provided). For Administrator. 4. Provide a way to see summary of the registers in a web page (provided). For Administrator. 5. Provide a way to filter the registers included in the summary search according to search criteria provided. For Administrator. 6. Provide a way to populate the MySQL DB through uploading an excel-like file. For Administrator. ## Deliverables It is project about DB connection, independent from user interface (user interface design is not included in the scope). The project consists on the construction of a database in MySQL to be populated from a web page. the web page is already designed and provided in the documentation. It is a form with about 45 fields mainly in text format. Every time that an event related with medical devices happens, the users can enter the web page and report the issue by registering the information in the form. The administrator must have the possibility to see the registers entered by users in the same format (using the same webpage forms used to populate the DB). In addition, the administrator must have the possibility to see a summary of registers in a table in a web page (web page provided). Besides, a function to filter the summary is also needed. Finally, a method to populate the DB through an excel-like file upload should be provided. See description of requirements in detail as follows: 1. Build a simple database in MySQL (about 7 tables with total 45 fields), according to access DB provided. Inputs: - Access file: Techno Surveillance v1.0 accdb. It includes the tables with fields, format fields and 3 examples of registers, just for reference and better understanding of relationship between tables. - A special table <Tittles> is provided, in order to display the name of the fields in different language (Spanish), using the English names for the programming. 2. Provide a way to populate the MySQL DB from a web page (Provided). For final users. - Input: Web Page: Index.html. Users making a report, goes in the web page provided, and filled the forms. - - The file [login to view URL] and Forms with field [login to view URL] are provided to show the relationship between the field in the wepage and the fields in the access database. - Only The following button functions must be provided. Don't care the other buttons. - Reports -> Send: Create a register with the information provided in the forms. If a mandatory field is not filled, provide a warning message and give opportunity to fill it up. - Reports->Save Draft: Create a temporary file in local folder called <temp>, with the information filled so far. The file name is the same email input by user. - Reports->Load Draft: Load the temporary file saved in local folder called <temp>. The file name is the same email input by user in the form. Overwrite any information filled before the load action. - Include a NEXT and PREV buttons to navigate through the reports in chronological order. Use any space available in the webpage provided. 3. Provide a way to see details of registers configured by users in point 2 with the same format used in 2. (web page provided). For Administrator. - The same webpage form used to enter the information by the user, is used to see the information by administrator (accessed through a different link, for example the summary in point 3). 4. Provide a way to see summary of the registers in a web page (provided). For Administrator. - Input:webpage summary.html. - A special consult <event summary> is provided to see the information to be seen in the summary, as a table format. - Every register can be fully seen through a click in the column <see report>. 5. Provide a way to filter the registers incluided in the summary search according to search criteria provided. For Administrator. - The information provided in the <search> bar, is a filter for the registers. Only regarding the fields in the summary. Other fields not included in the summary, don't need to be checked - Provide an additional method to filter from a specific date to a specific date. This feature is not provided in the webpage, so it must be included in some unused area of [login to view URL] with any format suggested.
ID projekta: 3350317

Več o projektu

6 ponudb
Projekt na daljavo
Aktivno pred 13 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
See private message.
$212,50 USD v 6 dneh
5,0 (9 ocen)
4,1
4,1
6 freelancerjev je oddalo ponudbo s povprečno vrednostjo $351 USD za to delo
Avatar uporabnika
See private message.
$595 USD v 6 dneh
4,3 (61 ocen)
6,1
6,1
Avatar uporabnika
See private message.
$310,25 USD v 6 dneh
5,0 (22 ocen)
4,2
4,2
Avatar uporabnika
See private message.
$97,75 USD v 6 dneh
5,0 (12 ocen)
3,1
3,1
Avatar uporabnika
See private message.
$255 USD v 6 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
See private message.
$637,50 USD v 6 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava COLOMBIA
Bogota, Colombia
5,0
10
Plačilna metoda je verificirana
Član(ica) od nov. 7, 2010

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.