Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>PHP Data Objects (PDO) and MySQL</title>
- </head>
- <body>
- <!-- used table from database ithtl:
- student: { firstname: string, lastname: string }
- -->
- <?php
- /* build database connection */
- $dsn = 'mysql:dbname=ithtl;host127.0.0.1';
- $user = 'root';
- $password = '';
- try{
- $dbh = new PDO($dsn, $user, $password);
- echo "<h3>Simple query by using the statement query</h3>";
- $sql = "SELECT * FROM student";
- $users = $dbh->query($sql);
- foreach($users as $row){
- print $row["firstname"] . " - " . $row["lastname"] . "<br>";
- }
- echo "<h3>Prepared Statements with unnamed parameters</h3>";
- $statement = $dbh->prepare("SELECT * FROM student WHERE firstname = ? AND lastname = ?");
- $statement->execute(array('Mas', 'Mustermann'));
- while($row = $statment->fetch()){
- echo $row["firstname"] . " " . $row["lastname"] . "<br>";
- }
- }catch(PDOException $e){
- 'Connection failed: ' . $e->getMessage();
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement