[Resolved] Forum View and Thread View

AndrewWest

Hello,

I'm currently writing a forum for own personal satisfaction (Not for commercial or free use to anyone else or on a public server) and I have a modulization system that seperate templates from .php and so I just call a template particle with an include..

So any ways.. I do not plan to use categories, but just forum listing and thread listing..

Ok now, I need help working with how to get them to call all of them uniquely opposed to me having to call each one by coding it in the html..

I would think that it would need to use the foreach() or something like that, but I'm not sure..

Basically here's what I 'll need

For Forum indexing

for each database listing in the forums column I need to include the forum_listing_individual.html theme...

For thread listing

I'll need for each thread listing the thread database to include the thread_listing_individual.html

Basically I need to know how to call a database row foreach one. opposed to listing all or just a certain number.

jordy

urrrrm maybe you should read some stuff about php and mysql databases..

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
// statements
}

more info:
http://nl.php.net/mysql

AndrewWest

I know plenty about PHP, I've just never worked with generating multiple rows with one command opposed to two.

(Search around on the boards, you'll see I know a little bit)

Now, a question..

How does the code you give me allow me to use one piece of html code for multiple rows? That's my hard time understanding.

I'm hoping someone who's developed a templated system or a forum before can help me.

jordy

okay okay i get it.. my bad..

you have a template with certain tags in it and those need to be replaced by values?!

this is the way i do it.. i have a template with html comment in it..

the array with values:

$TEMPLATE[title] = "mytitle";
$TEMPLATE[header] = "this is the page header";
$TEMPLATE[content] = "this is the content of the page";
$TEMPLATE[footer] = "tjsah";

now the parsing:
$thewebsite contains the template data (return the file to that var)

// fetch all template variables
preg_match_all("##Uis", $thewebsite, $arr);

// if items are more than one time used.. parse them once
$arr[0] = array_unique($arr[0]);

// loop through the list..
foreach ($arr[0] as $val) {
// strip the comment tags
$templateval = eregi_replace("[()]",null,$key);
// replace the data
$thewebsite = eregi_replace($val,
$TEMPLATE[$templateval], $thewebsite);
}

// print without further comment in the html code
echo eregi_replace("",null,$thewebsite);}

hope this helps.. btw.. there may be some coding errors in here.. because its written without testing..

AndrewWest

Ok, I think that I may have confused you.

I have a html template system that calls different parts of the system as I need them in my php code..

Say the html template is

<table>
<tr>
<td>forum</td>
<td>posts</td>
</tr>
<tr>
<td>$f['name']</td>
<td>$f['post_count']</td>
</tr>
</table>

Ok, then I would call this in my code..

include("/dir/to/forum_list.html");

Ok now what I need to do is take some php code that take grabs data from a data column in the database and

then is something like

foreach() {
......
include("/dir/to/forum_list.html");
}

The foreach() is the stuff I don't understand clearly, the PHP.net tutorial for it, just boggles my mind, maybe some coder to coder explanation will help?

jordy

foreach() {
// fill $f with the database values..
// $f[name] = "my name";
// $f[post_count] = 11;
include("/dir/to/forum_list.php");
}

// template:

<? global $f; ?>
<table>
<tr>
<td>forum</td>
<td>posts</td>
</tr>
<tr>
<td><?=$f['name']?></td>
<td><?=$f['post_count']?></td>
</tr>
</table>

you need to include the template as a php page then and make the variable $f global in the template..

AndrewWest

I hate to sound really stupid, but doesn't foreach() have to be filled with some sort of information?

foreach($something as $somethinelse) ?

I'm just curious by examples I'm viewing..

////

So the example you gave me should load the database variables properly after I've inserted the proper data for $f?

jordy

okay the complete story..

// dbconnection here
$result = QueryDb("SELECT f1, f2, f3 FROM table;");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($row AS $key => $val) $row[$key] = stripslashes($val);
include('template.php');
unset ($row);
}

// template:

<? global $row ?>
<h1><?=$f1?></h1>
<p><?=$f2?></p>
<p><?=$f3?></p>

etc....

AndrewWest

Thanks, there was a problem but I fixed it.

The $f1, etc should've been in brackets $row[f1] etc.

Thanks though this worked out perfect. 🙂 Thanks soo much

AndrewWest

ok wait....

I just tried two forums, and this only shows one forum listing..

<?php

$result = mysql_query("SELECT id, name, post_count FROM forums ORDER BY id DESC");
if (!$result) {
   die('Invalid query: ' . mysql_error());
}

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 foreach ($row AS $key => $val) $row[$key] = stripslashes($val);
  $row['name'] = "<a href='$siteurl/index.php?page=showforum&f=" .$row['id']. "'>$row[name]</a>";
   include("W:/www/modulization/templates/forum_list.php");
 return ($row);
}

?>

AndrewWest

I just realized, that I didn't need all that.

while ($row = mysql_fetch_array($result)) {
   include("W:/www/modulization/templates/forum_list.php");
}

Was the only thing after SQL query I needed.

jordy

You will need this to strip the slashes:

foreach ($row AS $key => $val) $row[$key] = stripslashes($val);

AndrewWest

I haven't had any problems with slashes, and that code you've just given me (For some reason I don't know why) limits my display to only ONE..

So I'll live with the slashes to see all of the array lol