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();
do {
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (isset($result[0]['a'])) {
$esito = $result[0]['a'];
}
} while ($stmt->nextRowset());
echo "\n";
if ($esito === 12) {
echo "uguale";
} else {
echo "diverso";
}