MySQL-dan foydalanishni optimallashtirish

3339

Yangi formatda davom etish uchun: https://uzfor.net/view.php?id=10228&page=2

MySQL-dan foydalanishni optimallashtirish

Xabarlar

MrShahzodbek [1027] [off]
#22 19:06:07, 20 Apr 2018

Savol:
Narx jadvalida narxlar ustuni va 3 ta qator bor.

3 ta qatordagi narxlar qiymatini 3 joyda chiqarishni bitta so'rov bilan amallasa bo'ladimi?

Bitta so'rov qilinsa, $result['narxlar']; 3ta narxni ketma-ket yozyabdi.

Menga esa natija 3 joyda chiqishi kerak. 3 marta so'rov bilan chiqarish mumkin, ammo 1 ta so'rov bilan shuni chiqarish mumkinmi?

MrShahzodbek [1027] [off]
#24 11:43:06, 21 Apr 2018

Сирожиддин, Shu o'xshamayabdi. Tushuna olmadim.
11 daqiqa 39 soniyadan keyin yozdi:

$hosttype = hosting;
$query = sprintf("SELECT cost, servername FROM tarifs WHERE vid = '%s' ORDER BY id ASC LIMIT 3",
mysql_real_escape_string($hosttype));
$result = mysql_query($query);
IF (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}
while ($row = mysql_fetch_assoc($result)) {
echo $row['cost'];}  ?>

Ushbu koddan

<? echo $row['cost'];  ?>

ni 3 joyda qo'yib ko'rdim, ammo natija o'xshamayabdi.

Sahifa: https://uzhost.net/my/hottest.php

Bekmurod [304] [off]
#25 12:49:39, 23 Apr 2018

MrShahzodbek, Tog'ri tushungan bo'lsam sizga ketma ket emas har hil joyda nechta qator bo'lsa shuncha chiqishi kerak shundaymi? Unday bo'lsa HTMLdan tablesidan foydalanganingiz maqul. Agar faqat 3ta bo'lsa uni iloji bor.
Yuqoridagi sikldan oldim $b=0; $narxi=array(); larni yozing kegin sikl ichida (while(){})
$b++;
$narxi[$b]=$row['cost'];
qiling shunda $narxi massivini hoxlagan joyda ishlatib bilasiz. Mas: $narxi[1];

MrShahzodbek [1027] [off]
#26 13:37:45, 23 Apr 2018

Bekmurod, to'liq yozishni iloji bormi yuqoridagi kod bilan birgalikda?
1 daqiqa 33 soniyadan keyin yozdi:

$hosttype = hosting;
    $query = sprintf("SELECT cost, servername FROM tarifs WHERE vid = '%s' ORDER BY id ASC LIMIT 3",
    mysql_real_escape_string($hosttype));
    $result = mysql_query($query);
    IF (!$result) {
        $message  = 'Invalid query: ' . mysql_error() . "\n";
        $message .= 'Whole query: ' . $query;
        die($message);
    }
 
$b=0; $narxi=array();
 
    while ($row = mysql_fetch_assoc($result)) {
    echo $narxi[$b]=$row['cost'];}  ?>

Shundaymi?

Bekmurod [304] [off]
#27 16:25:49, 23 Apr 2018

MrShahzodbek,

$hosttype = hosting;
    $query = sprintf("SELECT cost, servername FROM tarifs WHERE vid = '%s' ORDER BY id ASC LIMIT 3",
    mysql_real_escape_string($hosttype));
    $result = mysql_query($query);
 
$b=0; $narxi=array();
 
    while ($row = mysql_fetch_assoc($result)) {
$b++;
$narxi[$b]=$row['cost'];}  ?>

buni faylni yuqorisiga yozasiz kegin faylni pastida hoxlagan joyida

echo '1-tarif '.$narxi['1'];

bo'ldi

Krgold [56] [off]
#40 20:44:31, 10 Dec 2018

Rare, # Rare (10.12.2018 / 20:37)
Krgold, masalan 100 ta alohida soz oldin sinab keyin yozing iloji bulsa
3 daqiqa 14 soniyadan keyin yozdi:
shu sozni ham bittalab yozsa ulgurmayapdi baza tekshirib yozishgaManing tushunimcha siz 100ta sozni birdaniga bazaga qoshmaqchisiz. Shunaqami?

Tepadagi kod aniq ishlaydi 100% Kodni togri orniga qoysangiz!