Help! Losing Hair Over This!

Ham

I am at a loss... I have tried everything I can find to do in my text book but this script is only working partly.

I am attempting to enter data into a MySQL Database. The table where the data should go is called 'discs'. If I don't fill out all the fields I get an error saying such (which I should). However, if I DO fill out all the field, the page loads the <h1> Header but then just stops. No error... No "1 disc inserted into database"... nothing!

Here is my PHP Code... can ANYONE help me?

<html>
<head>
  <title>Add Disc</title>
</head>
<body>
<h1>Disk Entry Results</h1>
<?
  if (!$system || !$title || !$rating || !$discs || !$loaned)
  {
     echo "You have not entered all the required details.<br>"
          ."Please go back and try again.";
     exit;
  }

  $system = addslashes($system);
  $title = addslashes($title);
  $rating = addslashes($rating);
  $discs = doubleval($discs);
  $loaned = doubleval($loaned);

  @ $db = mysql_pconnect("localhost", "my_username", "my_password");

  if (!$db)
  {
    echo "Error: Could not connect to database.  Please try again later.";
    exit;
  }

  mysql_select_db("discs");
  $query = "insert into discs values ('".$system."', '".$title."', '".$rating."', '".$discs."', '".$loaned."')"; 
  $result = mysql_query($query);
  if ($result)
      echo  mysql_affected_rows()." disc inserted into database."; 
?>

</body>
</html>

This comes right out of my text book but I have heard from severals that there are errors in the lessons all throughout the book.

Also... AFTER I get this working correctly, is there a way to submit the confirmation message / error inside my html templates instead of just using this nasty looking page?

kidsleep

The reason you aren't getting an error is because you haven't told it to give you one if the insertion fails.

try this statement instead:


if ($result)
echo  mysql_affected_rows()." disc inserted into database.";

else
{
echo(mysql_error());
}

That will at least give you an idea of where your code is choking

HTH

Ham

OK, I WAS calling my database incorrectly (calling the table instead of the db). Now I am getting THIS error:

Disk Entry Results
Column count doesn't match value count at row 1

Hmmm....

Lars_Berg

The number of values in the values clause is not the same as the number of columns in the table.

If you don't give values for all columns, you need to specify a list of columns for which you do have values

e.g.

insert into ogrish(aleb,bleb) values (1,2)

Ham

Sorry to be so lame, but could you give me an example from my script? I am new to PHP and had a hard time with your example code:

<?
  if (!$system || !$title || !$rating || !$discs || !$loaned)
  {
     echo "You have not entered all the required details.<br>"
             ."<a href=/add.php>Please go back</a> and try again.";
     exit;
  }

  $system = addslashes($_POST['system']);
  $title = addslashes($_POST['title']);
  $rating = addslashes($_POST['rating']);
  $discs = addslashes($_POST['rating']);
  $loaned = addslashes($_POST['loaned']);

  @ $db = mysql_pconnect("localhost", "name", "pass");

  if (!$db)
  {
    echo "Error: Could not connect to database.  Please try again later.";
    exit;
  }

  mysql_select_db("abraham_games");
  $query = "insert into discs values ('".$system."', '".$title."', '".$rating."', '".$discs."', '".$loaned."')"; 
  $result = mysql_query($query);
  if ($result)
      echo  mysql_affected_rows()." disc inserted into database."; 

  else
  {
  echo(mysql_error());
  }
?>