
<?php

    // $con = mysql_connect('dmj.rm153.com:33333','root','321');

    // $db  = mysql_select_db('dbplb',$con);
include 'connect.php';
session_start();

$nobukti=$_SESSION['nobukti'];
$nofaktur=$_SESSION['nofaktur'];
$bln=date('m');
$tahun=date('Y');

    

    if (isset($_GET['input'])) {

        $input = $_GET['input'];
		
	
        $query = mysqli_query($con,"SELECT a.kdbrg,b.namabrg1,b.isi3,a.qty,b.namabrg1 as gabung,a.qty as saldo FROM draft3 a
		left join barang b on b.kdbrg=a.kdbrg
		WHERE a.nobukti='$nobukti' and a.nofaktur='$nofaktur' and b.namabrg1 LIKE '%$input%'"); //query mencari hasil search

        if ($query === FALSE) {

    die(mysqli_error());

}

        $hasil = mysqli_num_rows($query);
        if ($hasil > 0)


        {

            while ($data = mysqli_fetch_row($query)) {

            ?>

            <a href="javascript:autoInsert('<?=$data[0]?>','<?=$data[1]?>','<?=$data[2]?>','<?=$data[3]?>','<?=$data[4]?>','<?=$data[5]?>');"><?=$data[1]?><br> <!--- hasil -->

            <?php

            }    

        }

    } 

?>