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
CREATE TABLE user_value
(`a` int, `b` int)
;
INSERT INTO `user_value` (`a`, `b`) VALUES (12, 13);
SELECT * FROM `user_value`;
<?php
/* create a prepared statement */
$stmt = $mysqli->prepare("SELECT * FROM user_value");
/* bind parameters for markers */
//$stmt->bind_param("s", $city);
/* execute query */
$stmt->execute();
/* bind result variables */
$stmt->bind_result($a, $b);
/* fetch value */
$stmt->fetch();
printf("result %d, %d\n", $a, $b);
echo "\n";
if ($a === 12) {
echo "uguale";
} else {
echo "diverso";
}