php - insert record from temp table to new table and also delete from temp table -

<?php include("conn.php"); ?> <?php $id=$_get['id']; $name=$_post['name'];  $fathers_name=$_post['fathers_name']; $gotra=$_post['gotra']; $image=$_post['image']; $village=$_post['village']; $company_name=$_post['company_name']; $address1=$_post['address1']; $address2=$_post['address2']; $city=$_post['city']; $pincode=$_post['pincode']; $mobile1=$_post['mobile1']; $mobile2=$_post['mobile2']; $village_number=$_post['village_number']; if($_post['add2']) { $i=mysql_query("insert members_data values(null,'".$name."','".$fathers_name."','".$gotra."','".$image."','".$village."','".$company_name."','".$address1."','".$address2."','".$city."','".$pincode."','".$mobile1."','".$mobile2."','".$village_number."')");   $res=mysql_query("select id temp_members_data 'id' = '$id'");  $row=mysql_fetch_array($res);  mysql_query("delete temp_members_data 'id' = '$id'");   } ?> 

i need in inserting in 1 table , deleting table clicking add button. adding in main table , deleting temp table. please correcting above. if suggest move old new please correct code above , show fresher in php.

the form this:

<form method="post" action="add2.php?id=<?php echo $row['id']?>" name="file" enctype="multipart/form-data"> ............... <input type="submit" name="add2" value="add" /> 

please not getting solution anywhere.

create connection:

$conn = new mysqli($servername, $username, $password, $dbname); 

prepare insert statement:

$sql = "insert myguests (firstname, lastname, email) values ('john', 'doe', 'john@example.com')"; 

run statement:

if (mysqli_query($conn, $sql)) {     echo "new record created successfully"; } else {     echo "error: " . $sql . "<br>" . mysqli_error($conn); } 

to delete:

sql delete record $sql = "delete temp_members_data id= '".$id."'";  if ($conn->query($sql) === true) {     echo "record deleted successfully"; } else {     echo "error deleting record: " . $conn->error; } 

you can always:

echo $sql; 

your statements check if u have put "" in correct way , statement getting.

also care :

warning: extension (mysql) deprecated of php 5.5.0, ,  removed in future. instead, mysqli or pdo_mysql extension  should used. 

you can read more here w3schools.com / sql tutorial