Specific mysql record listing

144
March 09, 2018, at 9:22 PM
        <section class="latest-news-index">
    <table style="width: 100%; max-width: 100%;margin-bottom: 20px; "class="table table-hover ">
            <tbody><tr><td style="border-bottom: 1px solid #9e9e9e;border-top: none;font-size: 2.1em;font-weight: bold;" colspan="99" class="date-header"><?php echo date('m.d.y');?></td></tr>
            <?php
            $sayfa = $news->pager($SAYFA,15,'haber','h_id',"WHERE onay='1' AND time<='".time()."'");
            $sql = $db->sql(
    "SELECT haber.h_id, 
            haber.k_id, 
            haber.baslik, 
            haber.baslik_renk, 
            haber.resim, 
            haber.k_icerik, 
            haber.link, 
            haber.time, 
            kategori.baslik as kategori 
    FROM haber 
    LEFT JOIN kategori ON haber.k_id=kategori.k_id
    WHERE kategori.onay='1' 
      AND haber.onay='1' 
      AND DATE(FROM_UNIXTIME(haber.time)) = DATE(SYSDATE())
    ORDER BY haber.time DESC 
    "
);
            if($db->num_rows($sql)>0):
                $i = 1;
                while($data = $db->f_array($sql)):
                    $id     = $news->dataview($data['h_id']);
                    $baslik = $news->dataview($data['baslik']);
                    $baslik_renk= ($news->dataview($data['baslik_renk']) ? ' style="color:'.$news->dataview($data['baslik_renk']).';"' : '');
                    $resim      = $news->dataview($data['resim']);
                    $kIcerik    = $news->dataview($data['k_icerik']);
                    $time   = $news->dataview($data['time']);
                    $kategori = $news->dataview($data['kategori']);
                    $haberlink  = $news->dataview($data['link']);
                    $link = ($haberlink == '' ? $news->url('haber',$id,$baslik) : $haberlink);
        ?>
                <tr style="padding: 8px;font-size: 15px;line-height: 1.42857143;vertical-align: top;">
                <?php if($sistem['iceriktarih']): ?>
            <td style="padding: 8px;font-size: 15px;line-height: 1.42857143;color: red;vertical-align: top;border-top: 1px solid #ddd;"><?=$news->saat($time)?></td>
            <?php endif; ?>
            <td style="padding: 8px;font-size: 15px;line-height: 1.42857143;color:#black;vertical-align: top;border-top: 1px solid #ddd;"><?=$kategori?> </td>
            <td style="padding: 8px;font-size: 20px;line-height: 1.42857143;vertical-align: top;border-top: 1px solid #ddd;"><b><a style="color: #0f3f5e;" href="<?=$link?>"><?=$baslik?><span class="title-icons"></span></a></b></td>
        </tr>
        <?php
                endwhile;
            endif;
        ?>            
    </tbody></table>
</section>

Hello friends, My system has: video, photo, "breaking news"

This is how my system should work:

If news has video it should have video Icon.

If news has photo gallery it should have photo icon.

Can someone help me with this?

Thanks in advance.

Rent Charter Buses Company
READ ALSO
Updating MYSQL table row column sum by appending

Updating MYSQL table row column sum by appending

I would like to update a column row inside MYSQL by adding 50 to the last current numberMeans column named sum was 200 and after query, it will update to 250

199
how to detect charset from json response in php

how to detect charset from json response in php

I'm trying to receive a JSON Response from a webservice using GuzzleHttp Client but I'm unable to decode the received json data with json_decode which returns null

211
php if query works with wamp but not on live server

php if query works with wamp but not on live server

I'm using the code below to choose an image based on the domain

173
Visual Basic, HTML, Excel automatic input to website

Visual Basic, HTML, Excel automatic input to website

This is related to a question I posted yesterday but I need help with the third stepI have excel visual basic code that goes to my companies link and enters an 8 digit number into an input box

43