Postingan lainnya
saya tidak bisa memperbaiki ini
disini saya tidak bisa memperbaiki suatu websait dan saya sudah coba cari cari di google dan mengikuti tetapi tidak bisa juga ini masalah pada ID
<?php
$id=$_GET['id'];
$sql="select * from tblcms where id='$id'";
?>
14 Jawaban:
Jawaban Terpilih
banyak faktor penyebab itu salah, coba kirim yang lengkap
<script language="javascript" type="text/javascript" src="ckeditor/ckeditor.js"></script>
<div class="post">
<h2 class="title"><a href="#">Artikel Berita STIT Muslim Asia Afrika</a></h2>
<p class="meta"><em>
<?php
echo date("l").", ";
echo date("d F Y").", ";
echo date("h:i A");
?></em></p>
<div class="entry">
<?php
include "../koneksi.php";
if(isset($_POST['simpan'])){
$idkategori=$_POST['idkategori'];
$judul=$_POST['judul'];
$content=$_POST['content'];
$status=$_POST['status'];
$gambar=$_FILES['gambar']['name'];
if(strlen($gambar)>0){
if(is_uploaded_file($_FILES['gambar']['tmp_name'])){
move_uploaded_file($_FILES['gambar']['tmp_name'],"../gambar/berita/".$gambar);
}
}
$file=$_FILES['file']['name'];
if(strlen($file)>0){
if(is_uploaded_file($_FILES['file']['tmp_name'])){
move_uploaded_file($_FILES['file']['tmp_name'],"../file/".$file);
}
}
if(empty($idkategori)||empty($judul)||empty($content)){
echo "<script type='text/javascript'>
onload =function(){
alert('Data isian belum lengkap, silahkan periksa kembali!');
}
</script>";
}else{
$a="insert into tblcms(id,judul,idkategori,content,gambar,file,user,status)values('','$judul','$idkategori','$content','$gambar','$file','$_SESSION[level]','$status')";
$b=mysql_query($a);
if($b){
echo "<script type='text/javascript'>
onload =function(){
alert('Berita telah tersimpan');
}
</script>";
}else{
echo "<script type='text/javascript'>
onload =function(){
alert('Berita gagal disimpan');
}
</script>";
}
}
}
//Proses edit
//tampilkan data yang diedit
$id=$_POST['id'];
$sql="select * from tblcms where id='$id'";
$query=mysql_query($sql);
$baris=mysql_fetch_array($query);
if(isset($_POST['Edit'])){
$idkategori=$_POST['idkategori'];
$judul=$_POST['judul'];
$content=$_POST['content'];
$status=$_POST['status'];
$gambar=$_FILES['gambar']['name'];
if(strlen($gambar)>0){
if(is_uploaded_file($_FILES['gambar']['tmp_name'])){
move_uploaded_file($_FILES['gambar']['tmp_name'],"../gambar/berita/".$gambar);
}
mysql_query("update tblcms set gambar='$gambar' where id='$id'");
}
$file=$_FILES['file']['name'];
if(strlen($file)>0){
if(is_uploaded_file($_FILES['file']['tmp_name'])){
move_uploaded_file($_FILES['file']['tmp_name'],"../file/".$file);
}
mysql_query("update tblcms set file='$file' where id='$id'");
}
$a="Update tblcms set judul='$judul',idkategori='$idkategori',content='$content',status='$status' where id='$id'";
$b=mysql_query($a);
if($b){
echo "<script type='text/javascript'>
alert('Artikel telah terupdate..!');
</script>";
echo "<meta http-equiv='refresh' content='0; url=index.php'>";
}else{
echo "<script type='text/javascript'>
onload =function(){
alert('Berita gagal diubah!');
}
</script>";
}
}
?>
<table border="0" cellspacing="0" cellpadding="0" width="100%" height="83%">
<table width="644" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td width="549">
<h3 align="center">Kelola Artikel </h3>
<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
<table width="600" border="0" align="center">
<tr>
<td width="98"><strong>Judul Berita </strong></td>
<td width="295"><label>
<input name="judul" type="text" size="75" value="<?php echo $baris['judul'];?>"/>
</label></td>
</tr>
<tr>
<td><strong>Kategori</strong></td>
<td><label>
<?php if($_GET[id]==1){
echo "<input type='text' name='idkategori' value='Tidak Dikategori' readonly>";
}else{
echo "<select name='idkategori' id='idkategori'>";
$kategori=mysql_query("select * from tblkategori");
while($data=mysql_fetch_array($kategori)){
$pilih = ($baris['idkategori']==$data['idkategori'])?"selected" : "";
echo"<option value=\"$data[idkategori]\" $pilih>$data[kategori]</option>";
}
}
?>
</select>
</label></td>
</tr>
<tr>
<td><strong>Content</strong></td>
<td><label>
<textarea name="content" cols="65" rows="12" id="content" class="ckeditor"><?php echo $baris['content'];?></textarea>
</label></td>
</tr>
<tr>
<td><strong>Gambar</strong></td>
<td><label>
<?php if($_GET['id']){
//tampilkan foto saat mau ngedit
echo "<img src='../gambar/berita/$baris[gambar]' width=150 height=110> <br />";
}
?>
<input name="gambar" type="file" id="gambar" />
</label></td>
</tr>
<tr>
<td><strong>Lampirkan File</strong></td>
<td><label>
<input type="file" name="file" />
</label></td>
</tr>
<?php if($_GET['id']){
echo "<tr><td><b></b></td><td>File: ".$baris['file']."</td></tr>";
echo "<tr><td colspan=2><font color='red'>Apabila file tidak diganti, dikosongkan saja</font></td></tr>";
}
?>
<tr>
<td>Tampilkan</td>
<td>: <input type="radio" name="status" value="Y" <?php if($baris['status']=="Y"){ echo "checked";}?> > Ya
<input type="radio" name="status" value="T" <?php if($baris['status']=="T"){ echo "checked";}?> > Tidak</td>
</tr>
<tr>
<tr>
<td> </td>
<td><label>
<?php if(!$_GET['id']){
//bila mau tambah data yang tampil tombol simpan
echo "<input name=\"simpan\" type=\"submit\" id=\"simpan\" value=\"simpan\" /> ";
echo "<input name=\"batal\" type=\"reset\" id=\"batal\" value=\"batal\" />";
} else {
//Apabila mau edit yg tampil tombol edit dan hapus
echo "<input name=\"edit\" type=\"submit\" id=\"edit\" value=\"edit\" />";
} ?>
</label></td>
</tr>
</table>
</form>
<p align="left"><h2>Tabel Berita </h2></p>
<table width="644" border="1" align="left" cellspacing="0">
<tr bgcolor="#FFffff">
<td width="36" height="25"><div align="center"><strong>No</strong></div></td>
<td width="237"><div align="center"><strong>Judul</strong></div></td>
<td width="143"><div align="center">
<blockquote>
<p><strong>Kategori</strong></p>
</blockquote>
</div></td>
<td width="95"><strong>Pengirim</strong></td>
<td width="42"><div align="center"><strong>Tampilkan</strong></div></td>
<td width="65"><div align="center"><strong>Aksi</strong></div></td>
</tr>
<?php
$sql="select * from tblcms,tblkategori where tblcms.idkategori=tblkategori.idkategori and tblcms.id<>1 order by id DESC";
$query=mysql_query($sql);
$no=1;
while($data=mysql_fetch_array($query)){
?>
<tr>
<td><div align="center"><?php echo $no; ?></div></td>
<td><?php echo $data['judul']; ?></td>
<td><?php echo $data['kategori']; ?></td>
<td><?php echo $data['user']; ?></td>
<td><div align="center"><?php echo $data['status']; ?></div></td>
<td><div align="center"><a href="?page=artikel_berita&id=<?php echo $data['id']; ?>"><img src="../images/icon/button-edit.gif" width="20" height="20" border="0" /></a>
<a href="javascript:if(confirm('Anda yakin akan menghapus data ini??')){document.location='hapus_berita.php?id=<?php echo $data['id']; ?>';}"><img src="../images/icon/button-cross.gif" width="20" height="20" border="0" /></a></div></td>
</tr>
<?php $no++;}?>
</table>
</td>
</tr>
</table>
</tr>
</table>
</div>
</div>
ga semuanya juga keles, periksa database nya tkt table / colmnya salah
oksaya sudah kirimkan source code lengkap
yang GET saya coba ganti dengan POST tetap saja tidak ada perubahan
<?php
if(isset($_GET['id'])) {
$id=$_GET['id'];
$sql="select * from tblcms where id='$id'";
} else {
echo 'Ga ada GET id, Undefined index: id';
}
?>
masih belum bisa kah ? perlu saya remote ?
iya, masih belum juga saya dah coba otak atik. boleh saja
@KepalaSekolah remote tv apa remote ac tuh gan? :D
@Jeyachmad url yg diakses query parameternya gimana? Bisa di posting juga full urlnya? Kalau ada id ya seharusnya ga muncul eror.