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 (f float)");
$mysqli->query("insert into t values (1.25)");
echo "true\n";
$mysqli->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, true);
$stmt = $mysqli->prepare("select * from t");
$stmt->execute();
var_dump($stmt->get_result()->fetch_row()[0]);
var_dump($mysqli->query("select * from t")->fetch_row()[0]);
echo "false\n";
$mysqli->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, false);
$stmt = $mysqli->prepare("select * from t");
$stmt->execute();
var_dump($stmt->get_result()->fetch_row()[0]);
var_dump($mysqli->query("select * from t")->fetch_row()[0]);