Smart Data Collection

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 6

Project Description

The project is to develop a php/html/jquery data collection script that will be used to populate and update a Microsoft SQL Server Express database. The form will have one dynamic dropdown field (which populates automatically from the database) and about 4 static drop down fields. There are also some fields on the form that would need to be automatically filled when an item is selected from the dropdownlist while the rest of the fields will be entered by the user based on data collected from the field; In a situation where the required item does not exist in the dropdownlist, the script should provide blank fields for the user to enter all the information manually.

The created form will be pushed onto a smart trimble GPS that uses a software called field Inspector. The users will use the smart GPS to collect the field data and then upload the information to the database via a web access when they are not in the office or via the usb connection when they are in the office.

So far I have created the database and the various tables required for storing the data. I have also installed and configured the smart GPS to communicate with the SQL server database. I have also created an html form with the dropdown fields (Screenshots attached with the script error at the bottom) but I have not been able to get my dynamic dropdown listing to populate from the SQL server database and so not yet able to get the fields that needs to be automatically filled when an item is selected from the dropdown list to do so. This is how far i have gotten with this project.

I will appreciate to hear from anyone who is very proficient with PHP,JQuery and SQL Server database. (Please note that SQL Server is different from MySQL). I am also attaching my script here to serve as a basis if needed.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online