Question 21400 in Mysql Question posted in
The official MySQL documentation can be found here.

How to Insert values on Multiple Table on my data base – Mysql

I need to insert values into multiple table. Please correct my code because it just double the inserted value on table_attendace

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

        $text =$_POST['text'];


        // insert query 
        $sql = "INSERT INTO table_attendance(NAME,TIMEIN) VALUES('$text',NOW())";
        $query =mysqli_query($conn,$sql) or die(mysqli_error($conn));
        
        if($query==1) 
        {
            $ins="INSERT INTO table_attendancebackup(NAME,TIMEIN) VALUES('$text',NOW())";
            $quey=mysqli_query($conn,$sql) or die(mysqli_error($conn));
                if ($quey==1) {
                    $_SESSION['success'] = 'Action Done';
                }else{
                    $_SESSION['error'] = $conn->error;
                }
        }
    }
Tags:

2

Answers


  1. 0

    In the second query, you reused the first query $sql again, instead of using $ins.
    It should be

    $quey=mysqli_query($conn,$ins) or die(mysqli_error($conn));
    Login or Signup to reply.
  2. 0

    you can write two queries in single variable with semicolon then you can save the same data in both table.

    And
    $quey=mysqli_query($conn,$sql) or die(mysqli_error($conn)); -> in this line you placed the $ins variable wrongly instead of $ins.

    $sql = "INSERT INTO table_attendance(NAME,TIMEIN) VALUES('$text',NOW()); INSERT INTO table_ttendancebackup(NAME,TIMEIN) VALUES('$text',NOW())";

$query = mysqli_query($conn, $sql) or die(mysqli_error($conn));
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search