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 A (
DATA VARCHAR(10) NOT NULL
);
INSERT INTO A (
DATA
) VALUES ('a');
INSERT INTO A (
DATA
) VALUES ('b');
SELECT * FROM A;
<?php
use Carbon\Carbon;
$query = "SELECT DATA FROM A;";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
// extract($row);
// var_dump($data);
$countries_json = json_decode('{
"name": "Malaysia",
"nativeName": "Malayssadfaia",
},
{
"name": "Singapore",
"nativeName": "Singasdaapore",
},', true);
print_r($countries_json);
$countries = array_values(array_map(function($obj) {
return strtoupper($obj->name);
}, $countries_json));
print_r($countries);