membuat forum dengan php ~ pheloe

Sekedar share

tidak mau repot mambaca.... saya kasi link donloadnya di bawah...dengan catatan mengganti semua script <? dengan <?php

pertama kita mambuat coneksinya

dengan nama conn.php

<html>

<head>

</head>

<body>

<?php

ini_set('display_errors',FALSE);

$host="localhost";

$user="root";

$pass="";

$db="kunokuno";

$entries=3;

$koneksi=mysql_connect($host,$user,$pass);

$tanggal=date("Y-m-d H:i:s");

if ($koneksi)

{

//echo "berhasil : )";

}else{

?><script language="javascript">alert("Gagal Koneksi Database MySql !!")</script>

<?php

}

</body>

</html>

kedua mambuat halaman utama untuk forum

dengan nama forum.php

<html>

<head><title>Forum</title></head><br>

<tr>

<td width="81%" bgcolor="#5686c6" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">FORUM</font></strong></div></td>

</tr>

<tr>

<tr>

<?php

include "conn.php";

<?php

//untuk paging

$query=mysql_db_query($db,"select * from forum where ID_replay=0 order by tanggal desc",$koneksi); //input

$get_pages=mysql_num_rows($query);

if ($get_pages>$entries) //proses

{

echo "Halaman : ";

$pages=1;

while($pages<=ceil($get_pages/$entries))

{

if ($pages!=1)

{

echo " | ";

}

<a href="forum.php?id=<?php echo ($pages-1); ?> " style="text-decoration:none"><font size="2" face="verdana" color="#009900"><?php echo $pages; ?></font></a>

<?php

$pages++;

}

}else{

$pages=0;

}

</font></p>

<?php

//akhir paging

//proses halaman

$page=(int)$_GET['id'];

$offset=$page*$entries;

$result=mysql_db_query($db,"select * from forum where ID_replay=0 order by tanggal desc limit $offset,$entries",$koneksi); //output

$jumlah=mysql_num_rows($query);

if ($jumlah){

<tr>

<td width="223" bgcolor="#e8e8e8"><div align="center"><b><font face="verdana" size="2">TOPIK</font></b></div></td>

<td width="59" bgcolor="#e8e8e8"><div align="center"><b><font face="verdana" size="2">Replay</font></b></div></td>

<td width="187" bgcolor="#e8e8e8"><div align="center"><b><font face="verdana" size="2">Posting</font></b></div></td>

</tr>

<?php

while ($row=mysql_fetch_array($result))

{

$ID_topik=$row[0];

$nama=$row[1];

$email=$row[2];

$topik=$row[3];

$isi=$row[4];

$ID_replay=$row[5];

$tanggal=$row[6];

//jumlah replay setiap topik

$replay=mysql_db_query($db,"select * from forum where ID_replay='$ID_topik'",$koneksi);

$jml=mysql_num_rows($replay);

<tr>

<td align="left"><b><a href="forum-view.php?ID_topik=<?php echo $ID_topik;?>" style="text-decoration:none ">

<font face="verdana" size="-4" color="#666666">Autor: <?php echo $nama; ?> </font> </td>

</tr>

<tr>

</tr>

<?php

}

</table>

<?php

}else{

<p align="center"><font color="#FF0000" face="verdana" size="2"><b>Belum ada data!!</b></font>

<?php

}

</p>

</td>

</tr>

</table></td>

</tr>

<tr>

<td bgcolor="#5686c6" ><div align="center"><strong><font face="verdana" size="1" color="#333333">Jumlah Topik : <?php echo $jumlah; ?></font></strong></div></td>

</tr>

</table>

</html>

ketiga kita buat halaman untuk inputan datanya

kita namai forum-new.php

<?php

include "conn.php";

if(isset($_POST['nama']))

