<?
//koneksi kedatabase
$dblink = mysql_connect('localhost','root','');
if(!is_resource($dblink))
{
die("koneksi gagal rek : ".mysql_error());
}


//mengaktifkan database
if (!mysql_select_db('gudang',$dblink))
{
die("Gagal mengaktifkan database");
}


//Generate ID
$q = mysql_query("select max(id) as maxid from buku");
if(!is_resource($q))
{
die("query gagal : ".mysql_error());
}

$r = mysql_fetch_assoc($q);
$newid = $r['maxid'] + 1;

//simpan data
$sql = "insert into buku values ('$newid','$_POST[kode]','$_POST[nama]','$_POST[jenis]','$_POST[merk]','$_POST[jumlah]','$_POST[harga]')";
$q = mysql_query($sql);
if(!$q)
{
die("Gagal menyimpan data: ". mysql_error());
}
else
{
header("Location: index.php\n\n");
die;
}
?>