7 yıl önce sordu

Php 2 Tablo Arasındaki Veri Yoksa

Reklam alanlar(adsrice) ve reklamlar (adver - kısalttım) ve bu tabloların içinde ortak hash var. Şimdi: eğer adsrice ile adver eşleşmezse adver tablosunu yazdırsın. PHP Kodu: [code]

Cevaplar(3)

oxcakmak

7 yıl önce Cevapladı

Yazılım Soru - Kod Kısmı

	<?php
$advertisement_query = mysql_query("SELECT * FROM andesite_adsrice INNER JOIN andesite_advertisement WHERE andesite_adsrice.adsrice_username = '$user_nickname'");
$adsrice_query = mysql_query("SELECT * FROM andesite_advertisement");
$num_log = mysql_num_rows($advertisement_query);

if ($num_log > 0){
    while (($ads_row = mysql_fetch_array($advertisement_query)) && ($ade_row = mysql_fetch_array($adsrice_query))) {

			if($ads_row['adsrice_adsase'] != $ade_row['adsrice_adsase']){
				
				
				echo '<tr>
                        <td>'.$ads_row['advertisement_id'].'</td>
                        <td>'.$ads_row['advertisement_title'].'</td>
                        <td><a class="btn btn-success btn-success flat btn-xs" href="/Surf/'.$ads_row['advertisement_base'].'" target="_blank"><i class="fa fa-eye"></i>&nbsp;'.ls_view.'</a></td>
                    </tr>
                ';
				
			}else{
				
			$timeA = $ads_row['adsrice_time'];
            $timeB = date("d.m.Y H:i");
            $timeDiff = strtotime($timeB) - strtotime($timeA);
            if ($timeDiff > $ads_time){
				echo '<tr>
                        <td>'.$ade_row['advertisement_id'].'</td>
                        <td>'.$ade_row['advertisement_title'].'</td>
                        <td><a class="btn btn-success btn-success flat btn-xs" href="/Surf/'.$ade_row['advertisement_base'].'" target="_blank"><i class="fa fa-eye"></i>&nbsp;'.ls_view.'</a></td>
                    </tr>
                ';
			}
			
			}
		}	
} else {
	$ads_f_query = mysql_query("SELECT * FROM andesite_advertisement");
	while($ads_f_row = mysql_fetch_array($ads_f_query)){
   echo '<tr>
                        <td>'.$ads_f_row['advertisement_id'].'</td>
                        <td>'.$ads_f_row['advertisement_title'].'</td>
                        <td><a class="btn btn-success btn-success flat btn-xs" href="/Surf/'.$ads_f_row['advertisement_base'].'" target="_blank"><i class="fa fa-eye"></i>&nbsp;'.ls_view.'</a></td>
                    </tr>
                ';
	}
}
?>

Beğen (0) Yorumlar(0) Yorum Yaz

Gönder