Dynamic Pages from mysql

[DanKD]

Hello again,

I want a piece of code that will allow me to dynamically create pages from a mysql table. I am close, but am having two problems.

1. Right now it uses $_GET to get the id, so when the page displays it displays index.php?id=1 . What I want is to replace id with a variable that is located in the mysql table. So I want it to be index.php?page=HotGirls (or whatever I call the page in my page mysql row)

2. I have php code in some of my row['content'] rows, but when using echo to display the row, the php code is displayed as regular html. So, what do I need to use to make it so that I can display both php and html code within row['content'] ?

Help is very much appreciated.

if( !empty($GET['id']) && is_numeric($GET['id']) )
{
$result = mysql_query("SELECT * FROM sampletable WHERE pageid = " . $_GET["id"]);
if( mysql_num_rows($result) == 0 ) echo("Page not found");
else
{
$row = mysql_fetch_assoc($result);
echo $row['content'];
//Input Page content
}
}
else echo("No Page Info was specified.");

[TheDefender]

1) Instead of using $GET['id'], change it to $GET['page'], and adjust your query accordingly. For example:
"SELECT * FROM sampletable WHERE pagecategory = '" . $_GET['page']'"

2) Use [man]eval[/man]

[DanKD]

When I do that I get no page info was specified because the outer IF statement is false.

[DanKD]

I got #2 working the way I want using Eval. Thanks Defender.

Now I just need to get the 1st problem fixed.

[TheDefender]

Then you need to figure out how you want to define your outer IF.

Probably something like:

IF(isset($_GET['page']) && $_GET['page'] != ''){

since in the example you gave, you wouldn't be expecting a numeric value anyhow.

[DanKD]

Yeesh, still can't get it to work. I current have this. It gets past the initial if loop fine, but I keep getting page not found.

if( !empty($GET['page']) && isset($GET['page']) )
{
$result = mysql_query("SELECT * FROM table WHERE approved = 1 AND pagetitle = " . $_GET["page"]);
if( mysql_num_rows($result) == 0 ) echo("Page not found");
else
{
$row = mysql_fetch_assoc($result);
$content = $row['content'];
print eval ("?>$content");
//Input Page content
}
}