<!-- Collection of code snippets by Arne Vajhøj -->
<!-- posted to eksperten.dk, usenet and other places (2002-now) -->
<?php
function dump($con, $lbl) {
        print "$lbl:\r\n";
        if($rs = $con->query('SELECT * FROM T1')) {
            while ($row = $rs->fetch_array()) {
                print $row['F1'] . ' ' . $row['F2'] . "\r\n";
            }
        } else {
            die($con->error);
        }
        $rs->free();
}

$con = new mysqli('localhost', 'root', '', 'Test');
if(mysqli_connect_errno()) {
    die(mysqli_connect_error());
}
dump($con, 'Before');
$f1 = 77;
$f2 = 'XX';
$stmt = $con->prepare('INSERT INTO T1 VALUES(?,?)');
print $stmt->param_count . "\r\n";
if(!$stmt->bind_param('is', $f1, $f2)) {
        die($con->error);
}
if(!$stmt->execute()) {
        die($stmt->error);
}
dump($con, 'After');
$con->close();
?>