Printing html and php from MySQL

VooDooRT

I'm having some problems echoing/printing an html/php header I entered into mysql.

The html part works fine, but when part of the code calls a php variable, I can't get it to work right.

Here is what I've tried:

<?php echo"$myrow[title]" ?>

This shows up something like this:
http://www.fuziontek.com/<?php

It's supposed to show up like this:
http://fuziontek.com/ftek6/link.php

I also tried this:

$myrow[title]

But this shows up like this:
http://www.fuziontek.com/$myrow[title]

I've tried with quotations, and without, I've tried with a php echo statement, and without...nothing seems to work.

Basically, I'm calling a file called header.php as the header in my files, and header.php calls on a mysql table entry that has the html/php stored in it. I wouldn't think you would need to put in php tags, because the header.php file is all php, and doesn't tag out before the include...But, it's not showing up correctly...

I dunno what the deal is...ugh....

JoelyUK

Originally posted by VooDooRT
Basically, I'm calling a file called header.php as the header in my files, and header.php calls on a mysql table entry that has the html/php stored in it. I wouldn't think you would need to put in php tags, because the header.php file is all php, and doesn't tag out before the include...But, it's not showing up correctly...

If I understand that bit correctly, which could also be causing this whole problem, then this snippet from PHP.net's guide on include(); will explain:

When a file is included, parsing drops out of PHP mode and into HTML mode at the beginning of the target file, and resumes again at the end. For this reason, any code inside the target file which should be executed as PHP code must be enclosed within valid PHP start and end tags.

I could be way wrong though 😉

VooDooRT

More info:

When I use

$myrow[site_url]/images/image.gif

I get:
http://www.fuziontek.com/ftek6/admin/$myrow[site_url]/images/topleftbg.gif

Where fuziontek.com/ftek6/admin is the location of the file calling the sql query.

When I use

<?echo php "$myrow[site_url]" ?>

I get
http://www.fuziontek.com/ftek6/admin/<?php echo

SO....

It keeps putting the files directory in there, THEN errors out on the sql call....

Hell if I know what's happening here...

JoelyUK

Erm, out of guess work... try this:

{$var}

Where you are trying to echo variables, instead of <?php echo $var; ?>

VooDooRT

trying it now...

What's it do? lol

VooDooRT

negative, comes up as

http://www.fuziontek.com/ftek6/admin/{$myrow[site_url]}/images/topleftbg.gif

JoelyUK

It echos a variable in an echo statement, without having to close an "" etc.

Just another "see if it works" guess, Im afraid.

I see your problem, I just cant get my head round it..lol

JoelyUK

Ok, can you show some of the code for how you make up the links (including any HTML etc.)

I may collapse from tiredness shortly, but I'll keep trying and let you know tomorrow if I work something out 🙂

JoelyUK

Uh...have you tried this:

<?php echo $myrow[site_url]; ?>

Just discounting another posibility 😉

VooDooRT

Here is the file that calls the mysql query...

<?php
require("/home/voodoo/public_html/ftek6/db_connect.php");

$result = mysql_query("SELECT * FROM site_info, links, header, templates");
$myrow = mysql_fetch_array($result);

?>
<html>

<head>
<TITLE><?php echo "$myrow[title]" ?></TITLE>
<meta name="AUTHOR" content="Jason R. Churchill, (<?php echo "$myrow[admin_email]" ?>)">
<meta name="COPYRIGHT" content="<?php echo "$myrow[copyright]" ?>">
<meta name="DESCRIPTION" content="<?php echo "$myrow[description]" ?>">
<meta name="KEYWORDS" content="<?php echo "$myrow[keywords]" ?>">
<meta name="TITLE" content="<?php echo "$myrow[title]" ?>">
<SCRIPT language=Javascript src="<?php echo "../$myrow%5Bsite_url%5D" ?>/scripts/fade.js"></SCRIPT>
<style>
a:link  {text-decoration: none; color: <?php echo "$myrow[link]" ?>}
a:visited {text-decoration: none; color: <?php echo "$myrow[link]" ?>}
a:active {text-decoration: none; color: <?php echo "$myrow[link]" ?>}
a:hover {text-decoration: none; color: <?php echo "$myrow[link_visited]" ?>}
input        { font-family: <?php echo "$myrow[form_text]" ?>; font-size: <?php echo "$myrow[form_text_size]" ?>; color: <?php echo "$myrow[form_text_color]" ?>;
               font-style: font-weight: bold; 
               border: 2px solid <?php echo "$myrow[form_border_color]" ?>; background-color: <?php echo "$myrow[form_bg_color]" ?>;}
