How can I call the content of a page into a fixed content block?

[sgharris]

Right now, I'm calling a text file using the following code:

<?php include(WB_PATH.'/media/upcoming.txt');?>

But that text file is, essentially, the same as another existing page (Upcoming Events).  It would be nice to only have to update it once.

I've tried a few things, but just don't seem to have the php knowledge to do this.

Any help would be appreciated.

Steve
www.blyc.bio-geek.com

[Ruud]

Right now, I'm calling a text file using the following code:

<?php include(WB_PATH.'/media/upcoming.txt');?>

But that text file is, essentially, the same as another existing page (Upcoming Events).  It would be nice to only have to update it once.

I've tried a few things, but just don't seem to have the php knowledge to do this.

Any help would be appreciated.

Steve
www.blyc.bio-geek.com

Try this snippet:

Code:

<?php
$sid = 53;
$gc = $database->query("SELECT content FROM ".TABLE_PREFIX."mod_wysiwyg WHERE section_id = '".$sid."'");
$rc = $gc->fetchRow();
echo $rc['content'];
?>

Set $sid to the section you like to use (must be a mod_wysiwyg section)

You can find the section ID when hovering your mouse over the section in the "admin->pages->manage sections" page and read the url in the statusbar of your browser.
The section is the last part of the url  (http://yourserver/admin/pages/modify.php?page_id=10#53)

Good luck

Ruud

[sgharris]

Thanks a bunch!  It works great!

 (well, once I remembered to changed the $sid= to the correct page number, that is) 

[thefly]

Thanks, Ruud, too!

But I've noticed that hovering mouse on the page shows not section, but page ID, so this code work:

Code:

$pid = 52;
$gc = $database->query("SELECT content FROM ".TABLE_PREFIX."mod_wysiwyg WHERE page_id = '".$pid."'");
$rc = $gc->fetchRow();
echo $rc['content'];

Thanks again!
Asen :)

[spida]

Hi,

I am also playing around with the script. Since I want to include news, I changed it a bit to

Code:

$pid = 2;
$gc = $database->query("SELECT content FROM ".TABLE_PREFIX."mod_news_posts WHERE post_id = ' ".$pid." ' ");
$rc = $gc->fetchRow();
echo $rc['content'];

But I am getting an error message as the result:

Fatal error: Call to a member function fetchRow() on a non-object in C:\xampplite\htdocs\site\modules\code\view.php(30) : eval()'d code on line 3

Has someone an idea what I have to use instead of or additional with fetchRow?

Best regards,
spida

[Ruud]

Code:

$gc = $database->query("SELECT content FROM ".TABLE_PREFIX."mod_news_posts WHERE post_id = ' ".$pid." ' ");

"content" is not a field in the mod_news_posts table.
use content_short or content_long instead of content.

Cheers,

Ruud

[spida]

Hi Ruud,

thank you very much for your hint. That was the cause of course!

Regards,
spida

[Argos]

An alternative:

Code:

<?php 
$section_id = XX; 
$query_sections = $database->query("SELECT section_id,module FROM ".TABLE_PREFIX."sections WHERE section_id = '$section_id' ");
if($query_sections->numRows() > 0) { $section = $query_sections->fetchRow(); 
$section_id = $section['section_id']; 
$module = $section['module']; 
require(WB_PATH.'/modules/'.$module.'/view.php'); 
} 
?>

[spida]

Hi Argos,

what's the benefit of your script? Could you please explain to these PHP idiots like me 

Kind regards,
spida

[Argos]

I don't know, I'm an idiot with php as well 

I just happened to be doing the same as you, and the code I gave was the one I found after searching the forums. I works fine, and can be used for not only WYSIWYG I think. So if you have problems with the first code, try this one.

[pcwacht]

Spida's code fetches only a field from the database, in his case the content_short field from the news table

Argos's code uses WB build in routines to show a whole section, section can be anything.
Argos's code is allso used for global blocks


Have fun,
John

[Ruud]

One little problem with Argos' code.

When you use this in a code section the folloing sections are not handled anymore.
By using the variable '$query_sections' as the query result, it destroys the original $query_sections from the framework.functions .php.
Any other sections behind a codeblock with this snippet will not be shown anymore.

This code is modified so any following sections will still work.

Code:

$section_id = xx;
$query_sec = $database->query("SELECT section_id,module FROM ".TABLE_PREFIX."sections WHERE section_id = '$section_id' ");
if($query_sec->numRows() > 0) {
$section = $query_sec->fetchRow();
$section_id = $section['section_id'];
$module = $section['module'];
require(WB_PATH.'/modules/'.$module.'/view.php');
}

Ruud

[Argos]

Thanks for the update Ruud!

[spida]

Thanks to all you guys for explanations, and for the update code too.

keep on going, websitebaker!