public_html/utenti.php

   1 <?php
   2         include 'util.php';
   3         include './dbData.php';
   4         $data = file_get_contents('php://input'); /*file_get_contents:data una stringa, recupera i parametri di query. In questo caso viene presa la stringa inviata come dato dal JS*/
   5         $result = json_decode($data);
   6         $con=mysqli_connect($DATA['dbLink'],$DATA['dbAdmin'],$DATA['dbPassword'],$DATA['dbName']);
   7         if ($con==false)
   8         {
   9                 $arr=array('result'=>"errore nella connessione al database");
  10                 $ris=json_encode($arr);
  11                 echo $ris;
  12                 die;
  13         }
  14         $str="SELECT * FROM ".$DATA['tbUtenti'].";";
  15         $str=mysqli_query($con,$str);
  16         if (!$str)
  17         {
  18                 $arr= array('result'=>"nessun elemento presente");
  19                 $ris=json_encode($arr);
  20                 echo $ris;
  21                 die;
  22         }
  23         $utenti;
  24         while($risp=mysqli_fetch_array($str))
  25         {
  26                 $utenti[]=$risp[$DATA['clUser']];
  27         }
  28         $ex=array('utenti'=>$utenti);
  29         $return_json=__json_encode($ex);
  30         echo $return_json;
  31 ?>
  32