PHPize Online / SQLize Online  /  SQLtest Online

<?php use Carbon\Carbon; $now = Carbon::now()->format('d/m/Y'); printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion()); $query = 'SELECT column1, column2, column3 from table1 where column1 = "tree"'; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($row as &$rowvalue) { $rowvalue['column2'] = strval($rowvalue['column2']); } echo json_encode($row, JSON_PRETTY_PRINT);