my_commands.php

<?php $page_name = 'My Commands'; include('../includes/header.php'); ?>
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.4/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="../assets2/css/memnav.css">

<?php
 if(isset($_SESSION['user_id']))
 {
    $user_id = $_SESSION['user_id'];
    $query_log = mysqli_query($conn,"SELECT * FROM iv_mem_details WHERE iv_mem_details_id ='$user_id'");
    $row_log = mysqli_fetch_assoc($query_log);
 }
 else
 {
    $_SESSION['page_name'] =$_SERVER['REQUEST_URI'];  
   echo "<script>window.location.href='../signin'</script>";
 }
?>

<div id="content">

<div class="container-fluid">
    <div class="row m-4">
        <div class="col-md-12">
            <table id="example" class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <th>S.no</th>
                        <th>Blog</th>
                        <th>Command</th>
                        <th>date</th>
                        <th>View</th>
                    </tr>
                </thead>
                 <tbody>
                    <?php 
                    $i=1;
                        $query = mysqli_query($conn,"SELECT * FROM iv_comments WHERE iv_comments_user_id = '$user_id'");
                        while($row = mysqli_fetch_assoc($query))
                        {
                    ?>
                    <tr>
                        <td><?php echo $i; ?></td>
                        <td>
                            <?php
                            $bid = $row['blog_id'];
                            $bq = mysqli_query($conn,"SELECT iv_blogs_title FROM iv_blogs WHERE iv_blogs_id='$bid'");
                            $rq = mysqli_fetch_assoc($bq);
                            echo $rq['iv_blogs_title'];
                            ?>
                        </td>
                        <td> <?php 
                            $myString = $row['iv_comments_cmt'];
                            if (strlen($myString) > 100) {
                                            echo substr($myString, 0, 100) . '...';
                                             } else {
                                            echo $myString;
                                            }
                            ?></td>
                        <td><?php echo $row['created_date']; ?></td>
                        <td><a class="text-dark" href="../blogs_details.php?blog_id=<?php echo $bid  ?>#cm<?php echo $row['iv_comments_id']; ?>">View <i class="fa fa-eye"></i></i></a></td>
                    </tr>
                    <?php
                    $i++;
                        }
                    ?>
                </tbody>
            </table>
        </div>
    </div>
</div>
    </div>
</div>

<?php include('../includes/footer.php') ?>
<script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.13.4/js/dataTables.bootstrap4.min.js"></script>

$('.sub').hide();

$('#sub').change(function () {
            if ($('#sub').val() == 'Other Subject - not listed here') {
                $('.sub').show();
            } else {
                $('.sub').hide();
            }
        });
    });
</script>

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/training

	.	4096
	..	4096
X	.htaccess	2089
X	booking_summary.php	3332
X	chat_rights.php	1926
X	contact_us.php	6073
X	delete_account.php	2684
X	download_level.php	1645
X	download_summary.php	3041
X	edit_profile.php	51581
X	forget_password.php	3435
X	group_chat.php	5176
	includes	4096
X	index.php	1785
X	my_chat_summary.php	1699
X	my_commands.php	3923
X	my_donations.php	6225
X	my_event_booking.php	3931
X	my_profile.php	8940
X	my_training.php	7661
X	otp_verification.php	2312
X	prayer_summary.php	2854
X	subscription.php	5278