Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
CREATE TABLE language ( code varchar(3), title varchar(64), base int, id int ); INSERT INTO language VALUES ('ru', 'Russian', 0, 1), ('en', 'English', 0, 2);

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php $result = $pdo->query( "SELECT code, title, base, id FROM language ORDER BY base DESC" ); $langs = $result->fetchAll(); $langs = array_combine(array_column($langs, 'code'), $langs); var_export($langs);
Copy Clear