Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors', 1); ini_set('error_reporting', E_ERROR);
- include '../../inc/inc.koneksi.php';
- $id = $_POST['id'];
- $nama=$_POST['nama'];
- //$table = 'msapotik';
- //$id = $_POST['id'];
- //$text = "SELECT * FROM $table WHERE Id_obat= '$id'";
- $text="SELECT obat.Id_obat, obat.nama_obat, msapotek.HrB, msapotek.Hrj,
- msapotek.Qty_obat,suplier.nama_suplier
- FROM msapotek
- INNER JOIN suplier ON suplier.id_suplier=msapotek.Id_suplier
- INNER JOIN obat ON obat.id_obat=msapotek.id_obat
- WHERE obat.Id_obat= '$id'";
- $sql = mysql_query($text);
- $row = mysql_num_rows($sql);
- $result=array();
- if ($row>0){
- while ($r=mysql_fetch_array($sql)){
- //$data['id'] = $r[Id_obat];
- //$data['nama'] = $r[nama_obat];
- $data['HRB'] = $r[HrB];
- $data['HRJ'] = $r[Hrj];
- //$data['Keuntungan'] = $r[Keuntungan];
- $data['Stok'] = $r[Qty_obat];
- $data['namaS'] = $r[Id_suplier];
- //echo json_encode($data);$resul
- $result[]=$data;
- }
- }else{
- //$data['id'] = '';
- $data['nama'] = '';
- $data['HRB'] = '';
- $data['HRJ'] = '';
- //$data['Keuntungan'] = '';
- $data['Stok'] = '';
- $data['namaS'] = '';
- $result[]=$data;
- }
- echo json_encode($result);die()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement