PHP Datenbankzugriff: PDO
Revision as of 09:37, 7 July 2022 by 85.31.21.47 (talk)
Datenbankzugriff: PDO
Link zur alten Seite: https://web.cb-kompetenzen.at/pdo/
Verbindung zur MySQL-Datenbank mittels PDO:
<?php $pdo = new PDO('mysql:host=localhost;dbname=test-db', 'root', ''); ?>
Mit Try, Catch-Block
<?php try { $pdo = new PDO('mysql:host=localhost;dbname=test-db', 'root', ''); } catch(PDOException $e) { echo $e->getMessage(); } ?>
SQL Query an Datenbank senden:
<?php $pdo = new PDO('mysql:host=localhost;dbname=test-db', 'root', ''); $sql = "SELECT * FROM users"; foreach ($pdo->query($sql) as $row) { echo $row['email']."<br />"; echo $row['firstName']."<br />"; echo $row['lastName']."<br /><br />"; } ?>