php创建带主键表,php - 如何插入主键第二张表

if (isset($_POST['submit']))

{

$firstname=$_POST['firstname'];

$lastname=$_POST['lastname'];

$gender=$_POST['gender'];

$datofbirth=$_POST['dateofbirth'];

$primary_email=$_POST['primary_email'];

$Email_Confirm=$_POST['Email_Confirm'];

$phone=$_POST['contact'];

$password=$_POST['password'];

$confirmpassword=$_POST['confirmpassword'];

$username= $_POST['username'];

$status=2;

//payment information

$ownername=$_POST['ownername'];

$cvvnumber=$_POST['cvvnumber'];

$cardnumber=$_POST['cardnumber'];

$cardtype=$_POST['cardtype'];

$expirydate=$_POST['expirydate'];

$balance=$_POST['money'];

$mysql_get_users = mysql_query("SELECT * FROM user where username='$username'");

$get_rows = mysql_affected_rows($conn);

if($get_rows >=1)

{

echo "user exists";die();

}

else

{

$query1= mysql_query("

INSERT INTO

user

(firstname,lastname,gender,datofbirth,primary_email,contact,password,username,status)

VALUES

('$firstname','$lastname','$gender','$datofbirth','$primary_email','$phone','$password','$username','$status')");

$query2 = mysql_query("

INSERT INTO

payment_details

(Owner_Name,CVV_Numer,Card_Number,Card_Balance,Card_Type,Validation)

VALUES

('$ownername','$cvvnumber','$cardnumber','$balance','$cardtype','$expirydate')");