Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$mysqli->query("create table t (id int primary key unique, stat tinyint default 1)");
mysqli_report(MYSQLI_REPORT_OFF);
$stmt = $mysqli->stmt_init();
$stmt->prepare("insert into t (id) values(?)");
$id = 3;
$stmt->bind_param('i',$id);
var_dump($stmt->execute());
$stmt->close();
$stmt = $mysqli->stmt_init();
var_dump($stmt->prepare("insert into t (id) values(?) RETURNING id;"));
$id = 's';
$stmt->bind_param('s',$i);
var_dump($stmt->execute());
?>