PHP database form not working

[ChaosKnight]

Hi,

can somebody see why this code does absolutely nothing?

 

<?php session_start();
  include("dbstuff.inc");
  $link = mysql_connect($host,$username,$password)
    if (!$link) 
      die("Couldn't connect to server");
  echo "Connected successfully";
  $select = mysql_select_db($db);
    if (!$select)
      die("couldn't connect to database");
  echo "Connected to database";
  $date = date("Y-m-d H:i:s");
  foreach ($_POST as $field => $value)
  {
    $$field = strip_tags(trim($value));
  }
  $sql = "INSERT INTO contact (name,email,heading,message,unread,date_created) VALUES ('$name','$email','$heading','$message','yes','$date')";
  mysql_query($sql,$link);
  mysql_close($link);
  header("Location: index.php?page=contact");
?>

 

It gets sent via a normal HTML post form.

 

When I tried it on localhost without the database lines and echoed the variables it  worked perfectly..

So I guess something is wrong with the database lines?

 

The database host, username, password and database name also gets returned as expected, so nothing is wrong with that.

 

The problem is that absolutely nothing else gets returned... The page is completely blank, it doesn't even execute the header("location: ...") command.

 

Oh, and the shared host that I'm on doesn't support mysqli, just for in case you wondered...

[TeddyKiller]

Messy code. Try this.

<?php session_start();
include("dbstuff.inc");

$link = mysql_connect($host,$username,$password)
if (!$link) { 
die("Couldn't connect to server");
} else {
echo "Connected successfully";
}

$select = mysql_select_db($db);
if (!$select) {
die("couldn't connect to database");
} else {
echo "Connected to database";
}

$date = date("Y-m-d H:i:s", time());

foreach ($_POST as $field => $value) {
    $$field = strip_tags(trim($value));
}

$sql = "INSERT INTO contact (name,email,heading,message,unread,date_created) VALUES ('$name','$email','$heading','$message','yes','$date')";
mysql_query($sql,$link) or die(mysql_error());

mysql_close($link);

header("Location: index.php?page=contact");
?>

[ChaosKnight]

Mmm... It still doesn't work, it sends back a completely blank page, no code, no nothing...

 

Any suggestions?

[Pikachu2000]

Line 3 missing semicolon.

[TeddyKiller]

Could of been your issue in the first place

[ChaosKnight]

Do you know how much I love you right now??

 

Thanks to TeddyKiller and Pikachu2000 for all your help!

And to Pikachu's eagle eyes LOL

 

Problem solved!! 

[Pikachu2000]

It may behoove you to enable error reporting. Also, you should rename your dbstuff.inc file to a .php extension so it isn't viewable in a web browser, for obvious reasons.