How to Insert values on Multiple Table on my data base

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;
                }
        }
    }

>Solution :

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));

Leave a Reply