Multiple query method

1

Hi guys, I just want to know how to query two or more insert to(or any method) in slim framework and bind it in the param…

Here is my code:

$sql = “INSERT INTO user (id, first_name, last_name, email) VALUES (?, ?, ?, ?)”;
$stmt = $this->con->prepare($sql);
$stmt->bind_param(“ssss”, $id, $first_name, $last_name, $email);

The code above works but I need a second insert query. How can I add this query code? Thanks…

INSERT INTO security_user (id, username, password, signup_step, date_created, date_deactivated) VALUES (?, ?, ?, ?, ?, ?)

2

Did you try to just write it like the previous one? :slight_smile:

3

Perhaps you could try a while loop?

4

hi thanks for helping I was just a bit tired, I already did it with just doing the next insert with the same code just change the variable…