Salam kenal sedulur semua,.saya masih newbie mohon bantuannya..
begini para suhu, saya lagi belajar buat aplikasi inventory dari php dimana ada beberapa form inputan, misal input pemesanan, penerimaan dan stock gudang.
pertanyaannya gmn codingan untuk form input peneriman yang salah satu kolomnya (kode pemesanan) bisa membaca record data dari tabel pemesanan. misalkan kode pemesanan dan kode barang.
terima kasih sebelumnya untuk para suhu,..
Silahkan login untuk menjawab!
Hai Semua....
Saya Baru Belajar PHP dan mendapatkan LKP di kampus mengenai PHP....
Setelah saya buat tampilan dan koneksi ternyata data yang diinput tidak masuk ke database, hanya tampil halaman blank..... saat dibuka databasenya tidak ada data yang baru yang masuk
Mohon Bantuannya....
Berikut Codingnya.....

Ini Tabelnya
CREATE TABLE IF NOT EXISTS `dtalumni` (
“no_urut” int (4) NOT NULL AUTO_INCREMENT,
“jurusan” varchar (35) NOT NULL,
“n_ija3” varchar (20) NOT NULL,
“n_reg3” varchar(35) NOT NULL,
“t_yud3” varchar (25) NOT NULL,
“n_ipk3” varchar (4) NOT NULL,
“lulus3” varchar (25) NOT NULL,
“prodi3” varchar (25) NOT NULL,
“n_ija4” varchar (20) NOT NULL,
“n_reg4” varchar (35) NOT NULL,
“t_yud4” varchar (25) NOT NULL,
“n_ipk4” varchar (4) NOT NULL,
“lulus4” varchar (25) NOT NULL,
“prodi4” varchar (25) NOT NULL,
“nama” varchar (35) NOT NULL,
“kerja” varchar (35) NOT NULL,
“ttl_nya” varchar (35) NOT NULL,
“nip_nya” varchar (25) NOT NULL,
“alamat” varchar (50) NOT NULL,
“inst_nya” varchar (50) NOT NULL,
“hand_nya” varchar (15) NOT NULL,
“a_inst” varchar (50) NOT NULL,
“kelamin” varchar (15) NOT NULL,
“t_kerja” varchar (4) NOT NULL,
“kr_pes” varchar (35) NOT NULL,
Primary Key (“n_ija3”));


Ini file koneksi.php
<?php
$host = "localhost";
$user = "root";
$password = "";
$database_name = "alumni";
mysql_connect($host, $user, $password);
mysql_select_db($alumni);
?>


Ini file input.php
<?php
include"koneksi.php";
$no_urut=strip_tags(@$_POST);
$jurusan=strip_tags(@$_POST);
$n_ija3=strip_tags(@$_POST);
$n_reg3=strip_tags(@$_POST);
$t_yud3=strip_tags(@$_POST);
$n_ipk3=strip_tags(@$_POST);
$lulus3=strip_tags(@$_POST);
$prodi3=strip_tags(@$_POST);
$n_ija4=strip_tags(@$_POST);
$n_reg4=strip_tags(@$_POST);
$t_yud4=strip_tags(@$_POST);
$n_ipk4=strip_tags(@$_POST);
$lulus4=strip_tags(@$_POST);
$prodi4=strip_tags(@$_POST);
$nama=strip_tags(@$_POST);
$kerja=strip_tags(@$_POST);
$ttl_nya=strip_tags(@$_POST);
$nip_nya=strip_tags(@$_POST);
$alamat=strip_tags(@$_POST);
$inst_nya=strip_tags(@$_POST);
$hand_nya=strip_tags(@$_POST);
$a_ inst=strip_tags(@$_POST);
$kelamin=strip_tags(@$_POST);
$t_kerja=strip_tags(@$_POST);
$kr_pes=strip_tags(@$_POST);
mysql_query("Insert Into dtalumni(no_urut,jurusan,n_ija3,n_reg3,t_yud3,n_ipk3,lulus3,prodi3,n_ija4,n_reg4,t_yud4,n_ipk4,lulus4,prodi4,nama,kerja,ttl_nya,nip_nya,alamat,inst_nya,hand_nya,a_ inst,kelamin,t_kerja,kr_pes)values('', '$jurusan’ , '$n_ija3’, '$ n_reg3’, '$t_yud3’, '$n_ipk3’, '$lulus3’, '$prodi3’, '$n_ija4’, '$n_reg4’, '$t_yud4’, '$n_ipk4’, '$lulus4’, '$prodi4’, '$nama’, '$kerja’, '$ttl_nya’, '$nip_nya’, '$alamat’, '$inst_nya’, '$hand_nya’, '$a_ inst’, '$kelamin’, '$t_kerja’, '$kr_pes’)")or die(mysql_error());
?>


