Blog with multiple categories
10 posts by 3 authors in: Forums > CMS Builder
Last Post: May 15, 2017 (RSS)
By kovali - April 10, 2017
Hi,
I'm trying to build a blog with different categories, every category can have many stories. The list of all categories and list of corresponding stories should always be shown on the same page. Now, when I click on a category I only get the first story for that category... But I want it to show ALL stories for that category.
The code that I'm using now:
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
// load viewer library
$libraryPath = 'beheer/lib/viewer_functions.php';
$dirsToCheck = array('/home/weballbe/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
// load records from 'pe_blog_rubrieken'
list($pe_blog_rubriekenRecords, $pe_blog_rubriekenMetaData) = getRecords(array(
'tableName' => 'pe_blog_rubrieken',
'loadUploads' => false,
'allowSearch' => false,
));
// load records from 'pe_blog'
list($pe_blogRecords, $pe_blogMetaData) = getRecords(array(
'tableName' => 'pe_blog',
'where' => whereRecordNumberInUrl(1),
'loadUploads' => true,
'allowSearch' => false,
));
?>
I think it has something to do with 'where' => whereRecordNumberInUrl(1), why it's only showing 1 story but don't know the correct PHP code to get all stories for one categorie.
Anybody that can help me please ?
Thanks !
By ross - April 14, 2017
Hi there
Thanks for posting.
It is possible to display two lists on one page.
To start with, though, I recommend simplifying and focusing specifically on a page that lists all your blog posts.
Don't add anything about categories or single records or multiple lists.
Just build a page that lists all your blog posts regardless of category.
Once you have that, attach a copy of your file (instead of pasting code into a post), and I can review from there.
Does that make sense? Let me know any questions or feedback.
Thanks!
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
By kovali - April 25, 2017
Hi Ross,
I've build a page that simply lists all blog posts, see file attached please.
The result in the browser: http://pretecho-opleiding.be/blogtest.php
Best regards,
Koen
By gkornbluth - May 8, 2017 - edited: May 8, 2017
Hi Kovai,
One approach might be to set up a way to identify the different groups of blogs. I usually do that by setting up a multi record "Categories" section with a "Category" text field.
Next, set up a pull down list field in my blog section that gets its values and labels from the "Category" field in the "Categories" section, make it a required field, and "assign" each blog story to a particular category with that pull down. (this keeps everything nice and uniform, so searches don't go awry.)
Next on they blog list viewer, set up a similar pull down that gets its values from the Category field in the Categories section, (also make this a required choice using error checking) so that the visitor can choose from the same category list.
You can then use that choice to set a 'where' value to limit the blog posts shown to only that category.
It's pretty easy once you get going, and there's a lot more on the details in my CMSB Cookbook recipes.
Good luck
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
By kovali - May 9, 2017
Hi Jerry,
Thx for the help, much appreciated !
When you say: "You can then use that choice to set a 'where' value to limit the blog posts shown to only that category." I'm wondering what the 'where' statement should look like... could you give me an example pls ?
For the moment I have a working solution with a jump menu, see below, but your solution would be nicer I think...
Thanks again.
Koen
http://pretecho-opleiding.be/blog.php
<form id="form1">
<select name="menu1" onchange="MM_jumpMenu('parent',this,0)">
<option value="">Kies een rubriek</option>
<?php foreach ($pe_blog_rubriekenRecords as $record): ?>
<option value="blog.php?rubriek=<?php echo urlencode($record['title']) ?>"><?php echo $record['title'] ?></option>
<?php endforeach; ?>
</select>
</form>
By gkornbluth - May 9, 2017
Hi Koen,
I'm not able to access any examples right now, but have a look through the recipes in the CMSB Cookbook. You'll find examples there.
If you're not a subscriber, you can get a trial subscription. just follow the link below.
Good luck,
Jerry
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
By ross - May 15, 2017
Hi kovali
Just wanted to check in on how you are making out with your blog.
Did you find what you need in The Cookbook?
Let me know if you still have any questions.
Thanks!
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/