Advertisement
tcelestino

Return json

Jul 30th, 2012
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.14 KB | None | 0 0
  1. <?php
  2.  
  3.  require('../../../../wp-load.php');
  4.  
  5.  global $wpdb;
  6.  
  7.  $lat = $_POST['lat'];
  8.  $lng = $_POST['lng'];
  9.  $date = $_POST['date'];
  10.  $hour = $_POST['hour'];
  11.  
  12.  $query = "SELECT *
  13. FROM {$wpdb->prefix}posts
  14. INNER JOIN {$wpdb->prefix}postmeta m1
  15.  ON ( {$wpdb->prefix}posts.ID = m1.post_id )
  16. INNER JOIN {$wpdb->prefix}postmeta m2
  17.  ON ( {$wpdb->prefix}posts.ID = m2.post_id )
  18. WHERE
  19. {$wpdb->prefix}posts.post_type = 'agenda'
  20. AND {$wpdb->prefix}posts.post_status = 'publish'
  21. AND ( m1.meta_key = '_lat' AND m1.meta_value ='$lat' )
  22. AND ( m2.meta_key = '_lng' AND m2.meta_value = '$lng' )
  23. GROUP BY {$wpdb->prefix}posts.ID
  24. ORDER BY {$wpdb->prefix}posts.post_date
  25. DESC";
  26.  
  27.     $results = $wpdb->get_results($query);
  28.  
  29.    
  30.     $json = array();
  31.  
  32.     foreach($results as $key => $post) {
  33.  
  34.       $id = $post->ID;
  35.       $tit = $post->post_title;
  36.       $ctn = $post->post_content;
  37.  
  38.       $json['local']['id'] = $id;
  39.       $json['local']['tit'] = $tit;
  40.       $json['local']['ctn'] = $ctn;
  41.       $json['local']['lat'] = $lat;
  42.       $json['local']['lng'] = $lng;
  43.       $json['local']['hour'] = $hour;
  44.     }
  45.  
  46.  
  47.     echo json_encode($json);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement