Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "SELECT * FROM landmarks where L_ID=:id";
- $dbhost = '127.0.0.1';
- $dbuser = 'root';
- $dbpass = '';
- $dbname = 'maalem';
- try {
- $con = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
- $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $con->query('SET NAMES utf8');
- $stmt = $con->prepare($sql);
- $stmt->bindParam("id", $_GET["L_ID"]);
- $stmt->execute();
- $marker = $stmt->fetchObject();
- $con = null;
- echo '{"item":'. json_encode($marker) .'}';
- } catch(PDOException $e) {
- echo '{"error":{"text":'. $e->getMessage() .'}}';
- }
- $sql2="SELECT img FROM image WHERE L_ID=:id";
- try {
- $con = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
- $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $con->query('SET NAMES utf8');
- $stmt = $con->prepare($sql2);
- $stmt->bindParam("id", $_GET["L_ID"]);
- $stmt->execute();
- $img = $stmt->fetchObject();
- $con = null;
- echo '{"img":'. json_encode($img) .'}';
- } catch(PDOException $e) {
- echo '{"error":{"text":'. $e->getMessage() .'}}';
- }
- ?>
- $('#detailsPage').live('pageshow', function(event) {
- var id = getUrlVars()["L_ID"];
- $.getJSON(serviceURL + 'getmarker.php?L_ID='+id, displayMarker);
- });
- function displayMarker(data) {
- var marker = data.item;
- var imgs =data.img;
- console.log(marker);
- console.log(imgs);
- $('#Name').text(marker.Title);
- $('#Dec').text(marker.Description);
- $('#pics').attr('src', 'images/' + imgs.img);
- $('#actionList').listview('refresh');
- }
- function getUrlVars() {
- var vars = [], hash;
- var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
- for(var i = 0; i < hashes.length; i++)
- {
- hash = hashes[i].split('=');
- vars.push(hash[0]);
- vars[hash[0]] = hash[1];
- }
- return vars;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement