Bagaimana cara menambahkan Balas Komentar Swarakalibata CI

Bagaimana cara menambahkan Balas Komentar Swarakalibata CI Dibuat 6 Tahun lalu \| 2018-04-04 14:47:15 WIB, Login Terakhir 1 Tahun lalu, Telah Dilihat 2186 Kali
Sultan Account
Sultan Account	Kodirrrrrrrrrrrrrrr Mengatakan : Sultan Account Assalamualaikum Warahmatullahi Wabarakatuh...bagaimana menambahkan fitur membalas komentar di halaman admin? Ada 1 File Kiriman : 1. komentar.png (50 KB)

Ada 10 Jawaban

Bukhori Muslim
commented on 05 Apr 2018 08:58:19 Sultan Account

Assalam,.. berarti maksudnya membalas per-komentar nya gan?
jika memng seperti itu berarti harus ditambahkan 1 table baru untuk menmpung reply dari komentar yg sudah terbit
kurang lebih struktur tablenya seperti ini nanti :
 
CREATE TABLE IF NOT EXISTS `komentar_reply` (
  `id_komentar_reply` int(5) NOT NULL,
  `id_komentar` int(5) NOT NULL,
  `nama_komentar` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `url` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `isi_komentar` text COLLATE latin1_general_ci NOT NULL,
  `tgl` date NOT NULL,
  `jam_komentar` time NOT NULL,
  `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  `email` varchar(100) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=161 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
ALTER TABLE `komentar_reply` ADD PRIMARY KEY (`id_komentar_reply`);
 
jadi setiap komentar reply yg masuk akan insert ke table ini dengan membawa id_komentar pada table komentar, 
selanjutnya pada script komentar di tiap berita detail juga perlu perbaikan menjadi seperti ini.
 
<?php
$no = 1;
$komentar = $this->model_utama->view_where_ordering_limit('komentar',array('id_berita' => $rows['id_berita'],'aktif' => 'Y'),'id_komentar','ASC',0,100);
	foreach ($komentar->result_array() as $kka) {
	$isian=nl2br($kka['isi_komentar']); 
	$komentarku = sensor($isian); 
 
	if(($no % 2)==0){ $warna="#ffffff;"; }else{ $warna="#e3e3e3"; }
	$test = md5(strtolower(trim($kka['email'])));	
	echo "<div style='background:$warna' class='commment-content'>
			<div class='user-avatar'>
				<a href='#' class='hover-effect'>";
					if ($kka['email'] == ''){
						echo "<img class='setborder' src='".base_url()."asset/foto_user/blank.png'/>";
					}else{
						echo "<img class='setborder' src='http://www.gravatar.com/avatar/$test.jpg?s=100'/>";
					}
				echo "</a>
			</div>
			<strong class='user-nick'><a href='$kka[url]'>$kka[nama_komentar]</a></strong>
			<span class='time-stamp'>".tgl_indo($kka['tgl']).", $kka[jam_komentar] WIB</span>
			<div class='comment-text'><p>$komentarku</p></div>
		  </div>";
		  $komentar_reply = $this->model_utama->view_where_ordering_limit('komentar_reply',array('id_komentar' => $kka['id_komentar'],'aktif' => 'Y'),'id_komentar','ASC',0,100);
			foreach ($komentar_reply->result_array() as $kka) {
			$isian=nl2br($kka['isi_komentar']); 
			$komentarku = sensor($isian); 
 
			if(($no % 2)==0){ $warna="#ffffff;"; }else{ $warna="#e3e3e3"; }
			$test = md5(strtolower(trim($kka['email'])));	
			echo "<div style='background:lightblue; margin-left:30px' class='commment-content'>
					<div class='user-avatar'>
						<a href='#' class='hover-effect'>";
							if ($kka['email'] == ''){
								echo "<img class='setborder' src='".base_url()."asset/foto_user/blank.png'/>";
							}else{
								echo "<img class='setborder' src='http://www.gravatar.com/avatar/$test.jpg?s=100'/>";
							}
						echo "</a>
					</div>
					<strong class='user-nick'><a href='$kka[url]'>$kka[nama_komentar]</a></strong>
					<span class='time-stamp'>".tgl_indo($kka['tgl']).", $kka[jam_komentar] WIB</span>
					<div class='comment-text'><p>$komentarku</p></div>
				  </div>";
			$no++;
		}
	$no++;
}
?>

Kodirrrrrrrrrrrrrrr commented on 05 Apr 2018 17:06:47 Sultan Account

	Assalam,.. saya sudah coba cara diatas, hasilnya halaman detil berita jadi acak2an, dan hasil dari tabel tadi ga muncul

Kodirrrrrrrrrrrrrrr
commented on 05 Apr 2018 17:45:39 Sultan Account

Assalam,.. Ralat, sekarang sudah bisa, setelah di utak atik, ada sedikit perbaikan di scripnya dan tabelnya
---------------------------------------------------
<?php
$no = 1;
$komentar = $this->model_utama->view_where_ordering_limit('komentar',array('id_berita' => $rows['id_berita'],'aktif' => 'Y'),'id_komentar','ASC',0,100);
	foreach ($komentar->result_array() as $kka) {
	$isian=nl2br($kka['isi_komentar']); 
	$komentarku = sensor($isian); 
 
	if(($no % 2)==0){ $warna="#ffffff;"; }else{ $warna="#e3e3e3"; }
	$test = md5(strtolower(trim($kka['email'])));	
	echo "<div style='background:$warna' class='commment-content'>
			<div class='user-avatar'>
				<a href='#' class='hover-effect'>";
					if ($kka['email'] == ''){
						echo "<img class='setborder' src='".base_url()."asset/foto_user/blank.png'/>";
					}else{
						echo "<img class='setborder' src='http://www.gravatar.com/avatar/$test.jpg?s=100'/>";
					}
				echo "</a>
			</div>
			<strong class='user-nick'><a href='$kka[url]'>$kka[nama_komentar]</a></strong>
			<span class='time-stamp'>".tgl_indo($kka['tgl']).", $kka[jam_komentar] WIB</span>
			<div class='comment-text'><p>$komentarku</p></div>
		  </div>";
		  $komentar_reply = $this->model_utama->view_where_ordering_limit('komentar_reply',array('id_komentar' => $kka['id_komentar'],'aktif' => 'Y'),'id_komentar','ASC',0,100);
			foreach ($komentar_reply->result_array() as $kkb) {
			$isian=nl2br($kkb['isi_reply']); 
			$komentarku = sensor($isian); 
 
			if(($no % 2)==0){ $warna="#ffffff;"; }else{ $warna="#e3e3e3"; }
			$test = md5(strtolower(trim($kkb['email'])));	
			echo "<div style='background:$warna; margin-left:30px' class='commment-content'>
						<div class='user-avatar'>
					<a href='#' class='hover-effect'>";
					if ($kka['email'] == ''){
							echo "<img class='setborder' src='".base_url()."asset/foto_user/blank.png'/>";
					}else{
							echo "<img class='setborder' src='http://www.gravatar.com/avatar/$test.jpg?s=100'/>";
					}
				echo "</a>
			</div>
					<strong class='user-nick'>$kkb[petugas]</a></strong>
					<span class='time-stamp'>".tgl_indo($kkb['tgl_reply']).", $kkb[jam_reply] WIB</span>
					<div class='comment-text'><p>$komentarku</p></div>
				  </div>";
			$no++;
		}
	$no++;
}
?>

Kodirrrrrrrrrrrrrrr
commented on 05 Apr 2018 17:47:47 Sultan Account

Assalam,.. ini tabelnya
REATE TABLE `komentar_reply` (
  `id_komentar_reply` int(5) NOT NULL,
  `id_komentar` int(5) NOT NULL,
  `petugas` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `isi_reply` text COLLATE latin1_general_ci NOT NULL,
  `tgl_reply` date NOT NULL,
  `jam_reply` time NOT NULL,
  `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Terdapat 1 File dilampirkan :

1. Maaf File 'komentar_reply.sql (0)' Gagal Terkirim!

Kodirrrrrrrrrrrrrrr commented on 05 Apr 2018 17:49:11 Sultan Account

	Assalam,.. ini sql tabelnya Terdapat 1 File dilampirkan : 1. komentar_reply.zip (790 B)

Kodirrrrrrrrrrrrrrr
commented on 05 Apr 2018 17:50:49 Sultan Account

Assalam,.. iniperubahan pada modul edit komentar
-----------------------------------------------------------------------------
function edit_komentarberita(){
		cek_session_akses('komentarberita',$this->session->id_session);
		$id = $this->uri->segment(3);
		if (isset($_POST['submit'])){
			$data = array('nama_komentar'=>$this->input->post('a'),
                        		'url'=>$this->input->post('b'),
                        		'isi_komentar'=>$this->input->post('c'),
                        		'aktif'=>$this->input->post('d'),
                        		'email'=>$this->input->post('e'));
			$where = array('id_komentar' => $this->input->post('id'));
			$this->model_app->update('komentar', $data, $where);
			$data2 = array('isi_reply'=>$this->input->post('l'),
                        		'jam_reply'=>date('H:i:s'),
                        		'aktif'=>$this->input->post('d'),
                        		'tgl_reply'=>date('Y-m-d'),
					'isi_reply'=>$this->input->post('l'),
					'petugas'=>$this->session->username,
					'id_komentar'=>$this->input->post('id'));
			$this->model_app->insert('komentar_reply', $data2);
			redirect('depanel/komentarberita');
		}else{
			$proses = $this->model_app->edit('komentar', array('id_komentar' => $id))->row_array();
			$data = array('rows' => $proses);
			$this->template->load('depanel/template','depanel/mod_komentar/view_komentar_edit',$data);
		}
	}

Kodirrrrrrrrrrrrrrr
commented on 05 Apr 2018 17:52:43 Sultan Account

Assalam,.. ini perubahan pada view komentar edit
-----------------------------------------------------------------------------
 
<?php 
    echo "<div class='col-md-12'>
              <div class='box box-info'>
                <div class='box-header with-border'>
                  <h3 class='box-title'>Edit Komentar Berita</h3>
                </div>
              <div class='box-body'>";
              $attributes = array('class'=>'form-horizontal','role'=>'form');
              echo form_open_multipart('depanel/edit_komentarberita',$attributes); 
          echo "<div class='col-md-12'>
                  <table class='table table-condensed table-bordered'>
                  <tbody>
                    <input type='hidden' name='id' value='$rows[id_komentar]'>
                    <tr><th width='120px' scope='row'>Nama Komentar</th>    <td><input type='text' class='form-control' name='a' value='$rows[nama_komentar]'></td></tr>
                    <tr><th scope='row'>Website</th>    <td><input type='text' class='form-control' name='b' value='$rows[url]'></td></tr>
                    <tr><th scope='row'>Email</th>    <td><input type='text' class='form-control' name='e' value='$rows[email]'></td></tr>
                    <tr><th scope='row'>Isi Komentar</th>             <td><textarea class='form-control' name='c' style='height:200px'>$rows[isi_komentar]</textarea></td></tr>
		    <tr><th scope='row'>Balasan</th>             <td><textarea class='form-control' name='l' style='height:200px'>$rows[isi_reply]</textarea></td></tr>
                    <tr><th scope='row'>Aktif</th>    <td>"; if ($rows['aktif']=='Y'){ echo "<input type='radio' name='d' value='Y' checked> Ya <input type='radio' name='d' value='N'> Tidak"; }else{ echo "<input type='radio' name='d' value='Y'> Ya <input type='radio' name='d' value='N' checked> Tidak"; } echo "</td></tr>
 
                  </tbody>
                  </table>
                </div>
 
              <div class='box-footer'>
                    <button type='submit' name='submit' class='btn btn-info'>Update</button>
                    <a href='index.php'><button type='button' class='btn btn-default pull-right'>Cancel</button></a>
 
                  </div>
            </div></div></div>";
            echo form_close();
----------------------------------------------------------
semoga bermanfaat buat yang lain

PHPMU.COM Support commented on 07 Apr 2018 09:17:38 Sultan Account

	Assalam,.. oke mas mantap terima kasih sudah berbagi ilmunya.

Rahmat Sasmita
commented on 23 Mei 2018 16:05:42 Sultan Account

Assalam,.. untuk script ini disimpan dimana ya :
 
function edit_komentarberita(){
		cek_session_akses('komentarberita',$this->session->id_session);
		$id = $this->uri->segment(3);
		if (isset($_POST['submit'])){
			$data = array('nama_komentar'=>$this->input->post('a'),
                        		'url'=>$this->input->post('b'),
                        		'isi_komentar'=>$this->input->post('c'),
                        		'aktif'=>$this->input->post('d'),
                        		'email'=>$this->input->post('e'));
			$where = array('id_komentar' => $this->input->post('id'));
			$this->model_app->update('komentar', $data, $where);
			$data2 = array('isi_reply'=>$this->input->post('l'),
                        		'jam_reply'=>date('H:i:s'),
                        		'aktif'=>$this->input->post('d'),
                        		'tgl_reply'=>date('Y-m-d'),
					'isi_reply'=>$this->input->post('l'),
					'petugas'=>$this->session->username,
					'id_komentar'=>$this->input->post('id'));
			$this->model_app->insert('komentar_reply', $data2);
			redirect('login/komentarberita');
		}else{
			$proses = $this->model_app->edit('komentar', array('id_komentar' => $id))->row_array();
			$data = array('rows' => $proses);
			$this->template->load('login/template','login/mod_komentar/view_komentar_edit',$data);
		}
	}

Rahmat Sasmita commented on 30 Mei 2018 16:50:31 Sultan Account

	Assalam,.. up

Maaf, Untuk Memberikan Komentar Anda Harus Login !!!

	BSI - Bank Syariah Indonesia (451)

	ROBBY PRIHANDAYA
	1043-5665-19


	Bank Muamalat (147)
	ROBBY PRIHANDAYA
	4220-0174-81

Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67504 Members, 783 Products, 5291 Topic, 12956 Comments)

Bagaimana cara menambahkan Balas Komentar Swarakalibata CI

Ada 10 Jawaban

Projects Remote

Hot Questions

Tentang Kami

Jam Layanan

Knowledgebase