September 2015 - Estuff Code - Advanced Coding Blog

How to get recharge response status in XML format and checking mobile no is allocated to someone or not using PHP

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<pre brush="php">
<!--php include("../lib/opin.inc.php"); 
@Header('Content-type: text/xml');
$mobileno = $_GET['mobileno'];

//echo $mobileno."asaas";
        //$find_mobile_number_query = $BSC--->db_query("SELECT * FROM #_stock WHERE `msisdn`='".$mobileno."' and ");
  $find_mobile_number_query = $BSC->db_query("SELECT * FROM #_stock WHERE `msisdn`=".$mobileno." and `over_partners` = 2 and `sim_type` = 'Pre Paid' and `typez` = 'presim' and `sim_status` = 'Active'");
  
          //$caf_result = $BSC->db_fetch_array($find_mobile_number_query);
$rss_txt = '<Xml>';
$rss_txt .= '<recharge_data>';
    //echo $find_mobile_number_query;
    $find =  mysql_num_rows($find_mobile_number_query);
     //echo $find;
   if($find > 0)
   {
          $lstatus = $BSC->getSingleresult("select lstatus from #_stock WHERE `msisdn`=".$mobileno."");
          if($lstatus=='Challaned Out')
       {
        $userid = $BSC->getSingleresult("select userid from #_stock WHERE `msisdn`=".$mobileno."");
        $userid_info = $BSC->db_query("select fname, lname, email from #_member WHERE `pid`=".$userid."");
        $userid_result = $BSC->db_fetch_array($userid_info);
        $status = 1;
             $rss_txt .= '<status>' .$status. '</status>';
                            $rss_txt .= '<Executivefname>' .$userid_result[0]. '</Executivefname>';            
                            $rss_txt .= '<Executivelname>' .$userid_result[1]. '</Executivelname>';
       $rss_txt .= '<Executiveemail>' .$userid_result[2]. '</Executiveemail>';
       
        // echo "Executive name: ".$userid_result[0]." ".$userid_result[1].",<br /> Email Id: ".$userid_result[2];
       }
         
         else if($lstatus=='Customer')
       {
        $ltrans = $BSC->getSingleresult("select ltrans from #_stock WHERE `msisdn`=".$mobileno."");
        $cafid_info = $BSC->db_query("select fname, lname, email from #_member WHERE `cafid`=".$ltrans."");
        $cafid_info_result = $BSC->db_fetch_array($cafid_info);
        $status = 1;
             $rss_txt .= '<status>' .$status. '</status>';
             $rss_txt .= '<Customerfname>' .$cafid_info_result[0]. '</Customerfname>';            
                            $rss_txt .= '<Customerlname>' .$cafid_info_result[1]. '</Customerlname>';
       $rss_txt .= '<Customeremail>' .$cafid_info_result[2]. '</Customeremail>';
        
             //echo "Customer name: ".$cafid_info_result[0]." ".$cafid_info_result[1].",<br /> Customer Email Id: ".$cafid_info_result[2];
        }
     else{
      
      $status = 0;
               $rss_txt .= '<status>' .$status. '</status>';
     }
   //$status = 1;
   //echo $status."Sim Available";
   }
   else{
   
   $status = 0;
   $rss_txt .= '<status>' .$status. '</status>';
   
   //echo $status."Sim Not Available";
    }

$rss_txt .= '</recharge_data>';
$rss_txt .= '</Xml>';
echo $rss_txt;
    
//SELECT * FROM `owt_stock` WHERE `msisdn` !='' and `over_partners` = 2 and `sim_type` = 'Pre Paid' and `typez` = 'presim' and `sim_status` = 'Active' and (`lstatus`='Customer' || `lstatus`='Challaned Out');
?>
</pre>

Thanks and Happy Coding...
</div>