Payaso
Новичок
Конвертация и передача PEAR result array в SMARTY
POzhalujsta,po dskazhite kak peredat smarty poniatnij dla nego array, chtobi otobrazhal dannie viborki iz basi dannix (PEAR)?
v PHP :
VOt eta peremennaya $array_numb soderzhit dannie.
Vse zamechatelno otobrazhaetsa v php putem:
A mne nado etot resultat peredat v template smarty i tam s pomoshju funkcii {foreach} ego otobrazhat!
Spasibo zaranie za otvet!
POzhalujsta,po dskazhite kak peredat smarty poniatnij dla nego array, chtobi otobrazhal dannie viborki iz basi dannix (PEAR)?
v PHP :
PHP:
$query=& $db->query('select distinct id_im from rating');
if (PEAR::isError($query)) {
die($query->getMessage());
}
while($query->fetchInto($q))
{
$sum_numb=0;
$id= 'select numb from rating where id_im= ?';
$where= $q['id_im'];
$id_im_source=& $db->query($id, $where);
if (PEAR::isError($id_im_source)) {
die($id_im_source->getMessage());
}
while($id_im_source->fetchInto($q2))
{
$sum_numb+=$q2['numb'];
}
$count_vote= & $db->query('select * from rating where id_im= ?', array($q['id_im']));
$count_vote= $count_vote->numRows();
$array_numb[$q['id_im']] = (int)($sum_numb/$count_vote) ;
echo $q['id_im']."-->".$array_numb[$q['id_im']]."<br>";
}
Vse zamechatelno otobrazhaetsa v php putem:
PHP:
foreach($array_numb as $index => $val){
echo $index."==";
echo $val."<br>";
}
Spasibo zaranie za otvet!
