php script displayed as text - need help please

jque

Hello there,

I am new to PHP/MYSQL.

Up to the this point, all my codes have worked fine. I created a new database, added a new table on the fly based on the user's input -table name and numbers of field. I created a form to collect data for a new record and call for addrecord.php. however, the php page is displayed as text in the web browser. Could someone take a look at what is wrong in the code below? Thanks a lot.

if ((!$POST[id]) || (!$POST[format]) || (!$_POST[title])) {
header("Location: /addrecord.html");
exit;
}

$db_name="sampledb";
$table_name="my_video";

//connect to MySQL and select database to use

$connection = @mysql_connect ("localhost", "freeman", "greenpass")
or die(mysql_error());

$db = @mysql_select_db($db_name, $connection) or die(mysql_error());

$sql="INSERT INTO $table_name (id, format, title, artist_fn, artist_ln,my_notes)
VALUES ('$POST[id]','$POST[format]','$POST[title]','$POST[artist_fn]','$POST[artist_ln]','$POST[my_notes]')";

$result = mysql_query($sql,$connection) or die(mysql_error());

<html>

html part works fine.

</html>

thanks a lot.

jque 😕

tommynanda

Your Webserver is not parsing PHP pages. check your file extension.
Also
Are you using [url]http://localhost(or)domainname/yourfoldername/addrecords.php[/url]
?

php pages wont be parsed if you are double clicking them in the explorer window.

jque

Thank Tommynana,

I use localhost.

It seems php does parse, because using $_POST method displays field data in the table in HTML works.

The interesting thing is that when I tried to debug the script at each single step, only when I inc;ude $sql I got a blank page. I am not really sure why it behavior this way. Any idea?

Thanks.

Jque