php evaluated directly by mysql and not the webserver ?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Heinz

    #1

    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


  • Robert Downes

    #2
    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"

    Comment

    • Nikolai Chuvakhin

      #3
      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

      Comment

      • Savut

        #4
        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]


        Comment

        • Mike Johnston

          #5
          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

          Comment

          • Kevin Thorpe

            #6
            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

            Comment

            Working...