database
CREATE TABLE IF NOT EXISTS `tbl_barang` ( `id_barang` varchar(13) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `nama_barang` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `id_kategori` varchar(3) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `id_satuan` varchar(3) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `harga` float(13,2) NOT NULL, PRIMARY KEY (`id_barang`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO `tbl_barang` (`id_barang`, `nama_barang`, `id_kategori`, `id_satuan`, `harga`) VALUES ('1', 'mie', 'mkn', 'bks', 1500.00), ('2', 'torabika', 'mnm', 'bks', 1000.00), ('3', 'kecap', 'mkn', 'btl', 5000.00);
ambildata.php
index.php
untuk source kode silahkan download di sini
No comments:
Post a Comment