call sp and return the last paramete

call-sp.inc.php

function call_sp( \mysqli|\PDO $db, string $sp_name, ...$params ): string
{
        $placeholders   = array_fill( 0, count( $params ), "?" );
        $placeholders[] = "@__newid;

        $sql = "CALL $sp_name( " . implode( ", ", $placeholders ) . " );";

        try {
                LOG->debug( "calling Stored Procedure", [ "sql" => $sql ] );
                if( $db instanceof \mysqli ) {
                        $db->execute_query( $sql, $params );
                        $result   = $db->query( "select @__newid;" );
                        $newid = (string) $result->fetch_column( 0 );
                }        else {
                        $db->prepare( $sql )->execute( $params );
                        $newid= (string) $db->query( "select @__newid;" )->fetchColumn( 0 );
                }
                // get the number of affected rows

                return $newid;

        } catch ( \Exception $e ) {
                LOG->error( "Error calling Stored Procedure", [ "sql" => $sql, "params" => $params, "error" => $e->getMessage() ] );
                throw $e;
        }
}