Advertisement
Guest User

Untitled

a guest
Feb 11th, 2017
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. $sql = "SELECT * FROM landmarks where L_ID=:id";
  2.  
  3. $dbhost = '127.0.0.1';
  4. $dbuser = 'root';
  5. $dbpass = '';
  6. $dbname = 'maalem';
  7. try {
  8. $con = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
  9. $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  10. $con->query('SET NAMES utf8');
  11. $stmt = $con->prepare($sql);
  12. $stmt->bindParam("id", $_GET["L_ID"]);
  13. $stmt->execute();
  14. $marker = $stmt->fetchObject();
  15. $con = null;
  16. echo '{"item":'. json_encode($marker) .'}';
  17. } catch(PDOException $e) {
  18. echo '{"error":{"text":'. $e->getMessage() .'}}';
  19. }
  20.  
  21. $sql2="SELECT img FROM image WHERE L_ID=:id";
  22.  
  23. try {
  24. $con = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
  25. $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  26. $con->query('SET NAMES utf8');
  27. $stmt = $con->prepare($sql2);
  28. $stmt->bindParam("id", $_GET["L_ID"]);
  29. $stmt->execute();
  30. $img = $stmt->fetchObject();
  31. $con = null;
  32. echo '{"img":'. json_encode($img) .'}';
  33. } catch(PDOException $e) {
  34. echo '{"error":{"text":'. $e->getMessage() .'}}';
  35. }
  36.  
  37. ?>
  38.  
  39. $('#detailsPage').live('pageshow', function(event) {
  40. var id = getUrlVars()["L_ID"];
  41. $.getJSON(serviceURL + 'getmarker.php?L_ID='+id, displayMarker);
  42. });
  43.  
  44. function displayMarker(data) {
  45. var marker = data.item;
  46. var imgs =data.img;
  47. console.log(marker);
  48. console.log(imgs);
  49.  
  50. $('#Name').text(marker.Title);
  51. $('#Dec').text(marker.Description);
  52. $('#pics').attr('src', 'images/' + imgs.img);
  53.  
  54.  
  55. $('#actionList').listview('refresh');
  56.  
  57. }
  58.  
  59. function getUrlVars() {
  60. var vars = [], hash;
  61. var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
  62. for(var i = 0; i < hashes.length; i++)
  63. {
  64. hash = hashes[i].split('=');
  65. vars.push(hash[0]);
  66. vars[hash[0]] = hash[1];
  67. }
  68. return vars;
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement