why is this not parsing?

satch

ok please help me, i am pulling my hair out over here.

I have this file...

<?

$today = date("m-d-y");

#load templates
function load_template($name){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return "$row[template]";
}

echo stripslashes(load_template(start_page));
?>

the template in the database has this in it:

	
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">

<html>
<head>
<title>Untitled</title>
</head>
<body>
$today

but when the template is called to the page the variable is not parsed, it just comes up as &today. How do I get php variables to work in this sort of set up? Thanks in advance!

🆒

benwestgarth

Just a guess, but try passing $today to your function as a second argument. ie.

<?

$today = date("m-d-y");

#load templates
function load_template($name, $today){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return "$row[template]";
}

echo stripslashes(load_template(start_page, $today));
?>

7khat

return "$row[template]"; -- BAD
return $row['template']; -- GOOD

satch

Nope, I tried both.. now the code is like this..

<?
require "./header.php";

#set variables for time:
$today = date("m-d-y");

#load templates
function load_template($name){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return $row['template'];
}

echo stripslashes(load_template(start_page));
?>

still comes through as &today.. any other ideas?

bernouli

sorry wrong codes

winterbeef

Originally posted by satch
Nope, I tried both.. now the code is like this..

<?
require "./header.php";

#set variables for time:
$today = date("m-d-y");

#load templates
function load_template($name){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return $row['template'];
}

echo stripslashes(load_template(start_page));
?>

still comes through as &today.. any other ideas? [/B]

I'm assuming that start_page is a variable passed in on the QueryString/Post/Cookie/Session:

echo stripslashes(load_template(start_page));
--- is missing a '$' ----
echo stripslashes(load_template($start_page));

HTH

satch

ok, seems to be confusion.. I have a mysql database with HTML templates in it. One is called start_page that contains:

<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">

<html>
<head>
<title>Untitled</title>
</head>
<body>
$today

Then I have a php script that access that database and displays the content to the browser. The $today variable is declared on that script before the template is loaded from mysql

<?
#connects to database
require "./header.php";

#set variables for time:
$today = date("m-d-y");

#load templates
function load_template($name){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return $row['template'];
}

#load the start_page template
echo stripslashes(load_template(start_page));
?>

The code is displayed correctly, but the variable $today does not get parsed, it just displays as $today at the end of the template. I hope that helps clear up my problem.. Thanks guys for your help!
🆒

winterbeef

satch,

No confusion; I understood that. But there are 2 problems:

Problem 1:
Still, the function load_template() expects a string.
That string is used to find a matching record in the db -- i.e.: SELECT template FROM surf_templates WHERE name ='$name'
The call to load_template() is
load_template(start_page)) -- but this cannot be.

What is start_page? It's an invalid identifier; $start_page would be a valid string.

Problem 2:
What you get returned from the db is a string, not PHP code.

Change :
echo stripslashes(load_template(start_page));
to:
eval(' ?>'.load_template(start_page).'<?php ');

The close & open PHP tags are necessary because the eval is "inside" a PHP block and you need to jump out (then back in again) for the duration of the eval.

HTH

winterbeef

Whoops!

eval(' ?>'.load_template(start_page).'<?php ');

should be

eval(' ?>'.load_template($start_page).'<?php ');

Try that!

satch

start_page is the template I am loading with the function.

the table is set up like this:

table surf_templates
id int;
name varchar;
template text;

so i assume that the funtion load_templates:

#load templates
function load_template($name){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return $row['template'];
}

will grab the "template" content of the row $name I send it. In this case "start_page".

I just can't seem to get the $variables to parse at all.. I have tried all of these ideas, and the end result is still displayed as the $variable_name.
Maybe I'm missing something here. I'll try a few more things.

winterbeef

Satch,

Originally posted by satch
...
will grab the "template" content of the row $name I send it. In this case "start_page".
...

AHA! Okay, so 'start_page' is NOT a variable, but a string itself. Fine, but you must call it thusly:

load_template('start_page')

and NOT:

load_template(start_page)

AND, you will want to eval() the thing, rather than echo() (see my last post)

HTH

satch

thank you so much for your help, but it is still not parsing the variable (see my "pulls out hair comment above")

here is where I stand

<?
#connect to database
require "./header.php";

#set variables for time:
$today = date("m-d-y");

#load templates
function load_template($name){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return $row['template'];
}



eval(' ?>'.load_template('start_page').'<?php '); 

?>

still returns this:


<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">

<html>
<head>
<title>Untitled</title>
</head>
<body>
$today

that is exactly what is in that template, but I am hopeing to parse the $variable(s)

(and remove the slashes, but I can do that with a stripslashes() )

any other ideas?

winterbeef

replace $today in the template with <?php echo $today;?>

HTH

satch

that worked!

but the goal was to have the template read into a print statement, that way I wll not need to declare php tags in templates database..

for example:

print("this is the template content, it is $today");

would become:

echo load_template('start_page');

the templates have the slashes and such in them, that way I can just add the code as it would be in a print statement or such.. Does this seem like a good idea? or does it not really matter

again, thanks for the help

winterbeef

Hmmm...I don't think you can do exactly that without putting '<?php' in your template.

Though, you might try something like this:

Template:

<b>%BOOK%</b> is my favorite book.<br>
<b>%PETNAME%</b> is my dog.<br>
Today is %DATE%.<br>

Get that into $template and then have the code use str_replace():

$data = array(
                                    '%BOOK%' => 'Neuromancer',
                                    '%PETNAME%' => 'Fluffy',
                                    '%DATE%' => date('m-d-Y'),
                                    '%COLOR%' => 'Kelly Green');

$src = str_replace( array_keys($data), array_values($data), $template);

Just be aware that in versions < 4.0.5 str_replace will not take arrays as parameters, but you can fake it with a simple loop.

HTH

7khat

Alternativly:

<?php
#connect to database
require "./header.php";

#set variables for time:
$today = date("m-d-y");

#load templates
function load_template($name){
$result=MYSQL_QUERY("SELECT template FROM surf_templates WHERE name ='$name'");
$row=MYSQL_FETCH_ARRAY($result);
return eregi_replace("\$today", $today, $row['template']);
}



eval(' ?>'.load_template('start_page').'<?php '); 

?>