PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
DELIMITER $$ CREATE PROCEDURE `counter`(INOUT `inc` INT) DETERMINISTIC SET inc=inc+1$$ DELIMITER ;
Copy Clear
Copy Format Clear
<?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));
Show:  
Copy Clear