php evaluated directly by mysql and not the webserver ?

Re: php evaluated directly by mysql and not the webserver ?

Heinz wrote:[color=blue]
> Hi there
>
> Out of curiosity ....
>
> Long time ago I was working with Infomix (now IBM) Universal Server, that
> had a data type 'html' implemented as data blade. Through data blades you
> could extend the sql engine with your own data types.
>
> Can't remember exactly how it worked but you could store html with embedded
> 'sql code' in the database.
> If you ran a query against that 'page', values from the query where passed
> to the code in the page and then the page was evaluated directly by the
> database engine. The output was plain html as in evaluating php by a
> webserver.
>
> So is there similar work underway with php being evaluated directly by
> mysql, instead of the web server ?
>
> Cheers
> Heinz[/color]

Any execution of code in the database server is down to stored
procedures. MySQL are going to implement in version 5.0 initially to
execute something like Oracle's PL/SQL with links to external languages.
php will probably be one of the first as there seems to be a lot of
interest in using it.

http://www.mysql.com/doc/en/ANSI_diff_Triggers.html

Re: php evaluated directly by mysql and not the webserver ?

nc@iname.com (Nikolai Chuvakhin) wrote:
[color=blue]
>"Heinz" <lullundlall@ya hoo.com> wrote in message
> news:<bq7ld7$1v niim$1@ID-25174.news.uni-berlin.de>...[color=green]
>>
>> Long time ago I was working with Infomix (now IBM) Universal Server, that
>> had a data type 'html' implemented as data blade. Through data blades you
>> could extend the sql engine with your own data types.
>>
>> Can't remember exactly how it worked but you could store html with embedded
>> 'sql code' in the database.
>> If you ran a query against that 'page', values from the query where passed
>> to the code in the page and then the page was evaluated directly by the
>> database engine. The output was plain html as in evaluating php by a
>> webserver.[/color]
>
>Was that before or after database security became an issue? What
>you are describing sounds like a huge disaster waiting to happen...
>[color=green]
>> So is there similar work underway with php being evaluated directly by
>> mysql, instead of the web server ?[/color]
>
>I hope not.
>
>Cheers,
>NC[/color]

How is that any different than being able to run JAVA in Oracle?
Thanks
Mike Johnston

Re: php evaluated directly by mysql and not the webserver ?

Not but maybe eval() is what you need if you want to store PHP code in a
MySQL db and they tell the webserver to execute these code as PHP. But
directly MySQL can't run PHP code. It would be a disaster if it happen. And
this is not what a db should have to do.

Savut

"Nikolai Chuvakhin" <nc@iname.com > wrote in message
news:32d7a63c.0 311281507.25055 d00@posting.goo gle.com...[color=blue]
> "Heinz" <lullundlall@ya hoo.com> wrote in message
> news:<bq7ld7$1v niim$1@ID-25174.news.uni-berlin.de>...[color=green]
> >
> > Long time ago I was working with Infomix (now IBM) Universal Server,[/color][/color]
that[color=blue][color=green]
> > had a data type 'html' implemented as data blade. Through data blades[/color][/color]
you[color=blue][color=green]
> > could extend the sql engine with your own data types.
> >
> > Can't remember exactly how it worked but you could store html with[/color][/color]
embedded[color=blue][color=green]
> > 'sql code' in the database.
> > If you ran a query against that 'page', values from the query where[/color][/color]
passed[color=blue][color=green]
> > to the code in the page and then the page was evaluated directly by the
> > database engine. The output was plain html as in evaluating php by a
> > webserver.[/color]
>
> Was that before or after database security became an issue? What
> you are describing sounds like a huge disaster waiting to happen...
>[color=green]
> > So is there similar work underway with php being evaluated directly by
> > mysql, instead of the web server ?[/color]
>
> I hope not.
>
> Cheers,
> NC[/color]

Re: php evaluated directly by mysql and not the webserver ?

"Heinz" <lullundlall@ya hoo.com> wrote in message
news:<bq7ld7$1v niim$1@ID-25174.news.uni-berlin.de>...[color=blue]
>
> Long time ago I was working with Infomix (now IBM) Universal Server, that
> had a data type 'html' implemented as data blade. Through data blades you
> could extend the sql engine with your own data types.
>
> Can't remember exactly how it worked but you could store html with embedded
> 'sql code' in the database.
> If you ran a query against that 'page', values from the query where passed
> to the code in the page and then the page was evaluated directly by the
> database engine. The output was plain html as in evaluating php by a
> webserver.[/color]

Was that before or after database security became an issue? What
you are describing sounds like a huge disaster waiting to happen...
[color=blue]
> So is there similar work underway with php being evaluated directly by
> mysql, instead of the web server ?[/color]

I hope not.

Cheers,
NC

Re: php evaluated directly by mysql and not the webserver ?

Heinz wrote:[color=blue]
>
> So is there similar work underway with php being evaluated directly by
> mysql, instead of the web server ?[/color]

Surely, to do that, you'd have to make mySQL the server that replied to
HTTP requests, and get rid of Apache altogether, otherwise Apache is
always going to be the system that reads through requested documents to
see what needs doing?
--
Bob
London, UK
echo Mail fefsensmrrjyahe eoceoq\! | tr "jefroq\!" "@obe.uk"

Hi there

Out of curiosity ....

Long time ago I was working with Infomix (now IBM) Universal Server, that
had a data type 'html' implemented as data blade. Through data blades you
could extend the sql engine with your own data types.

Can't remember exactly how it worked but you could store html with embedded
'sql code' in the database.
If you ran a query against that 'page', values from the query where passed
to the code in the page and then the page was evaluated directly by the
database engine. The output was plain html as in evaluating php by a
webserver.

So is there similar work underway with php being evaluated directly by
mysql, instead of the web server ?

Cheers
Heinz