cotezska

if ($_POST['proses'] == 'simpan') {
			foreach ($_POST['rows'] as $key => $i) {
				$kode_produk = $mysqli -> real_escape_string($_POST['sn_'.$i]);
				$id_jenis = $mysqli -> real_escape_string($_POST['id_jenis_'.$i]);
				$nama = $mysqli -> real_escape_string($_POST['nama_'.$i]);
				$harga = $mysqli -> real_escape_string($_POST['harga_'.$i]);
				$q = $mysqli -> query("INSERT INTO produksn
								(kode_produk,id_jenis,nama,harga_beli)
								VALUES
								('$kode_produk','$id_jenis','$nama','$harga')");

				if (!$q) {
					echo $mysqli -> error;
				} else {
					$val .= "";
				}

				$i++;
			}

			$val.= konfirm('sukses');
		}

<?php

function setKoneksi() {
	$Host = "localhost";
	$User = "root";
	$Pass = "";
	$Db_name = "cctv";

	$mysqli = new mysqli( $Host, $User, $Pass, $Db_name );
	if ($mysqli->connect_error){
	echo "Gagal terkoneksi ke database : (".$mysqli->connect_error.")";
	}

	return $mysqli;
}


?>