calling PHP from MySQL

cfarrell

Can someone please tell me before I eat my computer, how I can parse PHP that is stored as text in my MySQL database?
Site is set up with one index.php page. I feed this with data like so: http://mysite.com/index.php?page_id=0001. However, I cannot get it to parse PHP which I store in the database...Linux and Windows.

I've heard that I should use eval() and I have tried, but to be honest, I don't know how. Where does the eval function go - on index.php site in front of where I use echo($recordset)?

I've looked through the threads but I can't seem to find anything so any info would be appreciated

laserlight

Well, say you have a piece of code stored in your database table php under the fieldname mycode, having the id of 5

Now in that cell is:
echo 'Hello World!';

Then in your php file you might have

<?php
//assume database connected and selected
$query = mysql_query("SELECT mycode FROM php WHERE id='5'");
$code = mysql_fetch_array($query);
eval($code['mycode']);
?>

I presume something alone those lines will work, though I myself havent work with eval().

Norman_Graham

Just to confirm Laserlight's correct response - you definitely need eval(), otherwise the stuff in the database will be displayed as HTML.

Best o luck

Norman

cfarrell

Thanks to laserlight and norman for the help. Have done some quick reading on eval() but the php.net website was a bit over my head. This is the code on the index.php page. Where does the eval() function go and how is it phrased! I've tried putting it in in the break as you can see, but that obviously doesn't work. Once again,any help would be appreciated!

eval ($Recordset1);

$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

Norman_Graham

... nice try, but I think you have to do your mysql_fetch_assoc etc stuff AND THEN use eval(). Assign everything you want from the database to a variable - in your case $row_Recordset1 - and then do eval($row_Recordset1);

I believe this is the way forward. Give it a try. Anyone else know more?

I agree that the eval() explanation at PHP.net is hard to follow. I do wish they would stop with that foobar stuff and use practical examples - but hey, you shouldn't look a gift horse in the mouth.

Best o luck

Norman

cfarrell

Thanks again Norman. I've tried putting it in in a number of ways but it just doesn't want to work. Does anyone know where I could get a working example of code from a database being parsed? What I want to do is to call an include() from the database, which will itself have php in it. I really don't know if this is possible, but to call the include would be nice. Here's the full code----

