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_db (id int, name varchar(64));
insert into User_db values (1, 'User 1');
<?php
$sql_all_user="SELECT * FROM `User_db`";
$stmt = $pdo->prepare($sql_all_user);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($result, JSON_NUMERIC_CHECK);