Re: PHP code in a MySQL record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Either what Kris says, or you can use a templating engine.

See Smarty (http://smarty.php.net)

On 7/29/05, Kristen G. Thorson <kthorson@xxxxxxxxxxxxxxxxxxxxxx> wrote:
> Is there a particular reason you need *PHP* in the database?  If not,
> then use a placeholder system of some sort ( like #var# ) and str_replace():
> 
> while( $row=mysql_fetch_row($result) ) {
>     echo str_replace( '#var#', $that_var, $row['entry'] );
> }
> 
> 
> 
> kgt
> 
> 
> 
> 
> Nathaniel Hall wrote:
> 
> >I am working on a project that uses an index.php page.  Depending on the
> >variable in the URL, a different php page is included.  I have a
> >config.php that contains variables that are accessible from any page.
> >That is the easy part.
> >
> >I have some pages pulling HTML out of a database. I would like to be
> >able to reference some of the variables in the config.php in the
> >database blob field.  Here is an example:
> >
> >index.phphalln_\@_otc_\._edu
> >------
> ><html><head>...etc
> ><?php
> >       include 'config.php';
> >       if (blabla) {
> >               include "thispage.php";
> >       } else {
> >               include "thatpage.php";
> >       }
> >?>
> >
> >config.php
> >------
> ><?php
> >       $this_var=1;
> >       $that_var="Nothing";
> >?>
> >
> >test.php
> >------
> ><?php
> >       $query="SELECT * from table";
> >       $result=mysql_query($query) or die ("Cannot process query");
> >       $row=mysql_fetch_row($result);
> >       echo $row[1];
> >?>
> >
> >MySQL record:
> >------
> >id,year,month,day,entry
> >
> >1,2005,01,01,This is a test<br><? echo $that_var; ?>
> >
> >_____________________________
> >I have tried using <br>&gt;? echo $that_var; ?&lt; and I have tried
> >escaping everything, but that still didn't work.  Any ideas?
> >
> >Nathaniel Hall
> >halln_\@_otc_\._edu
> >
> >
> >
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux