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 VERSION() as version;"; // // get DB version using PDO // $stmt = $pdo->prepare($query); // $stmt->execute(); // $row = $stmt->fetch(PDO::FETCH_ASSOC); // printf('DB version (PDO): %s ' . PHP_EOL, $row['version']); // // Run query using mysqli // $result = $mysqli->query($query); // $version = $result->fetch_object(); // printf('DB version (mysqli): %s ' . PHP_EOL, $version->version); // // Select using Laravel // $version = $db::select($query); // printf('DB version (Laravel Query Builder): %s ' . PHP_EOL, $version[0]->version); $input = ""; $n = mysqli_real_escape_string(, $input); $q = "select group_concat(correct) as c from assessment where lecture_cate='{$n}' order by description asc"; echo $q;