Ini ini file entry_data.php
<html>
<head>
<title>Data Alumni</title>
<style type="text/css">
.labelfrm{
display:block;
font-size:small;
margin-top:5px;
}
.error{
font-size:small;
color:red;
}
</style>
</head>
<body>
<form name="input_data" action="input.php" method="post" id="frm">
<table border="0" bordercolor="black" bgcolor="" cellpadding="0" cellspacing="0" width="100%">
<tr>
<th Colspan="0" align="left"></th>
</tr>
</table>
<marquee direction="left" scrollamount="10" align="center"><font size="6" color="blue"><b>SELAMAT DATANG DI APLIKASI PENDATAAN ALUMNI</b></font></marquee>
<table>
<tr>
<td><b>A. DATA AKADEMIK</b></td>
</tr>
</table>
<table border="0" bordercolor="black" bgcolor="" cellpadding="4" cellspacing="0" width="100%">
<tr>
<td width="1%">1.</td>
<td width="15%"><label for="jurusan" class="labelfrm">Jurusan</label></td>
<td width="1%">:</td>
<td width="10%"><select name="jurusan" id="jurusan" class="required">
<option value="Keperawatan">Keperawatan</option>
<option value="Kebidanan">Kebidanan</option>
<option value="Keperawatan Gigi">Keperawatan Gigi</option>
<option value="Kesehatan Lingkungan">Kesehatan Lingkungan</option>
<option value="Gizi">Gizi</option>
<option value="Farmasi">Farmasi</option></td>
<td width="68%"></td>
</tr>
</table>
<table border="0" bordercolor="black" bgcolor="silver" cellpadding="4" cellspacing="0" width="100%">
<tr>
<td></td>
</tr>
<tr>
<td width="1%">2.</td>
<td width="15%"><label for="n_ija3" class="labelfrm">Nomor Ijazah Diploma 3</label></td>
<td width="1%">:</td>
<td width="10%"><input type="text" name="n_ija3" id="n_ija3" maxlength="20" class="required" size="15"/></td>
<td width="1%"></td>
<td width="19%"><label for="n_ija4" class="labelfrm">Nomor Ijazah Diploma 4</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="n_ija4" id="n_ija4" maxlength="20" class="required" size="15"/></td>
</tr>
<tr>
<td width="1%">3.</td>
<td width="15%"><label for="n_reg3" class="labelfrm">Nomor Registrasi Ijazah Diploma 3</label></td>
<td width="1%">:</td>
<td width="10%"><input type="text" name="n_reg3" id="n_reg3" maxlength="35" class="required" size="20"/></td>
<td width="1%"></td>
<td width="19%"><label for="n_reg4" class="labelfrm">Nomor Registrasi Ijazah Diploma 4</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="n_reg4" id="n_reg4" maxlength="25" class="required" size="20"/></td>
</tr>
<tr>
<td width="1%">4.</td>
<td width="15%"><label for="t_yud3" class="labelfrm">Tanggal Yudisium Diploma 3</label></td>
<td width="1%">:</td>
<td width="10%"><input type="text" name="t_yud3" id="t_yud3" maxlength="25" class="required" /></td>
<td width="1%"></td>
<td width="19%"><label for="t_yud4" class="labelfrm">Tanggal Yudisium Diploma 4</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="t_yud4" id="t_yud4" maxlength="25" class="required" /></td>
</tr>
<tr>
<td width="1%">5.</td>
<td width="15%"><label for="n_ipk3" class="labelfrm">Indeks Prestasi Kumulatif Diploma 3</label></td>
<td width="1%">:</td>
<td width="10%"><input type="text" name="n_ipk3" id="n_ipk3" maxlength="4" class="required" size="5"/></td>
<td width="1%"></td>
<td width="19%"><label for="n_ipk4" class="labelfrm">Indeks Prestasi Kumulatif Diploma 4</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="n_ipk4" id="n_ipk4" maxlength="4" class="required" size="5"/></td>
</tr>
<tr>
<td width="1%">6.</td>
<td width="15%"><label for="lulus3" class="labelfrm">Tanggal Lulus Diploma 3</label></td>
<td width="1%">:</td>
<td width="10%"><input type="text" name="lulus3" id="lulus3" maxlength="20" class="required" /></td>
<td width="1%"></td>
<td width="19%"><label for="lulus4" class="labelfrm">Tanggal Lulus Diploma 4</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="lulus4" id="lulus4" maxlength="20" class="required" /></td>
</tr>
<tr>
<td width="1%">7.</td>
<td width="15%"><label for="Prodi3" class="labelfrm">Program Studi Diploma 3</label></td>
<td width="1%">:</td>
<td width="10%"><select name="Prodi3" id="Prodi3" class="required">
<option value="Keperawatan">D III Keperawatan Banda Aceh</option>
<option value="Keperawatan">D III Keperawatan Meulaboh</option>
<option value="Keperawatan">D III Keperawatan Langsa</option>
<option value="Kebidanan">D III Kebidanan Banda Aceh</option>
<option value="Kebidanan">D III Kebidanan Meulaboh</option>
<option value="Kebidanan">D III Kebidanan Langsa</option>
<option value="Keperawatan Gigi">D III Keperawatan Gigi</option>
<option value="Kesehatan Lingkungan">D III Kesehatan Lingkungan</option>
<option value="Gizi">D III Gizi</option>
<option value="Farmasi">D III Farmasi</option></select></td>
<td width="1%"></td>
<td width="15%"><label for="Prodi4" class="labelfrm">Program Studi Diploma 4</label></td>
<td width="1%">:</td>
<td width="10%"><select name="Prodi4" id="Prodi4" class="required">
<option value="Keperawatan">D IV Keperawatan</option>
<option value="Kebidanan">D IV Kebidanan</option>
<option value="Keperawatan Gigi">D IV Keperawatan Gigi</option>
<option value="Kesehatan Lingkungan">D IV Kesehatan Lingkungan</option>
<option value="Gizi">D IV Gizi</option></select></td>
</tr>
</table>
<table>
<tr>
<td></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td width="50%"><b>B. DATA ALUMNI</b></td>
<td width="29%"><b>C. DATA PENYERAPAN ALUMNI</b></td>
</tr>
</table>
<table border="0" bordercolor="black" bgcolor="silver" cellpadding="4" cellspacing="0" width="100%">
<tr>
<td></td>
</tr>
<tr>
<td width="1%">1.</td>
<td width="15%"><label for="nama" class="labelfrm">Nama Alumni</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="nama" id="nama" maxlength="25" class="required" size="30"/></td>
<td width="1%">1.</td>
<td align="left"><label for="Kerja" class="labelfrm">Pekerjaan Alumni</label></td>
<td align="left">:</td>
<td align="left"><select name="Kerja" id="Kerja" class="required">
<option value="Pegawai Negeri Sipil">Pegawai Negeri Sipil</option>
<option value="TNI">TNI</option>
<option value="Polri">Polri</option>
<option value="Tenaga Honorer">Tenaga Honorer</option>
<option value="Tenaga Kontrak">Tenaga Kontrak</option>
<option value="Tenaga Bhakti">Tenaga Bhakti</option>
<option value="Wiraswasta">Wiraswasta</option>
<option value="Petani">Petani</option>
<option value="Nelayan">Nelayan</option>
<option value="Belum Bekerja">Belum Bekerja</option></select>
</td>
</tr>
<tr>
<td width="1%">2.</td>
<td width="15%"><label for="ttl_nya" class="labelfrm">Tempat / Tanggal Lahir</label></td>
<td width="1%">:</td>
<td width="10%"><input type="text" name="ttl_nya" id="ttl_nya" maxlength="35" class="required" /></td>
<td width="1%">2.</td>
<td width="19%"><label for="nip_nya" class="labelfrm">Nomor Induk Pegawai ( <i>PNS, TNI dan Polri</i> )</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="nip_nya" id="nip_nya" maxlength="25" class="required" /></td>
</tr>
<tr>
<td width="1%">3.</td>
<td width="15%"><label for="alamat" class="labelfrm">Alamat Rumah</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="alamat" id="alamat" maxlength="100" class="required" /></td>
<td width="1%">3.</td>
<td width="19%"><label for="inst_nya" class="labelfrm">Institusi Tempat Bekerja</label></td>
<td width="1%">:</td>
<td width="1%"><input type="text" name="inst_nya" id="inst_nya" maxlength="50" class="required" /></td>
</tr>
<tr>
<td width="1%">4.</td>
<td width="15%"><label for="hand_nya" class="labelfrm">Nomor Hanphone ( HP )</label></td>
<td width="1%">:</td>
<td width="15%"><input type="text" name="hand_nya" id="hand_nya" maxlength="15" class="required" /></td>
<td width="1%">4.</td>
<td width="19%"><label for="a_inst" class="labelfrm">Alamat Institusi Tempat Bekerja</label></td>
<td width="1%">:</td>
<td width="1%"><input type="text" name="a_inst" id="a_inst" maxlength="100" class="required" /></td>
</tr>
<tr>
<td width="1%">5</td>
<td width="15%"><label for="kelamin" class="labelfrm">Jenis Kelamin</label></td>
<td width="1%">:</td>
<td width="10%"><select name="kelamin" id="kelamin" class="required">
<option value="Laki">Laki-Laki</option>
<option value="Perempuan">Perempuan</option></select></td>
<td width="1%">5.</td>
<td width="15%"><label for="t_kerja" class="labelfrm">Tahun Mulai Bekerja</label></td>
<td width="1%">:</td>
<td width="10%"><input type="text" name="t_kerja" id="t_kerja" maxlength="4" class="required" /></td>
</tr>
</table>
<h4><label for="kr_pes" class="labelfrm">Ketik Kritik Atau Saran Anda :</label></h4>
<textarea name="kr_pes" cols="120" rows="5"></textarea>
<input type="submit" name="input" value="Simpan Data" id="input"/>
<input type="reset" name="clear" value="Kosongkan Form Entry" id="clear"/>
</form>
</body>
</html>
Silahkan login untuk menjawab!
gimana ya cara login dengan curl tapi ada chapthanya
Silahkan login untuk menjawab!

fuzzy mamdani

_FB_NAME_ · Nov 30, 2015
[help]
ada yang punya contoh penghitungan min max fuzzy mamdani?
mohon bantuannya
Silahkan login untuk menjawab!
helpp..??
tanya mas saya sudah membuat laporan menggunakan html2pdf...
gimana caranya didalam laporan tersebut ingin saya cantumkan barcode berdasarkan nomor surat.trims
Silahkan login untuk menjawab!
saya sedang buat form dengan radio button dan combo box. Cara validasi pake session gmna ya gan?
mohon bantuannya gan
Silahkan login untuk menjawab!