Game Development Community

PHP Help (Off Topic)

by Chris "DiGi" Timberlake · in General Discussion · 03/08/2005 (7:21 pm) · 11 replies

Hello, i'm having a bit of a problem with PHP, i'm trying to echo a php statement inside html, inside a mysql database. So far i haven't been able to figuare out how. Is this possible? If so, how? Please help.


Edit: Yes, i have googled it, if its there, i must've missed it or something.
NextNext Thread
PrevPrevious Thread
More from General Discussion


Torque Owner Josiah Wang
#1
03/08/2005 (7:26 pm)
Huh? You mean, echoing a statement into html code, and then putting that chunk of text into a db?

Erg...then you'd probably put it all in one variable like so...

</?php
$htmlstuff = "<html><body>blabhablhablhablhab";
$htmlstuff .= " i love $food</body></html>";

$insertsql = "INSERT into mytable ("text") values ($htmlstuff)";
$res = mysql_query($insertsql, $conn) or die(mysql_error());
?>

(forgive me, i'm a bit rusty >.<)

Torque 3D Owner Chris "DiGi" Timberlake
#2
03/08/2005 (7:27 pm)
No, I mean theres php code inside the html code, inside a mysql database, and I want to echo it, with the php working (of Course).

Edit: SP

Torque Owner Josiah Wang
#3
03/08/2005 (7:28 pm)
Er/...not really understanding...

Torque Owner Josiah Wang
#4
03/08/2005 (7:29 pm)
Oh wait, so you have a chunk of html inside your db....and that chunk has php code in it...and you want to echo it out?

so it goes like...

(database)
    (html)
         (code)(/code)
     (/html)
(/database)

?

Torque 3D Owner Chris "DiGi" Timberlake
#5
03/08/2005 (7:33 pm)
Exactly!

Torque Owner Josiah Wang
#6
03/08/2005 (7:40 pm)
Hrm...first I would extract the entire html block from the db...then write a string function to take only the php code (since php code blocks begin with

in semi-psuedo code it'd prob appear like this:

Quote:
//first, pull the HTML out of db



$gethtmlsql = "SELECT myhtmlstuff FROM mytable WHERE blah = boo";
$res = mysql_query($gethtmlsql, $conn) or die(mysql_error());
$html = mysql_result($res, 0, "myhtmlstuff");


//now we have all the html code in a variable...extract php code
//NOTE: this part is in pseudo code, since i'm not familar with string functions...
$startindex = find_position_of_text($html, " $endindex = find_position_of_text($html, "?>");


$phpcode = extract_text($html, $startindex, $endindex);


//now, to execute the code, use the eval() function (a REAL function)

eval($phpcode);


?>

hope this helps...

edit: line breaks...wtf?

Torque 3D Owner Chris "DiGi" Timberlake
#7
03/08/2005 (7:47 pm)
How would it know where to execute the PHP Codes, if its extracting it from the html?

Torque Owner Robert Pierce
#8
03/08/2005 (8:01 pm)
EVAL() just executes it as if it were a PHP file correct?

So then couldn't he just put something like
<html>
<head>
  <title>I am in a code block, woot!</title>
</head>
<body>
text here
<?php
//php code here
?>
</body>
</html>
or something to that effect in the database.

By the way, what would this be used for, I am pretty sure there may be an easier way to do it, :P.

--Robertp

Torque 3D Owner Chris "DiGi" Timberlake
#9
03/08/2005 (8:05 pm)
Echoing varibles, in the html code, in the database. So the possitioning has to be correct.

Edit: So, its basically echoing a mysql statement (teh html) then echoing a varible inside that html code.

so its like

<?php

echo $mysql_row['content'];

?>

database

<?php $pie = "Pie"; ?>
<b> Hi I'm <?php echo $pie; ?> </b>

Torque Owner Josiah Wang
#10
03/09/2005 (4:31 am)
Oh wait...so you want to echo the VALUE of the variable into a piece of html, and then echoing that into a database?

Torque Owner Eugene Goh
#11
03/09/2005 (7:17 am) 
<?php echo html_entities($StrWithHtmlAndPhpTagsInIt); ?>

Proper indentation would probably take a bit of preg_replace() magic.