Oracle Query from Web Page 1

[ADB1]

All,

How hard is it to set up a basic Oracle SQL query from a form /input box on a web page then return a list of figures from the database wiht inthe browser?!

Thanks in advance.

A.

 

[Foamcow]

Use PHP. It has built in functions for connecting to Oracle databases.

http://uk.php.net/oracle

Foamcow Heavy Industries - Web design and ranting
Toccoa Games - Day of Defeat gaming community
Target Marketing Communications - Advertising, Direct Marketing and Public Relations
"I'm making time

 

[ADB1]

Superb thanks.

But this is where I get annoying! I know basic html etc where would this fit into a very very simple html page with an input box or go button for the query execution?!

A.

 

[Foamcow]

You would need to write a PHP script to take the input from the box and execute the query accordingly.

I've not worked with Oracle but with MySQL the basic (and very generalised) process is as follows.

[ul]
[li]Create the form in HTML and assign unique id's to the fields[/li]
[li]When the form is submitted execute the PHP script (there are a number of ways to do this)[/li]
[li]Using PHP get the values that were input into the form[/li]
[li]Open a connection to the Oracle server
[li]Using those values, formulate your Query and throw it at the Oracle server[/li]
[li]Get the Query results... do something with them[/li]
[/ul]

Very general... you'd also need to parse the form info and check it, do some error checking on the connections etc.

Foamcow Heavy Industries - Web design and ranting
Toccoa Games - Day of Defeat gaming community
Target Marketing Communications - Advertising, Direct Marketing and Public Relations
"I'm making time

 

[ADB1]

Thanks! I'll have a play...