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'); 


[Lhotch]

Originally Posted by Eric Barnes

Try this:

The problem here as I see it is he is only pulling 1 record from the database and doesnt seem to be stating which record he is pulling.

He is using....

$data=$result->fetch();

which uses mysql_fetch_array to load the returned array into $data thereby making it a multidimensional array.

then at the template level looping over the $data array(which there is nothing to loop over because there was only 1 record pulled from DB) and trying to display the contents as a regular variable when in essence its another array.

[Abdulaziz]

hello Eric

i did what did you write and nothing happen

look at what has appeared
5
a
g

"5 is the id , a is the first of abdulaziz, g is the first of good"
that what are appear
the record in the database as picture in attachment
also u can visit the url to see that ??????? ?????? ? ????? ??????? ??????? ?????? ?????? ?????? ?????????
and one more thing if it possible to setup 68classified in the localhost?

[Eric Barnes]

Yes I think Larry was on to something. See if this works:

PHP Code:

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


[Abdulaziz]

I am greatful that you solved my problem it's working very well now
sending you my best regards