How to make a SELECT FROM WHERE Multiple conditions and use it in angularJS

0

PHP

<?php 
  header('Access-Control-Allow-Origin: *');   

  date_default_timezone_set("Chile/Continental");   
  $db = mysqli_connect("localhost", "sam", "", "sam")   

  or die('Error connecting to MySQL server.');   
  $postdata = file_get_contents("php://input");   
  $request = json_decode($postdata);   
  $servicio_id = $request->servicio_id;
  $servicio_id2 = $request->servicio_id2;   

  $query = "SELECT rut,numero,servicio_id FROM Tickets WHERE servicio_id = $servicio_id OR servicio_id = $servicio_id2";  

  mysqli_query($db, $query) or die('Error querying database.');   

  $result = mysqli_query($db, $query);   
  $array = array();   
  while ($row = mysqli_fetch_array($result)) {   
  $array[] = array(   
   "rut" => $row["rut"],  
   "numero" => $row["numero"],  
   "servicio_id" => $row["servicio_id"]  
  );   
  }   

  echo $json_info = json_encode($array);   

?>

Angularjs

$http({  
      method: 'POST',  
      url: 'http://localhost/Paneldetencion/app/php/consultaTickets.php',    
      headers: {  
          'Content-Type': 'application/json',  
          'Accept': 'application/json'  
      },  

      data:{  

        servicio_id: 38
        servicio_id2: 39
      }  

  })

.then (function (data) {

  var dat = data.data;
  $scope.tickets = [];

 for (var i = 0; i < dat.length; i++) {
    dat[i]
          var ticket = {
              numero: dat[i].numero,
              rut: dat[i].rut,
              servicio_id: dat[i].servicio_id
       };
              $scope.tickets.push(ticket);
}
});

FIN

    
asked by Hernan Humaña 09.11.2016 в 15:29
source

1 answer

1

Remove the "." within the query

$query = "SELECT rut,numero,servicio_id FROM Tickets WHERE servicio_id = $servicio_id OR servicio_id = $servicio_id2";
    
answered by 09.11.2016 / 15:35
source