PHP sql while yardım

07-12-2022, 14:59:57

datada veri aşağıdaki gibi verileri aldım ancak 10 11 12 diye premiumlar var üçü de yoksa No Premium yazdırmak istiyorum var olanları almayı başardım üçüde yoksa nasıl yazdırırım yardımcı olursanız sevinirim.

while ($premium = sqlsrv_fetch_array($pregetir, SQLSRV_FETCH_ASSOC)) {
// access column values using keys in the $row array

if($premium["bPremiumType"]==10) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>DC Premium</span>"; };

if($premium["bPremiumType"]==11) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>EXP Premium</span>"; };

if($premium["bPremiumType"]==12) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>WAR Premium</span>"; };
}

echo "<span 'class=kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-color:#000'>No Premium</span>";
echo  "<font color='red'>Aktif premium bulunamadı.</font> </td>";

07-12-2022, 15:06:06

Mhmmd

$premiums = [10,11,12];
while ($premium = sqlsrv_fetch_array($pregetir, SQLSRV_FETCH_ASSOC)) {
// access column values using keys in the $row array
 
if($premium["bPremiumType"]==10) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>DC Premium</span>"; };
 
if($premium["bPremiumType"]==11) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>EXP Premium</span>"; };
 
if($premium["bPremiumType"]==12) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>WAR Premium</span>"; };
}
 if(!in_array($premium["bPremiumType"], $premiums)){
    echo "<span 'class=kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-color:#000'>No Premium</span>";
    echo  "<font color='red'>Aktif premium bulunamadı.</font> </td>";
 }

böyle bir dener misiniz hocam?

07-12-2022, 15:10:24

Misafir

kayıt varken'de no premium getirdi

Mhmmd adlı üyeden alıntı: mesajı görüntüle

$premiums = [10,11,12];
while ($premium = sqlsrv_fetch_array($pregetir, SQLSRV_FETCH_ASSOC)) {
// access column values using keys in the $row array
 
if($premium["bPremiumType"]==10) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>DC Premium</span>"; };
 
if($premium["bPremiumType"]==11) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>EXP Premium</span>"; };
 
if($premium["bPremiumType"]==12) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>WAR Premium</span>"; };
}
 if(!in_array($premium["bPremiumType"], $premiums)){
    echo "<span 'class=kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-color:#000'>No Premium</span>";
    echo  "<font color='red'>Aktif premium bulunamadı.</font> </td>";
 }

böyle bir dener misiniz hocam?

07-12-2022, 15:11:58

CihanAksoy

Bu şekilde daha performanslı ve doğru olur. İstediğiniz gibi de çalışır

while ($premium = sqlsrv_fetch_array($pregetir, SQLSRV_FETCH_ASSOC)) {
// access column values using keys in the $row array

if($premium["bPremiumType"]==10) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>DC Premium</span>"; };

else if($premium["bPremiumType"]==11) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>EXP Premium</span>"; };

else if($premium["bPremiumType"]==12) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>WAR Premium</span>"; };
}

else {
echo "<span 'class=kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-color:#000'>No Premium</span>";
echo  "<font color='red'>Aktif premium bulunamadı.</font> </td>";
}

Ancak şu şekilde daha temiz bir kod olur;

while ($premium = sqlsrv_fetch_array($pregetir, SQLSRV_FETCH_ASSOC)) {
// access column values using keys in the $row array

$premium = 'No Premium';

if($premium["bPremiumType"]==10)  { $premium = 'DC Premium' };
else if($premium["bPremiumType"]==11)   { $premium = 'EXP Premium' };
else if($premium["bPremiumType"]==12)   { $premium = 'WAR Premium' };

echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>$premium</span>";

if($premium == 'No Premium')
 echo  "<font color='red'>Aktif premium bulunamadı.</font>

07-12-2022, 15:14:17

Mhmmd

Kodunuzdaki parantezleri göremedim o yüzden sanırım. şimdi tekrar deneyin.

$premiums = [10,11,12];
while ($premium = sqlsrv_fetch_array($pregetir, SQLSRV_FETCH_ASSOC)) {
// access column values using keys in the $row array
  
if($premium["bPremiumType"]==10) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>DC Premium</span>"; };
  
if($premium["bPremiumType"]==11) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>EXP Premium</span>"; };
  
if($premium["bPremiumType"]==12) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>WAR Premium</span>"; };

 if(!in_array($premium["bPremiumType"], $premiums)){
    echo "<span 'class=kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-color:#000'>No Premium</span>";
    echo  "<font color='red'>Aktif premium bulunamadı.</font> </td>";
 }
}

07-12-2022, 15:22:31

Misafir

premiumlar normal kayıtları silince no premium gelmiyor

Mhmmd adlı üyeden alıntı: mesajı görüntüle

Kodunuzdaki parantezleri göremedim o yüzden sanırım. şimdi tekrar deneyin.

$premiums = [10,11,12];
while ($premium = sqlsrv_fetch_array($pregetir, SQLSRV_FETCH_ASSOC)) {
// access column values using keys in the $row array
  
if($premium["bPremiumType"]==10) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>DC Premium</span>"; };
  
if($premium["bPremiumType"]==11) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>EXP Premium</span>"; };
  
if($premium["bPremiumType"]==12) { echo "<span class='kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-image: radial-gradient(ellipse farthest-corner at center 0px,#ffc400 -150%,#ffc400 45%,#ff8800 85%);'>WAR Premium</span>"; };

 if(!in_array($premium["bPremiumType"], $premiums)){
    echo "<span 'class=kg-lbl-status' style='font-size: 11px; font-weight: bold; border-radius: 3px;  text-align: center; color: #FFF; padding: 4px 5px; background-color:#000'>No Premium</span>";
    echo  "<font color='red'>Aktif premium bulunamadı.</font> </td>";
 }
}

07-12-2022, 16:31:16

#7

Misafir

hallettim çok teşekkürler