membuat web forum dengan php dan

7/28/2019 Membuat Web Forum Dengan Php Dan

1/68

Membuat Web Forum Dengan Php dan Mysql

Juli 30, 2011 bytriconstantine

ayobelajar phpdengan susah payah saya ahirnya bisa menyelesaikan tutorial php inikalow mau copy paste postingan saya harap cantumkan jg nama saya,,,,,terimaksih

atas perhatiannya..

dalam artikelMembuat Web Forum Dengan Php dan Mysql ini saya akan

memberikan beberapa contoh script php yg sya buat

maaf bila di dalam artikel Membuat Web Forum Dengan Php dan Mysqlkalau

masih kurang memuaskan

ya namanya juga samasama belajar

semoga artikelMembuat Web Forum Dengan Php dan Mysqlini bermanfaat

untuk anda..

saya persembahkan artikelMembuat Web Forum Dengan Php dan Mysql

untuk para pembaca yang tercinta.

kenalan yuk..kenalin aquw anak baru dari bogor, umur 15 tahun, cowok(just berondong),,,,numb

hape catet ia kalow di perluin,,,,,,085718383409.

tanpa basa basi pertama siapkan dulu header.jpg webnya..lalu download j query

dan fancy box..kalow blom tahuw j query dan fancy box itu apa silahkan tanya

ke paman google ok

truz siapin jg satu folder bernama upload..jgn lupa siapin jg bg.jpg untu latar

belakang,,,,,

nah yang inni simpan dengan nama connection.php

Code:
http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/author/triconstantine/http://triconstantine.wordpress.com/author/triconstantine/http://triconstantine.wordpress.com/author/triconstantine/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/author/triconstantine/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/


2/68

ini index.php

Code:

Imagenatoria

body{font-family:"Comic Sans Ms ";}a:link {text-decoration:none; color:#FF0000;}a:visited {text-decoration:none; color:#FF0000;}

a:hover {text-decoration:underline; color:#FF0000;}a:active {text-decoration:underline; color:#FF0000;}


3/68

//connect to databaseinclude connection.php;?>


4/68

Tio Web Production
SMKF Galenium Bogor

suka-gallery.php


5/68

Code:


6/68

List Comment for Topic :


7/68

echo
Post by : .$row3['first_name']..$row3['last_name'];echo

.$row2['description'].
; }while($row2=mysql_fetch_array($result2));}
?> Tio Web Production
SMKF Galenium Bogor

dellete-gallery.php

Code:


8/68

}header("Location: gallery.php"); ?>

do_login.php

Code:


9/68

//koneksi ke databaseinclude('connection.php');

