Advertisement
Guest User

Untitled

a guest
Jan 14th, 2017
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. <?php
  2. $password=$_POST['password'];
  3. $regix_id=$_POST['clg_id'];
  4. $host="mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/";
  5. $dbname="regix";
  6. $dbusername="adminZfxWTkx";
  7. $dbpassword="DYwa5Q9kB3Jx";
  8. $dsn="mysql:host=$host;dbname=$dbname;charset=utf8";
  9. try
  10. {
  11. $opt = [
  12. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  13. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  14. PDO::ATTR_EMULATE_PREPARES => false
  15. ];
  16. $mysql_connection=new PDO($dsn,$dbusername,$dbpassword,$opt);
  17. $sql="select password from institute_list where regix_id=?";
  18. $stmt=$mysql_connection->prepare($sql);
  19. $stmt->execute($regix_id);
  20. $row=$stmt->fetch();
  21. if($row)
  22. {
  23. echo "success";
  24. }
  25. else
  26. {
  27. echo "failed";
  28. }
  29. }
  30. catch(PDOException $e)
  31. {
  32. $mysql_connection=null;
  33. echo "error";
  34. }
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement