Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67423 Members, 783 Products, 5281 Topic, 12953 Comments)

form konsultasi di web portal berita seperti web sekolah

Dibuat
Login Terakhir 5 Tahun lalu,
Telah Dilihat 1804 Kali
caturrini wulandari Mengatakan : Sultan Account
  1. Assalamualaikum Warahmatullahi Wabarakatuh...
  2.  
  3. Kak mau tanya, gimana ya buat form konsultasi php, sama seperti form konseling di web sekolah? Makasih

Ada 3 Jawaban

Bukhori Muslim
commented on 07 Jun 2018 11:53:41
  1. Assalam,.. langsung ambil saja gan dari web sekolah, untuk tablenya ini :
  2. CREATE TABLE `tbl_comment` (
  3. `id_komentar` int(5) NOT NULL,
  4. `reply` int(5) NOT NULL,
  5. `nama_lengkap` varchar(150) NOT NULL,
  6. `alamat_email` varchar(150) NOT NULL,
  7. `isi_pesan` text NOT NULL,
  8. `tanggal_komentar` date NOT NULL,
  9. `jam_komentar` time NOT NULL
  10. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  11.  
  12. ALTER TABLE `tbl_comment` ADD PRIMARY KEY (`id_komentar`);
  13. ALTER TABLE `tbl_comment` MODIFY `id_komentar` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;
  14.  
  15. Selanjutnya ambil script konsultasi.php nya...
  16. itu saja cuma satu script/file php saja dan selesai,.. :)
caturrini wulandari
commented on 08 Jun 2018 09:31:55
  1. Assalam,.. Oke kak ntar tak coba, kalo ada yang error nanya lagi kak
