Difference between revisions of "PHP Datenbankzugriff: PDO"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
===Datenbankzugriff: PDO=== | ===Datenbankzugriff: PDO=== | ||
Link zur alten Seite: https://web.cb-kompetenzen.at/pdo/ | |||
====Verbindung zur MySQL-Datenbank mittels PDO:==== | ====Verbindung zur MySQL-Datenbank mittels PDO:==== |
Revision as of 09:37, 7 July 2022
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 />"; } ?>