Advertisement
Guest User

Untitled

a guest
Mar 8th, 2017
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2. $cooktime = '100';
  3. $username = 'id1016101_foodaids';
  4. $password = 'foodaids';
  5. $host = 'localhost'; //use localhost if on same server
  6. $dbname = 'id1016101_foodaids';
  7. $options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8');
  8. try
  9. {
  10. $db = new PDO("mysql:host={$host};dbname={$dbname};charset=utf8", $username, $password, $options);
  11. $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  12. $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  13. }
  14. catch(PDOException $ex)
  15. {
  16. die("Failed to connect to the database. Please contact administrator ");
  17. }
  18. $stmt = $db->prepare("SELECT * FROM `foodaids` WHERE cooktime> ?");
  19. $stmt->execute(array(
  20. $cooktime
  21. ));
  22. $depositrow = $stmt->fetch();
  23. echo $depositrow['title'];
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement