Advertisement
Guest User

DB connect template

a guest
Oct 20th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1.  
  2. <?php
  3.  
  4. $servername = "********";
  5. $username = "****";
  6. $password = "*****";
  7. $dbname = "database_name";
  8.  
  9. // connect to the database
  10. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  11.  
  12.  
  13.  
  14. $query = $conn->prepare("SELECT * FROM table_name")
  15.  
  16. $bResult = $query->execute();
  17. $sjResponse = $bResult ? '{"status":"ok"}' : '{"status":"error"}' ;
  18.  
  19. echo $sjResponse;
  20.  
  21. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement