<h2>File Contents: /home/u885320773/domains/sugatu.in/public_html/admin/testimonial-list.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/public_html/admin/testimonial-list.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php include 'includes/check-session.php'; ?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
    &lt;head&gt;
        &lt;meta charset=&quot;utf-8&quot; /&gt;
        &lt;title&gt;Testimonials - Sugatu&lt;/title&gt;
        &lt;meta http-equiv=&quot;x-ua-compatible&quot; content=&quot;ie=edge&quot; /&gt;
        &lt;meta name=&quot;description&quot; content=&quot;&quot; /&gt;
        &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1&quot; /&gt;
        &lt;meta property=&quot;og:title&quot; content=&quot;&quot; /&gt;
        &lt;meta property=&quot;og:type&quot; content=&quot;&quot; /&gt;
        &lt;meta property=&quot;og:url&quot; content=&quot;&quot; /&gt;
        &lt;meta property=&quot;og:image&quot; content=&quot;&quot; /&gt;
        &lt;!-- Favicon --&gt;
        &lt;link rel=&quot;shortcut icon&quot; type=&quot;image/x-icon&quot; href=&quot;assets/imgs/theme/favicon.png&quot; /&gt;
        &lt;!-- Template CSS --&gt;
        &lt;link href=&quot;assets/css/main.css?v=1.1&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&gt;
    &lt;/head&gt;

    &lt;body&gt;
        &lt;div class=&quot;screen-overlay&quot;&gt;&lt;/div&gt;
        &lt;!--==========  SIDEBAR LOGO AND MENU  =============--&gt;
        &lt;?php include 'includes/sidebar.php'; ?&gt;
        &lt;main class=&quot;main-wrap&quot;&gt;
            &lt;!--==========  HEADER  =============--&gt;
            &lt;?php include 'includes/header.php'; ?&gt;
            &lt;section class=&quot;content-main&quot;&gt;
                &lt;div class=&quot;content-header&quot;&gt;
                    &lt;div&gt;
                        &lt;h2 class=&quot;content-title card-title&quot;&gt;Testimonials&lt;/h2&gt;
                        
                    &lt;/div&gt;
                    &lt;div&gt;
                      
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div class=&quot;card&quot;&gt;
                    
                    &lt;div class=&quot;card-body&quot;&gt;
                    &lt;?php	if(isset($_GET['add'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Successfully Added&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
                &lt;?php	if(isset($_GET['active'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Vendor Account Activated Successfully&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
        &lt;?php	if(isset($_GET['edit'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Successfully Edited&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
				&lt;?php	if(isset($_GET['delete'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Successfully Deleted&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
								&lt;?php	if(isset($_GET['error'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Error While Adding Record&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
				
				
				
                        &lt;div class=&quot;row&quot;&gt;
                           
                            &lt;div class=&quot;col-md-12&quot;&gt;
                                &lt;div class=&quot;&quot;&gt;
                                &lt;?php
include 'config.php';

// SQL query to fetch data from the table
$sql = &quot;SELECT * FROM testimonials ORDER BY id DESC&quot;;

$result = $conn-&gt;query($sql);

if ($result-&gt;num_rows &gt; 0) {


    // Output data of each row
    echo '&lt;table class=&quot;table table-hover&quot;&gt;
                &lt;thead&gt;
                    &lt;tr&gt;
                        &lt;th&gt;Image&lt;/th&gt;
                        &lt;th&gt;Testimonial Title&lt;/th&gt;
                        &lt;th&gt;Date&lt;/th&gt;
                        &lt;th class=&quot;text-end&quot;&gt;Action&lt;/th&gt;
                    &lt;/tr&gt;
                &lt;/thead&gt;
                &lt;tbody&gt;';
    while($row = $result-&gt;fetch_assoc()) {
        $original_date = $row['created_at'];
        $date = new DateTime($original_date);
        $formatted_date = $date-&gt;format('d-m-Y');
      
        echo '&lt;tr&gt;
                &lt;td&gt;&lt;img src=&quot;' . $row['image_name'] . '&quot; style=&quot;height:70px; width:70px;&quot;&gt;&lt;/td&gt;
                &lt;td&gt;&lt;b&gt;' . $row['name'] . '&lt;/b&gt;&lt;/td&gt;
                &lt;td&gt;' . $formatted_date . '&lt;/td&gt;
                &lt;td class=&quot;text-end&quot;&gt;
                    &lt;div class=&quot;dropdown&quot;&gt;
                        &lt;a href=&quot;#&quot; data-bs-toggle=&quot;dropdown&quot; class=&quot;btn btn-light rounded btn-sm font-sm&quot;&gt; &lt;i class=&quot;material-icons md-more_horiz&quot;&gt;&lt;/i&gt; &lt;/a&gt;
                        &lt;div class=&quot;dropdown-menu&quot;&gt;
                            &lt;a class=&quot;dropdown-item text-primary&quot; href=&quot;testimonial-details.php?id=' . $row[&quot;id&quot;] . '&quot;&gt;View / Edit Testimonials&lt;/a&gt;
                            &lt;a class=&quot;dropdown-item text-danger&quot; href=&quot;process/delete-testimonial.php?id=' . $row[&quot;id&quot;] . '&quot;&gt;Delete Testimonials&lt;/a&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/td&gt;
            &lt;/tr&gt;';
    }
    echo '&lt;/tbody&gt;&lt;/table&gt;';
} else {
    echo &quot;0 results&quot;;
}

// Close connection
$conn-&gt;close();
?&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                            &lt;!-- .col// --&gt;
                        &lt;/div&gt;
                        &lt;!-- .row // --&gt;
                    &lt;/div&gt;
                    &lt;!-- card body .// --&gt;
                &lt;/div&gt;
                &lt;!-- card .// --&gt;
            &lt;/section&gt;
            &lt;!-- content-main end// --&gt;
            &lt;footer class=&quot;main-footer font-xs&quot;&gt;
                &lt;div class=&quot;row pb-30 pt-15&quot;&gt;
                    &lt;div class=&quot;col-sm-6&quot;&gt;
                        &lt;script&gt;
                            document.write(new Date().getFullYear());
                        &lt;/script&gt;
                        &amp;copy; Sugatu .
                    &lt;/div&gt;
                    &lt;div class=&quot;col-sm-6&quot;&gt;
                        &lt;div class=&quot;text-sm-end&quot;&gt;All rights reserved&lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/footer&gt;
        &lt;/main&gt;
        &lt;script src=&quot;assets/js/vendors/jquery-3.6.0.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/select2.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/perfect-scrollbar.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/jquery.fullscreen.min.js&quot;&gt;&lt;/script&gt;
        &lt;!-- Main Script --&gt;
        &lt;script src=&quot;assets/js/main.js?v=1.1&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;/body&gt;
&lt;/html&gt;
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fu885320773%2Fdomains%2Fsugatu.in%2Fpublic_html%2Fadmin'>⬅ Back to Directory</a>