CMS Made Simple Forums

Code: Select all

$query = "SELECT Tabelle_1_Spalte_1, 
			Tabelle_1_Spalte_2, 
			Tabelle_2_Spalte_5, 
   			Tabelle_2_Spalte_3, 
			Tabelle_3_Spalte_4, 
			Tabelle_4_Spalte_1
		FROM ".cms_db_prefix()."Tabelle_1 
		LEFT JOIN ".cms_db_prefix()."Tabelle_2 
		ON ".cms_db_prefix()."Tabelle_1.content_id = ".cms_db_prefix()."Tabelle_2.content_id 
	$dbresult = $db->Execute($query);
	while($dbresult && $row = $dbresult->FetchRow())
	{
		...
	}

Code: Select all

/* Get Global data */
global $gCms;


/* Get Database Configuration/Connection */

$db = &$gCms->db;

/*

mySQL Query
- Only queries "active" and "show in menu" enabled pages
- Only queries specified content block

*/

$q = "
	SELECT 
		content_name, 
		show_in_menu, 
		active, 
		prop_name,
		content
		
	FROM 
		".cms_db_prefix()."content, ".cms_db_prefix()."content_props
		
	WHERE 
		".cms_db_prefix()."content.content_id = ".cms_db_prefix()."content_props.content_id
		
	AND 
		active = 1

	AND 
		show_in_menu = 1
		
	AND 
		prop_name = '$params[block]'
		



";

/* Execute mySQL Query and Error handle */

$dbresult = $db->Execute( $q );

if( !$dbresult )
{
    echo 'DB error: '. $db->ErrorMsg()."<br/>";
}


/*
	Processing of mySQL query

*/

$content_dump = array();
	
while ($dbresult && $dbqueryresultrow = $dbresult->FetchRow())
{
	
		$dump_item = new StdClass;
		$dump_item->title = $dbqueryresultrow[content_name];
		$dump_item->content = $dbqueryresultrow[content];
		$content_dump[] = $dump_item;
		
}

$smarty = &$gCms->GetSmarty();
		$smarty->assign(dump, $content_dump);
	return;

Code: Select all

{dump block="content_en"}

Code: Select all

{dump block="content_en"}

{foreach from=$dump item=dump_item} 
<h1>{$dump_item->title}</h1>
<p>{$dump_item->content}</p>
{/foreach}

Code: Select all

		$dump_item = new StdClass;
		$dump_item->title = $dbqueryresultrow[content_name];
		$dump_item->content = $dbqueryresultrow[content];
		$content_dump[] = $dump_item;

Code: Select all

{dump block="content_en"}
{php}
{foreach from=$dump item=dump_item} 
<h3>{$dump_item->title}</h3>
<p>{$dump_item->content}</p>
{/foreach}
{/php}