PHPize Online / SQLize Online  /  SQLtest Online

<?php use Carbon\Carbon; use Illuminate\Support\Facades\DB; // Ensure you're importing the DB facade $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 data from records table using Laravel Query Builder $query = "SELECT * FROM records"; $records = DB::select($query); // Print out the records printf("Database data: \n"); foreach ($records as $record) { // Assuming 'id' and 'name' columns in the 'records' table, change accordingly printf("Record ID: %d, Name: %s\n", $record->id, $record->name); } // Select using Laravel Query Builder for DB version (as in the previous example) $version = DB::select($query); printf('DB version (Laravel Query Builder): %s ' . PHP_EOL, $version[0]->version);