PHPize Online / SQLize Online  /  SQLtest Online

<?php $sql = "SELECT TOP 2 * FROM tAuthors WHERE AuthorAge=:age"; $params = [':age'=> 40]; //v1 $query = $pdo->prepare($sql); $query->execute($params); $response = $query->fetchAll(PDO::FETCH_ASSOC); print_r($response); //v2 function query($sql, $params = array()) { global $pdo; $query = $pdo->prepare($sql); $result = false; try { if ($query &&$query->execute($params)) { $data = array(); while ($row = $query->fetch(\PDO::FETCH_ASSOC)) { $data[] = $row; } $result = new \stdClass(); $result->row = (isset($data[0]) ? $data[0] : array()); $result->rows = $data; $result->num_rows = $query->rowCount(); } } catch (\PDOException $e) { throw new \Exception('Error: ' . $e->getMessage() . ' Error Code : ' . $e->getCode() . ' <br />' . $sql); } if ($result) { return $result; } else { $result = new \stdClass(); $result->row = array(); $result->rows = array(); $result->num_rows = 0; return $result; } } $res = query($sql,$params); print_r($res);