mohon bantuannya ya gan yang jago PHP dan MYSQL..
jadi gini..ane punya kasus dimana ane harus masukkin data yang ada di tabel A ke tabel B..nah ane udah coba dengan ngambil pake perintah select terus ane simpan di satu variabel..tapi ketika ane masukkin eh gakbisa gan..
input stnk.php
<?php
include('koneksi.php');
?>
<html>
<head>
[removed][removed]
[removed]
var htmlobjek;
$(document).ready(function(){
//apabila terjadi event onchange terhadap object <select id=propinsi>
$("#propinsi").change(function(){
var propinsi = $("#propinsi").val();
$.ajax({
url: "ambilkota.php",
data: "propinsi="+propinsi,
cache: false,
success: function(msg){
//jika data sukses diambil dari server kita tampilkan
//di <select id=kota>
$("#kota").html(msg);
}
});
});
$("#kota").change(function(){
var kota = $("#kota").val();
$.ajax({
url: "ambilkecamatan.php",
data: "kota="+kota,
cache: false,
success: function(msg){
$("#kec").html(msg);
}
});
});
});
[removed]
<body>
<center><h3>INPUT STNK</h3>
<form name="postform" action="insert stnk.php" target="_parent" method="post">
<table border="0" cellpadding="5" cellspacing="0">
<tbody>
<tr>
<td>No Polisi</td>
<td>:</td>
<td> <input type="text" name="nopol" /></td>
<td>No Rangka</td>
<td>:</td>
<td> <input type="text" name="no_rangka" /></td>
</tr>
<tr>
<td>Nama Pemilik</td>
<td>:</td>
<td> <input type="text" name="nama_pemilik" /></td>
<td>No Mesin</td>
<td>:</td>
<td> <input type="text" name="no_mesin" /></td>
</tr>
<tr>
<td>Alamat </td>
<td>:</td>
<td><textarea name="alamat" required="required"></textarea></td>
<td>Isi Silinder</td>
<td>:</td>
<td> <input type="text" name="isi_silinder" /></td>
</tr>
<tr>
<td>Jenis</td>
<td>:</td>
<td><select name="id_jenis" id="propinsi">
<option>--Pilih Jenis--</option>
<?php
//mengambil nama-nama propinsi yang ada di database
$propinsi = mysql_query("SELECT * FROM jenis ORDER BY jenis");
while($p=mysql_fetch_array($propinsi)){
echo "<option value=\"$p[id_jenis]\">$p[jenis]</option>\n";
}
?>
</select>
</td>
<td>Bahan Bakar</td>
<td>:</td>
<td> <input type="text" name="bahan_bakar" /></td>
</tr>
<tr>
<td>Merk </td>
<td>:</td>
<td><select name="id_merk" id="kota">
<option>--Pilih Merk--</option>
<?php
//mengambil nama-nama propinsi yang ada di database
$kota = mysql_query("SELECT * FROM merk ORDER BY merk");
while($p=mysql_fetch_array($propinsi)){
echo "<option value=\"$p[id_merk]\">$p[merk]</option>\n";
}
?>
</select>
</td>
<td>Warna TNKB</td>
<td>:</td>
<td> <input type="text" name="warna_tnkb" /></td>
<tr>
<td>Tipe </td>
<td>:</td>
<td><select name="id_tipe" id="kec">
<option>--Pilih Tipe--</option>
</select></td>
<td>Tahun Registrasi</td>
<td>:</td>
<td> <input type="text" name="tahun_registrasi" /></td>
</tr>
<tr>
<td>Tahun</td>
<td>:</td>
<td><select name="thn" id="thn">
<option selected="selected">--Pilih Tahun--</option>
<?php
$now=date("Y");
for($thn=1978; $thn<=$now; $thn++){
echo "<option value=$thn>$thn</option>";
}
?>
</select>
</td>
<td>No BPKB</td>
<td>:</td>
<td> <input type="text" name="no_bpkb" /></td>
<tr>
<tr>
<td>Warna</td>
<td>:</td>
<td> <input type="text" name="warna" /></td>
<td>Berlaku Sampai</td>
<td>:</td>
<td colspan="2"><input type="text" id="from" name="from"><a ><img name="popcal" align="absmiddle" style="border:none" src="calender/calender.jpeg" width="34" height="29" border="0" alt=""></a></a>
</td>
</tr>
<tr>
<td>IDENT</td>
<td>:</td>
<td> <input type="text" name="ident" /></td>
<td align="right" colspan="3"><input type="submit" name="submit" value="Simpan"></td>
</tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
</form>
</center>
</body>
</html>
<iframe width=174 height=189 name="gToday:normal:calender/agenda.js" id="gToday:normal:calender/agenda.js" src="calender/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; forbidden999; position:absolute; top:-500px; left:-500px;">
</iframe>
insert stnk.php
<?php
include('koneksi.php');
//tangkap data dari form
$nopol = $_POST['nopol'];
$nama_pemilik = $_POST['nama_pemilik'];
$alamat = $_POST['alamat'];
$id_jenis = $_POST['id_jenis'];
$id_merk = $_POST['id_merk'];
$id_tipe = $_POST['id_tipe'];
$thn = $_POST['thn'];
$warna = $_POST['warna'];
$ident = $_POST['ident'];
$no_rangka = $_POST['no_rangka'];
$no_mesin = $_POST['no_mesin'];
$isi_silinder = $_POST['isi_silinder'];
$bahan_bakar = $_POST['bahan_bakar'];
$warna_tnkb = $_POST['warna_tnkb'];
$tahun_registrasi = $_POST['tahun_registrasi'];
$no_bpkb = $_POST['no_bpkb'];
$berlaku_sampai = $_POST['from'];
$query = mysql_query("select njkb.id_njkb from njkb,jenis,merk,tipe where njkb.id_jenis=jenis.id_jenis and njkb.id_merk=merk.id_merk and njkb.id_tipe=tipe.id_tipe and njkb.id_jenis='$id_jenis' and njkb.id_merk='$id_merk' and njkb.id_tipe='$id_tipe' and njkb.tahun='$thn'") or die(mysql_error());
$id_njkb = $query;
//simpan data ke database
$query2 = mysql_query("insert into stnk values('$nopol', '$nama_pemilik','$alamat','$id_njkb','$warna','$no_rangka','$no_mesin','$isi_silinder','$bahan_bakar','$warna_tnkb','$tahun_registrasi','$no_bpkb','$ident','$berlaku_sampai')") or die(mysql_error());
if ($query2) {
header('location:input stnk.php');
}
?>
