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 users (id int, Rn decimal(9,2));
insert into users(id) values(1);
<?php
$id = 1;
$num = 1.1;
echo $num;
// Run query using mysqli
$result = $mysqli->query("SELECT * FROM users;");
$users = $result->fetch_all();
print_r($users);
$query = "UPDATE users SET Rn=" . $num . " WHERE id=" . $id . "";
$mysqli->query($query);
$result = $mysqli->query("SELECT * FROM users;");
$users = $result->fetch_all();
print_r($users);