textarea     { font-family: <?php echo "$myrow[form_text]" ?>; font-size: <?php echo "$myrow[form_text_size]" ?>; color: <?php echo "$myrow[form_text_color]" ?>; 
               font-style: font-weight: bold; 
               border: 2px solid <?php echo "$myrow[form_border_color]" ?>; background-color: <?php echo "$myrow[form_bg_color]" ?>;}
select       { font-family: <?php echo "$myro3w[form_text]" ?>; font-size: <?php echo "$myrow[form_text_size]" ?>; color: <?php echo "$myrow[form_text_color]" ?>; 
               font-style: font-weight: bold; 
               border: 2px solid <?php echo "$myrow[form_border_color]" ?>; background-color: <?php echo "$myrow[form_bg_color]" ?>;}
</style>
<style>
body {
scrollbar-3dlight-color: <?php echo "$myrow[scrollbar_3dlight_color]" ?>;
scrollbar-arrow-color: <?php echo "$myrow[scrollbar_arrow_color]" ?>;
scrollbar-base-color: <?php echo "$myrow[scrollbar_base_color]" ?>;
scrollbar-darkshadow-color: <?php echo "$myrow[scrollbar_darkshadow_color]" ?>;
scrollbar-face-color: <?php echo "$myrow[scrollbar_face_color]" ?>;
scrollbar-highlight-color: <?php echo "$myrow[scrollbar_highlight_color]" ?>;
scrollbar-shadow-color: <?php echo "$myrow[scrollbar_shadow_color]" ?>;
/* scrollbar-track-color: <?php echo "$myrow[scrollbar_track_color]" ?>;*/
}
</style>
</head>
<?php echo "$myrow[header]" ?>

And here is a file that calls THAT file...

Lots of them do...

<?php
require("core.php");
//Check to see if user has cookie set for login
$user_name = $usercook;
$password = $passcook;

setcookie("usercook", $user_name);
setcookie("passcook", $password);

include("/home/voodoo/public_html/ftek6/header.php");

//Check to make sure password and user name match mysql information
$mypw="";
pw_check($pw_sql, $user_name, $result, $mypw);
if($mypw[password] == $password and $user_name != NULL ) {

It's calling the html part of it great, just not letting me use variables...

VooDooRT

This is the actual line that's calling the table entry in mysql...

<?php echo "$myrow[header]" ?>

The rest of the first file (header.php) works just fine...just not the body...

JoelyUK

Try changing the echos to this instead:

<?php echo $myrow[site_url]; ?>

I think thats your problem - at least I hope its that simple.

JoelyUK

Ohhh hang onnn...

Does the variable $myrow[header] contain PHP from the database, which your trying to print on the page?

If so, I'm afraid I'm really not sure how you can do this, as my head can't think to save it's own life just now 🙂

e.g, if you printed out the content, you get:

$myrow[header] = "<?php echo $blah; ?>HTML HTML HTML";

etc.

VooDooRT

Originally posted by JoelyUK
Ohhh hang onnn...

Does the variable $myrow[header] contain PHP from the database, which your trying to print on the page?

If so, I'm afraid I'm really not sure how you can do this, as my head can't think to save it's own life just now 🙂

e.g, if you printed out the content, you get:

$myrow[header] = "<?php echo $blah; ?>HTML HTML HTML";

etc.

EGGZACTLY! LoL

That's excatly what's happening...

VooDooRT

Still no luck....any ideas?

JoelyUK

I can't think of any way of doing it - it could mean you'll need to find another way I'm afraid.

I've never found a way to get PHP to parse within PHP, except when you include() something 🙁

VooDooRT

What do you suggest? Include a file that only sets the variable?

Heck, I dunno what to do...

MarkE

AFAIK you should change this:

<TITLE><?php echo "$myrow[title]" ?></TITLE>

to this:

<TITLE><?php echo "$myrow['title']" ?></TITLE>

in other words: put apostrophes around the associative array element names (in this case 'title' )