Can I configure a web page to interact to a database?

Question

I need to create/configure a form on my website to talk to a database full of information. The form would have to allow users to press a button labeled, "Get Random Flight." That button/form would then go talk to the database and get a random flight/info out of the database. The database would them have to deliver that flight/info back to the form/website and there would have to be a way for the user to simply select one button and the website will copy the info the database gave you and allow the user to paste it into an email. I know this isn't easy to understand but it anyone can help me it would be most appreaciated.

Thank you!!

Answer 1

Yes, you can do it. You need a Web hosting account that includes access to a database server and programming capabilities.

Answer 2

1) you need a programming language.
2) you need some application on the server that makes the data available.

for 1, I suggest JS to do an xmlhttprequest. or you can do all the dirty work on the server in your custom cgi.

for 2, depending on wether you need a live feed or a extract, you can use a custom cgi (perl,php,asp,jsp, whatever) app or a simple extract util that comes with almost every database system.

Answer 3

You will be looking a php and mysql. Php is a scipting language which makes interaction between the database (mysql) and the webserver much easier.

Php isn't a difficult language to learn and is widely used by large and small corporations alike and best of all both mysql and php are open source products meaning they are free to download and use.

Answer 4

you just need a hosting account that has MySQL DB capabilities, and sound slike you need some PHP coding knowledge too.