1 reply to this topic

[highamperage]

I am looking for some pointers… I have a hosting package which includes a number of mySQL databases. I would like to create a web based front end/entry form that allows people to enter data, and then submit it where it is saved in the mySQL database…(and also allows recall via an identifier) so I can then run queries on it using SQL Server Studio, dbVisualizer, or some other similar SQL tool.

I have some experience scripting SQL, and I think I can setup the database ok. The issue I am having is how to create and connect a web based form to the database. I would rather not create this at the code level and am hoping there is a simple solution, such as a program or service which I can enter parameters such as field names, and use a template.
Does anyone have any pointers?

[Kaishain]

I'm not aware of any templates that you could use for that, but it's not too difficult to set up a simple form yourself.

I'm guessing that your hosting package is a web hosting package provided by a third party. They usually offer PHP hosting as well, so I'd recommend creating a simple PHP form yourself.

The following tutorial is pretty easy to follow and should quickly show you how to set up a PHP page and add form fields to it and then connect it to your database: PHP/MySQL Tutorial - Part 1

Assuming you already know the SQL you want to execute to insert the values, this should be pretty straightforward for you.


Hope it helps!