.-.-.-.-.-

<?php
$title = "Inbox";
include 'header.php';
//include_once('lib/ps_pagination.php');
?>
<div class="container-fluid">
<?php echo getMessage(); ?>
    <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);">Lexa</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 table-bordered table-striped">
                        <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`='admin' ORDER BY `datetime` DESC";

$rs = mysqli_query($connection, $query);
//                            $i = 1;
                            if ($rs) {
                                while ($row = mysqli_fetch_object($rs)) {
                                    $name = mysqli_fetch_object(mysqli_query($connection, "SELECT login_id, name FROM user WHERE uid='" . $row->by . "'"));
                                    ?>
                                    <tr>
                                        <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 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
                                }
                            }
                            ?>
                        </tbody>
                    </table>
                    <?php //echo $pager->renderFullNav();      ?>  
                </div>
            </div>
        </div> 
    </div>
    
</div>
<?php include 'footer.php'; ?>

/home2/wtmwscom/public_html/post/../doc/../mail/../admin/inbox.php