Dump MySQL SQL query to JSON

dump.php

<?php
/*
Usage:

$ php dump.php "SELECT * FROM mytable" > mytable.json
*/

error_reporting(E_ALL | E_STRICT);
ini_set('display_startup_errors', 1);
ini_set('display_errors', 1);
ini_set('default_charset', 'utf-8');
date_default_timezone_set('Europe/Helsinki');

$dbh = new PDO('mysql:dbname=DBHERE;host=127.0.0.1', "USER", "PASS");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$statement = $dbh->prepare($argv[1])->execute();
$l = array();
foreach($statement->fetchAll(PDO::FETCH_ASSOC); as $row) {
  $l[] = (object)$row;
}

echo json_encode($l, JSON_PRETTY_PRINT);