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]
--
htmlhead...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 testbr? echo $that_var; ?
_
I have tried using brgt;? echo $that_var; ?lt; 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
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]
--
htmlhead...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 testbr? echo $that_var; ?
_
I have tried using brgt;? echo $that_var; ?lt; 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
[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]
--
htmlhead...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 testbr? echo $that_var; ?
_
I have tried using brgt;? echo $that_var; ?lt; 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
