Advertisement
Guest User

Untitled

a guest
Jan 21st, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. <?php
  2.  
  3. $hostname = 'localhost';
  4. $dbname = 'latihan';
  5. $username = 'root';
  6. $password = '';
  7.  
  8. try {
  9. $pdo = new PDO('mysql:host='.$hostname.';dbname='.$dbname, $username, $password, array(
  10. PDO::ATTR_PERSISTENT => true
  11. ));
  12. $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  13. } catch(PDOException $e){
  14. echo "Ada error gan: ".$e->getMessage();
  15. }
  16.  
  17. $sql_select = "SELECT * FROM `artikel`";
  18. $query = $pdo->prepare($sql_select);
  19. $query->execute();
  20. $row = $query->fetchAll();
  21. foreach ($row as $data) {
  22. echo "<h3>Judul = ".$data['judul']."</h3>";
  23. echo "<p>Isi = ".$data['isi']."</p>";
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement