Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
<?php $pdo = createConnection(); // Simple query (no user data — safe) $stmt = $pdo->query("SELECT * FROM categories ORDER BY name"); $categories = $stmt->fetchAll(); // Row count echo $stmt->rowCount(); // Single row $stmt = $pdo->query("SELECT COUNT(*) as total FROM users"); $row = $stmt->fetch(); echo $row["total"];
Result
Open