if($_POST){ //jika tombol update ditekan dan data terkirim ke server//bentuk sql query untuk update

$update = "update foto set deskripsi='".$_POST['deskripsi']."' ";if($_FILES['file']['size'] > 0 && $_FILES['file']['error

'] == 0){ //update gambar hanya jika user memilih file b

aru$move = move_uploaded_file($_FILES['file']['tmp_name'],

"upload/".$_FILES['file']['name']);

if($move){$update .= ", nama_file='".$_FILES['file']['name']."'";}}

$update .= " where id='".$_POST['id']."'";mysql_query($update); //update data ke databaseheader("Location: gallery.php");

exit;}

?>

Edit Picture


10/68


11/68

Code:

Login to Forum

Email Address Password


12/68

logout.php

Code:

main_forum.php

Code:


13/68

//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Forum Kami

body{font-family:"";}a:link {text-decoration:none; color:#FF0000;}

a:visited {text-decoration:none; color:#FF0000;}a:hover {text-decoration:underline; color:#FF0000;}a:active {text-decoration:underline; color:#FF0000;}

Selamat datang di forum kami,


14/68

$row=mysql_fetch_array($result);echo .$row['first_name'];echo Logout;?>


15/68

$mulai_dari = $limit * ($page - 1);$sql_limit = select * FROM topic order by topic_id desc limit $mulai_dari, $limit;$result=mysql_query($sql_limit);while($row=mysql_fetch_array($result)){

//display topicecho .$row['title'].
; //get who post the topic$query1=SELECTCONCAT_WS(,first_name,last_name) as name_1 from user

_login whereemail=.$row['post_by_user'].;$result1=mysql_query($query1)or die(mysql_error());$row1=mysql_fetch_array($result1);echo Post By :.$row1['name_1'].
;

//display post_dateecho Post Date : .$row['post_date'].

;//display descriptionecho $row['description'];//get number comment to topic$query2=select count(topic_id) as num_comment from comment where topic_id=.$row['topic_id'];$result2=mysql_query($query2);$row2=mysql_fetch_array($result2);echo New Comment | Comment(.$row2['num_comment'].)
; }?>


16/68

$banyakHalaman = ceil($banyakData / $limit);echo Halaman:;for($i = 1; $i

Tio Web Production
SMKF Galenium Bogor

new_comment.php

Code:


17/68

}else{header(location:new_comment.php?topic=$topic_id&msg=2);}}else{

header(location:new_comment.php?topic=$topic_id&msg=1);}}?>

>

body{font-family:";}

a:link {text-decoration:none; color:#FF0000;}a:visited {text-decoration:none; color:#FF0000;}a:hover {text-decoration:underline; color:#FF0000;}a:active {text-decoration:underline; color:#FF0000;}
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/1999/xhtml%E2%80%9D&gthttp://www.w3.org/1999/xhtml%E2%80%9D&gthttp://www.w3.org/1999/xhtml%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gt


18/68


19/68

Tio Web Production
SMKF Galenium Bogor

new_topic.php

Code:


20/68

$desc=$_REQUEST['desc'];// check are user click button saveif($_REQUEST['action']==insert){//checkif title and description no emptyif($title== || $desc==){

header(Location: new_topic.php?msg=1);}else{//data no empty//save data to database$query=INSERT INTO topic (title,description,post_date,post_by_user) value($title,'$desc,NOW(),.$_SESSION['user_forum'].);$result=@mysql_query($query);if($result){header(Location: main_forum.php);

}else{header(Location:new_topic.php?msg=2);}}}?>
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/1999/xhtml%E2%80%9D&gthttp://www.w3.org/1999/xhtml%E2%80%9D&gthttp://www.w3.org/1999/xhtml%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gthttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%E2%80%9D&gt


21/68

Main Forum -> New Topic


22/68


23/68

body {background-color: ;}

>

