Insert Not working

mystrymaster

Here Is the form that collects the data

<form action="familyProcess.php" method="post" class="text10">
<!-- Family Record -->
Last Name: <input type="text" name="lastName" size="10" class="text10"><br>
Mother: <input type="text" name="mother" size="10" class="text10"><br>
Father: <input type="text" name="father" size="10" class="text10"><br>
Address: <input type="text" name="address" size="20" class="text10"><br>
Address2: <input type="text" name="address2" size="20" class="text10"><br>
City: <input type="text" name="city" size="20" class="text10"><br>
State: <input type="text" name="state" size="20" class="text10"><br>
Zip: <input type="text" name="zip" size="20" class="text10"><br>
Home Phone: <input type="text" name="homePhone" size="10" class="text10"><br>
Work Phone: <input type="text" name="workPhone" size="20" class="text10"><br>
Work Phone2: <input type="text" name="workPhone2" size="20" class="text10"><br>
Cell Phone: <input type="text" name="cellPhone" size="20" class="text10"><br>

<!-- Input Child Record -->
<!-- Add funcionality for additional children on edit -->

Child: <input type="text" name="name" size="20" class="text10"><br>
Class: <select name="class" style="text10">
<?php
// SQL CALL AND BUILDING OF DROPDOWN FOR CLASSES
	$class = mysql_query("SELECT classId FROM classRoster");
	while ($CID  = mysql_fetch_array($class)){
		echo "<option value='$CID[0]'>$CID[0]";
	}
?>
</select>
Birthday: <input type="text" name="birthday" size="20" class="text10"><br>
<input type="submit" value="Add Family" class="text10">
</form>

And Here is the insert page

<?php
//INSERT ALL DATA INTO THE FAMILY

$FamIns = mysql_query("INSERT INTO family (LastName, Mother, Father, Address, Address2, City, State, Zip, 
HomePhone, WorkPhone, WorkPhone2, CellPhone)
 VALUES ('$_POST[lastName]', '$_POST[mother]'], '$_POST[father]', '$_POST[address]', '$_POST[address2]', '$_POST[city]',
 '$_POST[state]', '$_POST[zip]', '$_POST[homePhone]', '$_POST[workPhone]', '$_POST[workPhone2]', '$_POST[cellPhone]')");

//GET FAMILY ID FROM PREVIOUSLY INSERTED RECORD

$family = mysql_query("SELECT ID FROM family");
$famID = mysql_num_rows($family);

//INSERT CHILD

$ChildIns = mysql_query("INSERT INTO child (name, FamilyId, Birthday) 
VALUES ('$_POST[name]', '$famID', '$_POST[birthday]') WHERE FamilyId = '$famID'");

//GET CHILD ID FROM PREVIOULSY INSERTED RECORD

$kid = mysql_query("SELECT ID FROM child");
$kidID = mysql_num_rows($kid);

//INSERT CHILD INTO CLASS

$ClassIns = mysql_query("INSERT INTO roster (Child, ClassId) VALUES ('$kidID', '$_POST[class]')");


?>

I don't get any errors however the data does not enter into the database

anyone?

mogster

Hmmm...
Try to comment away the sql-sentences and echo the data to see if the $_post values is printed on submit.

Like;
echo $POST[mother]."<br>";
echo $POST[father]."<br>";

and so on.
If it works, you can be sure that the data correctly registers on the receiving script, and may concentrate on checking the sql.

A good idea is then to provoke a mysql error by removing a ' or something, to see what's printed out.
Could it be your mysql-users user rights, perhaps?

Maybe you're not licenced to INSERT? 😃

knutm

mystrymaster

Yeah I tried echoing some of the data and it is indeed there and I am using a global user - I also removed some of the quotes to get errors from mysql and they are all normal erros - it just isn't inserting the data

Anyone?

jpmoriarty

have you tried putting in sample data straight into the database? you may find it's something to do with the table design (a required field, telephone number as an int and you've got spaces in it or something).

just a guess...

mystrymaster

Good guess man that was my first - I have dummy data in there and I can get it.

ecg

have you tried echoing the sql statements and then copying them into the sql executor for your database?
I often find I'm missing a ' or when a usually numeric value = NULL it causes issues... and this is the easiest way to find it.

Let us know how you go
Beth

pinoy

why dont you use $REQUEST varialble instead of $POST varable

mystrymaster

The data getting to this page is not the problem as I am echoing it out and indeed I do get the data.

But what is the difference between $REQUEST and $POST ?

pinoy

$_REQUEST = This is a 'superglobal', or automatic global, variable. This simply means that it is available in all scopes throughout a script

$POST and $GET= These individual globals are not autoglobals it depends on what method you use in your <form> tag at your HTML code.

jpmoriarty

The data getting to this page is not the problem as I am echoing it out and indeed I do get the data.

No that's not what was suggested - have you tried copying the echoed statement and then pasting it into mysql to see if the statement works?

zalath

$POST and $GET= These individual globals are not autoglobals it depends on what method you use in your <form> tag at your HTML code.

Pardon me, but that's not exactly true. Sez the PHP manual:

HTTP POST variables: $_POST
Note: Introduced in 4.1.0. In earlier versions, use $HTTP_POST_VARS.

An associative array of variables passed to the current script via the HTTP POST method. Automatically global in any scope.

This is a 'superglobal', or automatic global, variable. This simply means that it is available in all scopes throughout a script. You don't need to do a global $_POST; to access it within functions or methods, as you do with $HTTP_POST_VARS.

$HTTP_POST_VARS contains the same information, but is not an autoglobal.

So $GET and $POST are super/autoglobals, and IMO it's a better practice to use them - you can verify that the form is being submitted using the correct method. It's easy to confyuse things if you don't.

mystrymaster

I have entered the sql call through the control center and yes it does insert the data that way so that is why I figured it was a problem witrh the php portion of the code.

mystrymaster

Well all thanks for the help - I figured out what was wrong I wasn't inserting something into a required field