Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE Foobar (
id VARCHAR(255)
);
INSERT INTO Foobar (id) VALUES ('ten'), ('twelve');
<?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 count(*) as count FROM Foobar;";
$result = mysqli_query($mysqli, $query);
$version = mysqli_fetch_assoc($result);
var_dump($version);
die();
// 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);
$x = $mysqli->query("SHOW TABLES;");
printf('DB version (Laravel Query Builder): %s ' . PHP_EOL, $version[0]->version);