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/sabrinaluxebraidedwigs.com/public_html/ |
<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']);
include("header.php"); ?>
<?php
if (isset($_GET['product'])){
$product_id = mysqli_real_escape_string($con,$_GET['product']);
$stmt = $con -> prepare('SELECT * FROM products WHERE product_id=?');
$stmt -> bind_param('s',$product_id);
$stmt -> execute();
$stmt -> store_result();
$stmt -> bind_result($product_id,$product_cat,$product_brand,$product_title,$product_price,$product_desc,$product_image,$product_keywords,$old_price,$new_tag,$home_products,$tags,$in_stock,$featured,$picture2,$picture3,$picture4,$picture5,$picture6);
$numrows = $stmt -> num_rows();
if($numrows > 0){
while ($stmt -> fetch()) { }
}
//get category name
$get_categories = mysqli_query($con,"SELECT * FROM categories WHERE cat_id=$product_cat");
$count_categories = mysqli_num_rows($get_categories);
if($count_categories > 0){
while($row = mysqli_fetch_array($get_categories)){
$cat_id = $row["cat_id"];
$cat_title = $row["cat_title"];
}//end of while loop
}
}
else{echo "<meta http-equiv=\"refresh\" content=\"0; url=index.php\">";exit();}
?>
<title><?php echo $company_name; ?> - <?php echo $product_title; ?></title>
<div class="col-md-12 col-xs-12" id="product_msg"></div>
<!-- breadcrumb -->
<div class="bread-crumb bgwhite flex-w p-l-52 p-r-15 p-t-30 p-l-15-sm">
<a href="index.php" class="s-text16">
Home
<i class="fa fa-angle-right m-l-8 m-r-9" aria-hidden="true"></i>
</a>
<a href="products.php" class="s-text16">
Products
<i class="fa fa-angle-right m-l-8 m-r-9" aria-hidden="true"></i>
</a>
<span class="s-text17">
<?php echo"$product_title"; ?>
</span>
</div>
<!-- Product Detail -->
<div class="container bgwhite p-t-35 p-b-80">
<div class="flex-w flex-sb">
<div class="w-size13 p-t-30 respon5">
<div class="wrap-slick3 flex-sb flex-w">
<div class="wrap-slick3-dots"></div>
<div class="slic"style=''>
<script src="js/jssor.slider-28.1.0.min.js" type="text/javascript"></script>
<script type="text/javascript">
window.jssor_1_slider_init = function() {
var jssor_1_SlideshowTransitions = [
{$Duration:800,x:0.3,$During:{$Left:[0.3,0.7]},$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:-0.3,$SlideOut:true,$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:-0.3,$During:{$Left:[0.3,0.7]},$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:0.3,$SlideOut:true,$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:0.3,$During:{$Top:[0.3,0.7]},$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:-0.3,$SlideOut:true,$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:-0.3,$During:{$Top:[0.3,0.7]},$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:0.3,$SlideOut:true,$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:0.3,$Cols:2,$During:{$Left:[0.3,0.7]},$ChessMode:{$Column:3},$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:0.3,$Cols:2,$SlideOut:true,$ChessMode:{$Column:3},$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:0.3,$Rows:2,$During:{$Top:[0.3,0.7]},$ChessMode:{$Row:12},$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:0.3,$Rows:2,$SlideOut:true,$ChessMode:{$Row:12},$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:0.3,$Cols:2,$During:{$Top:[0.3,0.7]},$ChessMode:{$Column:12},$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,y:-0.3,$Cols:2,$SlideOut:true,$ChessMode:{$Column:12},$Easing:{$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:0.3,$Rows:2,$During:{$Left:[0.3,0.7]},$ChessMode:{$Row:3},$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:-0.3,$Rows:2,$SlideOut:true,$ChessMode:{$Row:3},$Easing:{$Left:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:0.3,y:0.3,$Cols:2,$Rows:2,$During:{$Left:[0.3,0.7],$Top:[0.3,0.7]},$ChessMode:{$Column:3,$Row:12},$Easing:{$Left:$Jease$.$InCubic,$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,x:0.3,y:0.3,$Cols:2,$Rows:2,$During:{$Left:[0.3,0.7],$Top:[0.3,0.7]},$SlideOut:true,$ChessMode:{$Column:3,$Row:12},$Easing:{$Left:$Jease$.$InCubic,$Top:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,$Delay:20,$Clip:3,$Assembly:260,$Easing:{$Clip:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,$Delay:20,$Clip:3,$SlideOut:true,$Assembly:260,$Easing:{$Clip:$Jease$.$OutCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,$Delay:20,$Clip:12,$Assembly:260,$Easing:{$Clip:$Jease$.$InCubic,$Opacity:$Jease$.$Linear},$Opacity:2},
{$Duration:800,$Delay:20,$Clip:12,$SlideOut:true,$Assembly:260,$Easing:{$Clip:$Jease$.$OutCubic,$Opacity:$Jease$.$Linear},$Opacity:2}
];
var jssor_1_options = {
$AutoPlay: 1,
$SlideshowOptions: {
$Class: $JssorSlideshowRunner$,
$Transitions: jssor_1_SlideshowTransitions,
$TransitionsOrder: 1
},
$ArrowNavigatorOptions: {
$Class: $JssorArrowNavigator$
},
$ThumbnailNavigatorOptions: {
$Class: $JssorThumbnailNavigator$,
$SpacingX: 5,
$SpacingY: 5
}
};
var jssor_1_slider = new $JssorSlider$("jssor_1", jssor_1_options);
/*#region responsive code begin*/
var MAX_WIDTH = 980;
function ScaleSlider() {
var containerElement = jssor_1_slider.$Elmt.parentNode;
var containerWidth = containerElement.clientWidth;
if (containerWidth) {
var expectedWidth = Math.min(MAX_WIDTH || containerWidth, containerWidth);
jssor_1_slider.$ScaleWidth(expectedWidth);
}
else {
window.setTimeout(ScaleSlider, 30);
}
}
ScaleSlider();
$Jssor$.$AddEvent(window, "load", ScaleSlider);
$Jssor$.$AddEvent(window, "resize", ScaleSlider);
$Jssor$.$AddEvent(window, "orientationchange", ScaleSlider);
/*#endregion responsive code end*/
};
</script>
<style>
/*jssor slider loading skin spin css*/
.jssorl-009-spin img {
animation-name: jssorl-009-spin;
animation-duration: 1.6s;
animation-iteration-count: infinite;
animation-timing-function: linear;
}
@keyframes jssorl-009-spin {
from { transform: rotate(0deg); }
to { transform: rotate(360deg); }
}
/*jssor slider arrow skin 106 css*/
.jssora106 {display:block;position:absolute;cursor:pointer;}
.jssora106 .c {fill:#fff;opacity:.3;}
.jssora106 .a {fill:none;stroke:#000;stroke-width:350;stroke-miterlimit:10;}
.jssora106:hover .c {opacity:.5;}
.jssora106:hover .a {opacity:.8;}
.jssora106.jssora106dn .c {opacity:.2;}
.jssora106.jssora106dn .a {opacity:1;}
.jssora106.jssora106ds {opacity:.3;pointer-events:none;}
/*jssor slider thumbnail skin 101 css*/
.jssort101 .p {position: absolute;top:0;left:0;box-sizing:border-box;background:#000;}
.jssort101 .p .cv {position:relative;top:0;left:0;width:100%;height:100%;border:2px solid #000;box-sizing:border-box;z-index:1;}
.jssort101 .a {fill:none;stroke:#fff;stroke-width:400;stroke-miterlimit:10;visibility:hidden;}
.jssort101 .p:hover .cv, .jssort101 .p.pdn .cv {border:none;border-color:transparent;}
.jssort101 .p:hover{padding:2px;}
.jssort101 .p:hover .cv {background-color:rgba(0,0,0,6);opacity:.35;}
.jssort101 .p:hover.pdn{padding:0;}
.jssort101 .p:hover.pdn .cv {border:2px solid #fff;background:none;opacity:.35;}
.jssort101 .pav .cv {border-color:#fff;opacity:.35;}
.jssort101 .pav .a, .jssort101 .p:hover .a {visibility:visible;}
.jssort101 .t {position:absolute;top:0;left:0;width:100%;height:100%;border:none;opacity:.6;}
.jssort101 .pav .t, .jssort101 .p:hover .t{opacity:1;}
@media (max-width: 576px) {
#jssor_1{
width:351px !important;
left:-1%;
}
.second{
width:351px !important;
}
.jssort101{
width:351px !important;
}
.goat{
right:-11px !important;
}
}
@media (min-width: 577px) {
#jssor_1{
width:500px !important;
left:3%;
}
.second{
width:400px !important;
}
.jssort101{
width:500px !important;
}
.goat{
right:91px !important;
}
}
</style>
<div id="jssor_1" style="position:relative;margin:0 auto;top:0px;height:600px;overflow:;visibility:hidden;">
<!-- Loading Screen -->
<div data-u="loading" class="jssorl-009-spin" style="position:absolute;top:0px;left:0px;width:100%;height:100%;text-align:center;background-color:rgba(0,0,0,0.7);">
<img style="margin-top:-19px;position:relative;top:50%;width:38px;height:38px;" src="images/spin.svg" />
</div>
<div data-u="slides" class='second' style="cursor:default;position:relative;top:0px;left:0px;height:400px;overflow:hidden;">
<?php
echo"
<div>
<img data-u='image' src='$admin_no/assets/img/products/$product_image' />
<img data-u='thumb' src='$admin_no/assets/img/products/$product_image' />
</div>";
if($picture2 !=""){echo"
<div>
<img data-u='image' src='$admin_no/assets/img/products/$picture2' />
<img data-u='thumb' src='$admin_no/assets/img/products/$picture2' />
</div>
";}
if($picture3 !=""){echo"
<div>
<img data-u='image' src='$admin_no/assets/img/products/$picture3' />
<img data-u='thumb' src='$admin_no/assets/img/products/$picture3' />
</div>
";}
if($picture4 !=""){echo"
<div>
<img data-u='image' src='$admin_no/assets/img/products/$picture4' />
<img data-u='thumb' src='$admin_no/assets/img/products/$picture4' />
</div>
";}
if($picture5 !=""){echo"
<div>
<img data-u='image' src='$admin_no/assets/img/products/$picture5' />
<img data-u='thumb' src='$admin_no/assets/img/products/$picture5' />
</div>
";}
if($picture6 !=""){echo"
<div>
<img data-u='image' src='$admin_no/assets/img/products/$picture6' />
<img data-u='thumb' src='$admin_no/assets/img/products/$picture6' />
</div>
";}
?>
</div><a data-scale="0" href="#" style="display:none;position:absolute;"></a>
<!-- Thumbnail Navigator -->
<div data-u="thumbnavigator" class="jssort101" style="position:absolute;left:0px;bottom:80px;height:100px;background-color:#fff;" data-autocenter="1" data-scale-bottom="0.75">
<div data-u="slides">
<div data-u="prototype" class="p" style="width:90px;height:90px;">
<div data-u="thumbnailtemplate" class="t"></div>
<svg viewbox="0 0 16000 16000" class="cv">
<circle class="a" cx="8000" cy="8000" r="3238.1"></circle>
<line class="a" x1="6190.5" y1="8000" x2="9809.5" y2="8000"></line>
<line class="a" x1="8000" y1="9809.5" x2="8000" y2="6190.5"></line>
</svg>
</div>
</div>
</div>
<!-- Arrow Navigator -->
<div data-u="arrowleft" class="jssora106" style="width:55px;height:55px;top:190px;left:5px;" data-scale="0.75">
<img src='images/arrr_left.png'style='width:37px;height:40px;border-radius:5px;'>
</div>
<div data-u="arrowright" class="jssora106 goat" style="width:55px;height:55px;top:190px;" data-scale="0.75">
<img src='images/arrr_right.png'style='width:37px;height:40px;border-radius:5px;'>
</div>
</div>
<script type="text/javascript">jssor_1_slider_init();
</script>
<!-- #endregion Jssor Slider End -->
</div>
</div>
</div>
<div class="w-size14 p-t-30 respon5">
<h4 class="product-detail-name m-text16 p-b-13 greenfont">
<?php echo "$product_title"; ?>
</h4>
<span class="m-text17">
</span>
<span class="m-text17 redfont">
<?php echo $currency ?><?php echo number_format($product_price); ?>
</span>
<p class="s-text8 p-t-10">
<?php echo "$product_desc"; ?>
</p>
<!-- -->
<div class="p-t-33 p-b-60">
<div class="flex-r-m flex-w p-t-10">
<div class="w-size16 flex-m flex-w">
<div class="btn-addcart-product-detail size9 trans-0-4 m-t-10 m-b-10">
<!-- Button -->
<button pid='<?php echo"$product_id";?>' id='product' class="flex-c-m sizefull bg1 bo-rad-23 hov1 s-text1 trans-0-4 redbackground">
Add to Cart
</button>
</div>
</div>
</div>
</div>
<!-- -->
<?php
$stmt_ree = $con -> prepare('SELECT id FROM product_reviews WHERE product_id = ? ORDER BY id DESC');
$stmt_ree -> bind_param('s',$product_id);
$stmt_ree -> execute();
$stmt_ree -> store_result();
$stmt_ree -> bind_result($ree);
$numrows_ree = $stmt_ree -> num_rows();
if($numrows_ree > 0){
while ($stmt_ree -> fetch()) { }}
?>
<div class="row my-5">
<div class="card card-outline-secondary my-4" style='width:100%;'>
<div class="card-header">
<h4>Reviews <?php echo "($numrows_ree)"; ?></h4>
</div>
<div class="card-body">
<?php
$stmt_re = $con -> prepare('SELECT * FROM product_reviews WHERE product_id = ? ORDER BY id DESC');
$stmt_re -> bind_param('s',$product_id);
$stmt_re -> execute();
$stmt_re -> store_result();
$stmt_re -> bind_result($review_id,$review_product_id,$review_user_id,$review,$rating,$review_date);
$numrows_re = $stmt_re -> num_rows();
if($numrows_re > 0){
while ($stmt_re -> fetch()) {
//format date
$date = new DateTime("$review_date");
$review_date_formatted = $date->format('jS M Y');
//get review first and last name
$stmt_na = $con -> prepare('SELECT first_name,last_name FROM users WHERE user_id = ?');
$stmt_na -> bind_param('s',$review_user_id);
$stmt_na -> execute();
$stmt_na -> store_result();
$stmt_na -> bind_result($reviewer_first_name,$reviewer_last_name);
$numrows_na = $stmt_na -> num_rows();
if($numrows_na > 0){
while ($stmt_na -> fetch()) { }}
?>
<div class="media mb-3 rate_container">
<div class="mr-2">
<?php include("rating.php"); ?>
</div>
<div class="media-body">
<p><?php echo $review; ?></p>
<small class="text-muted"><?php echo "$reviewer_first_name $reviewer_last_name - $review_date_formatted"; ?></small>
</div>
</div>
<hr>
<?php } }else{echo"<div>No reviews yet.</div>";} ?>
<a href="review.php?product=<?php echo $product_id; ?>" class="btn hvr-hover">Leave a Review</a>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include("footer.php"); ?>