.-.-.-.-.-

<?php
$title = "Inbox";
include 'header.php';
//include_once('../../lib/ps_pagination.php');
$uid = $_SESSION['userid'];
?>
<?php echo getMessage(); ?>

<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Inbox</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="javascript:void(0);">Home</a></li>
                    <li class="breadcrumb-item"><a href="javascript:void(0);">Support</a></li>
                    <li class="breadcrumb-item active">Inbox</li>
                </ol>

</div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-20">
                <div class="card-body">

<table class="table mb-0 datatable">
                        <thead>
                            <tr>
                                <th>Subject</th>
                                <th>Message</th>
                                <th>Sender</th>
                                <th>Time</th>
                                <th>Attach File</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $query = "SELECT `id`, `by`, `to`, LEFT(subject,50) as subject, LEFT(message,50) as message, `filename`, `datetime`, `read` FROM `message` WHERE `to`='" . $uid . "' ORDER BY `datetime` DESC";

$rs = mysqli_query($connection, $query);
                            $i = 1;
                            if ($rs) {
                                while ($row = mysqli_fetch_object($rs)) {
                                    ?>
                                    <tr>
                                        <td><?php echo $i; ?></td>
                                        <td><span <?php if ($row->read == 0) { ?> style="font-weight: bold;"<?php } ?>><?php echo $row->subject; ?></span></td>
                                        <td><a href="full_message.php?id=<?php echo $row->id; ?>" <?php if ($row->read == 0) { ?> style="font-weight: bold;"<?php } ?>><?php echo $row->message; ?></a></td>
                                        <td><?php
                                            if ($row->by == 'admin') {
                                                echo 'Admin';
                                            } else {
                                                echo $name->name . " (" . $name->login_id . ")";
                                            }
                                            ?></td>
                                        <td><?php echo date("d M, Y h:i A", strtotime($row->datetime)); ?></td>
                                        <td>
                                            <?php if (file_exists("../static/backend/user-resource/uploads/attachment/" . $row->filename) && $row->filename != '') { ?>
                                                <a href="../static/backend/user-resource/uploads/attachment/<?php echo $row->filename; ?>" target="_blank">View File</a>
                                    <?php } ?>
                                        </td>
                                    </tr>
                                    <?php
                                    $i++;
                                }
                            }
                            ?>
                        </tbody>
                    </table>
<?php //echo $pager->renderFullNav();     ?>  
                </div>
            </div>
        </div> 
    </div>
    
</div>

<?php include 'footer.php'; ?>

/home2/wtmwscom/./public_html/member/inbox.php