database interaction with php

[coolpapa]

hello, I am trying to deploy a mysql/php cms system that was written on this site using a upload.php to upload files into the database and then call them with a getdata.php. I have been able to upload, update and call the several pages, but none of my php code within the pages stored in the mysql database work. Is there a way to get the code within the pages stored in the database to execute/work?

This is the file I use to call the pages:

?php

if($id) {
$conn = mysql_connect("j", "", "");

mysql_select_db("files", $conn);

$query = "select bin_data from file where id=$id";
$result = MYSQL_QUERY($query);
$data = MYSQL_RESULT($result,0,"bin_data");
$type =

echo $data;

};
?>

[trex005]

look into eval() but
If you are not the only one who is able to upload, giving this access to anyone else is a HUGE security risk... they could do anything on your server that you are able to do.

[coolpapa]

tried the eval funtion, but it didn't work. It gave this error:
Parse error: syntax error, unexpected '<' in gdata2.php(12) : eval()'d code on line 1. I've been reading some, and fopen or fread seem promising, but I cannot get them to work, gives errors on filesize stat. Your help is appreciated.

[trex005]

I'm not positive, but I'm thinking that your error would possibly be the <? beginning the page. give it a shot with removing that

[coolpapa]

nope...standard html opening tag, the php code I want to be executed comes later in the html code. It gives the error on the first line...can the eval function run standard html and php code? Later man...thanks for your input

[TheDefender]

Let's get back to basics for a second:

Look at the first line of code you posted:

?php

That line should look like this:

<?php

If your <?php tag isn't opening properly, then no php will execute on the page at all... Make that fix, and then let's go from there...