Advertisement
Guest User

Untitled

a guest
May 12th, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. <?php
  2. $hostname="localhost";
  3. $db="lab8";
  4. $Username="user1";
  5. $Password="user1abc";
  6.  
  7.  
  8. $conn=new PDO("mysql:host=$hostname;dbname=$db",$Username,$Password);
  9. $sql= "select StudentID from students";
  10.  
  11. try
  12. {
  13. echo "Connected successfully";
  14. $stmt=$conn->prepare($sql);
  15. $stmt->execute();
  16. $results=$stmt->fetchAll();
  17.  
  18. }
  19. catch(Exception $ex)
  20. {
  21. echo($ex -> getMessage());
  22. }
  23.  
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement