> From: R.S. Herhuth
> Sent: Thursday, April 11, 2002 4:41 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Dynamic querys to SQl Server
>
> Basically what I have created so far is a page that dynamically builds
> all of the column names of a database. I have assigned each a unique
> variable name. When the user selects the check box next to the name and
> submits the form, I am using the HTTP_POST_VARS() to explode out the
> variables on the following page. What I need to do though is create a
> way to dynamically query the DB only returning the selected columns.
> What is an efficient way of doing this?
>
> Does anyone know of any tutorials or examples that can get me close?
Effective and effective, and don't know if my suggestion is, but I (at
least the way I like to design things) is to pull all these things into
the database it self (but to be honest, it might mainly be because I
think it so bloody boring to write these web scripts.)
Anyhow, I uses the web server to passes (logical) messages to the data base,
and then the RDBMS resolves the requested "service" by performing some magical
dynamic bindings, e.g. looks up the proper stored procedure to execute, pass,
if needed, arguments and parameters to the stored procedure, and then BANG -
just feed back the answer to the web server, were the only purpose of the
web serer is to display whatever result set that was returned by the RDBMS.
So basically I view the web server only as a user interface management system,
and it purpose is only to display the information, and provide a communication
channel to the RDBMS to the enduser - no data processing is done at the webserer
end, mainly because the web server does have no clue what so ever what included
in the data base.
What do I win with this? Well, I only once write a general communications
system at the web server end, and then I never ever need to do any more
programming at the webserver end since everything is controlled by the
RDBMS instead - no need for so called web-"programmers" anymore. A database
programmer is the only thing needed.
So the ingrediens for this cake is:
one Web Server
one RDBMS
a bit of Dynamic Name Binding
and lots of Information Hiding
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
