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 A (
DATA VARCHAR(10) NOT NULL
);
INSERT INTO A (
DATA
) VALUES ('a');
INSERT INTO A (
DATA
) VALUES ('b');
SELECT * FROM A;
<?php
use Carbon\Carbon;
$query = "SELECT DATA FROM A;";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
extract($row);
var_dump($DATA);
}
for ($i=1; $i <10; ++$i) {
switch ($i % 2) {
case 0:
$stmt = $pdo->prepare($query);
$stmt->execute();
break;
default: continue 1;
}
$row = $stmt->fetch(PDO::FETCH_ASSOC)
echo "hehe$i {$stmt->rowCount()}\n";
}