Bulletin board

Skull

well , I've done most of it, but its just the part where the threads are shown that i'm stuck on and really can't figure out, so if someone could help me out it would be great

I'll post the whole code so that you know what's what

Skull

anyone?

n00854180t

What specifically are you having problems with?

All you need to do to display threads and topics/posts it set it up like so:

Make some functions that take some stuff as arguements, such as the number of threads to show per page or something and the forum id. You can then grab these arguements from the URL via a $_GET['whatever'].

The functions should handle at least showing the threads, maybe more.

<?php
// Stuff here...
// DB connection and such

function ShowThreads($forumID, $numberPerPg)
{

// I assume you have some sort of HTML for this page
// continue it here


?>

<table><td>Thread</td</table>

<?php


for ($i = 0; $i<$row['id']; $i++)
{
    echo $row['threadname'];
}
}

?>

Note the above is an example, don't expect to copy>paste it.

Hope this helps!

Skull

		$SQL = "SELECT * FROM ".$_REQUEST['board']."_thread ".$pinned." ORDER BY -threadid LIMIT ".$page*$displaytotal.",$displaytotal";
		$result = mysql_query($SQL) or die(mysql_error());
		while($row = mysql_fetch_array($result))
			{
						$SQL2 = "SELECT * FROM ".$_REQUEST['board']."_post ".$pinned." WHERE threadid='".$row['threadid']."'";
						$result2 = mysql_query($SQL2) or die(mysql_error());
						while($row2 = mysql_fetch_array($result2))
							{

?>
				  <ul>
					<li> 
<?
					  if($p == "y")
						  {
							  echo "<strong>PINNED:</strong>";
						  }
?>
					  <a href="<?=$_SERVER['PHP_SELF']?>?c=read&id=<?=$row2["id"]?>&thread=<?=$row['threadid']?>&name=<?=$_REQUEST['name']?>&board=<?=$_REQUEST['board']?>"> 
						<?=$row["subject"]?>
					  </a>
					  by 
					  <em> 
						  <?=$row["name"]?>
					  </em> - 
					  <?=$row["date"]?>

				</li>
<?
						$SQL3 = "SELECT * FROM ".$_REQUEST['board']."_post ".$pinned." WHERE threadid='".$row['threadid']."' AND id!='".$row2['id']."' ORDER BY -id";
						$result3 = mysql_query($SQL3) or die(mysql_error());
						while($row3 = mysql_fetch_array($result3))
							{
						if($row3['id'] !== $row2['id']){
						echo $row3['id'];echo $row2['id'];
							echo "<li>";
?>
					  <a href="<?=$_SERVER['PHP_SELF']?>?c=read&id=<?=$row2["id"]?>&thread=<?=$row['threadid']?>&name=<?=$_REQUEST['name']?>&board=<?=$_REQUEST['board']?>"> 
						<?=$row["subject"]?>
					  </a>
					  by 
					  <em> 
						  <?=$row["name"]?>
					  </em> - 
					  <?=$row["date"]?>
<?
							echo "</li>";
					 		}
							}	
?>
				  </ul>
<?
			  $count++;
			}
			}

thats the part that i'm having problems with, I can't get it to show the threads, it just all mucks up

parawizard

i have finished my own forum and the basic way would be

1)pull out posts numbers into an array.
2)count posts array pieces to get end for loop .
3)output in while loop using how many posts there are from the 4)count as the end of the loop.
5)make a counter variable to end loop when all posts have been outputed

while($counter!=$postcount)

6)query info for post by using counter and the posts array

$posts[counter];

7)output info into row in table
8)up the counter by 1

$counter++

9) end the while loop and end the html with table end tags and body/html end tags

hope that helps

🙂

Ryan_Sanders

I have made a forum of my own once. It wasn't nothing like this, but it was basic. I don't know if this is bad or good, but I have never used arrays.

planetsim

Im not saying you should do it now but if you plan to make a future version of this to have PHP and HTML seperated in different files. Makes it look a lot cleaner.

parawizard

Originally posted by planetsim
Im not saying you should do it now but if you plan to make a future version of this to have PHP and HTML seperated in different files. Makes it look a lot cleaner.

seperate can be a giant pain in the ass unless u have some sorta dynamic plugin to add stuff to the forum. id say to SOME extent. maybe not in the main loop file but maybe in smaller chunks that you load on every page such as button bar command bar, forum path, etc. once you have coded it a few times over you can start working a better dynamic structure and recode it all into smaller pieces that perform within a main loop or PHP file. im taking this brutal task of recoding my forum with the best dynamic structure i can think of so I can A) make it easily upgradable 😎 make it easier customizable by user (lessss hardcoding more dynamic choices) C) so I can add a plugin or addon to something without having to "fit it in" somewhere.