473,327 Members | 2,103 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

php evaluated directly by mysql and not the webserver ?

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
Jul 17 '05 #1
5 1765
Heinz wrote:

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


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 fefsensmrrjyaheeoceoq\! | tr "jefroq\!" "@obe.uk"
Jul 17 '05 #2
"Heinz" <lu*********@yahoo.com> wrote in message
news:<bq*************@ID-25174.news.uni-berlin.de>...

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.
Was that before or after database security became an issue? What
you are describing sounds like a huge disaster waiting to happen...
So is there similar work underway with php being evaluated directly by
mysql, instead of the web server ?


I hope not.

Cheers,
NC
Jul 17 '05 #3
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:32**************************@posting.google.c om...
"Heinz" <lu*********@yahoo.com> wrote in message
news:<bq*************@ID-25174.news.uni-berlin.de>...

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.


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


I hope not.

Cheers,
NC

Jul 17 '05 #4
nc@iname.com (Nikolai Chuvakhin) wrote:
"Heinz" <lu*********@yahoo.com> wrote in message
news:<bq*************@ID-25174.news.uni-berlin.de>...

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.


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


I hope not.

Cheers,
NC


How is that any different than being able to run JAVA in Oracle?
Thanks
Mike Johnston
Jul 17 '05 #5
Heinz wrote:
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


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

Jul 17 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Bob | last post by:
Hi, I have a website in a Linux/Apache shared hosting environment and have been given access to the MySQL server running on the same machine. To access this database from PHP, I have to call...
7
by: Alex Hunsley | last post by:
A while ago I found a mysql/php/webserver bundle of software for windows that installed all three at once and made it easy to start developing sql/php web apps. Now I can't remember what it was or...
9
by: Sheldon | last post by:
Hi, I have a mysql setting problem that is driving me mad. Hopefully someone can give some advice: On the local network I have windows 2000/iis5 machine running our intranet site, with php...
2
by: Otto Leholt | last post by:
Hi I have made several website using MS Access and asp. Now I need to upgrade from Accesss to MYSQL - I got my website working with MYSQL on my local PC - but now the problem is how I get it...
29
by: smorrey | last post by:
I've been thinking on this long and hard, and I can't seem to come up with an answer on it. Why is it almost always assumed the MySQL will be the server for nearly any PHP app? Why is it...
8
by: Dung Ping | last post by:
My attempt to install php and mysql to my computer failed. There are errors with both installations. I believe the problem is with my computer or the Windows XP in it. My computer is an old and...
2
by: ¥|¥J | last post by:
Dear all, Please help~~ I have a problem in connecting my new FC5 webserver (apache 2.2 + php 5.1.4) to a few database servers through the PHP scripts (RH9, FC2, FC3). I have set host...
5
by: Ben | last post by:
Hi, i would like to have an explanation about this: This works, but i get the message in code-behind: access of shared member,... or nested type through an instance; qualifying expression will...
0
by: Pablo | last post by:
Hello, I have read some books, blogs and tutorials about managing data in php5, but all are focused on mysql, instead native xml. They talk about the new php5 xml functions, xml as web services,...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.