Guest User

Untitled

a guest
Jan 19th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. <?php
  2. $driver = 'mysql';
  3. $database = "dbname=CODINGGROUND";
  4. $dsn = "$driver:host=localhost;$database";
  5.  
  6. $username = 'root';
  7. $password = 'root';
  8.  
  9. try {
  10. $conn = new PDO($dsn, $username, $password);
  11. echo "Database CODINGGROUND Connected\n";
  12. }catch(PDOException $e){
  13. echo $e->getMessage();
  14. }
  15. $sql = 'SELECT * FROM users';
  16. $stmt = $conn->prepare($sql);
  17. $stmt->execute();
  18.  
  19. while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
  20. foreach($row as $value)
  21. {
  22. echo sprintf("%s, ", $value);
  23. }
  24. echo "\n";
  25. }
  26. ?>
Add Comment
Please, Sign In to add comment