{

$nama=$_POST['nama'];

$email=$_POST['email'];

$topik=$_POST['topik'];

$isi=$_POST['isi'];

$tanggal;

if (empty($nama) || empty($email) || empty($topik) || empty($isi))

{

echo "<script> document.location.href='forum-new.php?status=Maaf, Data Anda belum lengkap!!'; </script>";

}else{

$query=mysql_db_query($db,"insert into forum(nama,email,topik,isi,tanggal) values('$nama','$email','$topik','$isi','$tanggal')",$koneksi);

if($query)

{

echo "<script> document.location.href='forum.php?status=Berhasil Membuat Topik Baru'; </script>";

}else{

echo "<script> alert('Gagal Query!!'); </script>";

}

}else{

unset($_POST['nama']);

}

<html><head><title>Forum Ri32</title></head><br>

<tr>

<td width="60%" bgcolor="#5686c6" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">New Forum</font></strong></div></td>

</tr>

<tr>

<td>

<tr >

</tr>

<tr>

<td align="left"><font face="verdana" size="2">Email</font></td><td>:</td><td align="left">

</tr>

<tr>

<td align="left"><font face="verdana" size="2">TOPIK</font></td><td>:</td><td align="left">

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</center>

</form>

</td></tr>

</table>

</td>

</tr>

<tr>

</tr>

</table>

</center>

</html>

ke empat kita buat halaman selanjutnya

kita namai forum-reply.php

<?php

include "conn.php";

if(isset($_POST['nama']))

{

$nama=$_POST['nama'];

$email=$_POST['email'];

$topik=$_POST['topik'];

$isi=$_POST['isi'];

$ID_topik=$_POST['ID_topik'];

if (empty($nama) || empty($email) || empty($topik) || empty($isi))

{

?><script language="javascript">document.location.href='forum-reply.php?ID_topik=<?php echo $ID_topik;?>&topik=<?php echo $topik;?>&status=Maaf, Data Anda masih kosong!!'; </script>";</script><?php

}else{

$query=mysql_db_query($db,"insert into forum(nama,email,topik,isi,tanggal,ID_replay) values('$nama','$email','$topik','$isi','$tanggal','$ID_topik')",$koneksi);

if($query)

{

echo "<script>alert('Berhasil mengisi reply!!');</script>";

?><script language="javascript">document.location.href='forum-view.php?ID_topik=<?php echo $ID_topik;?>'; </script>";</script><?php

}else{

echo "<script>alert('gagal!!');</script>";

}

}else{

unset($_POST['nama']);

}

<html>

<head><title>Forum Ri32</title></head><br>

<tr>

<td width="90%" bgcolor="#5686c6" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">Reply Forum</font></strong></div></td>

</tr>

<tr>

<td>

<tr >

<input type="hidden" value="<?php echo $_GET['ID_topik']; ?>" name="ID_topik"><font face="verdana" size="2"><?php echo $_GET['ID_topik']; ?></font></td>

</tr>

<tr >

</tr>

<tr>

<td align="left"><font face="verdana" size="2">Email</font></td><td>:</td><td align="left">

</tr>

<tr>

<td align="left"><font face="verdana" size="2">Topik</font></td><td>:</td><td align="left">

<input type="text" value="<?php echo $_GET['topik']; ?>" name="topik" size="33"></td>

</tr>

<tr>

</tr>

<tr>

<td>

<a href="forum-view.php?ID_topik=<?php echo $_GET['ID_topik']; ?>&topik=<?php echo $_GET['topik'];?>" style="text-decoration:none" title="Kembali">

</a>

</td>

</tr>

</table>

</form>

</td></tr>

</table>

</td>

</tr>

<tr>

</tr>

</table>

</center>

</html>

terakhir kita membuat halaman yang kita namai forum-view.php

<html>

<head><title>Forum Ri32</title></head><br>

<tr>

<td width="95%" bgcolor="#5686c6" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">View Forum</font></strong></div></td>

</tr>

<tr>

<tr>

<?php

#menampilkan topik

$ID_topik=$_GET['ID_topik'];

include"conn.php";

$query=mysql_db_query($db,"select * from forum where ID_topik='$ID_topik'",$koneksi); //untuk posting

$quey=mysql_db_query($db,"select * from forum where ID_replay='$ID_topik'",$koneksi); //untuk jumlah replay

$jml=mysql_num_rows($quey); //untuk jumlah replay

while ($row=mysql_fetch_array($query))

{

$ID_topik=$row[0];

$nama=$row[1];

$email=$row[2];

$topik=$row[3];

$isi=$row[4];

$ID_replay=$row[5];

$tanggal=$row[6];

}

//isi dari forum yang di tampilkan

echo "<b>"."Topik : ".$topik."</b>"."<br>";

?><font face="verdana" size="1" color="#666666"><?php

echo "Posted : ".$tanggal."<br>";

?>By : <a href="mailto:<?php echo $email;?>" style="text-decoration:none "><?php echo $nama; ?></a><br><?php

echo "Hit : ".$jml." replay"."<br>";

?></font><br><font face="verdana" size="2"><?php

echo $isi;

echo "</font>";

</td>

</tr>

<tr>

<?php

?><p align="center"><font face="verdana" size="2"><?php

//untuk paging

$query2=mysql_db_query($db,"select * from forum where ID_replay='$ID_topik' order by tanggal desc",$koneksi); //input

$get_pages=mysql_num_rows($query2);

if ($get_pages>$entries) //proses

{

echo "<br>Halaman : ";

$pages=1;

while($pages<=ceil($get_pages/$entries))

{

if ($pages!=1)

{

echo " | ";

}

<a href="index.php?page=9&id=<?php echo ($pages-1); ?>&ID_topik=<?php echo $_GET['ID_topik']; ?> " style="text-decoration:none"><font face="verdana" size="2" color="#009900"><?php echo $pages; ?></font></a>

<?php

$pages++;

}

}else{

$pages=0;

}

?></font></p><?php

//akhir paging

//proses halaman

$page=(int)$_GET['id'];

$offset=$page*$entries;

$result=mysql_db_query($db,"select * from forum where ID_replay='$ID_topik' order by tanggal desc limit $offset,$entries",$koneksi); //output

$jumlah=mysql_num_rows($query2);

if($jumlah){

while ($row2=mysql_fetch_array($result))

{

$ID_topik2=$row2[0];

$nama2=$row2[1];

$email2=$row2[2];

$topik2=$row2[3];

$isi2=$row2[4];

$ID_replay2=$row2[5];

$tanggal2=$row2[6];

?><br><br><font face="verdana" size="2"><b>Re : <?php echo $topik2 ?></b></font>

<font face="verdana" size="1" color="#666666"><?php

echo "Posted : ".$tanggal2;

?> By : <a href="mailto:<?php echo $email2;?>" style="text-decoration:none "><?php echo $nama2; ?></a><?php

?></font><?php

echo "<br><br><font face='verdana' size='2'>";

echo $isi2;

echo "<hr></font>";

}

}else{

<p align="center"><font color="#0066FF" face="verdana" size="2"><blink>Belum ada data!!</blink></font></p>

<?php

}

</td>

</tr>

<tr>

<td>

<p><a href="index.php?page=10&ID_topik=<?php echo $ID_topik; ?>&topik=<?php echo $topik;?>" style="text-decoration:none ">

</a><a href="forum.php" title="Kembali"><img src="./img/back.png" alt="kembali" border="0"></a><a href="forum-reply.php?ID_topik=<?php echo $ID_topik; ?>&topik=<?php echo $topik;?>" style="text-decoration:none "><img src="./img/reply.gif" border="0"></a></p>

</center>

</td>

</tr>

</table>

</td></tr>

</table>

</td>

</tr>

<tr>

</tr>

</table>

</html>

Download script lengkap dan database nya di Sini

Posted in: belajar PHP

9 komentar:

Deni Indrawan says:

22 Juni 2012 pukul 11.25

terima kasih artikelnya membantu pembuatan project tugas saya,

shoechardex says:

21 September 2012 pukul 01.42

sama sama gan. say juga lagi belajar

Present to dhia says:

30 September 2012 pukul 02.29

itu gan maksud dari catatan mengganti semua script <? dengan <?php apa???

Nofel_Apen says:

5 November 2012 pukul 20.17

overall dah jalan gan. namun masih ada eror 1 bagian yaitu paging di halaman view topik, ktika buat topik, trus masuk ke topiknya, ada 5orang komen, trus ad paging 1 dan 2, ketika di klik paging 1 atau 2 object not found, itu kenapa ya? mohon bantuannya

5 November 2012 pukul 20.33

owh setelah saya liat2 agan salah ketik hehe, tadi di kodingan forum-view: <a href="index.php?
seharusnya
<a href="forum-view.php"

nice bgt gan bermanfaat ^^

Pratama says:

2 November 2015 pukul 10.57

makasih banyak bro, sangat membantu