
<?php

    // $con = mysql_connect('dmj.rm153.com:33333','root','321');

    // $db  = mysql_select_db('dbplb',$con);
include 'connect.php';
session_start();


    

    if (isset($_GET['input'])) {

        $input = $_GET['input'];
		
        $query = mysqli_query($con,"SELECT a.kdbrg,a.namabrg1,a.isi3,a.hrgjual,concat(a.namabrg1,' /isi : ',a.isi3) as gabung  FROM barang a
		WHERE a.stat='1' and a.namabrg1 LIKE '%$input%' order by a.kdbrg desc limit 20"); //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[1]?><br> <!--- hasil -->

            <?php

            }    

        }

    } 

?>