Такая вот проблема! Есть запрос в базу, поиск названия!
Код |
<?php require_once "Tools/ToolsList.php"; $config= $DB->SelectRow("SELECT ResultPerPage, ResultPerFrame FROM ?_config"); $per=$config['ResultPerPage']; $frame=$config['ResultPerFrame']; $out=array(); $p=isset($_GET['p'])?$_GET['p']: 0; $story=$_GET['search']; $query = $DB->SelectPage($count, "SELECT * FROM ?_goods WHERE (`GoodsName` like '%$story%') AND `GoodsVisible`=1 ORDER BY `GoodsName` LIMIT ".$p.",".$per); if ($query){ $totalNumElements = $count; $out = ToolsList::framePages($frame, $per, $totalNumElements); $out['search']=$query; echo "<ol TYPE=\"l\" START=\"".($p+1)."\">"; foreach($out['search'] as $v) { echo "<li><a href=\"/catalog/$v[GoodsCat]/good/$v[GoodsID]/\">$v[GoodsName]</a></li>"; // echo "<li><a href=\"/catalog/goods.html?cat=$v[GoodsCat]&id=$v[GoodsID]\">$v[GoodsName]</a></li>"; } echo "</ol>"; if($out['pages'][0]['is_first'] !== $out['pages'][0]['is_last']) { echo "<div id=\"txt3\" align=\"justify\" style=\"margin-left: 10px;\">Страницы: "; if (@$out['prev'] != '') echo "<a href=".$out['prev']['url'].">...</a>"; foreach ($out['pages'] as $v) { if ($v['is_cur']) { if ($v['is_last'] !== 1) echo "<b>".$v['n']."</b> | "; else echo "<b>".$v['n']."</b> "; } else { if ($v['is_last'] !== 1) echo "<a href=\"".$v['url']."\">".$v['n']."</a> | "; else echo "<a href=\"".$v['url']."\">".$v['n']."</a> "; } } if (@$out['next'] != '') echo "<a href=\"".$out['next']['url']."\">...</a>"; echo "</div>"; } } else { echo "Ничего не найдено !"; } ?> |