Итак, прошу оценить код До-После
ДО
После
Насколько понимаете, работает одинаково.
ДО
PHP:
function ransmes () {
$r1 = rand (742, 872);
return "$r1";
}
function ranacces () {
$r1 = rand (1, 230);
return "$r1";
}
function ranpencil () {
$r1 = rand (426, 644);
return "$r1";
}
function ranwash () {
$r1 = rand (657, 715);
return "$r1";
}
$Query3 = mysqli_query($CONNECT, 'SELECT `id`, `name`, `namecate`, `priceflo`, `namephoto` FROM `products` WHERE `id` = '.$ransmes1.' AND `namecate` = "smes" ORDER BY `id` DESC LIMIT 1');
while ($Row = mysqli_fetch_assoc($Query3)) $Hit1 .= '<a href="/product2/material/id/'.$ransmes1.'"><div class="rg1cart"><span>'.$Row['name'].'</span>
<img src="/catalog/product/smes/img/1/'.$Row['namephoto'].'.jpg" title="'.$Row['name'].'" alt="'.$Row['id'].'" width="211" height="211">
<div class="rg1text1">Цена: <font color="#4f4f4f">'.ceil (KursRub($Row['priceflo'])).'</font> руб.</div>
<div class="BuybuttonHome">'.BUY ($Row['id']).'</div>
</div></a>';
$ranacces1 = ranacces();
$Query4 = mysqli_query($CONNECT, 'SELECT `id`, `name`, `namecate`, `priceflo` FROM `products` WHERE `id` = '.$ranacces1.' AND `namecate` = "accessories" ORDER BY `id` DESC LIMIT 1');
while ($Row = mysqli_fetch_assoc($Query4)) $Hit1 .= '<a href="/accessories/material/id/'.$ranacces1.'"><div class="rg1cart"><span>'.$Row['name'].'</span>
<img src="/catalog/product/accessories/img/1/'.$ranacces1.'.jpg" title="'.$Row['name'].'" alt="'.$Row['id'].'" width="211" height="211">
<div class="rg1text1">Цена: <font color="#4f4f4f">'.ceil (KursRub($Row['priceflo'])).'</font> руб.</div>
<div class="BuybuttonHome">'.BUY ($Row['id']).'</div>
</div></a>';
$ranpencil1 = ranpencil();
$Query5 = mysqli_query($CONNECT, 'SELECT `id`, `name`, `namecate`, `price`, `namephoto` FROM `products` WHERE `id` = '.$ranpencil1.' AND `namecate` = "pencilcase" ORDER BY `id` DESC LIMIT 1');
while ($Row = mysqli_fetch_assoc($Query5)) $Hit1 .= '<a href="/pencilcase/material/id/'.$ranpencil1.'"><div class="rg1cart"><span>'.$Row['name'].'</span>
<img src="/catalog/product/pencilcase/img/1/'.$Row['namephoto'].'.jpg" title="'.$Row['name'].'" alt="'.$Row['id'].'" width="211" height="211">
<div class="rg1text1">Цена: <font color="#4f4f4f">'.$Row['price'].'</font> руб.</div>
<div class="BuybuttonHome">'.BUY ($Row['id']).'</div>
</div></a>';
$ranwash1 = ranwash();
$Query6 = mysqli_query($CONNECT, 'SELECT `id`, `name`, `namecate`, `priceflo`, `namephoto` FROM `products` WHERE `id` = '.$ranwash1.' AND `namecate` = "shower" ORDER BY `id` DESC LIMIT 1');
while ($Row = mysqli_fetch_assoc($Query6)) $Hit1 .= '<a href="/shower/material/id/'.$ranwash1.'"><div class="rg1cart"><span>'.$Row['name'].'</span>
<img src="/catalog/product/shower/img/1/'.$Row['namephoto'].'.jpg" title="'.$Row['name'].'" alt="'.$Row['id'].'" width="211" height="211">
<div class="rg1text1">Цена: <font color="#4f4f4f">'.ceil (KursRub($Row['priceflo'])).'</font> руб.</div>
<div class="BuybuttonHome">'.BUY ($Row['id']).'</div>
</div></a>';
После
PHP:
$db = getPDOconnect (); // Подключение к БД
$id=array((rand(1, 230)),(rand(426, 644)),(rand(657, 715)),(rand(742, 872)));
$in= str_repeat('?,', count($id) - 1) . '?';
$query = "SELECT * FROM products WHERE `id` IN ($in)";
$stm = $db->prepare($query);
$stm->execute($id);
$echo_result=array();
foreach ($stm as $row)
{
$price_rub = $row['price'] + ceil(KursRub($row['priceflo']));
$echo_result = '<a href="/'.Refresh_Url_Product2($row['namecate']).'/material/id/'.$row['id'].'"><div class="rg1cart"><span>'.$row['name'].'</span>
<img src="/catalog/product/'.Way_Product2($row['namecate']).'/img/1/'.$row['namephoto'].''.JPG_PNG2($row['namecate']).'" alt="'.$row['id'].'" width="211" height="211">
<div class="rg1text1">Цена: <font color="#4f4f4f">'.$price_rub.' </font> руб.
<div class="BuybuttonHome">'.BUY ($row['id']).'</div></div>
</div></a>';
echo $echo_result;
}
Насколько понимаете, работает одинаково.