how to display var array in smary template

[Abdulaziz +]

hello

i stored array in var then i want to display this array in the smarty the field in database where they stored in the var are name, email, comment ??? how can i do it

look at what i did

PHP Code:

{foreach from=$rs item="entry"}
        {$smarty.const.LANG_NAMEE}  :{$entry.name}
        {$smarty.const.LANG_EMAIL}  :{$entry.email}
        {$smarty.const.LANG_COMMENT}:{$entry.comment}
        {/foreach} 


but it didn't work with me

so any idea for this ?

[Lhotch +]

Originally Posted by Abdulaziz

hello

i stored array in var then i want to display this array in the smarty the field in database where they stored in the var are name, email, comment ??? how can i do it

look at what i did

PHP Code:

{foreach from=$rs item="entry"}
        {$smarty.const.LANG_NAMEE}  :{$entry.name}
        {$smarty.const.LANG_EMAIL}  :{$entry.email}
        {$smarty.const.LANG_COMMENT}:{$entry.comment}
        {/foreach} 


but it didn't work with me

so any idea for this ?

This isnt really enough detail to go on.

Is your arfray multi-dimensionl?

Have you assigned the value of $rs to the template?

Try putting this in your template for testing purposes......

{php}print_r($rs){/php}


This should print out the array in the template, probably at the top of the page, post what it prints out here.

[Abdulaziz +]

i will explain

i created class guestbook which have this method

PHP Code:

function GetRecord()
   {
        global $db,$class_tpl;
        $sSQL="SELECT * FROM ".PREFIX."gustbook";
        $result=$db->query($sSQL);
        $rs=$result->fetch();
                  $class_tpl->assign('rss', $rs);
                RETURN;
   } 


and in the index.php

PHP Code:

require_once('modules/gustbook/includes/class.php');        
$gustbook = new Guestbook();
$gustbook->GetRecord();
$class_tpl->assign('body','gustbook.tpl.php'); 


and then i made gustbook.tpl

PHP Code:

{foreach from=$rs item="entry"}
        {$smarty.const.LANG_NAMEE}  :{$entry.name}
        {$smarty.const.LANG_EMAIL}  :{$entry.email}
        {$smarty.const.LANG_COMMENT}:{$entry.comment}
        {/foreach} 


these are the detail and the problem is in the last step i can't display the array which it stored in $rss


this is my first module and i would like to be in the right way so any idea please

[Lhotch +]

Assuming your the query to the database is working and collecting data the obvious problem I see is that you are assigning the php variable $rs to the template variable rss with this line...

$class_tpl->assign('rss', $rs);

Then in the tamplate you are trying to get data from the smarty variable $rs with the following line

{foreach from=$rs item="entry"}


there is no smarty variable $rs, its rss as it appears in the template asignment.

[Abdulaziz +]

thanks for your fast replay

i corrected the var $rss and when i test it i get only the first string from each field then i tried this code

PHP Code:

{foreach from=$rss item="entry"}
        {$smarty.const.LANG_NAMEE}  :{$entry}
        {/foreach} 


it's work but it display only one row.

what i want is to split the array and display it in template
thanks in advance

[Eric Barnes +]

Try this:

PHP Code:

function GetRecord()
{
    global $db;
    $sSQL="SELECT * FROM ".PREFIX."gustbook";
    $result=$db->query($sSQL);
    $data=$result->fetch();
    return $data;
}

// This is your normal file
require_once('modules/gustbook/includes/class.php');        
$gustbook = new Guestbook();
$data = $gustbook->GetRecord();
$class_tpl->assign('rss', $data);
$class_tpl->assign('body','gustbook.tpl.php');