Load script from DB problem with eval()?

[DokterG]

hi everyone

 

i've just finnished a lynda.com course and began coding my own site..

 

i want to be able to put the script it self in the database. Then from read and execute the script from content.php

BUT i get this error

 

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\content.php(35) : eval()'d code on line 1

Call Stack

 

 

so far it's has been fairly easy to correct the errors, but this one i don't know how to handle.. can anyone give me a hint where I've mistaken

 

 

The script i put in the database

 

if (!isset($_GET['category'])) {
$query = "SELECT * 
        FROM links
	ORDER BY category ASC";

$result = mysql_query($query);

echo "<table border=\"0\" width=\"100%\">
	<tr>
	<td>
	<ul>";

while ($row = mysql_fetch_assoc($result)) {
	echo "<li><a href=\"links.php?content=links&category=" . $row['category'] . "\">" . $row['category'] . "</a></li>";

}

echo "</ul>
  </td>
  </tr>
  </table>";
}



if (isset($_GET['category'])) {

$linkcat = $_GET['category'];

$query = "SELECT * 
        FROM links
	WHERE category='{$linkcat}'
	ORDER BY title ASC";

$result = mysql_query($query);




while ($row = mysql_fetch_assoc($result)) {
	echo "<table border=\"0\" width=\"100%\" height=\"160\">
 	<tr>
    		<td colspan=\"3\" align=\"center\" valign=\"top\">
			<h1><a href=\"" . $row['address'] . "\">" . $row['title'] . "</a></h1>
		</td>
    	</tr>
    	<tr>
    		<td colspan=\"3\" align=\"center\" valign=\"middle\">
			<p>" . $row['description'] . "</p>
		</td>
    	</tr>
    	<tr>
    		<td align=\"left\" valign=\"bottom\" style=\"float:right\"><a href=\"profile.php?username=" . $row['author'] . "\">" . $row['author'] . "</a></td>
        	<td align=\"center\" valign=\"bottom\"><p>" . $row['votes'] . "</p></td>
        	<td align=\"right\" valign=\"bottom\" style=\"margin-right:10;\"><p>" . $row['clicks'] . "</p></td>
    	</tr>
    
</table>
<br />
<hr />
<br />";
}
}

 

 

content.php

<?php require_once('includes/connection.php'); ?>
<?php

$content = $_GET['content'];

$query = "SELECT * 
        FROM pages
	WHERE page_name='{$content}'";

$result = mysql_query($query);

if (!$result) {
    echo "Could not successfully run query from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}
$row = mysql_fetch_assoc($result);


$str = $row['content'];

eval("\$str = \"$str\";");
echo $str;





?>

 

 

 

 

Thank you in advance

 

 

Dokter G

 

 

 

 

 

 

[trq]

i want to be able to put the script it self in the database.

 

What makes you believe this is a good design decision?

[DokterG]

What makes you believe this is a good design decision?

 

well as said i'm kinnda new to php so i dont know an other way to make scripts and code my homepage online.. is there a way to do that perhaps you got a link for a tutorial