Home / Questions / 49230
Accepted
ccfz
Asked: 2020-02-14 08:43:46 +0800 CST 2020-02-14 08:43:46 +0800 CST

PDO on two different INSERTs?

  • 772

Is it possible to make two prepared statements in two INSERTs from different tables that I have in a record, that is, one prepared for each one?

For example, I have this:

INSERT INTO datos (nombre, email) VALUES('$nombre', '$email');
INSERT INTO usuarios (usuario, password, id_datos) VALUES('$usuario','$password_hash','$idDatos');
php

1 Answers

  1. Best Answer

    You can declare two prepared statements without having to call one to declare the other:

    $insert1 = "INSERT INTO datos (nombre, email) VALUES(:nombre, :email);";
$insert2 = "INSERT INTO usuarios (usuario, password, id_datos) VALUES(:usuario,:password_hash,:idDatos);";

$statement1 = $conn->prepare($insert1);
$statement2 = $conn->prepare($insert2);

$statement1->bindValue(':nombre', $nombre, \PDO::PARAM_STR);
...
$statement1->bindValue(':usuario', $usuario, \PDO::PARAM_STR);
...
    • 1