Advertisement
GWibisono

ini hasilnya json..

Apr 15th, 2015
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.13 KB | None | 0 0
  1. <?php
  2. ini_set('display_errors', 1); ini_set('error_reporting', E_ERROR);
  3. include '../../inc/inc.koneksi.php';
  4. $id = $_POST['id'];
  5. $nama=$_POST['nama'];
  6. //$table = 'msapotik';
  7. //$id = $_POST['id'];
  8. //$text = "SELECT * FROM $table WHERE Id_obat= '$id'";
  9. $text="SELECT obat.Id_obat, obat.nama_obat, msapotek.HrB, msapotek.Hrj,
  10. msapotek.Qty_obat,suplier.nama_suplier
  11. FROM msapotek
  12. INNER JOIN suplier ON suplier.id_suplier=msapotek.Id_suplier
  13. INNER JOIN obat ON obat.id_obat=msapotek.id_obat
  14. WHERE obat.Id_obat= '$id'";
  15. $sql = mysql_query($text);
  16. $row = mysql_num_rows($sql);
  17. $result=array();
  18. if ($row>0){
  19. while ($r=mysql_fetch_array($sql)){
  20.  
  21. //$data['id'] = $r[Id_obat];
  22. //$data['nama'] = $r[nama_obat];
  23. $data['HRB'] = $r[HrB];
  24. $data['HRJ'] = $r[Hrj];
  25. //$data['Keuntungan'] = $r[Keuntungan];
  26. $data['Stok'] = $r[Qty_obat];
  27. $data['namaS'] = $r[Id_suplier];
  28.  
  29. //echo json_encode($data);$resul
  30. $result[]=$data;
  31. }
  32. }else{
  33. //$data['id'] = '';
  34. $data['nama'] = '';
  35. $data['HRB'] = '';
  36. $data['HRJ'] = '';
  37. //$data['Keuntungan'] = '';
  38. $data['Stok'] = '';
  39. $data['namaS'] = '';
  40.  
  41. $result[]=$data;
  42.  
  43. }
  44.  
  45.  
  46. echo json_encode($result);die()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement