public_html/elimina_esercizio.php

   1 <?php
   2         include './util.php';
   3         include './dbData.php';
   4         $data = file_get_contents('php://input');
   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'=>"error");
  10                 $ris=json_encode($arr);
  11                 echo $ris;
  12                 die;
  13         }
  14         if($result->id>0)
  15                 $str="DELETE FROM ".$DATA['tbEsercizi']." WHERE ".$DATA['clId']."=".$result->id.";";
  16         else if($result->id<0)
  17         {
  18                 $str="DELETE FROM ".$DATA['tbEsercizi']." WHERE ".$DATA['clUser']."='".$result->utente."';";
  19                 $str=mysqli_query($con,$str);
  20                 $str="DELETE FROM ".$DATA['tbConnessi']." WHERE ".$DATA['clUser']."='".$result->utente."';";
  21                 $str=mysqli_query($con,$str);
  22                 $str="DELETE FROM ".$DATA['tbUtenti']." WHERE ".$DATA['clUser']."='".$result->utente."';";
  23         }
  24         else
  25         {
  26                 $str="DELETE FROM ".$DATA['tbEercizi']." WHERE ".$DATA['clEsercizio']."='".$result->esercizio."';";
  27                 unlink("/var/www/html/esercizi/".$result->esercizio);
  28         }
  29         $str=mysqli_query($con,$str);
  30         $arr= array('result'=>"ok");
  31         $ris=json_encode($arr);
  32         echo $ris;
  33 ?>
  34