Server : LiteSpeed System : Linux us-phx-web1202.main-hosting.eu 4.18.0-553.84.1.lve.el8.x86_64 #1 SMP Tue Nov 25 18:33:03 UTC 2025 x86_64 User : u615232177 ( 615232177) PHP Version : 8.1.33 Disable Function : NONE Directory : /home/u615232177/domains/marisgoldunisexboutique.com/public_html/admin0564/ |
<?php use PHPMailer\PHPMailer\PHPMailer;use PHPMailer\PHPMailer\Exception;use PHPMailer\PHPMailer\SMTP; session_start();
$page_name = basename($_SERVER['PHP_SELF']);
include("headerstrict.php"); ?>
<?php
if (isset($_GET['u'])){
$user_id = mysqli_real_escape_string($con,$_GET['u']);
$stmt = $con -> prepare('SELECT * FROM users WHERE user_id=?');
$stmt -> bind_param('s',$user_id);
$stmt -> execute();
$stmt -> store_result();
$stmt -> bind_result($id,$user_id,$first_name,$last_name,$email,$password,$phone,$address,$date_signed_up);
$numrows = $stmt -> num_rows();
if($numrows > 0){
while ($stmt -> fetch()) { }
}
else{echo "<meta http-equiv=\"refresh\" content=\"0; url=index.php\">";exit();}
}
else{echo "<meta http-equiv=\"refresh\" content=\"0; url=index.php\">";exit();}
?>
<title><?php echo $company_name; ?> <?php echo "$first_name $last_name"; ?></title>
<?php
if (isset($_POST["delete"])) {
$stmt = $con -> prepare('DELETE FROM my_orders WHERE user_id = ?');
$stmt -> bind_param('s', $user_id);
$stmt -> execute();
$stmthg = $con -> prepare('DELETE FROM users WHERE user_id = ?');
$stmthg -> bind_param('s', $user_id);
$stmthg -> execute();
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="User successfully deleted.";
echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=users.php&m=$message\">";
}
if (isset($_POST['send_message'])) {
$content = mysqli_real_escape_string($con,$_POST['content']);
$sender ="System";
$receiver = "$user_id";
$seen ="No";
$date_notification = date("D,dS M, Y g:ia");
mysqli_query($con,"INSERT INTO notifications VALUES(
'0',
'$content',
'$sender',
'$receiver',
'$seen',
'$date_notification'
)")or die(mysqli_error($con));
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="Message successfully sent to $first_name.";
echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name?u=$user_id&m=$message\">";
}
?>
<!-- ======= Breadcrumbs ======= -->
<section id="breadcrumbs" class="breadcrumbs">
<div class="container"> </div>
</section>
<!-- End Breadcrumbs -->
<!-- ======= Contact Section ======= -->
<section id="contact" class="contact inner-page">
<div class="container" data-aos="fade-up">
<div class="section-title">
<h2><?php echo"$first_name $last_name"; ?></h2>
<p></p>
</div>
<div class="row">
<div class="col-lg-6">
<?php
echo"
User - <span class='number_bx' style='font-weight:900;width:100%;'>$first_name $last_name</span><br/>
Email - <span class='number_bx'>$email</span><br/>
Phone - <span class='number_bx'>$phone</span><br/>
<br/>
Signed up <b>$date_signed_up</b><br/>
Address <b>$address</b>
";
?>
<form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?><?php echo"?u=$user_id"; ?>" method="post" class="php-email-form1" enctype='multipart/form-data'>
<div class='text-center'>
<button type='submit' name='delete'>Delete User</button>
</div>
</form>
</div>
<div class="col-lg-6">
<br/><br/>
<form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?><?php echo"?u=$user_id"; ?>" method="post" enctype='multipart/form-data'>
<div class='form-group col-md-12'>
<textarea name='content' class='form-control' placeholder='Send <?php echo $first_name; ?> a message' required></textarea>
</div>
<div class='text-center php-email-form1'>
<button type='submit' name='send_message'>Send Message</button>
</div>
</form>
</div>
</div><!-- end row -->
<br/><br/>
<div class="section-title">
<h2><?php echo"$first_name $last_name"; ?>'s Orders</h2>
<p></p>
</div>
<div class="row">
<?php
$sql = "SELECT COUNT(id) FROM my_orders WHERE user_id='$user_id'";
$query = mysqli_query($con, $sql);
$row = mysqli_fetch_row($query);
//here we have the total row count
$rows = $row[0];
//number of results we want per page
$page_rows = 50;
//tells us the page number of our last page
$last = ceil($rows/$page_rows);
//this makes sure last cannot be less than 1
if($last < 1){$last = 1;}
//establish the page num variable
$pagenum = 1;
//Get pageum from $GET if it is present, else its 1
if(isset($_GET['pn'])){
$pagenum = preg_replace('#[^0-9]#', '', $_GET['pn']);
}
//below 1 or more than last page
if($pagenum < 1){
$pagenum = 1;
}else if ($pagenum > $last) {
$pagenum = $last;
}
//this sets the range of rows to query for the chosen pagenum
$limit = 'LIMIT ' .($pagenum - 1) * $page_rows .',' .$page_rows;
//grabs one page worth of rows
$sql = "SELECT * FROM my_orders WHERE user_id='$user_id' $limit ";
$query = mysqli_query($con, $sql);
//this shows the user what page they on and total number
$textline1 = "Messages $rows";
$textline2 = "Page $pagenum of $last";
//establish the pagination controls
$paginationCtrls = "";
//if there is more than one page worth of results
if($last != 1){
if($pagenum > 1){
$previous = $pagenum - 1;
//$paginationCtrls .='<a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Previous</a>  ';
$paginationCtrls .='<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Prev</a></li>';
//render clickable links to the left of target page number
for($i = $pagenum-4; $i < $pagenum; $i++){
if($i > 0){
//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'"></a> ';
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
}
}
}
//render target number bt not link
//$paginationCtrls .= ''.$pagenum.' ';
$paginationCtrls .= '<span class="pagination"><ul><li class="active"><a href="#">'.$pagenum.'</a></li></ul></span>';
//render clickable number links to the right of target number
for($i = $pagenum+1; $i <= $last; $i++){
//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a> ';
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
if($i >= $pagenum+4){
break;
}
}
//this does the same as above, only checking if we are on the last page
if($pagenum != $last) {
$next = $pagenum + 1;
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$next.'">Next</a></li>';
}
}
if(mysqli_num_rows($query) > 0 ){$countt=0;
while ($row_ads = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
$id = $row_ads['id'];
$order_id = $row_ads['order_id'];
echo"
<div class='col-md-2'>
<a href='order_details.php?order_id=$order_id' style='font-size:16px;text-decoration:underline;'>$order_id</a>
</div>
";?>
<?php
}//end of while
}
else{echo"$first_name has not made any orders.";}
?>
</div>
</div>
<div class="col-12 text-center"><br/><br/>
<ul class="pagination clearfix">
<?php
echo"$paginationCtrls<br/><br/><br/><br/>";
echo "<div class='text_line'>$textline2</div>";
?>
</ul>
</div>
<br/><br/>
<div class="section-title">
<h2><?php echo"$first_name $last_name"; ?>'s Inbox</h2>
<p></p>
</div>
<div class='container'>
<div class="row">
<?php
$sql = "SELECT COUNT(id) FROM notifications WHERE receiver='$user_id'";
$query = mysqli_query($con, $sql);
$row = mysqli_fetch_row($query);
//here we have the total row count
$rows = $row[0];
//number of results we want per page
$page_rows = 50;
//tells us the page number of our last page
$last = ceil($rows/$page_rows);
//this makes sure last cannot be less than 1
if($last < 1){$last = 1;}
//establish the page num variable
$pagenum = 1;
//Get pageum from $GET if it is present, else its 1
if(isset($_GET['pn'])){
$pagenum = preg_replace('#[^0-9]#', '', $_GET['pn']);
}
//below 1 or more than last page
if($pagenum < 1){
$pagenum = 1;
}else if ($pagenum > $last) {
$pagenum = $last;
}
//this sets the range of rows to query for the chosen pagenum
$limit = 'LIMIT ' .($pagenum - 1) * $page_rows .',' .$page_rows;
//grabs one page worth of rows
$sql = "SELECT * FROM notifications WHERE receiver='$user_id' $limit ";
$query = mysqli_query($con, $sql);
//this shows the user what page they on and total number
$textline1 = "Messages $rows";
$textline2 = "Page $pagenum of $last";
//establish the pagination controls
$paginationCtrls = "";
//if there is more than one page worth of results
if($last != 1){
if($pagenum > 1){
$previous = $pagenum - 1;
//$paginationCtrls .='<a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Previous</a>  ';
$paginationCtrls .='<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Prev</a></li>';
//render clickable links to the left of target page number
for($i = $pagenum-4; $i < $pagenum; $i++){
if($i > 0){
//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'"></a> ';
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
}
}
}
//render target number bt not link
//$paginationCtrls .= ''.$pagenum.' ';
$paginationCtrls .= '<span class="pagination"><ul><li class="active"><a href="#">'.$pagenum.'</a></li></ul></span>';
//render clickable number links to the right of target number
for($i = $pagenum+1; $i <= $last; $i++){
//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a> ';
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
if($i >= $pagenum+4){
break;
}
}
//this does the same as above, only checking if we are on the last page
if($pagenum != $last) {
$next = $pagenum + 1;
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$next.'">Next</a></li>';
}
}
if(mysqli_num_rows($query) > 0 ){$countt=0;
while ($row_ads = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
$noti_id = $row_ads['id'];
$content = $row_ads['content'];
$sender = $row_ads['sender'];
$reciever = $row_ads['receiver'];
$seen = $row_ads['seen'];
$date_noti = $row_ads['date'];
echo"
<div class='col-md-3'>
<hr>
<b>$content</b></br>
Read - $seen<br>
Date - $date_noti
<form action='user_details.php?u=$user_id' method='post' class='php-email-form1' enctype='multipart/form-data'>
<div class='text-center'>
<button type='submit' name='delete_noti$noti_id'>Delete</button>
</div>
</form>
<hr>
</div>
";
if (isset($_POST["delete_noti$noti_id"])) {
$stmt = $con -> prepare('DELETE FROM notifications WHERE id = ?');
$stmt -> bind_param('s', $noti_id);
$stmt -> execute();
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="Message successfully deleted.";
echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=user_details.php?u=$user_id&m=$message\">";
}
?>
<?php
}//end of while
}
else{echo"$first_name has no messages.";}
?>
</div>
</div>
<div class="col-12 text-center"><br/><br/>
<ul class="pagination clearfix">
<?php
echo"$paginationCtrls<br/><br/><br/><br/>";
echo "<div class='text_line'>$textline2</div>";
?>
</ul>
</div>
</div>
</section><!-- End Contact Section -->
<?php include("footer.php"); ?>