kawwТо есть если раньше моя функция выглядела так
function addUser() {
$request = \Slim\Slim::getInstance()->request();
$user = json_decode($request->getBody());
$sql = "INSERT INTO info (name, email, telephone, address, street, city, state, zip) VALUES (:name, :email, :telephone, :address, :street, :city, :state, :zip)";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->bindParam("name", $user->name);
$stmt->execute();
$user->id = $db->lastInsertId();
$db = null;
echo json_encode($user);
} catch(PDOException $e) {
echo '{"error":{"text":'. $e->getMessage() .'}}';
}
}
то сейчас будет так?
function addUser() {
$request = \Slim\Slim::getInstance()->request();
$user = json_decode($request->getBody());
try {
$db->beginTransaction()
$db->insert('into info (name, email, telephone, address) values (:name, :email, :telephone, :address)');
$db->insert('into addressInfo (street, city, state, zip) values (:street, :city, :state, :zip)');
$db->commit()
} catch(DbException $e) {
$db->rollBack()
}
}