Searchable Dynamic Web Pages - Principles & Method ?

[Bint Box]

Hi,

Would anyone please be able to assist in providing a summary of the principles and methods associated with creating dynamic web pages that can search a back end database and return the query results to a query output web page?

I hope to be able to set up a smallish database using either SQLite3 or MySQL and get some web pages created that will allow users to select values from drop down lists or enter free text and run a query on the database. The query could be activated by a button on the web page where the user selects the query parameters and once the data set has been obtained it should be displayed onscreen in a tabular layout.

I am familiar with the principles and methods to do similar stuff using an access database on a local PC using queries, forms, reports etc but when it comes to an online implementation along similar lines I just don't know where to start. I do not have the skills to do the online implementation so will need to hire someone to do it for me. However, before I look for a coder I just wish to understand what the principles are behind the process.

It is for an interest group associated with a hobby rather than a corporate work requirement if that makes any difference to the level of security and complexity of the need.

Any advice most appreciated.


Rgds
Binty

 

[Bint Box]

Create, Retrieve, Update, Delete. CRUD. Would be a bit easier if you gave a more specific example of what you're after. A single button that says "Get All"? Or a box where the user enters information to search etc.

FabienO,

I thought that I had indicated that it was to retrieve data sets based on the user entering or selecting values that are then used to query the database and return the query result??

I hope to be able to set up a smallish database using either SQLite3 or MySQL and get some web pages created that will allow users to select values from drop down lists or enter free text and run a query on the database. The query could be activated by a button on the web page where the user selects the query parameters and once the data set has been obtained it should be displayed onscreen in a tabular layout.

Am I missing something, the user selects the query parameters from either drop down box lists or free text entry into boxes, after selecting the filters the user clicks a button and retrieves a table of the query result. There is only R from CRUD involved, no creation of new records, no updating of existing records, no deleting of existing records, just a retrieval based on the filters entered by the user in the boxes.



Rgds

 

[Bint Box]

Thank you all for your help.

If I could just ask for clarification on a couple more points, would I look to get a fixed price from a coder for the job based on a specification? Or, look to hire a coder on an hourly rate? I really have no idea which approach I should take for web development. I have a good idea of the queries I wish to make available so am in a position to provide a reasonable specification.

Also, on the assumption that I need 10 HTML forms developing each one capable of running a separate query what ball park figure should I be looking to pay? I have the database setup on a local PC, all it needs is uploading to the web server then the HTML forms can be created.


Rgds
Binty