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