Hi all,
I'm new to php but not to programming. I've chosen php as the the language to write a front end to an Oracle database because I want something straight forward and quick to develop a UI in and php seems to fit the bill. So why am I here? Well I have a design question and I like some input from the experts:
I have a HTML form that has a number of ‘List of Value’ fields (title, occupation etc.) that are displayed as <SELECT> tags. Nothing unusual here I suspect.
I have a stored procedure that returns a ref cursor to a query that returns a list of values. For each LoV field I call the stored procedure and loop through the results to build up my <OPTION> tags.
It’s simple and it works. So what?
On a more complex form this approach could involve many round trips to the database. I am thinking this is bad for scalability? I could make one call to a stored procedure to return all of the data I need in one go. I would pass the LoV IDs as an XML string to the procedure which would return all the LoV values back via another XML string. Both Oracle and PHP have strong XML support so this would be pretty easy but would it be a better approach?
Of course there may be more important considerations to worry about! I'm at the start of the project and the whole thing is a learning experience so all comments are welcome.
Thanks.
php / Oracle design question
Moderator: General Moderators