Guest User

Untitled

a guest
Nov 16th, 2017
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. $dsn = 'mysql:dbname=testdb;host=127.0.0.1';
  2. $user = 'dbuser';
  3. $password = 'dbpass';
  4.  
  5. try {
  6. $db = new PDO($dsn, $user, $password);
  7. } catch (PDOException $e) {
  8. echo 'Connection failed: ' . $e->getMessage();
  9. exit;
  10. }
  11.  
  12. $sql = 'SELECT * FROM apartments';
  13. $apartments = $db->query($sql);
  14.  
  15. // Render template.
  16. ob_start();
  17. include 'view/apartments/index.phtml';
  18. echo ob_get_clean();
  19.  
  20. ?>
  21.  
  22. <?php foreach ($apartments as $item) :?>
  23. <?php if ($item['free'] == 1) :?>
  24. <div style="display:inline">
  25. <? else: ?>
  26. <div style="display:none">
  27. <?php endif; ?>
  28. <!-- Place div content here -->
  29. </div>
  30. <?php endforeach; ?>
Add Comment
Please, Sign In to add comment