PHP - Customizable Responsive Forum Php Mysql

Okay I am making a forum and it is almost finished. The only thing is, I am stuck on how to get the most updated topics to appear at the top of the list. Like on every forum there is a new forum post that you havent visited yet. They are at the top of the list. How would I do that???

Hello all,                I am working on my own PHP project where I can build myself my own forum just like how this site functions. I would like to have user accounts and when you log in have a list of bulletin topics that you can choose from and then post your own question or topic and then other users can go to your post and write answers to it. I know there are many forums out there that you can make and set up to use but I would like to have my own so I can customize it any way I want. Could I get some ideas on where I should start with this. I have been working on a website with a login functionality and I almost have that set up, then my next steps will be making it so users will be able to post topics. I been doing google research trying to get some tutorials on this but I haven’t found one that is much help. I will be using phpmyadmin database and I plan on writing my sql as mysqli. Thank you.

Hi,
I am implementing a forum in php and mysql. I want to close forum questions / posts automatically after four days of posting. How to implement this ? Please help me.

Thanks in advance.

Hello! I can't manage to get my forum to work. When I want a new topic to be made I got some code I will show in a second. But I just keep getting my own error message that just shows me something is wrong ... please help me figure it out.

here is my code which is supposed to return all forums from the database and then display them in their respective categories. however it only shows one of the forums and not all of them. Anyone know why?

