Guest User

Untitled

a guest
Mar 4th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.80 KB | None | 0 0
  1. <?php
  2.  
  3. $host = "localhost";
  4.  
  5. $user = "root";
  6.  
  7. $pass = "adsasd";
  8.  
  9. $database = "mysql";
  10.  
  11. $linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
  12.  
  13. mysql_select_db($database, $linkID) or die("Could not find database.");
  14.  
  15. $query = "SELECT * FROM demo";
  16. $resultID = mysql_query($query, $linkID) or die("Data not found.");
  17.  
  18. $dati = mysql_num_rows($resultID);
  19.  
  20. if($dati == 0){
  21.  
  22.         $json_data = array ('status'=>'KO', 'error'=>'not found');
  23.  
  24.         echo json_encode($json_data);
  25. }
  26. else{
  27.  
  28.         $row = mysql_fetch_assoc($resultID);
  29.  
  30.         $json_data = array ('status'=>'OK', 'data'=>array(
  31.  
  32.         'id'=>$row['idDemo'],'nome'=>$row['nome'],'descrizione'=>$row['descrizione'],'linkApk'=>$row['linkApk']));
  33.  
  34.         echo json_encode($json_data);
  35.  
  36. }
  37.  
  38. ?>
Add Comment
Please, Sign In to add comment