<h2>Editing File: /home/nudhamca/client.nudhamcapital.co.uk/dashboard/viewloans.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
session_start();
include_once ('../include/session.php');
require_once '../include/class.user.php';
if (!isset($_SESSION['acc_no'])) {
    header(&quot;Location: login.php&quot;);
    exit();
}


$reg_user = new USER();

$stmt = $reg_user-&gt;runQuery(&quot;SELECT * FROM account WHERE acc_no=:acc_no&quot;);
$stmt-&gt;execute(array(&quot;:acc_no&quot; =&gt; $_SESSION['acc_no']));
$row = $stmt-&gt;fetch(PDO::FETCH_ASSOC);


$email = $row['email'];

$temp = $reg_user-&gt;runQuery(&quot;SELECT * FROM ticket WHERE email = '$email' &quot;);
$temp-&gt;execute(array(&quot;:acc_no&quot; =&gt; $_SESSION['acc_no']));
$rows = $temp-&gt;fetch(PDO::FETCH_ASSOC);


?&gt;
&lt;?php include 'mheader.php';
?&gt;
&lt;title&gt;Loan Statement&lt;/title&gt;


&lt;!-- content @s --&gt;
                &lt;div class=&quot;nk-content nk-content-fluid&quot;&gt;
                    &lt;div class=&quot;container-xl wide-lg&quot;&gt;
                        &lt;div class=&quot;nk-content-body&quot;&gt;
                            &lt;div class=&quot;components-preview wide-md mx-auto&quot;&gt;
                                &lt;div class=&quot;nk-block-head nk-block-head-lg wide-sm&quot;&gt;
                                    &lt;div class=&quot;nk-block-head-content&quot;&gt;
                                        &lt;br&gt;
                                        &lt;h2 class=&quot;nk-block-title fw-normal&quot;&gt;Loan Statement&lt;/h2&gt;
                                        
                                    &lt;/div&gt;
                                &lt;/div&gt;&lt;!-- .nk-block-head --&gt;
                                &lt;div class=&quot;nk-block nk-block-lg&quot;&gt;
                                    &lt;div class=&quot;nk-block-head&quot;&gt;
                                        &lt;div class=&quot;nk-block-head-content&quot;&gt;
                                            &lt;h4 class=&quot;nk-block-title&quot;&gt;History&lt;/h4&gt;
                                            
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;card card-preview&quot;&gt;
                                        &lt;div class=&quot;card-inner&quot;&gt;
        &lt;table class=&quot;datatable-init-export nowrap table&quot; data-export-title=&quot;Export&quot;&gt;
                   &lt;thead&gt;
                      &lt;tr&gt;
						&lt;th class=&quot;no-sort&quot; style=&quot;width:1%&quot;&gt;Loan ID&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;Months&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;Amount&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;Reason&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;Date&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;Status&lt;/th&gt;
						 
						
					&lt;/tr&gt;
				&lt;/thead&gt;
				&lt;tbody&gt;
				 &lt;?php
                $acc_no = $_SESSION['acc_no'];
				$email = $row['email'];
				$his = $reg_user-&gt;runQuery(&quot;SELECT * FROM ticket WHERE email = '$email'&quot;);
				$his-&gt;execute(array(&quot;:acc_no&quot;=&gt;$_SESSION['acc_no']));
				while($rows = $his-&gt;fetch(PDO::FETCH_ASSOC)){?&gt;
					&lt;tr&gt;
					   &lt;td&gt;&lt;?php echo $rows['tc']; ?&gt;&lt;/td&gt;
					   &lt;td&gt;&lt;?php echo $rows['mail']; ?&gt;&lt;/td&gt;
                       &lt;td&gt;&lt;?php echo $rows['subject']; ?&gt;&lt;/td&gt;
                       &lt;td&gt;&lt;?php echo $rows['msg']; ?&gt;&lt;/td&gt;
                       &lt;td&gt;&lt;?php echo $rows['date']; ?&gt;&lt;/td&gt;
                       &lt;td&gt;&lt;?php echo $rows['status']; ?&gt;&lt;/td&gt;
						
					&lt;/tr&gt;
				&lt;?php } ?&gt;
				&lt;/tbody&gt;
			&lt;/table&gt;
        &lt;/div&gt;
              
                              &lt;/div&gt;&lt;!-- .card-preview --&gt;
                                &lt;/div&gt; &lt;!-- nk-block --&gt;    
    
	&lt;/div&gt;
                                    &lt;/div&gt; 
                                &lt;/div&gt;&lt;/div&gt;
                                &lt;/div&gt;
                                &lt;/div&gt;                          
   &lt;?php include 'mfooter.php';
?&gt;                             </textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fhome%2Fnudhamca%2Fclient.nudhamcapital.co.uk%2Fdashboard'>Back to Directory</a>