Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/www/website_93b53270/admin/manage_model/ |
Upload File : |
<?php
error_reporting(0);
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');
}
$login_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));
// Sidebar strat
include('../include/sidebar.php');
// Sidebar wrap
$id=$_GET['id'];
?>
<!-- [ Main Content ] start -->
<section class="pcoded-main-container">
<div class="pcoded-content">
<!-- [ breadcrumb ] start -->
<div class="page-header">
<div class="page-block">
<div class="row align-items-center">
<div class="col-md-12">
<div class="page-header-title">
<div class="card-header d-flex justify-content-between">
<button class="btn btn-dark text-light fw-bold btn-sm btn-round has-ripple"><i class="feather icon-edit"></i> Add | Edit | Model </button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->
<!-- [ Main Content ] start -->
<div class="row">
<div class="col-md-12">
<div class="card">
<!-- <div class="card-header d-flex justify-content-between">
</div> -->
<div class="card-body">
<?php if(isset($_SESSION['img_error'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i> <strong class="text-dark">'.$_SESSION['img_error'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['img_error']);
?>
<?php
$fetQuery=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM model_tbl WHERE id='$id'"));
?>
<form method="post" action="" enctype="multipart/form-data" autocomplete="off">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="status">Car Brand</label>
<select class="form-select" name="brand_id" id="brand_id" required>
<option value="">Please select Car Brand</option>
<?php $query = mysqli_query($conn, "SELECT * FROM `brand_tbl` WHERE status = 1");
while($mysqli_fet = mysqli_fetch_array($query)){
?>
<option value="<?=$mysqli_fet['id']?>" <?=($fetQuery['brand_id']==$mysqli_fet['id'])?'selected':'';?>><?=$mysqli_fet['name']?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="status">Car Variant</label>
<select class="form-select" name="variant_id" id="variant_id" required>
<option value="">Please First select Car Brand</option>
<!-- </?php $query = mysqli_query($conn, "SELECT * FROM `brand_tbl` WHERE status = 1");
while($mysqli_fet = mysqli_fetch_array($query)){
?>
<option value="<?=$mysqli_fet['id']?>" <?=($fetQuery['variant_id']==$mysqli_fet['id'])?'selected':'';?>><?=$mysqli_fet['title']?></option>
</?php } ?> -->
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="title">Model Name</label>
<input type="text" name="title" class="form-control" value="<?php if($id!=''){echo $fetQuery['title'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="commission_rate">Image</label>
<input type="file" name="image1" id="picture" class="form-control">
<p id="error1" style="display:none; color:#FF0000;">
Invalid File Format! File Format Must Be JPG, JPEG, PNG , Webp, MP4 OR MKV.
</p>
<p id="error2" style="display:none; color:#FF0000;">
File size must be less than 20MB
</p>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="status">Status</label>
<select class="form-select" name="status" required>
<option value="">Please select status</option>
<option value="1" <?=($fetQuery['status']=='1')?'selected':'';?>>Show</option>
<option value="0" <?=($fetQuery['status']=='0')?'selected':'';?>>Hide</option>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<?php
if(($id!='')){ ?>
<img src="<?=$base_url?>images/Upload/model/<?=$fetQuery['image1']?>" class="pb-2" style="width:120px; height:120px;">
<?php } ?>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<?php
if(($id!='')){
echo'<input type="submit" name="update" class="btn btn-success" value="Update">';
}else{
echo'<input type="submit" name="add" class="btn btn-success" value="Add">';
}
?>
<button class="btn btn-dark"><a class="text-white" href="show.php?page=mod">Back</a></button>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<?php include('../include/footer.php'); ?>
<script>
$(document).ready(function(){
$('#brand_id').on('change', function() {
var brand_id = this.value;
$.ajax({
url: "variant-ajax.php",
type: "POST",
data: {
brand_id: brand_id
},
cache: false,
success: function(result){
$("#variant_id").html(result);
}
});
});
// $('#variant_id').on('change', function() {
// var variant_id = this.value;
// $.ajax({
// url: "model-ajax.php",
// type: "POST",
// data: {
// variant_id: variant_id
// },
// cache: false,
// success: function(result){
// $("#model_id").html(result);
// }
// });
// });
});
</script>
<!-- Insert data start --->
<?php
if(isset($_POST['add'])){
$brand_id=$_POST['brand_id'];
$variant_id=$_POST['variant_id'];
$title=$_POST['title'];
$title=str_replace("'", "\'", $title);
$file_name=$_FILES['image1']['name'];
$file_tmp=$_FILES['image1']['tmp_name'];
$file_ext=strtolower(end(explode('.',$_FILES['image1']['name'])));
$num=rand();
$new_filename=$num.".".$file_ext;
$path="../../images/Upload/model/".$new_filename;
move_uploaded_file($file_tmp,$path);
$slug=create_url($title);
$status=$_POST['status'];
$addQry=mysqli_query($conn,
"INSERT `model_tbl` SET
`brand_id`='$brand_id',
`variant_id`='$variant_id',
`title`='$title',
`image1`='$new_filename',
`slug`='$slug',
`status`='$status'")or die(mysqli_error($conn));
// update slug code Start //
$ido = mysqli_insert_id($conn);
$slug1 = create_url($file_name).$ido;
mysqli_query($conn,"UPDATE `model_tbl` SET `slug`='$slug1' WHERE id='$ido'");
// update slug code End //
if($addQry){
echo "<script>window.location='show.php?page=mod';</script>";
$_SESSION['message']="Record Insertted successfully";
}
}
?>
<!-- Insert data warp --->
<!-- Update data start --->
<?php
if(isset($_POST['update'])){
$brand_id=$_POST['brand_id'];
$variant_id=$_POST['variant_id'];
$title=$_POST['title'];
$title=str_replace("'", "\'", $title);
$file_name=$_FILES['image1']['name'];
$file_tmp=$_FILES['image1']['tmp_name'];
$file_ext=strtolower(end(explode('.',$_FILES['image1']['name'])));
$num=rand();
$new_filename=$num.".".$file_ext;
$path="../../images/Upload/model/".$new_filename;
if(!empty($file_name))
{
$dl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `model_tbl` WHERE id='$id'"));
if($dl)
{
unlink('../../images/Upload/model/'.$dl['image1']);
}
move_uploaded_file($file_tmp,$path);
mysqli_query($conn,"UPDATE `model_tbl` SET `image1`='$new_filename' WHERE id='$id'")or die(mysqli_error($conn));
}
$slug=create_url($title).$id;
$status=$_POST['status'];
$editQry=mysqli_query($conn,"UPDATE `model_tbl` SET
`brand_id`='$brand_id',
`variant_id`='$variant_id',
`title`='$title',
`slug`='$slug',
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn));
if($editQry){
echo "<script>window.location='show.php?page=mod';</script>";
$_SESSION['message']="Record Updated successfully";
}
}
?>
<!-- Update data warp --->