ClarusDignus

Return two database results with the one jQuery AJAX form (o

May 25th, 2014
471
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.53 KB | None | 0 0
  1. <?php
  2. function buildorprojects_ajax(){
  3.      
  4.     global $wpdb;
  5.      
  6.     $sendingclienturn_js = $_POST['sendingclienturn_js'];
  7.    
  8.     $query_buildsorprojects = $wpdb->get_results(
  9.         "
  10.         SELECT *
  11.         FROM wp_crm_bplist
  12.         WHERE clienturn = '$sendingclienturn_js'
  13.         AND deleted <> '1'
  14.         ORDER BY buildorproject, recorddateandtime DESC
  15.         "
  16.     );
  17.      
  18.     if($query_buildsorprojects===FALSE){
  19.         echo "Error";  
  20.     }
  21.     else {
  22.  
  23.        
  24.         foreach ( $query_buildsorprojects as $query_buildorproject ) {
  25.             $aaa= '<option class="filterable_option" value="'.$query_buildorproject->recordurn.'"  data-clienturn="'.$query_buildorproject->clienturn.'">'.$query_buildorproject->buildprojecturn.' - '.$query_buildorproject->buildorproject.' ('.$query_buildorproject->buildorprojecttype.')</option>';
  26.         }  
  27.        
  28.     }
  29.    
  30. ////////////////////////////////////////////////////////////////
  31.     $query_penultimateratings = $wpdb->get_results(
  32.         "
  33.         SELECT *
  34.         FROM wp_crm_aclist
  35.         WHERE clienturn='$sendingclienturn_js'
  36.         AND deleted <> 1
  37.         ORDER BY recorddateandtime DESC
  38.         LIMIT 1
  39.         "
  40.     );
  41.      
  42.     if($query_penultimateratings===FALSE){
  43.         echo "Error";  
  44.     }
  45.     else {
  46.         foreach ( $query_penultimateratings as $query_penultimaterating ){
  47.            
  48.             $bbb =  $query_penultimaterating->prospectstrength;
  49.         }
  50.     }
  51.    
  52.     $aaabbb=array($aaa,$bbb);
  53.     return $aaabbb;
  54. ////////////////////////////////////////////////////////////////
  55.    
  56.     die();
  57. }
  58. add_action('wp_ajax_buildorprojects_ajax', 'buildorprojects_ajax');
  59. add_action('wp_ajax_nopriv_buildorprojects_ajax', 'buildorprojects_ajax');
Advertisement
Add Comment
Please, Sign In to add comment