PHPize Online / SQLize Online  /  SQLtest Online

<?php $needles = ['primary\s+key','auto_increment']; $regex='/(?=.*?'.implode(')(?=.*?', $needles).')/is'; echo $regex . PHP_EOL . PHP_EOL; $query = " create table department ( department_id int auto_increment primary KEY , name varchar(64) ); insert into department (name) values ('Management'),('Sales'); "; echo (preg_match($regex, $query) ? 'Good' : 'Not good') . PHP_EOL . PHP_EOL . PHP_EOL; $query = "select * from department"; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_NUM); $columns = []; for ($i = 0; $i < $stmt->columnCount(); $i++) { $col = $stmt->getColumnMeta($i); $columns[] = [ 'header'=>$col['name'], 'pdo_type'=>$col['pdo_type'] ]; } echo json_encode([[ 'headers' => $columns, 'data' => $rows ]], JSON_PRETTY_PRINT );