Form involving two queries into two table

[mizz key_me]

I have to make a form for student registration.

 

In my db, there are student and parents table where parent_icno is the foreign key in student.

 

And here's the code

 

	 <?php
	if(isset($_POST['add'])) {
				$student_name = addslashes($_POST['student_name']);
				$student_regno = addslashes($_POST['student_regno']);
				$student_gender = addslashes($_POST['student_gender']);
				$student_add = addslashes($_POST['student_add']);
			//	$student_dob = addslashes($_POST['student_dob']);
				$d1 = addslashes($_POST['d1']);
				$d2 = addslashes($_POST['d2']);
				$d3 = addslashes($_POST['d3']);
				$d = $d3."/".$d2."/".$d1;	
                                        $parent_name = addslashes($_POST['parent_name']);
				$parent_icno = addslashes($_POST['parent_icno']);
				$parent_job = addslashes($_POST['parent_job']);
				$parent_dependant = addslashes($_POST['parent_dependant']);
				$parent_totsalary = addslashes($_POST['parent_totsalary']);
				$parent_contactno = addslashes($_POST['parent_contactno']);

				include 'db_connect.php';

				$query1 = "	INSERT INTO student (student_name, student_regno, student_dob, student_gender, student_add)
							VALUES ('$student_name', '$student_regno', '$d', '$student_gender', '$student_add') WHERE student.parent_icno='$parents.parent_icno'";
                                        $query2 = $query = "INSERT INTO parents (parent_name, parent_icno, parent_job, parent_dependant, parent_totsalary,
						parent_contactno)
						VALUES ('$parent_name', '$parent_icno', '$parent_job', '$parent_dependant', '$parent_totsalary',
						'$parent_contactno')";

				$result = mysql_query($query) or die('SQL Error');
				if($result)
							echo 'Add success. Your request is been processed';
				else
							echo 'Add failed!! Try again.';


	}
	?>

 

I dont know where's my mistake..but the data did not get into both table...

Help me..

[waynew]

Could you post:

 

var_dump($_POST);

 

At the start of your file so that we can see if those $_POST variables are actually coming through?

 

Also, you should be using mysql_real_escape_string() instead of addslashes() to stop injection.

[mizz key_me]

may i know what "var_dump($_POST); for?

 

Here's my overall codes

<form action="registration.php" method="post">
<table width="596" border="0">
  <tr>
    <th width="286" scope="col" align="left"><span class="style11">Name :</span></th>
    <th width="300" scope="col" align="left"><input type="student_name" value="" size="50" maxlength="50" /></th>
  </tr>
  <tr>
  <td align="left" class="style11">Birth Certificate No. :</td>
  <td align="left"><input type="student_regno" value="" size="7" maxlength="7" /></td>
  </tr>
  <tr>
    <td align="left"><span class="style11">Date of Birth :</span></td>
    <td align="left"><select name="d1">
      <option value="">Day</option>
      <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
      <option value="6">6</option>
      <option value="7">7</option>
      <option value="8">8</option>
      <option value="9">9</option>
      <option value="10">10</option>
      <option value="11">11</option>
      <option value="12">12</option>
      <option value="13">13</option>
      <option value="14">14</option>
      <option value="15">15</option>
      <option value="16">16</option>
      <option value="17">17</option>
      <option value="18">18</option>
      <option value="19">19</option>
      <option value="20">20</option>
      <option value="21">21</option>
      <option value="22">22</option>
      <option value="23">23</option>
      <option value="24">24</option>
      <option value="25">25</option>
      <option value="26">26</option>
      <option value="27">27</option>
      <option value="28">28</option>
      <option value="29">29</option>
      <option value="30">30</option>
      <option value="31">31</option>
    </select>
      <select name="d2">
        <option value="">Month</option>
        <option value="1">January</option>
        <option value="2">February</option>
        <option value="3">March</option>
        <option value="4">April</option>
        <option value="5">May</option>
        <option value="6">June</option>
        <option value="7">July</option>
        <option value="8">August</option>
        <option value="9">September</option>
        <option value="10">October</option>
        <option value="11">November</option>
        <option value="12">December</option>
      </select>
      <select name="d3">
        <option value="">Year</option>
        <option value="2000">2000</option>
        <option value="2001">2001</option>
        <option value="2002">2002</option>
        <option value="2003">2003</option>
      </select>
    </td>
  </tr>
  <tr>
    <td align="left" class="style11">Gender :</td>
    <td align="left"><input name="student_gender" type="radio" value="MALE" /> <span class="style13">Male</span> 
    <input name="student_gender" type="radio" value="FEMALE" /> 
    <span class="style13">Female </span></td>
  </tr>
  <tr>
    <td align="left" class="style11">Father's / Guardian's Name :</td>
    <td align="left"><input type="parent_name" size="40" maxlength="40" value=""/></td>
  </tr>
  <tr>
    <td align="left" class="style11">Father's / Guardian's I/C No. :</td>
    <td align="left"><input type="parent_icno" size="12" maxlength="12" value=""/> <span class="style13">Ex : 630321015432</span></td>
  </tr>
  <tr>
    <td align="left" class="style11">Father's / Guardian's Occupation :</td>
    <td align="left">
      <input name="parent_job" type="text" size="30" maxlength="30" value=""/>
    </td>
  </tr>
  <tr>
    <td align="left" class="style11">Jumlah Tanggungan :</td>
    <td align="left"><input type="parent_dependant" size="3" maxlength="3" value=""/> 
      <span class="style13">person</span></td>
  </tr>
  <tr>
    <td align="left" class="style11">Total Monthly Salary :</td>
    <td align="left"><span class="style13">RM</span> 
    <input type="parent_totsalary" size="7" maxlength="7" value=""/></td>
  </tr>
  <tr>
    <td align="left" class="style11">Home Address :</td>
    <td align="left"><input name="student_add" type="text" size="40" maxlength="40" value=""/></td>
  </tr>
  <tr>
    <td align="left" class="style11">Contact No. :</td>
    <td align="left"><input name="parent_contactno" type="text" size="10" maxlength="10" value=""/>
      <span class="style13"> Ex : 0123456789</span></td>
  </tr>

[revraz]

You have a few problems, and using mysql_error after your queries would show you why your INSERTs are failing.

 

INSERT means to add a new record/row.  There is no reason to use WHERE since the row doesn't exist yet.

 

What is this supposed to do?

 

$query2 = $query = "INSERT INTO ...blah blah

 

http://dev.mysql.com/doc/refman/5.0/en/insert.html

[mizz key_me]

oops, my mistake...

i've correct it..but still the same error..

 

since i have to make the foreign key get into both table, what code should i really use?

Sorry for asking simple things..