Postingan lainnya
form edit di php
Salam kenal para master. saya mau bertanya saya sedang membuat halamat edit dari halaman detail, permasalahannya ketika tombol edit di tekan data tidak muncul dan tidak ada pesan error. berikut halaman pertama saya
<?php include 'header.php'; ?>
<h3><span class="glyphicon glyphicon-briefcase"></span> DATA UJIAN</h3>
<br/>
<?php
$id_user=$_SESSION['id'];
$per_hal=10;
$jumlah_record=mysql_query("SELECT COUNT(nama_ujian) from tr_guru_tes WHERE id_guru='$id_user'");
$jum=mysql_result($jumlah_record, 0);
$halaman=ceil($jum / $per_hal);
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_hal;
?>
<div class="col-md-12">
<a style="margin-bottom:10px" href="lap_barang.php" target="_blank" class="btn btn-default pull-right"><span class='glyphicon glyphicon-print'></span> Cetak</a>
</div>
<form action="cari_act.php" method="get">
<div class="input-group col-md-5 col-md-offset-7">
<span class="input-group-addon" id="basic-addon1"><span class="glyphicon glyphicon-search"></span></span>
<input type="text" class="form-control" placeholder="Cari Ujian di sini .." aria-describedby="basic-addon1" name="cari">
</div>
</form>
<br/>
<table class="table table-hover">
<tr>
<th class="col-md-1">No</th>
<th class="col-md-2">Ujian</th>
<th class="col-md-6">Nama Guru</th>
<th class="col-md-2">Mapel</th>
<th class="col-md-1">Soal</th>
<th class="col-md-1">Waktu</th>
<th class="col-md-3">Opsi</th>
</tr>
<?php
if(isset($_GET['cari'])){
$cari=mysql_real_escape_string($_GET['cari']);
$brg=mysql_query("select * from tr_guru_tes where nama like '$cari' or jenis like '$cari'");
}else{
$brg=mysql_query("select a.id as id_test,a.nama_ujian as ujian,a.jumlah_soal,a.waktu, b.nama AS mapel, c.nama AS nama_guru FROM tr_guru_tes a INNER JOIN m_mapel b ON a.id_mapel = b.id INNER JOIN m_guru c ON a.id_guru = c.id where a.id_guru='.$id_user.'");
}
$no=1;
while($b=mysql_fetch_array($brg)){
?>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $b['ujian'] ?></td>
<td><?php echo $b['nama_guru'] ?></td>
<td><?php echo $b['mapel'] ?></td>
<td><?php echo $b['jumlah_soal'] ?></td>
<td><?php echo $b['waktu'] ?></td>
<td>
<a href="det_barang.php?id_test=<?php echo $b['id_test']; ?>" class="btn btn-info">Detail</a>
</td>
</tr>
<?php
}
?>
</table>
<ul class="pagination">
<?php
for($x=1;$x<=$halaman;$x++){
?>
<li><a href="?page=<?php echo $x ?>"><?php echo $x ?></a></li>
<?php
}
?>
</ul>
<!-- modal input -->
<div id="myModal" class="modal fade">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title">Tambah Barang Baru</h4>
</div>
<div class="modal-body">
<form action="tmb_brg_act.php" method="post">
<div class="form-group">
<label>Nama Barang</label>
<input name="nama" type="text" class="form-control" placeholder="Nama Barang ..">
</div>
<div class="form-group">
<label>Jenis</label>
<input name="jenis" type="text" class="form-control" placeholder="Jenis Barang ..">
</div>
<div class="form-group">
<label>Suplier</label>
<input name="suplier" type="text" class="form-control" placeholder="Suplier ..">
</div>
<div class="form-group">
<label>Harga Modal</label>
<input name="modal" type="text" class="form-control" placeholder="Modal per unit">
</div>
<div class="form-group">
<label>Harga Jual</label>
<input name="harga" type="text" class="form-control" placeholder="Harga Jual per unit">
</div>
<div class="form-group">
<label>Jumlah</label>
<input name="jumlah" type="text" class="form-control" placeholder="Jumlah">
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Batal</button>
<input type="submit" class="btn btn-primary" value="Simpan">
</div>
</form>
</div>
</div>
</div>
<?php
include 'footer.php';
?>
halaman detail
<?php
include 'header.php';
?>
<h3><span class="glyphicon glyphicon-briefcase"></span> Jawaban Siswa</h3>
<a class="btn" href="barang.php"><span class="glyphicon glyphicon-arrow-left"></span> Kembali</a>
<table class="table table-hover">
<tr>
<th class="col-md-1">No</th>
<th class="col-md-2">Nama Siswa</th>
<th class="col-md-6">ID:No:Jawaban</th>
<th class="col-md-1">Benar</th>
<th class="col-md-1">Nilai</th>
<th class="col-md-1">Bobot</th>
<th class="col-md-3">Opsi</th>
</tr>
<?php
$id_test=mysql_real_escape_string($_GET['id_test']);
$_SESSION['id_test']=$id_test;
$det=mysql_query("SELECT m_siswa.nama as nama,tr_ikut_ujian.list_jawaban as jawaban,tr_ikut_ujian.jml_benar as benar,tr_ikut_ujian.nilai as nilai,tr_ikut_ujian.nilai_bobot as bobot,tr_ikut_ujian.id_user as idsiswa FROM m_guru,tr_ikut_ujian,m_siswa WHERE tr_ikut_ujian.id_user=m_siswa.id and tr_ikut_ujian.id_tes='.$id_test.' group by m_siswa.nama")or die(mysql_error());
$no=1;
while($b=mysql_fetch_array($det)){
?>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $b['nama'] ?></td>
<td><?php echo $b['jawaban'] ?></td>
<td><?php echo $b['benar'] ?></td>
<td><?php echo $b['nilai'] ?></td>
<td><?php echo $b['bobot'] ?></td>
<td>
<a href="edit.php?id_siswa=<?php echo $b['idsiswa']; ?>" class="btn btn-warning">Edit</a>
</td>
</tr>
<?php
}
?>
</table>
<?php include 'footer.php'; ?>
halaman edit
<?php
include 'header.php';
?>
<?php
$id_test=$_SESSION['id_test'];
?>
<h3><span class="glyphicon glyphicon-briefcase"></span> Edit Jawaban Siswa</h3>
<a class="btn" href="det_barang.php?id_test=<?php echo $id_test?>"><span class="glyphicon glyphicon-arrow-left"></span> Kembali</a>
<?php
$id_siswa=mysql_real_escape_string($_GET['id_siswa']);
echo "data=$id_test";
$det=mysql_query("SELECT a.nama, b.list_jawaban, b.jml_benar,b.nilai,b.nilai_bobot,b.id_user FROM m_siswa a INNER JOIN tr_ikut_ujian b ON a.id=b.id_user WHERE b.id_tes='.$id_test.' and b.id_user='.$id_siswa.'")or die(mysql_error());
echo "idsiswa=$id_siswa";
while($d=mysql_fetch_array($det)){
?>
<form action="update.php" method="post">
<table class="table">
<tr>
<td></td>
<td><input type="text" name="id_siswa" value="<?php echo $d['id_user'] ?>"></td>
</tr>
<tr>
<td>Nama Siswa</td>
<td><input type="text" class="form-control" name="nama" value="<?php echo $d['nama'] ?>"></td>
</tr>
<tr>
<td>Jawaban</td>
<td><textarea class="form-control" name="jawaban" rows="5"><?php echo $d['list_jawaban'] ?></textarea></td>
</tr>
<tr>
<td>Benar</td>
<td><input type="text" class="form-control" name="benar" value="<?php echo $d['jml_benar'] ?>"></td>
</tr>
<tr>
<td>Nilai</td>
<td><input type="text" class="form-control" name="nilai" value="<?php echo $d['nilai'] ?>"></td>
</tr>
<tr>
<td>Bobot</td>
<td><input type="text" class="form-control" name="bobot" value="<?php echo $d['nilai_bobot'] ?>"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" class="btn btn-info" value="Simpan"></td>
</tr>
</table>
</form>
<?php
}
?>
<?php include 'footer.php'; ?>
kira-kira letak troblenya dmn ya, terima kasih
0
7 Jawaban:
hasil echo id_siswa dan id_test dihalaman edit muncul gan?
0
coba ini di echo, trus jalankan di databasenya, datanya muncul atau tidak
echo "SELECT a.nama, b.list_jawaban, b.jml_benar,b.nilai,b.nilai_bobot,b.id_user FROM m_siswa a INNER JOIN tr_ikut_ujian b ON a.id=b.id_user WHERE b.id_tes='.$id_test.' and b.id_user='.$id_siswa.'"
0
klo script selectnya di jalankan di sql bisa tampil gan, namun hasil select klo di echo per field ndak keluar
0
SELECT a.nama, b.list_jawaban, b.jml_benar,b.nilai,b.nilai_bobot,b.id_user FROM m_siswa a INNER JOIN tr_ikut_ujian b ON a.id=b.id_user WHERE b.id_tes='.$id_test.' and b.id_user='.$id_siswa.'"
klo pakek scrip di atas di jalankan di sql dengan $id_test dan $id_siswa di ganti dengan nilai yg ada pada echo di php bs jalan dan ada hasilnya.
0
Jawaban Terpilih
Coba apus titiknya jadi:
$det=mysql_query("SELECT a.nama, b.list_jawaban, b.jml_benar,b.nilai,b.nilai_bobot,b.id_user FROM m_siswa a INNER JOIN tr_ikut_ujian b ON a.id=b.id_user WHERE b.id_tes='$id_test' and b.id_user='$id_siswa'")or die(mysql_error());
1
