coze_training/messages.php

<div class="messages">

    <div class="row <?= $bgcolor;?> py-2 text-right">
        <div class="col-12"><a href="/cb_message_add.php" class="cbOpen button big confirm mx-0">Add new message</a></div>
    </div>

    <div class="row <?= $bgcolor;?> p-2 text-upper text-grey">
        <div class="col-5 font-12">Message title</div>
        <div class="col-4 font-12">Session</div>
        <div class="col-1 font-12 text-center">Timer</div>
        <div class="col-1 font-12 text-center">Prog.</div>
        <div class="col-1 text-right"></div>
    </div>

    <?php
        $cnt=0;
        $q=mysqli_query($conn, "SELECT messages.*, session.name AS session_name FROM `messages`, session WHERE messages.sid = session.id ORDER BY session_name,messages.title DESC");
        while($r=mysqli_fetch_array($q)){
        $cnt++;
        $bgcolor = ($cnt%2) ? "bg-grey" : "bg-white";
    ?>

    <div class="row items <?= $bgcolor;?> p-2">
        <div class="col-5 font-12"><?= $r['title'];?></div>
        <div class="col-4 font-12"><?= $r['session_name'];?></div>
        <div class="col-1 font-12 text-center"><?= $r['timer'];?></div>
        <div class="col-1 font-12 text-center"><?= $r['progress'];?></div>
        <div class="col-1 text-right">
            <a href="/cb_message_edit.php?id=<?= $r['id'];?>" class="cbOpen text-black"><i class="fa fa-pencil-square ml-2"></i></a>
            <a href="<?= $BASE_URL.":3001/pushMessage.html?mid=".$r['id'];?>" class="cbOpenSmall text-black"><i class="fa fa-comment ml-2"></i></a>
            <a href="/cb_message_delete.php?id=<?= $r['id'];?>" class="cbOpenSmall text-black"><i class="fa fa-times-circle ml-2"></i></a>
        </div>
    </div>

    <?php
        }
    ?>


</div>