caridonk.pehape

<?php
if(isset($_POST['kode'])) {
        $ip = 'localhost';
        $username = 'blabla';
        $password = 'blublu';
        $database = 'bleble';
        $mysqlId = mysql_connect($ip,$username,$password);
        mysql_select_db($database);

        $kd = $_POST['kode'];
        $query = "select * from mbarang where kode='$kd'";
        $result = mysql_query($query,$mysqlId);
        if(mysql_num_rows($result)) {
                list($id,$kode,$nama,$harga,$satuan) =  mysql_fetch_row($result);
                mysql_free_result($result);
                echo "$id;$nama;$harga;$satuan";
        } else {
                echo "0; ; ; ";
        }
        mysql_close($mysqlId);
}
/* yg ini buat bikin table-nya
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+07:00";

CREATE TABLE IF NOT EXISTS `mbarang` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kode` varchar(7) NOT NULL,
  `nama` varchar(32) NOT NULL,
  `harga` int(10) unsigned NOT NULL,
  `satuan` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `kode` (`kode`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

INSERT INTO `mbarang` VALUES(1, 'B123', 'Pecah Tapi Tidak Belah', 175000, 'Pack');
INSERT INTO `mbarang` VALUES(2, 'X325A73', 'Bukan Narkoba', 318000, 'Dus');
INSERT INTO `mbarang` VALUES(3, 'MD539A', 'Obat Sakit Hati', 4631500, 'Koli');
INSERT INTO `mbarang` VALUES(4, 'A112233', 'Spare Part Pesawat', 222750, 'Set');
INSERT INTO `mbarang` VALUES(5, 'RK888', 'Rokok Special', 64730, 'Bungkus');
INSERT INTO `mbarang` VALUES(6, 'P432', 'Barang Import', 386825, 'Dus');
*/
?>