Advertisement
Guest User

Untitled

a guest
Apr 4th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.59 KB | None | 0 0
  1. <?php
  2. error_reporting(-1);
  3. ini_set('display_errors',1);
  4.  
  5. $dbUser = 'testUser';
  6. $dbName = 'testDB';
  7. $dbPassword = 'test';
  8. $dbHost = 'localhost';
  9. $dbCharset='utf-8';
  10. $dsn = sprintf('host=%s;dbname=%s;charset=%s',$dbHost,$dbName,$dbCharset);
  11. $db = new PDO($dsn,$dbUser,$dbPassword);
  12. $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  13.  
  14. $sql = "SELECT * FROM table";
  15.  
  16. $statement = $db->query($sql);
  17. $rows = $statement->fetchAll(PDO::FETCH_OBJ);
  18. ?>
  19.  
  20. <?php foreach($rows as $row):?>
  21. <a href="домен/student/?param=<?= $row->param ?>"><?= $row->text ?></a>
  22. <?php endforeach;?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement