PHP Not Parsing From Database

Hater_Alligator

I have a text field inside a database. Inside that text field, I have an echo function. The text field is supposed to echo the user's IP address. The problem is... well it isn't. The funny thing is that the database and page KNOWS its PHP, because when i view the source code, it has <?php echo "$REMOTE_ADDR"; ?>, but nothing shows up on the page itself.

When I take off the <?php and ?> tags, it shows up as text. I'm not sure what the problem is.

Any help is appreciated.

-Hater Alligator
http://www.hateralligator.com

LordShryku

tryed [man]eval[/man]?

nlhowell

I think I see what you're doing...something like this?

$ipcode; // this is the variable with the PHP code...
print $ipcode; // or echo, or something...

You're problem is that you can't do this:

 print "<?php print 'HELLO!'; ?>";

You can only print/echo HTML code to a page; PHP only processes output once, not recursively. If the PHP code wasn't there when PHP started processing, it won't be processed as PHP code.

What you want is what LordShryku said: eval(). The eval() function evaluates whatever you give it as php code. For example, this would print the above example correctly:

$ipcode = "print '199.162.105.215';";
eval($ipcode);

Note that if $ipcode were "<?php print '199.162.105.215'; ?>", it wouldn't work; you can't have PHP tags in it.

Note: that's not my real IP; I made it up.

HTH,
Nick

Hater_Alligator

Well, I dunno if you understand what's happening. I INSERTED html into a row in my mySQL database. So, toward the middle, I start a <?php tag, echo $REMOTE_ADDR, and then close the php tag ?>

I'm not doing anything like

<?php
echo "<html><body>";
echo "Text and HTML here";
<?php echo "$REMOTE_ADDR"; ?>
echo "</body></html>";
?>

I'm not doing that, im starting the first PHP tag toward the end of the HTML code, echoing $REMOTE_ADDR; and then closing the PHP. This is all inside of a textarea row of the mySQL database.

nlhowell

Right. For example, this might be the value of your field in MySQL:

<html>
<head>
    <title>My Title Is Here!</title>
</head>
<table align='center'>
    <tr>
        <td colspan='2' align='center' style='font-weight: bold; text-decoration: underline; font-size: 16pt;'>Information</td>
    </tr>
    <tr>
        <td>IP:</td>
        <td><?php echo $_SERVER['REMOTE_ADDR']; ?></td>
    </tr>
</table>
</html>

What I'm saying is that, regardless of where you're printing from, you cannot print PHP code from PHP, as it will not be evaluated:

<?php
print '<?php print $_SERVER["REMOTE_ADDR"]; ?>'; // prints that as HTML code; not evalutated as PHP
?>

You need to stick in the IP when you send it to the database, so that the field is like this:

<html>
<head>
    <title>My Title Is Here!</title>
</head>
<table align='center'>
    <tr>
        <td colspan='2' align='center' style='font-weight: bold; text-decoration: underline; font-size: 16pt;'>Information</td>
    </tr>
    <tr>
        <td>IP:</td>
        <td>199.185.167.802</td>
    </tr>
</table>
</html>

Hater_Alligator

What if it is supposed to show the person viewing it his/her IP address?

That specific row in the mySQL database is the coding for a page that shows the viewer his/her IP address, that's why I can't just enter a set IP adress, because it has to grab the $REMOTE_ADDR of the viewer, know what I mean?

Click here to see what I mean:
http://www.hateralligator.com/tutorials.php?show_tutorial=1&sub_id=19

See at the bottom where it says:

Ok, so now that you know how do it, let me show you your IP.
Your IP Address Is:

That blank space is where it's supposed to show the viewer's IP.

-Hater Alligator

nlhowell

Oh. Sorry. There are two ways you could do that. One is to have it write the html/php combo to a PHP file, save it, and then redirect the user to it:

<?php
$ipcode; // html and php code for the ip file
$fp = fopen("ip.php","w");
fwrite($fp,$ipcode);
fclose($fp);
print "<script> location.replace('ip.php'); </script>";
?>

The other, probably better way to do it is to have a special code for the IP, like this:

$ipcode = "<html>Hi, you ip is <!--ipcode-->!</html>"; // stored in database
print str_replace("<!--ipcode-->",$_SERVER['REMOTE_ADDR'],$ipcode);

BTW, using register globals is probably a bad idea. You'd want $_SERVER['REMOTE_ADDR'] instead of $REMOTE_ADDR.

Hater_Alligator

Awesome, thanks for the tip!

by the way, what is the diff between
$SERVER_['REMOTE_ADDR']

and

$REMOTE_ADDR