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
DELIMITER $$
CREATE PROCEDURE `counter`(INOUT `inc` INT)
DETERMINISTIC
SET inc=inc+1$$
DELIMITER ;
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
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']);
$nr = 0;
$query = "SET @nr = ?; Call counter(@nr)";
$stmt = $pdo->prepare($query);
$stmt->execute([$nr]);
var_dump($stmt->fetch(PDO::FETCH_ASSOC));