Table insert not working

[focus310]

Hello:

My mind went a total blank. I have a script which displays a form and inserts the data from the form into the table.

I added a fourth field and when I run the form the table no longer populates. I can't seem to figure out why. I stripped my script so I could troubleshoot and I still can't seem to find the problem.

My table looks like this:
id int(11) not null auto_increment primary key,
cat_code varchar(15) not null,
cat_name varchar(25) not null,
parent_id int(11) not null default 0

This is my script:

<?php # 
require_once ('mysql_connect.php'); // Connect to the database.

if (isset($_POST['submitted'])) { // Handle the form.

// Check for a category code.
if (!empty($_POST['catcode'])) {
	$cat_code = escape_data($_POST['catcode']);
} else {
	$cat_code = FALSE;
	echo '<p><font color="red">Please enter a category code!</font></p>';
}

// Check for a category name.
if (!empty($_POST['catname'])) {
	$cat_name = escape_data($_POST['catname']);
} else {
	$cat_name = FALSE;
	echo '<p><font color="red">Please enter a category name!</font></p>';
}

    if (!empty($_POST['parentid'])) {
          $pid = $_POST['parentid'];
    } else {
         $pid = 0;
    }


if ($cat_code && $cat_name && $pid) { // If everything's OK.

	// Add the category to the categories_description table
	$query = "INSERT INTO category (cat_code, cat_name, parent_id) VALUES ('$cat_code', '$cat_name', '$pid')";		
	$result = @mysql_query ($query); // Run the query.
}

} // End of the main submitted conditional.
// --------- DISPLAY THE FORM ---------
?>
<form action="add_category.php" method="post">
	<fieldset><legend>Fill out the form to add a category:</legend>

<p><b>Category Code:</b> <input type="text" name="catcode" size="60" maxlength="60"></p>

<p><b>Category Name:</b> <input type="text" name="catname" size="60" maxlength="60"></p>

    <p><b>Parent Category:</b><input type="text" name="parentid" size="60" maxlength="60"></p>

</fieldset>
<input type="hidden" name="submitted" value="TRUE" />

<div align="center"><input type="submit" name="submit" value="Submit" /></div>

</form>

The problem lies with the variable $pid which on the form is set to "parentid". The variable $pid should populate the field parent_id in the table.

Here is how the form should work: if a person leaves the Parent Category field blank, the field parent_id should default to 0 otherwise insert the value entered into the form into parent_id.

Well, when I try to run the form with the last form field blank, nothing gets inserted into the table. I can't seem to figure out why.

Can someone take a look and help me? I could use a fresh pair of eyes. I am sure that the solution is probably something very basic. As I said earlier, my mind went a complete blank.

Thank you in advance for your help.

[DESIGNGRAPHY]

You have different variable names:

if (isset($_POST['submitted'])) { // Handle the form.

<input type="submit" name="submit" value="Submit" />

name=... should be "submitted" => name"submitted"

That's why the submit can't insert into db.

[focus310]

Hi,

Thank you for your reply.

I changed my variable to submitted and re-ran the script.

It's still not working. The data is not being inserted into the table.

Any other ideas?

Thanks again.

[focus310]

Hello:

I think I've narrowed down my problem. I re-wrote the script and echoed my results each time I added a new variable.

The problem lies here:

if (empty($_POST['parentname'])) {
       $parentname = 0;
   } else {
       $parentname = $_POST['parentname'];
   }

if ($catcode && $catname && $parentname) {

echo $catcode;
echo $catname;
echo $parentname;
}

When I ran my form with $parentname being blank, rather than receiving a 0 in my echo, I received nothing.

When I ran my form with $parentname with a value, all three echo statements provided me with a result.

For whatever reason, the script doesn't like the $parentname = 0 statement. And, I don't know why.

Any thoughts?
Thanks

[cgraz]

I would assume that the first part of your statement didn't run, if it echo'd nothing. Try this to see what's happening

if (empty($_POST["parentname"])) 
{
	$parentname = 0;
	print "Variable is empty";
} 
else 
{
	$parentname = $_POST['parentname'];
	print "Variable was not empty";
}

Assuming that the first part of your if statement is not running, even if you leave the form field empty, you may want to use isset() and maybe even use it in combination with trim() and strlen() like this

if( (!isset($_POST["parentname"])) || (strlen(trim($_POST["parentname"])) == 0) )
{
	$parentname = 0;
}
else
{
	$parentname = $_POST["parentname"];
}

print "Parent Name equals " . $parentname;