Guest User

Untitled

a guest
Nov 1st, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. <?php
  2. $dsn = 'mysql:dbname=idle;host=localhost';
  3. $user = 'idlemaster';
  4. $password = 'idlepass';
  5.  
  6. print('MySQLへの接続テスト'.'<br />');
  7. try{
  8. $dbh = new PDO($dsn, $user, $password);
  9.  
  10. $sql = 'select * from idlename';
  11. foreach ($dbh->query($sql) as $row) {
  12. print($row['id'].'->');
  13. print($row['name']);
  14. print('<br />');
  15. }
  16. }catch (PDOException $e){
  17. print('Error:'.$e->getMessage());
  18. die();
  19. }
  20. $dbh = null;
Add Comment
Please, Sign In to add comment