function display_forum_list($crumbs)
{
    global $link, $template, $settings, $lang, $config, $user;
    
    $template->replace(
    array(
          '{CRUMBS}' => display_crumbs($crumbs)
    ), 'index_page');
    
    $query = $link->query("SELECT * FROM ".TBL_PREFIX."forums
                        ORDER BY f_lid ASC");
    $result = $query->fetchAll();            
    foreach($result as $key => $val)
    {
        if($result[$key]['f_pid'] == 0)
        {
            $cat_name = $result[$key]['f_name'];
        }
        else
        {
            $forum_name = $result[$key]['f_name'];
        }
        $forum_desc = $result[$key]['f_description'];
    }
    
    
    $template->replace(
        array(
          '{CATEGORY}' => $cat_name,
          '{F_ICON}' => '',
          '{F_NAME}' => $forum_name,
          '{F_DESC}' => $forum_desc,
          '{SITE_ROOT}' => $config['asf_root']
        ), 'forum_list');
}

Just a general question, but could someone help me and tell me how to allow the user to enter a <br> without actually typing it.
Like when they're typing in the forums, I want it to automatically go on a new line when they hit the ENTER key.
Or could someone lead me to a guide? I tried searching everywhere and just can't seem to find it.

Hey so I've been designing a custom forum script and I need help. I'm trying to create a breadcrumb that takes into account page title. My pages have an id, so for example: threadlist.php?id=1, viewthread.php?id=3 and so on. I used a tutorial to get started.This is what I have so far.

This portion is in header.php to get session:

$url =BASE_URL;
$_SESSION['history'][$title] = $url;
while(count($_SESSION['history']) > 4) array_shift($_SESSION['history']);

breadcrumbs.php
 

<div class="container pagination">
    <nav aria-label="breadcrumb">
        <ol class="breadcrumb">
            <?php
            foreach($_SESSION['history'] as $title => $url) {
                echo "<li class='breadcrumb-item'><a href=". $url .">". $title ."</a></li>";
            }

                ?>

        </ol>
    </nav>
</div>

It works decently well. Only problem is, when I go back to the homepage, or backwards, it doesn't remove the breadcrumb. Also, I can't click on the breadcrumb because the url isn't set up right. I know I have it set to BASE_URL buts that's only cause I can't figure out how to grab the url which would be different for every section of the site I'm on. 

we have a hacker on my forum using -1424 values as inputs

how do i block and make sure the input is not anything negative?

Hello! My problem is that in my forum I want to display the picutre of their user and if they do not have a picture I want to show the standard one. I got all of this working on another part of the page but for some reason I can only get it to display the standard picture and not their custom picture... The code looks like this:

Code: [Select]
<?php 
// Now query any responses out of the database and place in a dynamic list
$sqll = mysql_query("SELECT id FROM myMembers");
while($row = mysql_fetch_array($sqll)){

$id = $row["id"];

$check_pic = "..//members/$id/image01.jpg";
$default_pic = "..//members/0/image01.jpg";
if (file_exists($check_pic)) {
    $user_pic = "<img src=\"$check_pic\" align=\"left\" width=\"80px\" border=\"0\" />"; // forces picture to be 120px wide and no more
} else {
$user_pic = "<img src=\"$default_pic\" align=\"left\" width=\"80px\"  border=\"0\" />"; // forces default picture to be 120px wide and no more
}
}

$all_responses = "";
$sql = mysql_query("SELECT * FROM forum_posts WHERE otid='$thread_id' AND type='b'");
$numRows = mysql_num_rows($sql);
if ($numRows < 1) {
$all_responses = '<div id="none_yet_div">No respond has been posted yet.</div>';
} else {
    while($row = mysql_fetch_array($sql)){
$reply_author = $row["post_author"];
$reply_author_id = $row["post_author_id"];
$date_n_time = $row["date_time"];
$convertedTime = ($myAgoObject -> convert_datetime($date_n_time));
    $whenReply = ($myAgoObject -> makeAgo($convertedTime));
$reply_body = $row["post_body"];
$all_responses .= '<div class="response_top_div">  ' . $thread_title . ' &nbsp; &nbsp; | &nbsp; &nbsp; ' . $whenReply . ' 
<a href="../profile.php?id=' . $reply_author_id . '">' . $reply_author . '</a> said:</div>
<div class="response_div" style="padding-left:20px; vertical-align:text-top;">' . $user_pic . ' <div style="padding-left:117px;"> ' . $reply_body . '</div></div>';
   }
}

?>
Please help me if you can! Thank you!

Hey! So, I don't know if this is the current section, couldn't really decide on what section/board to post it, so ..    I've got a code that I got from a friend of mine (it was a gaming website (a game server), but he shut it down, I asked for some scripts, he sent me the whole site ..). I got all other scripts correctly, but I do not know how to get this Last Forum Posts to work (IP.Board). I've got the SEO set up as it should and everything, doesn't work.   When I use this

<?php
	$_handlerForum = new mysql("Forum","localhost","*********_fqipb2","*********_fqipb2","password");
	
	$topics = $_handlerForum->fetch("SELECT `tid`,`title`,`last_post`,`title_seo`,`last_poster_name` FROM `topics` ORDER BY `last_post` DESC LIMIT 0,3;",array());

	$content = "";

	foreach($topics as $topic) {
		$content .= "<a href='http://website.com/forum/index.php?/topic/".$topic['tid']."-".$topic['title_seo']."' target='_blank'>".$topic['title']."</a><br />
			<small class='dim'>".$topic['last_poster_name']." - ".date("H:i F d, Y",$topic['last_post'])."</small><hr style='margin: 5px 0px;' />";
	}
	
	return $content;
	
	return "Under Construction";
?>

I get this error

Fatal error: Class 'mysql' not found in /home/***/***/***/public_html/extra/forum.php on line 2

Thought that the problem was "new mysql" (on line 2), so I put in mysql_connect, still get an error. Can anyone help?

Lets say I have a simple table for Categories;
fid forum desc cat 1 General Forum desc here 1 2 Help Forum desc here 2 3 Console Forum desc here 3


Hello! I think I need some creative juice to start my flow and am thankful for any suggestions.

I am looking into some advice on how to code in "Category" wise.

Lets say if I have forums like this;

General Forum
Quote

General
Talk about anything in general to NewbWorld.

Suggestions
Have any ideas to give to NewbWorld?

Anything Goes
Talk about anything you want!


Help Forum Quote


HTML Help
If you are having problems with HTML coding post here!

PHP Help
If you are having problems with PHP coding post here!


Instead of me manually coding each Category (General Forum, Help Forum, Console Forum, etc)... I want to be able to have the following coded like so;

List Category
---Forum Sub Category
---Forum Sub Category
---Forum Sub Category

List Category 2
---Forum Sub Category
---Forum Sub Category
---Forum Sub Category

Right now; I've been coding the "List Category" manually to show "Sub Forums". I would like to know how to do this without manual anymore. I would love to start coding an admin/moderator panel soon.

Any help is much appreciated and thankyou for your time!

Hello im using mybb forum, and i have another webpage what i want to access with forum username and password. Dont know how to make it work.    

Whats is the best way to create a forum using php?
Should I use any frameworks?
If not is there any guide/tutorial/book that descibe this procedure?
Thank you.

Site Name: Forum Pioneer
Link to site: http://forumpioneer.com/  (Down Currently)
Positions Available:

2 Admin
Super and Normal Moderators
phpBB Support Team
MyBB Support Team
IPB Support Team
vBulletin Support Team
XenForo Support Team

Forum Pioneer is a resource site and webmasters central for forum software. I intend for it to be a collection of the best and the most useful modifications that forum owners need. Pm me for more info. We are currently on phpBB, but I intend to migrate to IPB when the forum gets bigger.