<?php require_once('Connections/lycosconnect.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($HTTP_GET_VARS['page_id'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['page_id'] : addslashes($HTTP_GET_VARS['page_id']);
}
mysql_select_db($database_lycosconnect, $lycosconnect);
$query_Recordset1 = sprintf("SELECT * FROM globaldb WHERE page_id = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $lycosconnect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
eval($row_Recordset1 ['page_title']);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>+ + + b a b e l w o r x + + +</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/babelworx.css" rel="stylesheet" type="text/css">
<link href="css/onceoff.css" rel="stylesheet" type="text/css">
</head>

//HV Menu- by Ger Versluis (http://www.burmees.nl/)
//Submitted to Dynamic Drive (http://www.dynamicdrive.com)
//Visit http://www.dynamicdrive.com for this script and more

function Go(){return}

</script>
<script type='text/javascript' src='exmplmenu_var.js'></script>
<script type='text/javascript' src='menu_com.js'></script>
<noscript>Your browser does not support script</noscript>
<table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/pwrtitle.jpg" width="770" height="92"></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="24%" valign="top" background="images/leftmenu.gif"><div align="center">
<p><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Your
Site Navigation:</strong></font></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<table width="85%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#000066"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Site
Information: </font></div></td>
</tr>
<tr>
<td class="babelworx"><p>babelworx deploys a powerful mix of
macromedia studio mx and a SuSE based LAMP system to bring
out the best in your website </p>
<table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><img src="images/geeko.png" width="86" height="47"></div></td>
</tr>
</table>
<p> </p></td>
</tr>
</table>
<p><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong><a href="phprint.php" class="onceoff">Print
This Page</a></strong></font></p>
</div></td>
<td width="2%"> </td>
<td width="74%" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="babelworx">
<td><font color="#000066" size="2" face="Arial, Helvetica, sans-serif">Welcome to
+ + + b a b e l w o r x + + + </td>
<td><div align="right">
<?php
echo( date("l, F dS Y.") ); ?>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td class="babelworx">

<?php

			  echo $row_Recordset1 ['page_record']?> 
              <!-- stopprint -->
            </td>
          </tr>
        </table></td>
    </tr>
  </table></td>

</tr>
<tr>
<td background="images/leftmenu.gif"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Copyright
© babelworx 2003. All Rights Reserved.</font></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Norman_Graham

Yeah, but you're not doing anything with the eval(). Just sticking it in like this:

eval($row_Recordset1 ['page_title']);

won't do anything. You have to do:

$Recordset1_new=eval($row_Recordset1 ['page_title']);
echo ($Recordset1_new);

to get it displayed or whatever you want to do with it. To the best of my knowledge, you can't use include() to call stuff from the database. You can, of course, stick the content of an include file in the database or simply stick the path to the include file in the database, which would make more sense.

Best o luck

Norman

cfarrell

I've tried it like this, but it just doesn't work. I really can't figure this out. Is there anything I-m obviously doing wrong!

<?php require_once('Connections/lycosconnect.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($HTTP_GET_VARS['page_id'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['page_id'] : addslashes($HTTP_GET_VARS['page_id']);
}
mysql_select_db($database_lycosconnect, $lycosconnect);
$query_Recordset1 = sprintf("SELECT * FROM globaldb WHERE page_id = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $lycosconnect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$Recordset1_new = eval($row_Recordset1 ['page_record']);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>+ + + b a b e l w o r x + + +</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/babelworx.css" rel="stylesheet" type="text/css">
<link href="css/onceoff.css" rel="stylesheet" type="text/css">
</head>

//HV Menu- by Ger Versluis (http://www.burmees.nl/)
//Submitted to Dynamic Drive (http://www.dynamicdrive.com)
//Visit http://www.dynamicdrive.com for this script and more

function Go(){return}

ehlpdesk

Hello,

norman is trying to tell you to change this:

echo ($Recordset1_new ['page_record']);

to this (where you are printing it):

echo $Recordset1_new;

Should give you the results your looking for.

Hope this helps.

Regards,
Ray

superwormy

$variable = "

my html goes here

<?php

print (\" this is my PHP code inside a varialbe \");

more strait html!

eval (" ?> " . $variable . " <?php ");

That will work correctly. $variable should be VALID AND ERROR-FREE PHP CODE, ie properly enclosed in <?php and ?> tags and without syntax errors. You DO NOT need to echo() or print() the results of the eval()'d code.

cfarrell

Thanks ray and norman again. must be really pi**ing you guys off. The code now looks like below, but nothing is being displayed. Anything else completely silly about it?

<?php require_once('Connections/lycosconnect.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($HTTP_GET_VARS['page_id'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['page_id'] : addslashes($HTTP_GET_VARS['page_id']);
}
mysql_select_db($database_lycosconnect, $lycosconnect);
$query_Recordset1 = sprintf("SELECT * FROM globaldb WHERE page_id = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $lycosconnect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$Recordset1_new = eval($row_Recordset1 ['page_record']);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>+ + + b a b e l w o r x + + +</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<?php
echo $Recordset1_new;
?>

<?php
mysql_free_result($Recordset1);
?>

Norman_Graham

... the reply from Superwormy. He knows what he's talking about - the eval() thing can be a bit tricky and my reply was insufficient.

Norman

cfarrell

Finally got it to work! Thanks to norman and superwormy. Here's how it eventually parsed my database content:

<?php
eval (" ?> " . $row_Recordset1 ['page_record'] . " <?php ");
?>

<?php
mysql_free_result($Recordset1);
?>