PHP Basic Tutorials ,PHP Sources Code,PHP Online Example

Algorithms Arrays Passwords Uncategorized
Commerce Uncategorized
Databases Abstraction Layers Informix LDAP MS SQL MySQL ODBC PostgreSQL Uncategorized
Date & Time Calculators Conversion Translation Uncategorized
Discussion Chat Forums Guestbooks Polls Uncategorized
Email Validation Uncategorized
External Uncategorized
Files and Directories Uncategorized
Games Uncategorized
Graphics 3-D Graphs Resizing Thumbnails Uncategorized
HTML Forms Menus & Navigation Source Viewers Tables Templates Uncategorized
HTTP Authentication Cookies File Uploading Uncategorized
I18N Uncategorized
Math Uncategorized
Miscellaneous Uncategorized
Searching and Trees Uncategorized
Security Uncategorized
Text Uncategorized
Utilities Calendars Counters Link Checkers Weather Uncategorized
XML Uncategorized

php sample source codes
Export Excel data from Mysql This is asimplest way. <? $con = mysql_connect("localhost" , "usename" , "password") or die ("Not Fouund" . mysql_error()); mysql_select_db("mydb") or die ("Not Fouund" . mysql_error()); $select = "SELECT * FROM Table_name"; $export = mysql_query($select); $fields = mysql_num_fields($export); $header = "" ; $data = ""; for ($i = 0; $i < $fields; $i++) { $header .= mysql_field_name($export, $i) . "\t"; } while($row = mysql_fetch_row($export)) { $line = ''; foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = "\t"; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . "\t"; } $line .= $value; } $data .= trim($line)."\n"; } $data = str_replace("\r","",$data); if ($data == "") { $data = "\n(0) Records Found!\n"; } header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=AjayExcel.xls"); header("Pragma: no-cache"); header("Expires: 0"); header("Lacation: excel.htm?id=yes"); print "$header\n$data"; ?>
FUDforum is PHP & MySQL forum with many customizable features. The forum supports both threaded & flat views, contains an integrated spell checker for messages, includes a private messaging system and many other features. From the admin side, FUDforum has a number of control panels allowing the administrators to easily administer the forum as well as change the settings. The layout of the forum is very flexible allowing for multiple layout and has easy CSS editor for quick layout modifications. /* A little to big to paste source, you can download tar ball here: http:/fud.prohost.org/download.php */
Not your average forum.. to say the least. Features include: <br><br>+ Delete, modify, and quote messages <br><br>+ + Thread/Forum status (based on # of posts/views) <br><br>+ + Dynamic styles (100% image-based) <br><br>+ + Huge administration core <br><br>+ + Mini administration panel (bottom of every page) <br><br>+ + Event logging <br><br>+ + User login/signup/profiles <br><br>+ + Photoshop Contests =] <? /* -------------------------------------- / / functions.php / / this is the core of the whole thing! / / james klatt '04 (http://phyr3xi4n.net) / / -------------------------------------- / // Logger function logger($who, $what, $from){ require ("settings.php"); if ($who == ''){ $who = "Anonymous"; } $when = $forum_datestamp . " (" . $forum_timestamp . ")"; $query00 = mysql_query("INSERT INTO `phorum_logger` (`logger_who`, `logger_what`, `logger_when`, `logger_from`)"."VALUES ('$who', '$what', '$when', '$from')"); } // Validate URL function validate($url){ $fp = @fopen($url,"r"); if ($fp){ fclose($fp); return true; } else{ return false; } } // Thanks to ZEND.COM, this could happen: function replacestring ($search,$replace,$subject){ $srchlen=strlen($search); while ($find = stristr($subject,$search)){ $srchtxt = substr($find,0,$srchlen); $subject = str_replace($srchtxt,$replace,$subject); } return $subject; } // R3X.C0D3 Parser function rc_parser ($junk, $what){ require ("settings.php"); require ("$settings_style/style.php"); // Gandolf fucked my sister if ($what != 'subject'){ // Check for an image $well = substr_count ($junk, '[img]'); if ($well != '0'){ // Get the URL of the image $junk = preg_replace("/\[img\]/", "[1]", $junk, 1); $junk = preg_replace("/\[\/img\]/", "[2]", $junk, 1); preg_match("/\[\d+](.)\[\d+]/", $junk, $matches); $img_url = $matches[1]; if (validate($img_url)){ // Get the dimensions of the image $img_dim = getimagesize($matches[1]); } // Reset [img] tags.. $junk = replacestring("[1]", "[img]", $junk); $junk = replacestring("[2]", "[/img]", $junk); } // Standard RC Parsing $junk = replacestring("[img]", "<img src='", $junk); if ($img_dim[0] > $max_imgwidth){ // Check if this is being quoted $quote_check = substr_count ($junk, '[quote]'); if ($quote_check != '0'){ $junk = replacestring("[/img]", "' width='500' alt='$img_url' border='0'>", $junk); } else{ $junk = replacestring("[/img]", "' width='$max_imgwidth' alt='$img_url' border='0'>", $junk); } } else{ $junk = replacestring("[/img]", "' alt='$img_url' border='0'>", $junk); } // RC Parse for a SCROLLING MARQUEE $junk = replacestring("[scroll, left]", "<marquee direction='left' scrollamount='5'>", $junk); $junk = replacestring("[scroll, right]", "<marquee direction='right'>", $junk); $junk = replacestring("[/scroll]", "</marquee>", $junk); // RC Parse for a BREAK $junk = replacestring("[br]", "<br>", $junk); // RC Parse for GLOWING TEXT $junk = replacestring("[glow(green)]", "<span style='width: 300; height: 1; filter: glow(color=#00FF00, strength=3)'>", $junk); $junk = replacestring("[/glow]", "</span>", $junk); $junk = replacestring("[glow(white)]", "<span style='width: 300; height: 1; filter: glow(color=#FFFFFF, strength=3)'>", $junk); $junk = replacestring("[/glow]", "</span>", $junk); $junk = replacestring("[glow(blue)]", "<span style='width: 300; height: 1; filter: glow(color=#0000FF, strength=3)'>", $junk); $junk = replacestring("[/glow]", "</span>", $junk); $junk = replacestring("[glow(red)]", "<span style='width: 300; height: 1; filter: glow(color=#FF0000, strength=3)'>", $junk); $junk = replacestring("[/glow]", "</span>", $junk); $junk = replacestring("[glow(black)]", "<span style='width: 300; height: 1; filter: glow(color=#000000, strength=3)'>", $junk); $junk = replacestring("[/glow]", "</span>", $junk); $junk = replacestring("[glow(pink)]", "<span style='width: 300; height: 1; filter: glow(color=#FF9999, strength=3)'>", $junk); $junk = replacestring("[/glow]", "</span>", $junk); $junk = replacestring("[glow(yellow)]", "<span style='width: 300; height: 1; filter: glow(color=#FFFF00, strength=3)'>", $junk); $junk = replacestring("[/glow]", "</span>", $junk); // RC Parse for ALIGNMENT $junk = replacestring("[align=", "<div align='", $junk); $junk = replacestring("[/align]", "</div>", $junk); // RC Parse for TEXT SIZE $junk = replacestring("[size=", "<font size='", $junk); $junk = replacestring("[/size]", "</font>", $junk); // RC Parse for QUOTING $junk = replacestring("[quote]", "<table width='100%' height='1' cellspacing='0' cellpadding='$quote_margin' border='0'><tr width='100%' height='1'><td width='100%' height='1'><table width='100%' height='1' cellspacing='0' cellpadding='0' border='0' align='center' bgcolor='$quote_border'><tr width='100%' height='1'><td width='1' height='1'></td><td width='' height='1'></td><td width='1' height='1'></td></tr><tr width='100%' height='1'><td width='1' height='1'></td><td width='' height='1'><table width='100%' height='100%' cellspacing='0' cellpadding='2' border='0' bgcolor='$quote_bgcolor'><tr><td>", $junk); $junk = replacestring("[/quote]", "</td></tr></table></td><td width='1' height='1'></td></tr><tr width='100%' height='1'><td width='1' height='1'></td><td width='' height='1'></td><td width='1' height='1'></td></tr></table></td></tr></table>", $junk); // RC Parse for LINKING $junk = replacestring("[url=", "<a href='", $junk); $junk = replacestring("[/url]", "</a>", $junk); // RC Parse for LINE BREAKS $junk = replacestring("\n", "<br>", $junk); } // RC Parse for BOLD, ITALIC, UNDERLINE, STRIKE, FONT COLOR, and FONT FACE $junk = replacestring("[b]", "<b>", $junk); $junk = replacestring("[/b]", "</b>", $junk); $junk = replacestring("[i]", "<i>", $junk); $junk = replacestring("[/i]", "</i>", $junk); $junk = replacestring("[u]", "<u>", $junk); $junk = replacestring("[/u]", "</u>", $junk); $junk = replacestring("[s]", "<strike>", $junk); $junk = replacestring("[/s]", "</strike>", $junk); $junk = replacestring("[color=", "<font color='", $junk); $junk = replacestring("[/color]", "</font>", $junk); $junk = replacestring("[font=", "<font face='", $junk); $junk = replacestring("[/font]", "</font>", $junk); // RC Parse for INDENTS $junk = replacestring("[indent]", "   ", $junk); // Then he fucked my mother if ($what != 'subject'){ $junk = replacestring("]", "' target='_blank' class='replies'>", $junk); // Word Filter if ($usefilter == '1'){ $query12 = mysql_query("SELECT FROM `phorum_filter`"); while ($array12 = mysql_fetch_array($query12)){ $junk = replacestring("{$array12['badword']}",$filter_beg . "{$array12['goodword']}" . $filter_end, $junk); } } } return $junk; } // Baleet Post function baleet ($postnum){ // Get information for `$postnum` $query00 = mysql_query("SELECT * FROM `phorum_replies` WHERE `id`='$postnum'"); $array00 = mysql_fetch_array($query00); // Physically delete the post $query01 = mysql_query("DELETE FROM `phorum_replies` WHERE `id`='$postnum'"); // Find the most recent postee $query02 = mysql_query("SELECT * FROM `phorum_replies` WHERE `t_pimp`='{$array00['t_pimp']}' ORDER BY `id` DESC"); $array02 = mysql_fetch_array($query02); // Apply that name to `phorum_threads` container $query03 = mysql_query("UPDATE `phorum_threads` SET `server_datestamp`='{$array02['server_datestamp']}' WHERE `id`='{$array00['t_pimp']}'"); } // Conjure a New Forum function newforum ($title, $desc, $mods){ $query01 = mysql_query("INSERT INTO `phorum_forums` (title, description, mods, type_current, type_backup)". "VALUES ('$title', '$desc', '$mods', 'open', 'open')"); } // Conjure a New Thread function newthread ($f_pimp, $title, $type_base, $type_current, $server_datestamp){ $query01 = mysql_query("INSERT INTO `phorum_threads` (f_pimp, title, type_base, type_current, server_datestamp)". "VALUES ('$f_pimp', '$title', '$type_base', '$type_current', '$server_datestamp')"); } // Post Reply function postreply ($f_pimp, $t_pimp, $post_author, $post_subject, $post_date, $post_time, $post_message, $server_datestamp){ if (isset($_SESSION['username'])){ $WHOpost_author = $_SESSION['username']; } else{ $WHOpost_author = "Guest"; } $query01 = mysql_query("INSERT INTO `phorum_replies` (f_pimp, t_pimp, post_author, post_subject, post_date, post_time, post_message, server_datestamp)". "VALUES ('$f_pimp', '$t_pimp', '$WHOpost_author', '$post_subject', '$post_date', '$post_time', '$post_message', '$server_datestamp')"); // Update the threads server time (helps with sorting) $query01 = mysql_query("UPDATE `phorum_threads` SET `server_datestamp`='$server_datestamp' WHERE `id`='$t_pimp'"); } // Modify Post function modify ($postnum, $newmessage, $newsubject){ require ("settings.php"); // Template to display $lastedit = "Last edited by: {$_SESSION['username']} on $forum_datestamp ($forum_timestamp)"; $query00 = mysql_query("UPDATE `phorum_replies` SET `post_message`='$newmessage', `lastedit`='$lastedit', `post_subject`='$newsubject' WHERE `id`='$postnum'"); } // Redirection function redirect ($url, $time, $pause){ print ('<script> var redirecturl="' . $url . '" var pausefor=' . $time . ' function postaction(){ if (window.timer){ clearInterval(timer) clearInterval(timer_2) } window.location=redirecturl } setTimeout("postaction()",pausefor' . $pause . ') </script>'); } // View Counter function viewcounter ($level, $t_id){ // Add 1 (one) view to the counter if user isn't an Admin if ($level != 'Admin'){ $query00 = mysql_query("SELECT FROM `phorum_threads` WHERE `id`='$t_id'"); $array00 = mysql_fetch_array($query00); $math = $array00['views'] + 1; $query01 = mysql_query("UPDATE `phorum_threads` SET `views`='$math' WHERE `id`='$t_id'"); } } // Laspost function lastpost ($lastpost_who, $lastpost_time, $lastpost_date){ if ($lastpost_who == '' oR $lastpost_time == '' OR $lastpost_date == ''){ print ('n/a'); } else{ if ($lastpost_who == 'Guest'){ print ('Guest<br>' . $lastpost_date . ' (' . $lastpost_time . ')'); } else{ // Get information on this user $query00 = mysql_query("SELECT * FROM `phorum_users` WHERE `username`='$lastpost_who'"); $array00 = mysql_fetch_array($query00); print ('<a href="index.php?page=viewprofile&u_id=' . $array00['id'] . '" class="forums">' . $lastpost_who . '</a><br>' . $lastpost_date . ' (' . $lastpost_time . ')'); } } } // Forum/Thread Status function status (){ if (!isset($_GET['page']) && !isset($_GET['f_id']) && !isset($_GET['t_id'])){ // Check if user is an Admin if ($_SESSION['level'] == 'Admin'){ print ('<a href="index.php?page=newforum" class="location">Start a new forum</a>'); } } elseif (isset($_GET['page']) && isset($_GET['f_id']) && !isset($_GET['t_id'])){ $query00 = mysql_query("SELECT * FROM `phorum_forums` WHERE `id`='{$_GET['f_id']}'"); $array00 = mysql_fetch_array($query00); // Check if the forum is locked or open if ($array00['type_current'] == 'locked'){ $status0 = "locked"; print ('This forum is locked!'); } elseif ($array00['type_current'] == 'open' AND $_GET['page'] != 'newthread'){ $status0 = "open"; print ('<a href="index.php?page=newthread&f_id=' . $_GET['f_id'] . '" class="location">Start a new thread</a>'); } } elseif (isset($_GET['page']) && isset($_GET['f_id']) && isset($_GET['t_id'])){ $query01 = mysql_query("SELECT * FROM `phorum_threads` WHERE `id`='{$_GET['t_id']}'"); $array01 = mysql_fetch_array($query01); if ($array01['type_current'] == 'locked'){ $status1 = "locked"; print ('This thread is locked!'); } elseif ($array01['type_current'] == 'open' AND $_GET['page'] != 'postreply' AND $_GET['page'] != 'modify' AND $_GET['page'] != 'baleet' AND $_GET['page'] != 'quote' AND $_GET['page'] != 'vote'){ $status1 = "open"; print ('<a href="index.php?page=postreply&f_id=' . $_GET['f_id'] . '&t_id=' . $_GET['t_id'] . '" class="location">Post a reply</a>'); } } } // Display Users Location function location (){ if (isset($_SESSION['username'])){ $query99 = mysql_query("SELECT * FROM `phorum_users` WHERE `username`='{$_SESSION['username']}'"); $array99 = mysql_fetch_array($query99); $username = "<a href=\"index.php?page=viewprofile&u_id=" . $array99['id'] . "\" class=\"location\">" . $_SESSION['username'] . "</a> "; } else{ $username = "Guest "; } // I don't quite remember doing this.. sigh if ($gayness == 'FiveBillion'){ } else{ if (!isset($_GET['page'])){ print ($username . 'Forum Index'); } else{ print ($username); if ($_GET['page'] == 'newforum'){ print ('<a href="index.php" class="location">Forum Index</a> Start a new forum'); } else{ // Retrieve all information for forums, threads, and replies if (isset($_GET['f_id'])){ $query00 = mysql_query("SELECT * FROM `phorum_forums` WHERE `id`='{$_GET['f_id']}'"); $array00 = mysql_fetch_array($query00); } if (isset($_GET['t_id'])){ $query01 = mysql_query("SELECT * FROM `phorum_threads` WHERE `id`='{$_GET['t_id']}'"); $array01 = mysql_fetch_array($query01); } if (isset($_GET['p_id'])){ $query02 = mysql_query("SELECT * FROM `phorum_replies` WHERE `id`='{$_GET['p_id']}'"); $array02 = mysql_fetch_array($query02); } // If the user is viewing a regular page (memberlist, register, etc) if (isset($_GET['page']) && !isset($_GET['f_id']) && !isset($_GET['t_id']) && !isset($_GET['p_id'])){ print ('<a href="index.php" class="location">Forum Index</a> '); if ($_GET['page'] == 'memberlist'){ print ('Member List'); } elseif ($_GET['page'] == 'viewprofile'){ print ('User Profile'); } elseif ($_GET['page'] == 'register'){ print ('Register'); } elseif ($_GET['page'] == 'editprofile'){ print ('Edit Profile'); } elseif ($_GET['page'] == 'administration'){ print ('Administration'); } } // If the user is viewing the threads in a forum if (isset($_GET['page']) && isset($_GET['f_id']) && !isset($_GET['t_id']) && !isset($_GET['p_id'])){ if ($_GET['page'] == 'newthread'){ print ('<a href="index.php" class="location">Forum Index</a> ' . '<a href="index.php?page=threads&f_id=' . $_GET['f_id'] . '" class="location">' . rc_parser($array00['title'], "subject") . '</a> Start a new thread'); } else{ print ('<a href="index.php" class="location">Forum Index</a> ' . rc_parser($array00['title'], "subject")); } } // If the user is viewing the replies in a thread if (isset($_GET['page']) && isset($_GET['f_id']) && isset($_GET['t_id']) && !isset($_GET['p_id'])){ if ($_GET['page'] == 'postreply'){ print ('<a href="index.php" class="location">Forum Index</a> <a href="index.php?page=threads&f_id=' . $_GET['f_id'] . '" class="location">' . rc_parser($array00['title'], "subject") . '</a> <a href="index.php?page=replies&f_id=' . $_GET['f_id'] . '&t_id=' . $_GET['t_id'] . '" class="location">' . rc_parser($array01['title'], "subject") . '</a> Post a reply'); } else{ print ('<a href="index.php" class="location">Forum Index</a> <a href="index.php?page=threads&f_id=' . $_GET['f_id'] . '" class="location">' . rc_parser($array00['title'], "subject") . '</a> ' . rc_parser($array01['title'], "subject")); } } // If the user is doing something to a post (baleet, modify, etc) if (isset($_GET['page']) && isset($_GET['f_id']) && isset($_GET['t_id']) && isset($_GET['p_id'])){ print ('<a href="index.php" class="location">Forum Index</a> <a href="index.php?page=threads&f_id=' . $_GET['f_id'] . '" class="location">' . rc_parser($array00['title'], "subject") . '</a> <a href="index.php?page=replies&f_id=' . $_GET['f_id'] . '&t_id=' . $_GET['t_id'] . '" class="location">' . rc_parser($array01['title'], "subject") . '</a> '); if ($_GET['page'] == 'vote'){ print ('Cast your vote'); } elseif ($_GET['page'] == 'baleet'){ print ('Baleet post'); } elseif ($_GET['page'] == 'modify'){ print ('Modify post'); } else{ print ('Quote post'); } } } } } } // Avatar Check function avatar_check ($u_id, $username){ require ("settings.php"); if ($username == 'Guest'){ if ($ava_guest == '1'){ print ('<img src="' . $settings_style . '/images/avatar_guest.gif" alt="Guest User">'); } else{ print (' '); } } else{ // Check if user exists $query00 = mysql_query("SELECT * FROM `phorum_users` WHERE `username`='$username'"); $nrows00 = mysql_num_rows($query00); if ($nrows00 != '0'){ $array00 = mysql_fetch_array($query00); // If the user is an Admin without an avatar if ($array00['level'] == 'Admin' && $array00['avatar'] == ''){ if ($ava_admin == '1'){ print ('<img src="' . $settings_style . '/images/avatar_admin.gif" alt="Administrator">'); } else{ print (' '); } } // If user is an Admin with an avatar elseif ($array00['level'] == 'Admin' && $array00['avatar'] != ''){ if (validate($array00['avatar'])){ // Get the dimensions of the image $img_dim = getimagesize($array00['avatar']); if ($img_dim[0] > $max_avawidth){ $resized_ava_width = $max_avawidth; } else{ $resized_ava_width = $img_dim[0]; } if ($img_dim[1] > $max_avaheight){ $resized_ava_height = $max_avaheight; } else{ $resized_ava_height = $img_dim[1]; } print ('<img src="' . $array00['avatar'] . '" width="' . $resized_ava_width . '" height="' . $resized_ava_height . '" alt="Custom Avatar">'); } } // If the user is a Regular User without an avatar elseif ($array00['level'] == 'User' && $array00['avatar'] == ''){ if ($ava_none == '1'){ print ('<img src="' . $settings_style . '/images/avatar_none.gif" alt="No Avatar!">'); } else{ print (' '); } } // If the user is a Regular User with an avatar elseif ($array00['level'] == 'User' && $array00['avatar'] != ''){ if (validate($array00['avatar'])){ // Get the dimensions of the image $img_dim = getimagesize($array00['avatar']); if ($img_dim[0] > $max_avawidth){ $resized_ava_width = $max_avawidth; } else{ $resized_ava_width = $img_dim[0]; } if ($img_dim[1] > $max_avaheight){ $resized_ava_height = $max_avaheight; } else{ $resized_ava_height = $img_dim[1]; } print ('<img src="' . $array00['avatar'] . '" width="' . $resized_ava_width . '" height="' . $resized_ava_height . '" alt="Custom Avatar">'); } } } else{ // The user must not exist! /gasp/ if ($ava_removed == '1'){ print ('<img src="' . $settings_style . '/images/avatar_removed.gif" alt="Non-existent User">'); } else{ print (' '); } } } } // Check Forum Type function forum_type_check ($type, $backup){ require ("settings.php"); if ($type == 'open'){ print ('<img src="' . $settings_style . '/images/forum_open.gif" alt="Open Forum">'); } elseif ($type == 'locked'){ print ('<img src="' . $settings_style . '/images/forum_locked.gif" alt="Locked Forum">'); } } // Check Thread Type function thread_type_check ($id, $base, $type, $backup, $stamp){ require ("settings.php"); // Get all information for this thread $query99 = mysql_query("SELECT * FROM `phorum_threads` WHERE `id`='$id'"); $array99 = mysql_fetch_array($query99); // If the thread is a PHOTOSHOP CONTEST if ($base == 'pscontest'){ $basepic = "pscontest"; $basealt = "Photoshop Contest"; // Check if the PS Contest has been 'offed (has ended) $query00 = mysql_query("SELECT * FROM `phorum_threads` WHERE `id`='$id'"); $array00 = mysql_fetch_array($query00); if ($array00['ps_status'] == 'offed'){ $offed = "yes"; } } // If the thread is IMPORTANT elseif ($base == 'important'){ $basepic = "important"; $basealt = "Important Thread"; } // If the thread is FUNNY elseif ($base == 'funny'){ $basepic = "funny"; $basealt = "Funny Thread"; } // If the thread is NORMAL elseif ($base == 'normal'){ $basepic = "normal"; $basealt = "Normal Thread"; } // If the thread isn't FINISHED if ($type == 'open'){ // Check if the thread is OLD if ($old_span_type == 'month'){ $chewwy = $old_span * 10000; } elseif ($old_span_type == 'day'){ $chewwy = $old_span * 100; } else{ $chewwy = 20 * 100; } $difference = $server_datestamp - $stamp; $query01 = mysql_query("SELECT * FROM `phorum_replies` WHERE `t_pimp`='$id'"); $nrows01 = mysql_num_rows($query01); if ($difference > $chewwy){ if ($nrows01 != '0'){ $alt = "Old"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_old.gif" alt="' . $basealt . ' (' . $alt . ')">'); } elseif ($offed == "yes"){ $alt = "Finished"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_offed.gif" alt="' . $basealt . ' (' . $alt . ')">'); } else{ $alt = "Zero Replies"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_open.gif" alt="' . $basealt . ' (' . $alt . ')">'); } } else{ // Check if the thread is HOTT (with TWO t's!) if ($hot_span_type == 'month'){ $bacca = $hot_span * 10000; } elseif ($hot_span_type == 'day'){ $bacca = $hot_span * 100; } else{ $bacca = 10 * 100; } $difference = $server_datestamp - $bacca; $query02 = mysql_query("SELECT * FROM `phorum_replies` WHERE `t_pimp`='$id' AND `server_datestamp`>'$notcool'"); $nrows02 = mysql_num_rows($query02); if ($nrows02 >= $hot_peek OR $array99['views'] >= $hot_views){ $alt = "Hot"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_hot.gif" alt="' . $basealt . ' (' . $alt . ')">'); } elseif ($offed == "yes"){ $alt = "Finished"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_offed.gif" alt="' . $basealt . ' (' . $alt . ')">'); } else{ $alt = "Open"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_open.gif" alt="' . $basealt . ' (' . $alt . ')">'); } } } elseif ($type == 'locked' AND $offed == "yes"){ $alt = "Locked & Finished"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_locked.gif" alt="' . $basealt . ' (' . $alt . ')">'); } elseif ($type == 'locked' AND $offed != "yes"){ $alt = "Locked"; print ('<img src="' . $settings_style . '/images/' . $basepic . '_locked.gif" alt="' . $basealt . ' (' . $alt . ')">'); } } // Check Moderators function forum_mod_check($string){ $string = explode("\|\|", $string); $howmany = count($string); // If there is only one moderator.. if ($howmany == '1'){ // Check if the ONLY moderator exists /sigh/ El Immigrante says, "Lonely, lonely moderator. You have no friends." $query03 = mysql_query("SELECT * FROM `phorum_users` WHERE `username`='{$string['0']}'"); $nrows03 = mysql_num_rows($query03); if ($nrows03 != '0'){ $array03 = mysql_fetch_array($query03); print ('<a href="index.php?page=viewprofile&u_id=' . $array03['id'] . '" class="forums">' . $string['0'] . '</a>'); } else{ if ($string[0] == ''){ print ('None'); } else{ print ($string[0]); } } } // If there is more than one moderator.. if ($howmany > '1'){ // Check if the first user exists.. $query00 = mysql_query("SELECT * FROM `phorum_users` WHERE `username`='{$string['0']}'"); $nrows00 = mysql_num_rows($query00); if ($nrows00 != '0'){ $array00 = mysql_fetch_array($query00); print ('<a href="index.php?page=viewprofile&u_id=' . $array00['id'] . '" class="forums">' . $string['0'] . '</a>'); } else{ print ($string[0]); } for ($i = 1; $i <= ($howmany - 1); $i++){ // Check if each additional user exists.. $query01 = mysql_query("SELECT * FROM `phorum_users` WHERE `username`='{$string[$i]}'"); $nrows01 = mysql_num_rows($query01); if ($nrows01 != '0'){ $array01 = mysql_fetch_array($query01); print (', <a href="index.php?page=viewprofile&u_id=' . $array01['id'] . '" class="forums">' . $string[$i] . '</a>'); } else{ print (', ' . $string[$i]); } } } } // In Japan they say, "and that concludes Lesson 2. In the first part of Lesson 3 [...], we'll start learning how to ask questions, and later get into some new, improved verbs. Cool." ?>
This program need only one single page to display and post the message, other features are : - Unlimited Threading, - HTML tag Parsing, - Database Admin, - Record Paging, - Highlight current message, - Upthreaded Link, Error Checking for Uncompletly Entry, and much more. <!-- *********************************************************************** --> <!-- [1] FILE NAME : diskusi_config.php, THIS IS CONFIGURATION FILE --> <!-- ********************************************************************* --> <?php // * DATABASE CONFIGURATION $db_serv="localhost"; $db_dbas="dbas"; $db_user="user"; $db_pass="pass"; $conn=mysql_connect($db_serv,$db_user,$db_pass) or die ("can't connect to server"); @mysql_select_db($db_dbas) or die ("can't select database"); ?> <style><!-- body { font-family: verdana; font-size: 8pt; color: #000000 } TD {font-family:verdana; font-size:8pt; color:#000000} a:link {color:#283AA0; text-decoration: none} a:active {color:#283AA0; text-decoration: none } a:visited {color:#283AA0; text-decoration: none } a:hover {color:#283AA0; text-decoration: underline } .ttl { font-family: Arial; font-size: 14pt; color: #FFFFFF; font-weight: bold; background-color: #808080 } .entri {background-color: #E9E8E8; font-family: verdana; font-size: 8pt; border: 1 inset #E9E8E8} .tombol {background-color: #C0C0C0; font-family: verdana; font-size: 8pt; color:#283AA0; font-weight: bold; border: 1 solid #808080; cursor:hand} --></style> <!-- YOU CAN DELETE THIS HTML BELOW, IT'S USE ONLY TO LINK THE FILE --> <table border=0 width=100% cellspacing=1 bgcolor=#000000><tr><td align=center bgcolor=#CCCCCC><b> [<a href="diskusi.php">Discussion Board</a>] &#149 [<a href="adm_diskusi.php">Admin</a>] </td></tr></table> <!-- *********************************************************************** --> <!-- [2] FILE NAME : diskusi.php, THIS IS FORUM - MAIN PAGE --> <!-- *********************************************************************** --> <?php include "diskusi_config.php"; ?> <p class=ttl> &#149 Discussion Board</p> <table border=0 width=100% cellspacing=10 cellpadding=0><tr><td> <?php $topic=@mysql_query("select * from diskusi_topic order by nama"); $ada=@mysql_num_rows($topic); if ($ada>0){ echo "<table border=0 cellspacing=4 cellpadding=0 width=100%>"; while ($r=@mysql_fetch_array($topic)){ echo "<tr><td><font style='font-size:14pt'>"; echo "<a href='diskusi_view.php?topic_id=".$r[id]."'>".$r[nama]."</a></font><br>"; echo nl2br($r[keterangan]); $jmlmsg=@mysql_num_rows(@mysql_query("select id from diskusi where topic='$r[id]'")); echo "<br>(Jumlah : ".number_format($jmlmsg)." messages)"; echo "<div align=right><a href='diskusi_view.php?topic_id=".$r[id]."'><b>[ENTER]</b></a></div>"; echo "</td></tr>"; echo "<tr><td background='images/line_hor.gif'><img src='images/line_hor.gif' border=0 width=4 height=1></td></tr>"; } echo "</table>"; } else { echo "<p>BELUM ADA TOPIC DISKUSI</p>"; } ?> </td></tr> </table> <!-- *********************************************************************** --> <!-- [3] FILE NAME : diskusi_view.php, THIS IS FORUM - FOR VIEWING & POSTING MESSAGE --> <!-- *********************************************************************** --> <?php include "diskusi_config.php"; ?> <p class=ttl> &#149 Discussion Board</p> <table border=0 width=100% cellspacing=10 cellpadding=0><tr><td> <script language="javascript"> <!-- function cek(form) { with (form) { if (msg_judul.value.length==0) { alert("Please fill Subject"); msg_judul.focus(); return false; } if (msg_message.value.length==0) { alert("Please fill your Message"); msg_message.focus(); return false; } if (msg_nama.value.length==0) { alert("Please fill your name"); msg_nama.focus(); return false; } if (msg_email.value.length==0) { alert("Please fill your email"); msg_email.focus(); return false; } } return; } //--> </script> <?php function anak($p_id,$jm,$tdcol){ global $topic_id; $rs2=@mysql_query("select * from diskusi where parent_id='$p_id' and topic='$topic_id'"); $ada=@mysql_num_rows($rs2); if ($ada>0){ $jm++; while ($r2=@mysql_fetch_array($rs2)){ $sp=""; for ($i=1;$i<=$jm-1;$i++){ $sp.="<img src='blank.gif' border=0 width=14 height=10>"; } echo "<tr>"; echo "<td bgcolor='".$tdcol."' valign=top>"; if ($jm<=6){ $bljm=$jm; } else { $bljm=($jm % 6); } echo "<table border=0 cellspacing=0 cellpadding=0><tr><td valign=top>"; echo $sp."<img src='bullet_".$bljm.".gif' border=0 width=10 height=10>"; echo "</td><td valign=top>"; echo "<b><a href='".$PHP_SELF."?message_id=".$r2[id]."&topic_id=".$topic_id."'>".$r2[judul]."</a>"; echo "</td></tr></table>"; echo "</td>"; echo "<td bgcolor='".$tdcol."' valign=top>".$r2[nama]."</td>"; echo "<td bgcolor='".$tdcol."' valign=top nowrap>".date('j M Y',$r2[tanggal])."</td>"; echo "</tr>"; anak($r2[id],$jm,$tdcol); } } } echo "<div><b><a href='diskusi.php'>TOPIC</a> <font style='font-size:12pt'> </font> "; $topic_name=@mysql_result(@mysql_query("select nama from diskusi_topic where id='$topic_id'"),0,0); $topic_name=strtoupper($topic_name); echo "<a href='diskusi_view.php?topic_id=".$topic_id."'>".$topic_name."</a></b></div>"; echo "<div align=right><b>[<a href='".$PHP_SELF."?reply_id=x&topic_id=".$topic_id."'>Post New Message</a>]</b></div><br>"; if ($msg_submit=="KIRIM"){ $now=time(); $qinsert="insert into diskusi (tanggal,judul,message,nama,email,parent_id,topic) "; $qinsert.="values ('$now','$msg_judul','$msg_message','$msg_nama','$msg_email','$msg_parent_id','$topic_id')"; @mysql_query($qinsert); $message_id=@mysql_result(@mysql_query("select id from diskusi where topic='$topic_id' order by id desc limit 0,1"),0,0); // * ADDING TO NEWSLETTER * // $sudahada=@mysql_num_rows(@mysql_query("select email from one_listener where email='$msg_email' and jenis_member='Newsletter'")); if ($sudahada==0){ @mysql_query("insert into one_listener (nama,email,jenis_member) values ('$msg_nama','$msg_email','Newsletter')"); } } if (!empty($reply_id)){ echo "<table width=100% border=0 cellspacing=1 cellpadding=10 bgcolor=#000000><tr><td bgcolor=#F7F7FF>"; echo "<form action='".$PHP_SELF."' method='post' onSubmit='return cek(this)'>"; echo "<br>Subject : "; if ($reply_id<>"x"){ $reply_subject=@mysql_result(@mysql_query("select judul from diskusi where id='$reply_id'"),0,0); $reply_subject="RE: ".$reply_subject; $reply_message=@mysql_result(@mysql_query("select message from diskusi where id='$reply_id'"),0,0); $reply_message=str_replace("\n","&gt",$reply_message); $reply_message="\n\n\n============================\n".$reply_message; echo "<input type='hidden' name='msg_parent_id' value='".$reply_id."'>"; } else { echo "<input type='hidden' name='msg_parent_id' value='0'>"; } echo "<input type='hidden' name='topic_id' value='".$topic_id."'>"; echo "<br><input name='msg_judul' size=50 class=entri value='".$reply_subject."'>"; echo "<br>Messages : "; echo "<br><textarea name='msg_message' rows=5 cols=50 class=entri>".$reply_message."</textarea>"; echo "<br>Name : "; echo "<br><input name='msg_nama' class=entri>"; echo "<br>Email : "; echo "<br><input name='msg_email' class=entri>"; echo "<br><br><input type='submit' name='msg_submit' class=tombol value='KIRIM'>"; echo "&nbsp<input type='reset' name='msg_reset' class=tombol value='RESET'>"; echo "</form>"; echo "</td></tr></table><br>"; } if (!empty($message_id)){ $msg_dtl=@mysql_query("select * from diskusi where id='$message_id' and topic='$topic_id'"); $adamsg=@mysql_num_rows($msg_dtl); if ($adamsg>0){ $id=@mysql_result($msg_dtl,0,"id"); $tanggal=@mysql_result($msg_dtl,0,"tanggal"); $judul=@mysql_result($msg_dtl,0,"judul"); $message=@mysql_result($msg_dtl,0,"message"); $nama=@mysql_result($msg_dtl,0,"nama"); $email=@mysql_result($msg_dtl,0,"email"); $parent_id=@mysql_result($msg_dtl,0,"parent_id"); echo "<table width=100% border=0 cellspacing=1 cellpadding=2 bgcolor=#000000><tr><td bgcolor=#F7F7FF>"; echo date('j M Y - H:i',$tanggal); echo "<br><b><a href='mailto:".$email."'>".$nama."</a></b>"; echo "<hr noshade size=1 color=#000000>"; echo "<u>".$judul."</u>"; echo "<br><br>".nl2br($message); echo "<hr noshade size=1 color=#000000>"; echo "<div align=right><b>"; if ($parent_id<>0){ echo "[<a href='".$PHP_SELF."?message_id=".$parent_id."&topic_id=".$topic_id."'>Up Thread</a>]&nbsp"; } echo "[<a href='".$PHP_SELF."?reply_id=".$id."&topic_id=".$topic_id."'>Reply This Message</a>]"; echo "</b></div>"; echo "</td></tr></table><br>"; } } // *** (start) PAGING if (empty($start)){ $start=0; } $recperpage=10; $totrec=@mysql_num_rows(@mysql_query("select id from diskusi where parent_id='0' and topic='$topic_id'")); if ($totrec>$recperpage){ $prev=$start-$recperpage; $next=$start+$recperpage; echo "<br><b>Page : </b>"; if (!$start==0){ echo "<a href='".$PHP_SELF."?start=".$prev."&topic_id=".$topic_id."' class=navart> </a>&nbsp"; } else { echo "<b> </b>&nbsp"; } echo "<b>"; for ($i=1; $i<=ceil($totrec/$recperpage);$i++){ if ((($start/$recperpage)+1)==$i){ echo "<font color=#FF0000><b>".$i."</b></font> "; } else { $startval=($i-1)$recperpage; echo "<a href='".$PHP_SELF."?start=".$startval."&topic_id=".$topic_id."' class=navart>".$i."</a> "; } } echo "</b>"; if ($start<($totrec-$recperpage)){ echo "<a href='".$PHP_SELF."?start=".$next."&topic_id=".$topic_id."' class=navart> </a>"; } else { echo "<b> </b>"; } echo "<br>"; } // (end) PAGING $rs=@mysql_query("select id,tanggal,judul,nama,email,parent_id from diskusi where parent_id='0' and topic='$topic_id' order by tanggal desc limit $start,$recperpage"); $ada=@mysql_num_rows($rs); if ($ada>0){ echo "<table width=100% border=0 cellspacing=1 cellpadding=2 bgcolor=#000000>"; echo "<tr>"; echo "<td bgcolor=#3996C6><font color=#FFFFFF><b>Subject</td>"; echo "<td bgcolor=#3996C6><font color=#FFFFFF><b>Sender</td>"; echo "<td bgcolor=#3996C6><font color=#FFFFFF><b>Postdate</td>"; echo "</tr>"; while ($r=@mysql_fetch_array($rs)){ $baris++; if (($baris % 2)==0){ $tdcol="#FFFFFF"; } else { $tdcol="#E7F3FF"; } echo "<tr>"; echo "<td bgcolor='".$tdcol."' valign=top><b><a href='".$PHP_SELF."?message_id=".$r[id]."&topic_id=".$topic_id."'>".$r[judul]."</a></td>"; echo "<td bgcolor='".$tdcol."' valign=top>".$r[nama]."</td>"; echo "<td bgcolor='".$tdcol."' valign=top>".date('j M Y',$r[tanggal])."</td>"; echo "</tr>"; anak($r[id],0,$tdcol); } echo "</table>"; } else { echo "<p>Messages Board untuk TOPIC : ".$topic_name." belum ada.</p>"; } ?> </td></tr> </table> <!-- ********************************************************************* --> <!-- [4] FILE NAME : adm_diskusi.php, THIS IS FORUM DATABASE ADMINISTRATION --> <!-- ********************************************************************* --> <?php include "diskusi_config.php"; echo "<p class=ttl> &#149 Admin Discussion Board</p>"; if (empty($topic_id)){ $topic_id="%%"; } echo "Pilih Topic : <select class='entri' onChange=\"window.location = this.options[this.selectedIndex].value\">"; echo "<option value='".$PHP_SELF."?topic_id=%%'"; if ($topic_id=="%%"){ echo " selected"; } echo ">- SEMUA TOPIC -</option>"; $rshow2=@mysql_query("select id,nama from diskusi_topic order by nama"); while($r=@mysql_fetch_array($rshow2)){ echo "<option value='".$PHP_SELF."?topic_id=".$r[id]."'"; if ($r[id]==$topic_id){ echo " selected"; } echo ">"; echo $r[nama]; echo "</option>"; } echo "</select>&nbsp<a href='adm_diskusi_topic.php'>[Modify Topic]</a><br>"; // * (start) PAGING if (empty($start)){ $start=0; } $recperpage=10; $totrec=@mysql_num_rows(@mysql_query("select id from diskusi where topic like '$topic_id'")); if ($totrec>$recperpage){ $prev=$start-$recperpage; $next=$start+$recperpage; echo "<b>Page : </b>"; if (!$start==0){ echo "<a href='".$PHP_SELF."?start=".$prev."&topic_id=".$topic_id."' class=navart> </a>&nbsp"; } else { echo "<b> </b>&nbsp"; } for ($i=1; $i<=ceil($totrec/$recperpage);$i++){ if ((($start/$recperpage)+1)==$i){ echo "<b>".$i."</b> "; } else { $startval=($i-1)$recperpage; echo "<a href='".$PHP_SELF."?start=".$startval."&topic_id=".$topic_id."' class=navart>".$i."</a> "; } } if ($start<($totrec-$recperpage)){ echo "<a href='".$PHP_SELF."?start=".$next."&topic_id=".$topic_id."' class=navart> </a>"; } else { echo "<b> </b>"; } } // (end) PAGING $t=@mysql_query("select id,tanggal,judul,nama,topic from diskusi where topic like '$topic_id' order by tanggal desc limit $start,$recperpage"); $ada=@mysql_num_rows($t); if ($ada>0){ echo "<table border=0 cellspacing=0 cellpadding=0 width=100%>"; while ($r=@mysql_fetch_array($t)){ echo "<tr><td colspan=4 background='line_hor.gif'><img src='line_hor.gif' border=0 width=4 height=1></td></tr>"; $topic_name=@mysql_result(@mysql_query("select nama from diskusi_topic where id='$r[topic]'"),0,0); echo "<tr><td>".$topic_name."</td>"; echo "<td>".date('j M Y - H:i',$r[tanggal])."</td>"; echo "<td>".$r[judul]."</td>"; echo "<td>".$r[nama]."</td>"; echo "<td><a href='adm_diskusi_mod.php?id=".$r[id]."'>Modify</a></td></tr>"; } echo "</table>"; } else { echo "<p>database is empty</p>"; } ?> <!-- ********************************************************************* --> <!-- [5] FILE NAME : adm_diskusi_mod.php, THIS IS FORUM DATABASE ADMINISTRATION FOR MODIFY MESSAGE RECORD --> <!-- *********************************************************************** --> <?php include "diskusi_config.php"; if ($btdelete=="DELETE"){ $qdelete.="delete from diskusi where id='$id'"; mysql_query($qdelete); } if ($btedit=="EDIT"){ $tanggal=mktime($jam,$mnt,0,$bln,$tgl,$thn); $qedit.="update diskusi set "; $qedit.="tanggal='$tanggal',"; $qedit.="judul='$judul',"; $qedit.="message='$message',"; $qedit.="nama='$nama',"; $qedit.="email='$email' "; $qedit.="where id='$id'"; mysql_query($qedit); } echo "<p class=ttl> &#149 Admin Discussion Board : MODIFY</p>"; if (!empty($id)){ $rsdtl=@mysql_query("select * from diskusi where id='$id'"); $ada=@mysql_num_rows($rsdtl); if ($ada>0){ // * (if exist) * // $id=@mysql_result($rsdtl,0,"id"); $tanggal=@mysql_result($rsdtl,0,"tanggal"); $judul=@mysql_result($rsdtl,0,"judul"); $message=@mysql_result($rsdtl,0,"message"); $nama=@mysql_result($rsdtl,0,"nama"); $email=@mysql_result($rsdtl,0,"email"); echo "<form action='".$PHP_SELF."' method='post'>"; echo "<table>"; echo "<tr><td align=right valign=top>Postdate : </td><td>"; echo "<select name='tgl' class=entri>"; for ($i=1;$i<=31;$i++){ echo "<option"; if ($i==date('j',$tanggal)){ echo " selected"; } echo ">".$i; echo "</option>"; } echo "</select>"; echo "<select name='bln' class=entri>"; $arrbln=array("","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); for ($i=1;$i<=12;$i++){ echo "<option value='".$i."'"; if ($i==date('n',$tanggal)){ echo " selected"; } echo ">".$arrbln[$i]; echo "</option>"; } echo "</select>"; echo "<select name='thn' class=entri>"; for ($i=1999;$i<=2010;$i++){ echo "<option"; if ($i==date('Y',$tanggal)){ echo " selected"; } echo ">".$i; echo "</option>"; } echo "</select> - "; echo "<select name='jam' class=entri>"; for ($i=0;$i<=23;$i++){ echo "<option"; if ($i==date('H',$tanggal)){ echo " selected"; } echo ">".sprintf("%02d",$i); echo "</option>"; } echo "</select>:"; echo "<select name='mnt' class=entri>"; for ($i=0;$i<=60;$i++){ echo "<option"; if ($i==date('i',$tanggal)){ echo " selected"; } echo ">".sprintf("%02d",$i); echo "</option>"; } echo "</select>"; echo "</td></tr>"; echo "<tr><td align=right valign=top>Subject : </td><td><input name='judul' size=40 value='".$judul."' class=entri></td></tr>"; echo "<tr><td align=right valign=top>Message : </td><td><textarea name='message' cols=40 rows=6 class=entri>".$message."</textarea></td></tr>"; echo "<tr><td align=right valign=top>Nama : </td><td><input name='nama' value='".$nama."' class=entri></td></tr>"; echo "<tr><td align=right valign=top>Email : </td><td><input name='email' value='".$email."' class=entri></td></tr>"; echo "<tr><td colspan=2 align=center bgcolor=#CCEDFF>"; echo "<input type='hidden' name='id' value='".$id."'>"; echo "<input type='submit' name='btedit' value='EDIT' class=tombol>"; echo " <input type='button' name='btdelete' value='DELETE' onclick='window.location = \"adm_diskusi_mod.php?btdelete=DELETE&id=".$id."\"' class=tombol>"; echo " <input type='button' name='btcancel' value='BACK' onclick='window.location = \"adm_diskusi.php\"' class=tombol>"; echo "</td></tr>"; echo "</table>"; echo "</form>"; if ($btedit=="EDIT"){ echo "<h2>One record has been updated!</h2>"; } } else { // * (if not exist = DELETED) * // echo "<h2>One Message Board deleted!</h2>"; echo "<input type='button' name='btcancel' value='BACK' onclick='window.location = \"adm_diskusi.php\"' class=tombol>"; } } else { echo "<p>Please select item to Modify!"; } if (!empty($error_teks)){ errormessage($error_teks); } ?> <!-- *********************************************************************** --> <!-- [6] FILE NAME : adm_diskusi_topic.php, THIS IS FORUM DATABASE ADMINISTRATION FOR : ADDING, EDITING & DELETING FORUM TOPICS --> <!-- *********************************************************************** --> <?php include "diskusi_config.php"; echo "<p class=ttl> &#149 Admin Discussion Board (Modify Topic)</p>"; $act_rsl=""; if ($btadd=="ADD"){ @mysql_query("INSERT INTO diskusi_topic (nama, keterangan) VALUES ('$fnama', '$fketerangan')"); $act_rsl="ONE TOPIC HAS BEEN ADDED"; } if ($btedit=="EDIT"){ @mysql_query("update diskusi_topic set nama='$fnama', keterangan='$fketerangan' where id='$topic_id'"); $act_rsl="ONE TOPIC HAS BEEN EDITED"; } if ($btdelete=="DELETE"){ @mysql_query("delete from diskusi_topic where id='$topic_id'"); @mysql_query("delete from diskusi where topic='$topic_id'"); $act_rsl="ONE TOPIC HAS BEEN DELETED, <br>AND ALL MESSAGES IN THIS TOPIC HAS BEEN DELETED TOO"; } echo "<p><a href='adm_diskusi.php'>Back to Admin Discussion Board</a>"; echo "  <a href='".$PHP_SELF."'>Add New Topic</a></p>"; $topic=@mysql_query("select * from diskusi_topic order by nama"); $ada=@mysql_num_rows($topic); if ($ada>0){ echo "<table border=0 cellspacing=4 cellpadding=0 width=100%>"; echo "<tr><td background='line_hor.gif'><img src='line_hor.gif' border=0 width=4 height=1></td></tr>"; while ($r=@mysql_fetch_array($topic)){ if ($topic_id==$r[id]){ echo "<form action='".$PHP_SELF."' method='post'>"; echo "<tr><td bgcolor=#CCEDFF>"; echo "Name:<br><input name='fnama' value='".$r[nama]."' size=40 class=entri><br>"; echo "Description:<br><textarea cols=40 rows=5 name='fketerangan' class=entri>".$r[keterangan]."</textarea><br>"; $jmlmsg=@mysql_num_rows(@mysql_query("select id from diskusi where topic='$r[id]'")); echo "(Total : ".number_format($jmlmsg)." messages)"; echo "</td></tr>"; echo "<tr><td align=center bgcolor=#CCEDFF>"; echo "<input type='hidden' name='topic_id' value='".$r[id]."'>"; echo "<input type='submit' name='btedit' value='EDIT' class=tombol>"; echo " <input type='submit' name='btdelete' value='DELETE' class=tombol>"; echo " <input type='button' name='btcancel' value='BACK' onclick='window.location = \"".$PHP_SELF."\"' class=tombol>"; echo "<br><font color=#FF0000><i><b>WARNING!!!</b><br>Deleting this topic<br>will delete all message in this topic</i></font>"; echo "</td></tr>"; echo "</form>"; echo "<tr><td background='line_hor.gif'><img src='line_hor.gif' border=0 width=4 height=1></td></tr>"; } else { echo "<tr><td>"; echo "<b>".$r[nama]."</b><br>"; echo nl2br($r[keterangan]); $jmlmsg=@mysql_num_rows(@mysql_query("select id from diskusi where topic='$r[id]'")); echo "<br>(Total : ".number_format($jmlmsg)." messages)"; echo "<div align=right><a href='".$PHP_SELF."?topic_id=".$r[id]."'><b>[MODIFY]</b></a></div>"; echo "</td></tr>"; echo "<tr><td background='line_hor.gif'><img src='line_hor.gif' border=0 width=4 height=1></td></tr>"; } } echo "</table>"; } if (empty($topic_id)){ echo "<b>ADD NEW TOPIC</b><br>"; echo "<table border=0 cellspacing=4 cellpadding=0 width=100%>"; echo "<form action='".$PHP_SELF."' method='post'>"; echo "<tr><td background='line_hor.gif'><img src='line_hor.gif' border=0 width=4 height=1></td></tr>"; echo "<tr><td bgcolor=#CCEDFF>"; echo "Name:<br><input name='fnama' size=40 class=entri><br>"; echo "Description:<br><textarea cols=40 rows=5 name='fketerangan' class=entri></textarea>"; echo "</td></tr>"; echo "<tr><td align=center bgcolor=#CCEDFF>"; echo "<input type='submit' name='btadd' value='ADD' class=tombol>"; echo " <input type='reset' name='btreset' value='RESET' class=tombol>"; echo "</td></tr>"; echo "</form>"; echo "<tr><td background='line_hor.gif'><img src='line_hor.gif' border=0 width=4 height=1></td></tr>"; echo "</table>"; } if (!empty($act_rsl)){ echo "<h3 align=center>".$act_rsl."</h3>"; } ?>
Simple message board working on MySQL database. It supports multiple levels, threads, search by topic or free text. SQL part is made up using PHPLib. Zip file includes a working example and images for toolbars. <? /****************************************************************************************** * TinyBoard 1.2 * * by Francesco Toscan, fathom@unixlover.com * * Included classes: PHPLib * * This code is released under GPL license * *****************************************************************************************/ $board_tbl_questions = "board_questions"; $board_tbl_answers = "board_answers"; function BoardToolsFull ($ID,$Depth,$FormerID) { global $PHP_SELF, $type; require("modules/board-toolsfull.html"); } function BoardToolsPartial () { global $PHP_SELF; require("modules/board-toolspartial.html"); } function BoardFooter () { require("modules/board-footer.html"); } / Let's simply list messages in questions table and check whether there are replies / function BoardIndex () { global $db, $PHP_SELF, $board_tbl_questions, $board_tbl_answers; $db->query("SELECT ID,Sender,Date,Topic,NumMsgs from $board_tbl_questions order by Date;"); $numrows = $db->num_rows(); if ($numrows != 0) { echo "<table width=\"100%\" border=\"0\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">"; echo "<tr><td>\n"; echo "<table width=\"100%\" border=\"0\" bgcolor=\"#e6e6e6\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">"; echo "<tr>\n"; echo "<th bgcolor=\"#333399\" width=\"60%\"><font size=\"-1\" color=\"#FFFFFF\">Topic</font>\n"; echo "</th>\n"; echo "<th bgcolor=\"#333399\" width=\"20%\"><font color=\"#FFFFFF\" size=\"-1\">Sender</font></th>\n"; echo "<th bgcolor=\"#333399\"><font color=\"#FFFFFF\" size=\"-1\">Date</font></th>\n"; echo "</tr>\n"; while ($db->next_record()) { $ID = $db->f(ID); $Sender = $db->f(Sender); $Date = $db->f(Date); $Topic = $db->f(Topic); echo "<tr>\n"; echo "<td width=\"60%\"><font size=\"-2\">\n"; if ($db->f(NumMsgs) > 0) { echo "<a href=\"$PHP_SELF?action=expand_thread&ID=$ID\"><img src=\"pics/plus.gif\" border=\"0\" valign=\"middle\"></a> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=question\">$Topic</a></font></td>\n"; } else { echo "<img src=\"pics/stateful.gif\" border=\"0\"> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=question\">$Topic</a></font></td>\n"; } echo "<td width=\"20%\" align=\"center\"><font size=\"-2\">$Sender</font></td>\n"; echo "<td align=\"center\"><font size=\"-2\">$Date</font></td>\n"; echo "</tr>\n"; } echo "</table>\n"; echo "</td></tr></table>\n"; } else { echo "No message found.\n"; } BoardFooter(); } / We want to add messages / function BoardAddNewMsg() { global $db, $CodSede, $Sender, $Text, $Topic, $PHP_SELF, $board_tbl_questions, $board_tbl_answers; / Let's make an unique ID for each message. / $ID = uniqid(rand(),true); $Date = date("Y/m/d"); / Check whether ID is really unique / $db->query("SELECT ID from $board_tbl_questions where ID=\"$ID\";"); $numrows = $db->num_rows(); if ($numrows != 0) { while ($numrows != 0) { $ID = uniqid(rand(),true); $numrows = $db->num_rows(); } } / Insert query / $query = "INSERT INTO $board_tbl_questions SET ID=\"$ID\",Sender=\"$CodSede\",Date=\"$Date\",Text=\"$Text\",Topic=\"$Topic\";"; if ($db->query($query)) { echo "<center>Message sent.<br>\n"; echo "<a href=\"$PHP_SELF\">Back</a></center>\n"; } else { echo "Problem has occurred while sending message. Send failed.\n"; } BoardFooter(); } / Expanding threads by question ID / function BoardThreadExpand($ID,$maxDepth) { global $db, $PHP_SELF, $board_tbl_questions, $board_tbl_answers; / First of all the former message / if ($maxDepth == 1) { $db->query("SELECT ID,Sender,Date,Topic from $board_tbl_questions where ID=\"$ID\";"); } else { $db->query("SELECT ID,Sender,Date,Topic from $board_tbl_answers where ID=\"$ID\";"); } $db->next_record(); $Sender = $db->f(Sender); $Date = $db->f(Date); $Topic = $db->f(Topic); echo "<table width=\"100%\" border=\"0\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">"; echo "<tr><td>\n"; echo "<table width=\"100%\" border=\"0\" bgcolor=\"#e6e6e6\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">"; echo "<tr>\n"; echo "<th bgcolor=\"#333399\" width=\"60%\"><font size=\"-1\" color=\"#FFFFFF\">Topic</font>\n"; echo "</th>\n"; echo "<th bgcolor=\"#333399\" width=\"20%\"><font color=\"#FFFFFF\" size=\"-1\">Sender</font></th>\n"; echo "<th bgcolor=\"#333399\"><font color=\"#FFFFFF\" size=\"-1\">Date</font></th>\n"; echo "</tr>\n"; echo "<tr>\n"; echo "<td width=\"60%\"><font size=\"-2\">\n"; echo "<a href=\"javascript: history.back(-1)\">"; echo "<img src=\"pics/minus.gif\" border=\"0\" valign=\"middle\"></a> "; if ($maxDepth == 1) { echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=question\">$Topic</a></font></td>\n"; } else { echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=answer\">$Topic</a></font></td>\n"; } echo "<td width=\"20%\" align=\"center\"><font size=\"-2\">$Sender</font></td>\n"; echo "<td align=\"center\"><font size=\"-2\">$Date</font></td>\n"; echo "</tr>\n"; / List all messages matching thread ID / $query = "SELECT ID,Sender,Date,Topic,Depth,NumMsgs from $board_tbl_answers where FormerID=\"$ID\" OR OrigID=\"$ID\";"; $db->query($query); $numMsgs = $db->num_rows(); while ($db->next_record()) { if ($db->f(Depth) == $maxDepth) { $ID = $db->f(ID); $Sender = $db->f(Sender); $Date = $db->f(Date); $Topic = $db->f(Topic); $Depth = $db->f(Depth); echo "<tr>\n"; echo "<td width=\"60%\"><font size=\"-2\">\n"; if ($db->f(NumMsgs) > 0) { $newDepth = $Depth +1; echo "<a href=\"$PHP_SELF?action=expand_thread&ID=$ID&maxDepth=$newDepth\"><img src=\"pics/plus.gif\" border=\"0\" valign=\"middle\"></a> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=answer\">$Topic</a></font></td>\n"; } else { echo "<img src=\"pics/node.gif\" border=\"0\"> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=answer\">$Topic</a></font></td>\n"; } echo "<td width=\"20%\" align=\"center\"><font size=\"-2\">$Sender</font></td>\n"; echo "<td align=\"center\"><font size=\"-2\">$Date</font></td>\n"; echo "</tr>\n"; } } echo "</table>\n"; echo "</td></tr></table>\n"; echo "<br>\n"; echo "<font size=\"-2\">Level <b>$maxDepth</b></font>\n"; BoardFooter(); } function BoardShowMsg ($ID,$type) { global $db, $PHP_SELF, $board_tbl_questions, $board_tbl_answers; if ($type == "question") { $query = "SELECT ID,Sender,Topic,Date,Text from $board_tbl_questions where ID=\"$ID\";"; } else { $query = "SELECT ID,Sender,Topic,Date,Text,FormerID,Depth from $board_tbl_answers where ID=\"$ID\";"; } $db->query($query); $numrows = $db->num_rows(); if ($numrows > 0) { $db->next_record(); $Sender = $db->f(Sender); $Topic = $db->f(Topic); $Date = $db->f(Date); $Text = $db->f(Text); $FormerID = $db->f(FormerID); $Depth = $db->f(Depth); BoardToolsFull($ID,$Depth,$FormerID); require("modules/board-show.html"); } else { echo "Message ID $ID not found.\n"; } BoardFooter(); } function BoardNewMsg () { require("modules/board-newmsg.html"); } function BoardAddReply ($ID) { global $PHP_SELF, $db, $type, $Depth, $Sender, $Text, $Topic, $FormerID, $board_tbl_questions, $board_tbl_answers; $newID = uniqid(rand(),true); $Date = date("Y/m/d"); if ($type == "question") { $query = "INSERT INTO $board_tbl_answers SET ID=\"$newID\",OrigID=\"$ID\",FormerID=\"$ID\",Depth=\"1\",Sender=\"$Sender\",Date=\"$Date\",Topic=\"$Topic\",Text=\"$Text\";"; $db->query($query); $update = "UPDATE $board_tbl_questions SET NumMsgs=NumMsgs +1 WHERE ID=\"$ID\";"; $db->query($update); echo "<center>Message sent.<br>\n"; echo "<a href=\"$PHP_SELF\">Back</a></center>\n"; } else { $Depth = $Depth +1; $query = "INSERT INTO $board_tbl_answers SET ID=\"$newID\",OrigID=\"$ID\",FormerID=\"$FormerID\",Depth=\"$Depth\",Sender=\"$Sender\",Date=\"$Date\",Topic=\"$Topic\",Text=\"$Text\";"; $db->query($query); $update = "UPDATE $board_tbl_answers SET NumMsgs=NumMsgs +1 WHERE ID=\"$ID\";"; $db->query($update); echo "<center>Message sent.<br>\n"; echo "<a href=\"$PHP_SELF\">Back</a></center>\n"; } BoardFooter(); } function BoardReplyMsg($ID) { global $PHP_SELF, $db, $FormerID, $Depth, $type, $CodSede, $board_tbl_questions, $board_tbl_answers; if ($type == "question") { $query = "SELECT Sender,Topic,Date,Text from $board_tbl_questions where ID=\"$ID\";"; } else { $query = "SELECT Sender,Topic,Date,Text from $board_tbl_answers where ID=\"$ID\";"; } $db->query($query); $numrows = $db->num_rows(); if ($numrows > 0) { $db->next_record(); $Sender = $db->f(Sender); $Topic = $db->f(Topic); $Date = $db->f(Date); $Text = $db->f(Text); } BoardToolsPartial(); require("modules/board-replymsg.html"); BoardFooter(); } function BoardPerformSearch ($what) { global $PHP_SELF, $db, $Topic, $Text, $board_tbl_questions, $board_tbl_answers; $found = 0; switch ($what) { case topic: $query = "SELECT ID,Sender,Topic,Date,NumMsgs from $board_tbl_questions WHERE Topic LIKE \"%$Topic%\";"; $db->query($query); echo "<h4>Search results</h4>\n"; BoardToolsPartial(); if ($db->num_rows() > 0) { $found++; echo "<table width=\"100%\" border=\"0\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">"; echo "<tr><td>\n"; echo "<table width=\"100%\" border=\"0\" bgcolor=\"#e6e6e6\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">"; echo "<tr>\n"; echo "<th bgcolor=\"#333399\" width=\"60%\"><font size=\"-1\" color=\"#FFFFFF\">Topic</font>\n"; echo "</th>\n"; echo "<th bgcolor=\"#333399\" width=\"20%\"><font color=\"#FFFFFF\" size=\"-1\">Sender</font></th>\n"; echo "<th bgcolor=\"#333399\"><font color=\"#FFFFFF\" size=\"-1\">Date</font></th>\n"; echo "</tr>\n"; while ($db->next_record()) { $ID = $db->f(ID); $Sender = $db->f(Sender); $Date = $db->f(Date); $Topic = $db->f(Topic); echo "<tr>\n"; echo "<td width=\"60%\"><font size=\"-2\">\n"; if ($db->f(NumMsgs) > 0) { echo "<a href=\"$PHP_SELF?action=expand_thread&ID=$ID\"><img src=\"pics/plus.gif\" border=\"0\" valign=\"middle\"></a> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=question\">$Topic</a></font></td>\n"; } else { echo "<img src=\"pics/stateful.gif\" border=\"0\"> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=question\">$Topic</a></font></td>\n"; } echo "<td width=\"20%\" align=\"center\"><font size=\"-2\">$Sender</font></td>\n"; echo "<td align=\"center\"><font size=\"-2\">$Date</font></td>\n"; echo "</tr>\n"; } echo "</table>\n"; echo "</td></tr></table>\n"; } else { echo "No message found.\n"; } break; case text: $query = "SELECT ID,Topic,Sender,Date,NumMsgs from $board_tbl_questions WHERE Text LIKE \"%$Text%\";"; $db->query($query); echo "<h4>Search results</h4>\n"; BoardToolsPartial(); echo "<table width=\"100%\" border=\"0\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">"; echo "<tr><td>\n"; echo "<table width=\"100%\" border=\"0\" bgcolor=\"#e6e6e6\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">"; echo "<tr>\n"; echo "<th bgcolor=\"#333399\" width=\"60%\"><font size=\"-1\" color=\"#FFFFFF\">Topic</font>\n"; echo "</th>\n"; echo "<th bgcolor=\"#333399\" width=\"20%\"><font color=\"#FFFFFF\" size=\"-1\">Sender</font></th>\n"; echo "<th bgcolor=\"#333399\"><font color=\"#FFFFFF\" size=\"-1\">Date</font></th>\n"; echo "</tr>\n"; if ($db->num_rows() > 0) { $found++; while ($db->next_record()) { $ID = $db->f(ID); $Sender = $db->f(Sender); $Date = $db->f(Date); $Topic = $db->f(Topic); echo "<tr>\n"; echo "<td width=\"60%\"><font size=\"-2\">\n"; echo "<img src=\"pics/stateful.gif\" border=\"0\"> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=question\">$Topic</a></font></td>\n"; echo "<td width=\"20%\" align=\"center\"><font size=\"-2\">$Sender</font></td>\n"; echo "<td align=\"center\"><font size=\"-2\">$Date</font></td>\n"; echo "</tr>\n"; } echo "</table>\n"; echo "</td></tr></table>\n"; } $query = "SELECT ID,Topic,Sender,Date,Depth,NumMsgs from $board_tbl_answers WHERE Text LIKE \"%$Text%\";"; $db->query($query); if ($db->num_rows() > 0) { $found++; while ($db->next_record()) { $ID = $db->f(ID); $Sender = $db->f(Sender); $Date = $db->f(Date); $Topic = $db->f(Topic); $Depth = $db->f(Depth); echo "<tr>\n"; echo "<td width=\"60%\"><font size=\"-2\">\n"; echo "<img src=\"pics/stateful.gif\" border=\"0\"> "; echo "<a href=\"$PHP_SELF?action=show_msg&ID=$ID&type=answer\">$Topic</a></font></td>\n"; echo "<td width=\"20%\" align=\"center\"><font size=\"-2\">$Sender</font></td>\n"; echo "<td align=\"center\"><font size=\"-2\">$Date</font></td>\n"; echo "</tr>\n"; } echo "</table>\n"; / if ($found == "0") { echo "<table width=\"100%\" border=\"0\" bgcolor=\"#e6e6e6\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">"; echo "<tr><td align=\"center\">No message found</td></tr></table>\n"; } / echo "</td></tr></table>\n"; } break; default: echo "Missing search key.\n"; break; } BoardFooter(); } function BoardSearchMsg() { global $PHP_SELF, $board_tbl_questions, $board_tbl_answers; require("modules/board-searchmsg.html"); BoardFooter(); } / Use at your own risk :)) */ ?>

php.ComLanka.com PHP Tutorial ,PHP source code, PHP online example