Created
August 8, 2019 23:30
-
-
Save desawarna/52f2fb6816f0602ea54d13dc15e8af74 to your computer and use it in GitHub Desktop.
Code PHP Pada CMSKu /cmsku/admin/content/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script type="text/javascript" src="../plugin/tinymce/tinymce.min.js"></script> | |
<script type="text/javascript" src="js/tinymce_config.js"></script> | |
<?php | |
if(!defined("INDEX")) header('location: ../index.php'); | |
$show = isset($_GET['show']) ? $_GET['show'] : ""; | |
$link = "?content=artikel"; | |
switch($show){ | |
//Menampilkan data | |
default: | |
echo '<h3 class="page-header"><b>Daftar Artikel</b> | |
<a href="'.$link.'&show=form" class="btn btn-primary btn-sm pull-right top-button"> | |
<i class="glyphicon glyphicon-plus-sign"></i> Tambah | |
</a> | |
</h3>'; | |
buka_tabel(array("Judul Artikel", "Kategori", "User", "Tanggal Posting")); | |
$no = 1; | |
$id_user = $_SESSION['iduser']; | |
if($_SESSION['leveluser']=="admin") $query = $mysqli->query("SELECT * FROM artikel ORDER BY id_artikel DESC"); | |
else $query = $mysqli->query("SELECT * FROM artikel WHERE id_user='$id_user' ORDER BY id_artikel"); | |
while($data = $query->fetch_array()){ | |
$user = $mysqli->query("SELECT nama_lengkap FROM user where id_user='$data[id_user]'"); | |
$us = $user->fetch_array(); | |
$kategori = $mysqli->query("SELECT * FROM kategori where id_kategori='$data[kategori]'"); | |
$kat = $kategori->fetch_array(); | |
$tanggal = tgl_indonesia($data['tanggal']); | |
isi_tabel($no, array($data['judul'], $kat['kategori'], $us['nama_lengkap'], $tanggal), $link, $data['id_artikel']); | |
$no++; | |
} | |
tutup_tabel(); | |
break; | |
//Menampilkan form input dan edit data | |
case "form": | |
if(isset($_GET['id'])){ | |
$query = $mysqli->query("SELECT * FROM artikel WHERE id_artikel='$_GET[id]'"); | |
$data = $query->fetch_array(); | |
$aksi = "Edit"; | |
}else{ | |
$data = array("id_artikel"=>"", "judul"=>"", "isi"=>"", "gambar"=>"", "kategori"=>"", "tag"=>""); | |
$aksi = "Tambah"; | |
} | |
if($aksi=="Edit" and $_SESSION['leveluser']!="admin" and $data['id_user']!=$_SESSION['iduser']){ | |
header('location:'.$link); | |
}else{ | |
echo'<h3 class="page-header"><b>'.$aksi.' Artikel</b> </h3>'; | |
buka_form($link, $data['id_artikel'], strtolower($aksi)); | |
buat_textbox("Judul Artikel", "judul", $data['judul'], 10); | |
buat_textarea("Isi Artikel", "isi", $data['isi'], "richtext"); | |
buat_imagepicker("Gambar", "gambar", $data['gambar']); | |
$kategori = $mysqli->query("SELECT * FROM kategori"); | |
$list = array(); | |
while($k = $kategori->fetch_array()){ | |
$list[] = array('val'=>$k['id_kategori'], 'cap'=>$k['kategori']); | |
} | |
buat_combobox("Kategori", "kategori", $list, $data['kategori']); | |
$tag = $mysqli->query("SELECT * FROM tag"); | |
$arr_tag = explode(",", $data['tag']); | |
$list = array(); | |
while($t = $tag->fetch_array()){ | |
$check = (array_search($t['tag_seo'], $arr_tag) === false) ? "" : "checked"; | |
$list[] = array("val"=>$t['tag_seo'], "cap"=>$t['tag'], "check"=>$check); | |
} | |
buat_checkbox("Tag", "tag", $list); | |
tutup_form($link); | |
} | |
break; | |
//Menyisipkan atau mengedit data di database | |
case "action": | |
$judul = addslashes($_POST['judul']); | |
$judul_seo = convert_seo($_POST['judul']); | |
$isi = addslashes($_POST['isi']); | |
$tag = implode(",",$_POST['tag']); | |
$user = $_SESSION['iduser']; | |
if($_POST['aksi'] == "tambah"){ | |
$mysqli->query("INSERT INTO artikel SET | |
judul = '$judul', | |
judul_seo = '$judul_seo', | |
isi = '$isi', | |
hari = '$hari_ini', | |
tanggal = '$tanggal', | |
jam = '$jam', | |
id_user = '$user', | |
tag = '$tag', | |
kategori = '$_POST[kategori]', | |
gambar = '$_POST[gambar]' | |
"); | |
}elseif($_POST['aksi'] == "edit"){ | |
$mysqli->query("UPDATE artikel SET | |
judul = '$judul', | |
judul_seo = '$judul_seo', | |
isi = '$isi', | |
hari = '$hari_ini', | |
tanggal = '$tanggal', | |
jam = '$jam', | |
id_user = '$user', | |
tag = '$tag', | |
kategori = '$_POST[kategori]', | |
gambar = '$_POST[gambar]' | |
WHERE id_artikel='$_POST[id]'"); | |
} | |
header('location:'.$link); | |
break; | |
//Menghapus data di database | |
case "delete": | |
$query = $mysqli->query("SELECT * FROM artikel WHERE id_artikel='$_GET[id]'"); | |
$data = $query->fetch_array(); | |
if($_SESSION['leveluser']=="admin" or $data['id_user']==$_SESSION['iduser']){ | |
$mysqli->query("DELETE FROM artikel WHERE id_artikel='$_GET[id]'"); | |
} | |
header('location:'.$link); | |
break; | |
} | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment