Re: [PHP] PHP code in a MySQL record
Either what Kris says, or you can use a templating engine.
See Smarty (http://smarty.php.net)
On 7/29/05, Kristen G. Thorson <[EMAIL PROTECTED]> 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:
> >
> >[EMAIL PROTECTED]
> >--
> >...etc
> > > include 'config.php';
> > if (blabla) {
> > include "thispage.php";
> > } else {
> > include "thatpage.php";
> > }
> >?>
> >
> >config.php
> >--
> > > $this_var=1;
> > $that_var="Nothing";
> >?>
> >
> >test.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
> >
> >_
> >I have tried using >? echo $that_var; ?< and I have tried
> >escaping everything, but that still didn't work. Any ideas?
> >
> >Nathaniel Hall
> >[EMAIL PROTECTED]
> >
> >
> >
>
> --
> 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
Re: [PHP] PHP code in a MySQL record
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:
[EMAIL PROTECTED]
--
...etc
config.php
--
test.php
--
MySQL record:
--
id,year,month,day,entry
1,2005,01,01,This is a test
_
I have tried using >? echo $that_var; ?< and I have tried
escaping everything, but that still didn't work. Any ideas?
Nathaniel Hall
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP code in a MySQL record
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: [EMAIL PROTECTED] -- ...etc config.php -- test.php -- MySQL record: -- id,year,month,day,entry 1,2005,01,01,This is a test _ I have tried using >? echo $that_var; ?< and I have tried escaping everything, but that still didn't work. Any ideas? Nathaniel Hall [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
