Eho a php script

NZ_Kiwis

In my MySQL database I have a script and what i want to do is something like this

$result = mysql_query ("SELECT * From scripts where scriptid = $id");
$row = mysql_fetch_array($result);
echo $script;

but the script might phase in and out of php.. how can this be done? must is stay in PHP if so how would i start the code in the DB?? can it start with

$result2 = mysql_query ("SELECT * From table where member = $4");.......

jkurrle

Let me get this straight:

1) You have a series of PHP commands stored into a MySQL database table, each correllated to an id number.
2) You want to extract the code from the database
3) you want to execute the extracted code.

Is this correct? If so, I might try to tackle it this way:

$select="select PHP_Code from Routines where id_num=\"$id\" ":
$result=mysql_query($select)
   or die("Select from Routines table had errors.");
while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
   {
   extract($row);
   $PHP_Code;
   }

I can't say for sure this would work, but it looks feasible at first glance.

NZ_Kiwis

Yes that's it, I have this code but only 1 shows up and thats from the echo... my database has this code in it as a test

$result55 = mysql_query ("SELECT * From news WHERE top = 1 order by id desc limit 1");
while ($row55 = mysql_fetch_array($result55)) {

echo $row55[id];
echo "<br>";
}

my code to run this script it this

<?php
if ($Page_ID == "") {
$Page_ID = '1';
}

echo $Page_ID;

$select = "SELECT HTML from Pages where Page_ID = '$Page_ID'"; 
$result2 = mysql_query($select) or die("Select from Routines table had errors."); 
while ($row2 = mysql_fetch_array($result2,MYSQL_ASSOC)) 
{ 
extract($row2); 
$PHP_Code; 
} 
?>

jkurrle

Ok, I suffering severe sleep deprivation and I really don't understand what the issue is.

1)Does the code snippet return all lines of the stored code?
2)Does the code execute?
3)If the code executes, does it contain errors? If so, what are they?
4) If you were to print out the returned code from the database instead of running it, does it show what the code should be?

Please try to explain more clearly to a sleep deprived, muddle headed code monkey...

NZ_Kiwis

1) When working yes it should, this way I have just one page index.php then all other pages can be index.php?Page_ID=3 for example.

2) Not your code no, but when i do a
$result55 = mysql_query ("SELECT HTML From Pages WHERE Page_ID = $Page_ID");
$row55 = mysql_fetch_array($result55);
echo $row55[HML];
it print it but as text not in PHP

3)No
4) Yes

Do you still with me??

jkurrle wrote:
Ok, I suffering severe sleep deprivation and I really don't understand what the issue is.

1)Does the code snippet return all lines of the stored code?
2)Does the code execute?
3)If the code executes, does it contain errors? If so, what are they?
4) If you were to print out the returned code from the database instead of running it, does it show what the code should be?

Please try to explain more clearly to a sleep deprived, muddle headed code monkey...

Keithamus

First post; you should feel privilaged.

The function you are looking for; if I understand you correctly, is eval()

$result55 = mysql_query ("SELECT HTML From Pages WHERE Page_ID = $Page_ID");
$row55 = mysql_fetch_array($result55);
echo $row55[HML];

should be

$result55 = mysql_query ("SELECT HTML From Pages WHERE Page_ID = $Page_ID");
$row55 = mysql_fetch_array($result55);
eval($row55[code=html]);

That is if you want to execute PHP code...

if you want HTML, then perhaps Urldecode() may be the function for you.

Hope this helps.
Keithamus