caturrini wulandari
commented on 23 Jun 2018 15:22:48
  1. Assalam,.. kak kenapa gak terinput ke database? terus gak tampil juga..maaf kak belum terlalu mahir
  2. ini script konsultasi yang sudah di edit
  3.  
  4. <?php if (isset($_GET['reply']) == ''){
  5. $stat = 'Pertanyaan';
  6. }else{
  7. $stat = 'Jawaban';
  8. }
  9.  
  10. if (isset($_GET['aksi'])=='hapus'){
  11. mysql_query("DELETE FROM tbl_comment where id_komentar='$_GET[id]'");
  12. echo "<script>window.alert('Sukses Hapus Pertanyaan.');
  13. window.location='konsultasi.php'</script>";
  14. }
  15. ?>
  16. <div id='form' class="main-page left">
  17. <div class="single-block">
  18. <div class="content-block main left">
  19. <div class="block">
  20. <div class="block-title">
  21. <h2>Tuliskan <?php echo "$stat"; ?> Anda Pada Form Dibawah Ini</h2>
  22. </div>
  23. <div class="block-content">
  24. <div id="writecomment">
  25.  
  26. <form action="" method="POST" onSubmit="return validasi(this)" id="form_komentar">
  27. <input type="hidden" name='id' value='<?php echo "$d[id_berita]"; ?>'>
  28. <p class="contact-form-user">
  29. <label for="c_name">Nama Anda<span class="required">*</label>
  30. <input type="text" placeholder="Nama Anda" id="nama" name='nama_komentar' class="required"/>
  31.  
  32. </p>
  33. <p class="contact-form-email">
  34. <label for="c_email">E-mail<span class="required">*</span></label>
  35. <input type="text" name='email' placeholder="Alamat E-mail" id="email" class="required"/>
  36. </p>
  37.  
  38. <?php
  39. $tanya = @mysql_fetch_array(@mysql_query("SELECT * FROM tbl_comment where id_komentar= ($_GET[reply]"));
  40. if (isset($_GET['reply']) != ''){
  41. echo "<p>
  42. <label for='c_email'><b>Pertanyaan</b><span class='required'></span></label>
  43. <div style='margin-left:8px;'>$tanya[isi_pesan] ? </div>
  44. </p>";
  45. }
  46. ?>
  47.  
  48. <p class="contact-form-message">
  49. <label for="c_message"><?php echo "$stat"; ?><span class="required">*</span></label>
  50. <textarea name='isi_komentar' placeholder="Tuliskan <?php echo "$stat"; ?> Anda.." class="required"></textarea>
  51. </p>
  52. <?php if (isset($_GET['reply']) == ''){ ?>
  53. <p><input type="submit" name="submit" class="styled-button" value="Kirimkan Pertanyaan"/></p>
  54. <?php }else{ ?>
  55. <p><input type="submit" name="submit" class="styled-button" value="Kirimkan Balasan"/></p>
  56. <?php } ?>
  57. </form>
  58. </div>
  59. </div>
  60.  
  61. <div id="viewcomment" class="block-title">
  62. <h2>
  63. <?php
  64. $total = @mysql_num_rows(@mysql_query("SELECT * FROM tbl_comment where reply='0'"));
  65. echo "Total Ada $total Pertanyaan";
  66.  
  67. if (isset($_POST['submit'])){
  68. $tanggal = date("Y-m-d");
  69. $jam = date("H:i:s");
  70. if (isset($_GET['reply']) != ''){
  71. $reply = ($_GET['reply']);
  72. }else{
  73. $reply = 0;
  74. }
  75.  
  76. @mysql_query("INSERT INTO tbl_comment (reply,
  77. nama_lengkap,
  78. alamat_email,
  79. isi_pesan,
  80. tanggal_komentar,
  81. jam_komentar)
  82. VALUES ('$reply',
  83. '$_POST[nama_komentar]',
  84. '$_POST[email]',
  85. '$_POST[isi_komentar]',
  86. '$tanggal',
  87. '$jam')");
  88. if (isset($_GET['reply']) != ''){
  89. echo "<script>window.alert('Sukses Kirimkan Komentar Balasan.');
  90. window.location='konsultasi.php#reply$_GET[reply]'</script>";
  91. }else{
  92. echo "<script>window.alert('Sukses Kirimkan Pertanyaan.');
  93. window.location='konsultasi.php'</script>";
  94. }
  95. }
  96. ?>
  97. </h2>
  98. </div>
  99. <div class="block-content">
  100. <div class="comment-block">
  101. <ol class="comments">
  102. <li>
  103. <?php
  104. $komentar = @mysql_query("SELECT * FROM tbl_comment where reply='0' order by id_komentar DESC");
  105.  
  106. while ($kka = @mysql_fetch_array($komentar)){
  107. $tgl = tgl_indo($kka['tanggal_komentar']);
  108. $isian=nl2br($kka['isi_pesan']);
  109. $isikan=sensor($isian);
  110. $komentarku = autolink($isikan);
  111.  
  112. if(($no % 2)==0){ $warna="#ffffff;"; }else{ $warna="#e3e3e3"; }
  113. $test = md5(strtolower(trim($kka['alamat_email'])));
  114.  
  115. echo "<div id='reply$kka[id_komentar]' style='background:$warna' class='commment-content'>
  116. <div class='user-avatar'>
  117. <a href='#' class='hover-effect'>";
  118. if ($kka['alamat_email'] == ''){
  119. echo "<img class='setborder' src='foto_user/blank.png'/>";
  120. }else{
  121. echo "<img class='setborder' src=\"http://www.gravatar.com/avatar/".$test.".jpg?s=100&d=".$_GET['d']."\" />";
  122. }
  123. echo "</a>
  124. </div>
  125. <strong class='user-nick'><a href='#'>$kka[nama_lengkap]</a></strong>
  126. <span class='time-stamp'>$tgl, $kka[jam_komentar] WIB</span>
  127. <div class='comment-text'>
  128. <p>$komentarku</p>";
  129. if ($_SESSION['leveluser']!=''){
  130. echo "<a class='button' style='background:#bf0000; color:#ffffff; float:right' href='dokter/logout.php'>Logout</a>
  131. <a class='button' style='background:#29b332; color:#ffffff; float:right' href='konsul.php?module=konsultasi&aksi=hapus&id=$kka[id_komentar]'>Hapus</a>
  132. <a class='button' style='background:#6cd43f; color:#ffffff; float:right' href='reply-konsultasi-$kka[id_komentar].html#form'>Berikan Jawaban</a>";
  133. }
  134.  
  135. echo "</div><div style='clear:both'></div>";
  136.  
  137. $reply = @mysql_query("SELECT * FROM tbl_comment where reply='$kka[id_komentar]'");
  138. while ($r = @mysql_fetch_array($reply)){
  139. $testt = md5(strtolower(trim($r['alamat_email'])));
  140. $tgll = tgl_indo($r['tanggal_komentar']);
  141. echo "<div style='background:$warna; margin-top:0px; margin-left:40px;'>
  142. <h4 style='background:lightgreen; color:#fff; margin-bottom:5px; padding:4px'>
  143. Dibalas Oleh : $r[nama_lengkap], Pada : $tgll, $kka[jam_komentar] WIB
  144. </h4>
  145. <div class='user-avatar'>
  146. <a href='#' class='hover-effect'>";
  147. if ($r[alamat_email] == ''){
  148. echo "<img class='setborder' src='foto_user/blank.png'/>";
  149. }else{
  150. echo "<img class='setborder' src=\"http://www.gravatar.com/avatar/".$testt.".jpg?s=100&d=".$_GET['d']."\" />";
  151. }
  152. echo "</a>
  153. </div>
  154. <div style='padding:left:10px'>
  155. <i style='color:red;'>$r[alamat_email]</i> -
  156. $r[isi_pesan]
  157. </div><div style='clear:both'></div>
  158. </div>";
  159. }
  160. echo "</div>";
  161. $no++;
  162. }
  163. ?>
  164. </li>
  165.  
  166. </ol>
  167.  
  168. </div>
  169.  
  170. </div>
  171. </div>
  172. </div>
  173. </div>
  174. </div>
Terdapat 1 File dilampirkan :
1. form_konsultasi.png (38 KB)
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!