Forms, reports and web display for a single table MySQL database.
- or -
Post a project like this- Posted:
- Proposals: 11
- Remote
- #2037765
- Awarded
Description
developing a PHP form for initial user data entry,
sending the results to a MySQL (or other) database hosted on United Hosting or a similar UK based cloud server (Russian server with an EU mirror is also acceptable). Only one table is involved,
designing forms with search functions to select and manage individual records,
designing interactive reports to select view and manage groups of records,
Display some fields and selected records from the MySQL database on a public web page.
I have attached an *.APT file which shows you my prototype in action. I have also attached a field list. I can also send the datatable in *.dbf or *.txt format for rapid creation of the fully filled example. The code chosen should be capable of displaying in English and Russian. Most of my team will be using Chrome on Chromeboxes but also Windows.
I am busy next week. I will assess proposals on Wednesday 20th May and demonstrate the operation of the existing (PC bound database).
I have specified PHP/MySQL because 1) it's available on United Hosting. 2) There is a lot of tutorial support so I can tweak it later. This has been prototyped and tested but in my experience databases need perpetual small adjustments. 3) There is a lot of expertise. If you think that there is an easy to use (In modern terms, I know a modest amount of Javascript. I have forgotten my Fortran) alternative, let me know. Zoho Creator and Knack have their own learning curves and a commitment to continuous expenditure. That said, if this project costs much more than a year's professional level subscription to either it is getting expensive.
20 June 2018
A file of live data in *.DBF format added. I can also save this data onto an SQL server directly given access codes. I think that there are tools for creating input forms directly from an SQL table so that part of the project should be straightforward.
There are actually two reports needing display. One on our intranet site (Google Sites) and one on our public website www.volgatrader.com/ (Weebly). I am open to offers for moving our Weebly site to our own server on United Hosting. There is a draft site in Concrete already there.
Philip O.
100% (11)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi again,
Can you advise what programme you use to create your .apt file?
Regards,
Carl.Philip O.08 Jun 2018The *.apt file is read only for data sharing. It was created with Lotus Approach (now obsolete). A live version would require Lotus Approach. *.apt allows the data to be shared and a limited degree of searching.
-
Hi Phillip,
Would I be correct in saying that none of the fields contain common information or several records that are the same. For example a column that contains a company name several times because companies have several entries? etc. If so it would be very inefficient and a bar to proper interrogation if the data was not rationalised into linked tables.
I feel that is a job is worth doing it worth doing well.
Regards,
Carl.Philip O.08 Jun 2018There is no need for linked tables. While I am not used to on line computing, I am used to databases. I have another workflow applications that joins 27 different tables, some static, most dynamic (e.g. currency rates). Future development of this project will require linking additional tables containing details about, say agents, who will be involved in multiple projects.