EqFghnwv

1<?php
2
3$driver = 'mysql';
4$database = 'dbname=CODINGGROUND';
5$dsn = "$driver:host=localhost;$database";
6
7$username = 'root';
8$password = 'root';
9
10try {
11    $conn = new PDO($dsn, $username, $password);
12    echo "Database CODINGGROUND Connected\n";
13} catch (PDOException $e) {
14    echo $e->getMessage();
15}
16
17$schema = 'CREATE TABLE IF NOT EXISTS `mitarbeiter_ist` (
18  `ID` int(11) NOT NULL,
19  `nn` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
20  `vn` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
21  `geb` date NOT NULL
22) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
23$conn->query($schema);
24$conn->query('ALTER TABLE `mitarbeiter_ist` ADD PRIMARY KEY (`ID`), ADD UNIQUE KEY `ID` (`ID`)');
25$conn->query('ALTER TABLE `mitarbeiter_ist` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;');
26
27$conn->query('TRUNCATE `mitarbeiter_ist`');
28$conn->query('INSERT INTO `mitarbeiter_ist` (`nn`, `vn`, `geb`) VALUES ("John", "Doe", "2019-01-01")');
29$conn->query('INSERT INTO `mitarbeiter_ist` (`nn`, `vn`, `geb`) VALUES ("Schwartz", "Alexander", "1995-04-19")');
30
31$stmt = $conn->prepare('SELECT * FROM mitarbeiter_ist WHERE `nn` = :nn AND `vn` = :vn AND `geb` = :geb');
32$last_name = "Schwartz";
33$first_name = "Alexander";
34$birthdate = "1995-04-19";
35$stmt->bindParam(':nn', $last_name);
36$stmt->bindParam(':vn', $first_name);
37$stmt->bindParam(':geb', $birthdate);
38
39$stmt->execute();
40while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
41    echo implode(', ', $row) . "\n";
42}