phpmysqliprepared-statement

Multiple Prepared statements in PHP with MySQLi


I want to make two prepared statements, one right after the other in PHP with MySQLi. I am a novice at PHP and MySQLi so I don't know whether I should close the statement, close the database connection, put all of the code in a function, or just have code not inside a function.

Basically, I just want to insert a record into one table and then insert the same record into another table using MySQLi.


Solution

  • Directly off the mysqli page: http://php.net/manual/en/mysqli.commit.php

    <?php
    mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
    $mysqli = new mysqli("localhost", "root", "", "");
    $mysqli->set_charset('utf8mb4');
    
    /* set autocommit to off */
    $mysqli->autocommit(FALSE);
    
    $stmt1 = $mysqli->prepare("INSERT INTO tbl1 (id, intro) VALUES (?, ?)");
    $stmt2 = $mysqli->prepare("INSERT INTO tbl2 (id, name) VALUES (?, ?)");
    
    $str1 = 'abc';
    $str2 = 'efg';
    $str3 = 'hij';
    $str4 = 'klm';
    
    $stmt1->bind_param('ss', $str1, $str2);
    $stmt2->bind_param('ss', $str3,$str4);
    
    $stmt1->execute();
    $stmt2->execute();
    
    /* commit and set autocommit to on */
    $mysqli->autocommit(true);