body{font-family:Comic Sans Ms ;}a:link {text-decoration:none; color:#FF0000;}

a:visited {text-decoration:none; color:#FF0000;}a:hover {text-decoration:underline; color:#FF0000;}a:active {text-decoration:underline; color:#FF0000;}


24/68


25/68

Registration

body{font-family:"";}

a:link {text-decoration:none; color:#FF0000;}a:visited {text-decoration:none; color:#FF0000;}a:hover {text-decoration:underline; color:#FF0000;}

a:active {text-decoration:underline; color:#FF0000;}


26/68


27/68

save-gallery.phpCode:


28/68

}} ?>

save_register.php

Code:

Registration


29/68

if($email== || $first_name== || $password1== || $password2==){echo Sorry data incomplete;}else{//cek if password anda retype password in sameif($password1!=$password2){

echo Password and Retype Password must be in same!;}else{//save data to database// creating query$query=INSERT INTO user_login (email, first_name, last_name, password) VALUES($email,$first_name,$last_name,$password1);

$result=@mysql_query($query)or die(mysql_error());

if($result){echo Registration Success
Continue Login;}else{echo Error!! Can not save data to database!;}}

}

?>

search.php

Code:


30/68

search

Search :


31/68

while($topic = mysql_fetch_array($result)){?>

session.php

Code:

oh iya saya hampir lupa, databasenya kayak gini..

Code:

-- phpMyAdmin SQL Dump

-- version 2.11.4


32/68

-- http://www.phpmyadmin.net--

-- Host: localhost-- Generation Time: Jul 23, 2011 at 09:49 AM-- Server version: 5.1.57

--PHP Version: 5.2.17SET SQL_MODE=NO_AUTO_VALUE_ON_ZER

O;Database: à3202487_imagen`--Table structure for table `comment`CREATE TABLE `comment` (

`topic_id` int(10) unsigned DEFAULT 0,`description` text,`post_date` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,`post_by_user` varchar(50) NOT NULL DEFAULT ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Dumping data for table `comment`

Table structure for table `foto`

CREATE TABLE `foto` (ìd` int(11) NOT NULL AUTO_INCREMENT,

`nama_file` varchar(255) NOT NULL,`deskripsi` varchar(255) DEFAULT NULL,`suka` int(11) NOT NULL,PRIMARY KEY (ìd`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


33/68

Dumping data for table `foto`

Table structure for table `topic`

CREATE TABLE `topic` (`topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,`title` varchar(255) NOT NULL DEFAULT ,

`description` text,`post_date` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,`post_by_user` varchar(50) NOT NULL DEFAULT ,PRIMARY KEY (`topic_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

ini contoh jadinya

imagenatoria.tk

ayo jangan nyerah teruslah belajar php

maaf ia kalow acakan..aku pendatang baru,,,,,

my facebook

http://www.facebook.com/tri.constantine

Membuat Web Forum Dengan Php dan Mysql
http://www.facebook.com/tri.constantinehttp://www.facebook.com/tri.constantinehttp://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://triconstantine.wordpress.com/2011/07/30/membuat-web-forum-dengan-php-dan-mysql/http://www.facebook.com/tri.constantine


34/68

MEMBUAT FORUM DENGAN PHP

SENIN, DESEMBER 19, 2011 SHOECHARDEX PHELOE 5 COMMENTS

Sekedar share

tidak mau repot mambaca.... saya kasi link donloadnya di bawah...dengan

catatan mengganti semua script


35/68

$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{

?>alert("Gagal Koneksi Database MySql

!!")


36/68

kedua mambuat halaman utama untuk forum

dengan nama forum.php

Forum

FORUM


37/68

?>


38/68


39/68

if ($jumlah){

?>

TOPIK

Replay

Posting


40/68

$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);

?>


41/68

Belum ada data!!


42/68

Jumlah Topik :

ketiga kita buat halaman untuk inputan datanya

kita namai forum-new.php


43/68

$nama=$_POST['nama'];

$email=$_POST['email'];

$topik=$_POST['topik'];

$isi=$_POST['isi'];

$tanggal;

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

{

echo " document.location.href='forum-new.php?status=Maaf, Data

Anda belum lengkap!!'; ";

}else{

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

values('$nama','$email','$topik','$isi','$tanggal')",$koneksi);

if($query)

{

echo " document.location.href='forum.php?status=Berhasil MembuatTopik Baru'; ";

}else{

echo " alert('Gagal Query!!'); ";


44/68

}

}

}else{

unset($_POST['nama']);

}

?>

Forum Ri32

New

Forum


45/68

Nama:

Email:


46/68

TOPIK:

Isi:


47/68

ke empat kita buat halaman selanjutnya

kita namai forum-reply.php


48/68

$topik=$_POST['topik'];

$isi=$_POST['isi'];

$ID_topik=$_POST['ID_topik'];

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

{

?>document.location.href='forum-

reply.php?ID_topik=&topik=&status=Maaf, Data Anda masih kosong!!'; ";


49/68

}

}else{

unset($_POST['nama']);

}

?>

Forum Ri32

Reply

Forum


50/68

ID:

Nama:


51/68

Email:

Topik:


52/68


53/68

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

Forum Ri32

View

Forum


54/68


55/68

$isi=$row[4];

$ID_replay=$row[5];

$tanggal=$row[6];

}

//isi dari forum yang di tampilkan

echo ""."Topik : ".$topik.""."
";

?>By :


56/68


57/68


58/68

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];

?>

Re :

By :


59/68

echo "";

}

}else{

?>

Belum ada data!!


60/68


61/68

Download script lengkap dan database nya di Sini

overall dah jalan gan. namun masih ada eror 1 bagian yaitu paging di halamanview 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

Nofel_Apensays:

5 November 2012 20.33 Reply

owh setelah saya liat2 agan salah ketik hehe, tadi di kodingan forum-view:


62/68

Code:

CREATE TABLE forum_posting (

postid bigint(20) NOT NULL auto_increment,

author varchar(255) NOT NULL default '',

title varchar(255) NOT NULL default '',

post mediumtext NOT NULL,

showtime varchar(255) NOT NULL default '',

realtime bigint(20) NOT NULL default '0',

lastposter varchar(255) NOT NULL default '',

numreplies bigint(20) NOT NULL default '0',

parentid bigint(20) NOT NULL default '0',

lastrepliedto bigint(20) NOT NULL default '0',

PRIMARY KEY (postid)

)


63/68

Lalu buat connect.php

Code:

$db = mysql_connect("localhost", "root", "cruzenaldo") ordie("Gak Bisa Koneksi.");

if(!$db)die("Gak Ada Databasenya");if(!mysql_select_db("forum",$db))die("Gak Ada Databasenya.");if(!get_magic_quotes_gpc()){$_GET = array_map('mysql_real_escape_string', $_GET);$_POST = array_map('mysql_real_escape_string', $_POST);$_COOKIE = array_map('mysql_real_escape_string', $_COOKIE);}else

{$_GET = array_map('stripslashes', $_GET);$_POST = array_map('stripslashes', $_POST);$_COOKIE = array_map('stripslashes', $_COOKIE);$_GET = array_map('mysql_real_escape_string', $_GET);$_POST = array_map('mysql_real_escape_string', $_POST);$_COOKIE = array_map('mysql_real_escape_string', $_COOKIE);}


64/68

?>

Ini file CSS-nya... Untuk memperbagus aja

Simpan dengan nama "Style.css"

Code:

Nah disini kita memerlukan 4 buah file yang akan kita gunakan untuk

menampilkan semua threads (index.php), File untuk melakukan posting

(post.php), untuk menampilkan pesan (message.php) dan untuk melakukan

reply (reply.php)

Pertama index.php

Code:

include "connect.php"; //untuk melakukan koneksi db

print "";

print "Topik Baru";

print "

Topik Nama Balasan Balasan Terakhir

$getthreads3[title] $getthreads3[author] $getthreads3[numreplies] $getthreads3[showtime]

Pesan Terakhir Dari

$getthreads3[lastposter]

";?>

Lalu message.php

Code:

include "connect.php"; //koneksi db$id=$_GET['id'];
http://www.jasakom.post.php/http://www.jasakom.message.php/?id=$getthreads3%5bpostid%5dhttp://www.jasakom.message.php/?id=$getthreads3%5bpostid%5dhttp://www.jasakom.post.php/


65/68

print "";

print "Kembali Ke Forum-Topik Baru-Balas";

print "

Author Post

$gettopic3[author] Last replied to at $gettopic3[showtime]

"; $message=strip_tags($gettopic3['post']); $message=nl2br($message); print

"$message

"; print "

$getreplies3[author] Last replied to at $getreplies3[showtime]

"; $message=strip_tags($getreplies3['post']); $message=nl2br($message); print

"$message

"; print "

";?>

Lalu post.php

Code:

include "connect.php";

print "";
http://www.jasakom.index.php/http://www.jasakom.post.php/http://www.jasakom.reply.php/?id=$idhttp://www.jasakom.reply.php/?id=$idhttp://www.jasakom.reply.php/?id=$idhttp://www.jasakom.reply.php/?id=$idhttp://www.jasakom.reply.php/?id=$idhttp://www.jasakom.reply.php/?id=$idhttp://www.jasakom.reply.php/?id=$idhttp://www.jasakom.post.php/http://www.jasakom.index.php/


66/68

print "

Posting Sebuah Pesan

"; if(isset($_POST['submit'])) { $name=$_POST['name']; $yourpost=$_POST['yourpost'];

$subject=$_POST['subject']; if(strlen($name)

reply.php

Code:include "connect.php";

print "";

print "

Balas

"; if(isset($_POST['submit'])) { $name=$_POST['name']; $yourpost=$_POST['yourpost'];$subject=$_POST['subject']; $id=$_POST['id']; if(strlen($name)


67/68

or die("Tidak Dapat Memasukkan Postingan"); $updatepost="Update forum_posting set

numreplies=numreplies+'1', lastposter='$name',showtime='$displaytime', lastrepliedto='$thedate'

where postid='$id'"; mysql_query($updatepost) or die("Tidak Dapat Mengupdate Postingan"); print

"Pesan Telah Berhasil, Kembali KeMessage."; } } else { $id=$_GET['id']; print " "; print ""; print "Nama: ";

print " "; print "Pesan: "; print " "; print ""; } print "

";?>

Letakkan semuanya di dalam satu folder dan jalankan... ...disini gunung dsana

gunung.. jangan bingung.. hikz
http://www.jasakom.message.php/?id=$idhttp://www.jasakom.message.php/?id=$idhttp://www.jasakom.message.php/?id=$idhttp://www.jasakom.message.php/?id=$id


68/68

membuat web forum dengan php dan

Documents