View difference between Paste ID: FU6aNLZL and hKWkNLwu

 <?php
 function autono($tabel,$inisial){
-$isi=mysql_query("select* from barang order by idbarang desc") or die(mysql_error());
+$isi=mysql_query("select idbarang from barang order by idbarang desc") or die(mysql_error());
-if(mysql_num_rows($isi)==0){
+$thn=date("Y");
-$IDbarang=autono("barang","B$thn");
+	if(mysql_num_rows($isi)==0){
-
+
-	$idbarang="B$thn"."001";
+		$IDbarang=autono("barang","B$thn");
 		$idbarang="B$thn"."0001";
 	}
-		$data=mysql_fetch_array($isi);
+
-		$bbb=intval(substr($data['idbarang'],3,3))+100001;
+		$n=mysql_num_rows($isi);
-		$idbarang="B$thn".substr($bbb,-3);
+		//$data=mysql_fetch_array($isi);
 		//$bbb=intval(substr($data['idbarang'],3,3))+100001;
-		return $idbarang;
+		//$idbarang="B$thn".substr($bbb,-3);
 		   $idbarang=sprintf("B%s.%03s",$thn,$n);
 		}
  return $idbarang;
 }
 
 //===== PERHATIKAN dari form apakah sudah ada enctype
 $gambarsmall=$_FILES['uploadsmall']['name'];
 $gambarbig=$_FILES['uploadbig']['name'];
 
 $simpan=mysql_query("insert into barang (idbarang,namabarang,kategori,spesifikasi,harga,stok,keterangan,gambar) values('$IDbarang','$_POST[namabarang]','$_POST[kategori]','$_POST[spesifikasi]','$_POST[harga]','$_POST[stok]','$_POST[keterangan]','$gambarsmall')") or die(mysql_error());
 move_uploaded_file($_FILES['uploadsmall']['tmp_name'],"produk/small/".$gambarsmall);
 move_uploaded_file($_FILES['uploadbig']['tmp_name'],"produk/big/".$gambarbig);
 if($simpan)
 {
 ?>
   <script type="text/javascript">
   alert('Data Tersimpan')
   document.location='?page=tampilbarang';
   </script>
 <?php
 
 }
 else
 {
 ?>
   <script type="text/javascript">
   alert('Gagal Tersimpan')
   document.location='?page=tambahbarang';
   </script>
 <?php
 }
 ?>