如何从table1到tabel2获取id？

Question

if ( isset( $_POST['add'] ) ) {

      $id = $sql['id'];
      $sql = "SELECT * FROM table1 WHERE id IN (id1, id2, ..., idn)";

      $insert = "INSERT INTO table1(firstname,lastname,birthday,numbers,numbers2,aadress,vali) VALUES('$firstname','$lastname','$birthday','$number','$capture_field_vals1','$aadress','$vali')";


      $insert2 = "INSERT INTO table2(number1, number2, number3, number4, number5, number6, number7, number8, number9, number10) VALUES('" . $capture_field_vals[0] . "','" . $capture_field_vals[1] . "','" . $capture_field_vals[2] . "','" . $capture_field_vals[3] . "','" . $capture_field_vals[4] . "','" . $capture_field_vals[5] . "','" . $capture_field_vals[6] . "','" . $capture_field_vals[7] . "','" . $capture_field_vals[8] . "','" . $capture_field_vals[9] . "')";
      $insert3 = "INSERT INTO table2 (contactID) VALUES ('$id')";
                    //$sql.= " WHERE id = '$id' ";


        if(mysql_query($insert)) {
            //echo "$eesnimi $perenimi ON $aastad AASTAT VANA";
        } else {
          //echo "Cannot Insert";
          }
  if(mysql_query($insert2)) {echo "KORRAS";} else {echo "Cannot Insert";}
  if(mysql_query($insert3)){echo 'KORRAS';}  else{echo 'Cannot Insert';}
}

Question is, how do I get table1 ID into table2 contactID ?

I tried a lot with different ways, but no output..

Answer 1

You can use this function: mysqli_insert_id()

Just do the first insert and request the insert ID afterwards:

$insert = "INSERT INTO table1(firstname,lastname,birthday,numbers,numbers2,aadress,vali) VALUES('$firstname','$lastname','$birthday','$number','$capture_field_vals1','$aadress','$vali')";
if(mysqli_query($insert)) {
  $insertID = mysqli_insert_id();
  $insert2 = "INSERT INTO table2(number1, number2, number3, number4, number5, number6, number7, number8, number9, number10) VALUES('" . $capture_field_vals[0] . "','" . $capture_field_vals[1] . "','" . $capture_field_vals[2] . "','" . $capture_field_vals[3] . "','" . $capture_field_vals[4] . "','" . $capture_field_vals[5] . "','" . $capture_field_vals[6] . "','" . $capture_field_vals[7] . "','" . $capture_field_vals[8] . "','" . $capture_field_vals[9] . "')";
  $insert3 = "INSERT INTO table2 (contactID) VALUES ('$insertID')";
  mysqli_query($insert2);
  mysqli_query($insert3);
}

BTW: You should use mysqli_* functions rather than mysql_* as they are deprecated.