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
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