How to work with transactions and prepared statement in php?

Question

PHP

Good afternoon! My project uses PostgreSQL and PHP.
The question was - how can I do multiple inserts but be able to rollback at the end using pg_prepare ? I really need bind variables...

Answer 1

PDO has everything for this www.php.net/manual/ru/book.pdo.php

Answer 2

I recommend PDO.

$db = new PDO(....connect .... );
$db->beginTransaction();

        if(
            $db->exec('custom sql') &&
            $db->exec('custom sql') &&
            $db->exec('custom sql') &&
            $db->exec('custom sql') &&
....
            $db->exec('custom sql')
        ){
            $db->commit();
        } else {
            $db->rollBack();
        }