require("connect.inc.php"); // Setting Font // Setting Form if (!$_POST[tambah]) { //echo $_SESSION['username']; ?>
Tambah KK
Nama KK
:
Kelompok
:
$q_klp = "SELECT id,nama_klp FROM Kelompok order by nama_klp " ; $hasil_klp = mysqli_query($koneksi, $q_klp) or die("Kesalahan pada query!"); while (list($id,$nama_klp) = mysqli_fetch_row($hasil_klp)) { ?>
>
Tambah Kelompok
} else { require("connect.inc.php"); $nama_kk = $_POST[nama_kk]; $klp = $_POST[klp]; $q_kat = "SELECT max(reg_kk) reg_ FROM kk_saham" ; $hasil_kat = mysqli_query($koneksi, $q_kat) or die("Kesalahan pada query!"); list($reg_) = mysqli_fetch_row($hasil_kat); $reg_akir = substr($reg_,-7)+1; $reg_kk_final = 'SA'.$seri.substr(('000000'.$reg_akir),-7); //echo $reg_kk_final; $query = "INSERT INTO kk_saham (reg_kk,nama_kk,nama_klp) VALUES ( '".addslashes(strtoupper($reg_kk_final))."', '".addslashes(strtoupper($nama_kk))."', '".addslashes(strtoupper($klp))."')"; //echo $query; $hasil = mysqli_query($koneksi,$query) or die('Kesalahan Query!'); ?> } ?>