[RESOLVED] php from db

owaring

i have a cms that stores pages in php or html format in a db.

i have written a small search script as an add on to this

when i select the code field from the db and output it to html it is displayed as raw code.
FYI the db does not store <?php ?> tags

how can i parse the code in the db and get it to output as normal?

advance thanks

nemonoman

What you describe is doable (but very odd, in many ways -- still it's doable). That part about not storing <php tags -- that's not true. You should post some code to better describe your methodology.

owaring

i think you may have mis understood me. this is not my code on the db side of things, its a content managment system call pagetool it gives the option to store either html or php in its db, (hence my <? tag comment)

the pages the search page is looking at are stored as php (untagged) as here

$template = '3way.tpl';

$left = <<<HTML
<form action="index.php?name=pagetool_search" method="post">
 <input type="text" name="search_term">
 <input type="submit" value="Search">
</form>
HTML;

$centre = <<<HTML

Audio Hire - Sales - Installation - Event Production

Urban Audio Productions is an energetic company with a 'can do' attitude
towards the challenges of the live events industry. We have a large inventory of 
please call 0121 689 2722 or email
<a href="mailto:info@uaproductions.com">info@uaproductions.com</a>
HTML;

$right = <<<HTML
<a href="index.php?name=pt_user_man_en">Check out the User Manual</a>
HTML;


$content = array
    ( 'title' => $my_title, 'left' => $left, 'centre' => $centre, 'right' => $right );
drawpage($template,$content);

this gets parsed somehow and output as html

now this code is what is returned after my search runs, i need to parse it and display the html, (or ideally a section of it!! (being the $centre variable) )

have a look at http://www.urban-audio.co.uk/index.php?name=pagetool_search and search for 'nexo'

thanks in advance

ollie

Weedpacket

[man]eval[/man] will do what you need (execute a string as code).

owaring

collio,
can i use a variable thats within the eval'ed code??

$codevar = <<<CODE 
$var1 = "qwerty";
$var2 = "asdfgh";
$var3 = "zxcvbn";
$var4 = "123456";
CODE; 

eval($codevar);

echo $var4;

rowanparker

Try it 😉

But I think that would work.

owaring

thanks to everyone for the input,
i find myself needing to get ridd of the last 2 lines of this code so i can use it.

i have come up with the following, i wanted to check if i could improve on my method

many thanks

$codevar = ' 
$var1 = "qwerty"; 
$var2 = "asdfgh"; 
$var3 = "zxcvbn"; 
$var4 = "123456";
echo $var4;';

$exp = explode(";", $codevar);
$offset = count($exp) - 3;
$exp = array_slice($exp, 0, $offset);
$newcode = implode(";", $exp);
$newcode = $newcode.';';


eval($newcode); // doesn't contain/output the echo command
echo $var3; // prints "zxcvbn"
echo $var4; // cannot!

bradgrafelman

What's the point of the code in the middle? Just trying to remove the echo command? Try this:

$codevar = ' 
$var1 = "qwerty"; 
$var2 = "asdfgh"; 
$var3 = "zxcvbn"; 
$var4 = "123456"; 
echo $var4;'; 

$newcode = preg_replace('/echo.*?;/i', '', $codevar);

eval($newcode); // doesn't contain/output the echo command 
echo $var3; // prints "zxcvbn" 
echo $var4; // prints "123456"

owaring

$exp = explode(";", $codevar);
$offset = count($exp) - 3;
$exp = array_slice($exp, 0, $offset);
$newcode = implode(";", $exp);
$newcode = $newcode.';';

this gets ridd or the last 2 lines of code.
the output is not via echo it is via a function call that is not available where i'm using this script