Manager

Back Back Up Advanced Editor

<?php

if(isset($_POST['add']))

{

$name    		= mysqli_real_escape_string($cn,$_POST['name']);

$image	      	= $_FILES['image']['name'];

$sort_order    	= $_POST['sort_order'];

$staus  	    = $_POST['status'];

$menu_type      = $_POST['menu_type'];

$slug_url		= mysqli_real_escape_string($cn,$_POST['slug_url']);

$validation = 1;

if(!empty($image))

{

$imgExe = explode(".",$image);

if($imgExe[1]=='jpg' or $imgExe[1]=='jpeg' or $imgExe[1]=='png')

{

move_uploaded_file ($_FILES['image']['tmp_name'],'../categorys/'.$image);

}

else

{

$error = "Only .jpg, .jpeg, .png Allow.";

$validation = 0;

}

if($validation==1)

{

$sql  = mysqli_query($cn, "select * from tbl_category where `name`='$name'");

if(mysqli_num_rows($sql)>0)

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> Category name already exists.</div>';

}

else

{

$sqlSubject=mysqli_query ($cn, "insert into `tbl_category` set `name`='$name', `image`='$image', `sort_order`='$sort_order', `slug_url`='$slug_url', `status`=1, `menu_type`='".$menu_type."'");

if ($sqlSubject)

{

echo '<div class="alert alert-success"><strong>Success!</strong> Category Added Successfully.</div>';

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> Category Not Added. Try Again.</div>';

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> '.$error.'</div>';

}

if(isset($_POST['edit']))

{

$id  		 = $_POST['id'];

$name		 = $_POST['name'];

$image	     = $_FILES['image']['name'];

$sort_order  = $_POST['sort_order'];

$status  	 = $_POST['status'];

$menu_type   = $_POST['menu_type'];

$slug_url    = mysqli_real_escape_string($cn,$_POST['slug_url']);

$sql  = mysqli_query($cn, "select * from tbl_category where id='$id'");

$sqlData = mysqli_fetch_array($sql);

$validation = 1;

if(!empty($image))

{

$imgExe = explode(".",$image);

if($imgExe[1]=='jpg' or $imgExe[1]=='jpeg' or $imgExe[1]=='png')

{

move_uploaded_file ($_FILES['image']['tmp_name'],'../categorys/'.$image);

}

else

{

$error = "Only .jpg, .jpeg, .png Allow.";

$validation = 0;

}

else

{

$image 		     = $sqlData['image'];

}

if($validation==1)

{

$sqlSubject = mysqli_query ($cn,"update tbl_category SET name='$name',image='$image',sort_order='$sort_order',status='$status',slug_url='$slug_url', `menu_type`='".$menu_type."' where `id`='$id'");

if($sqlSubject)

{

echo '<div class="alert alert-success"><strong>Success!</strong> Category Update Successfully.</div>';

}

else

{

echo '<div class="alert alert-success"><strong>Warrning!</strong> Category Not Updated. Try again.</div>';

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> '.$error.'</div>';

}

if(isset($_GET['edit_id']))

{

$id      = $_GET['edit_id'];

$sql     = mysqli_query($cn, "select * from tbl_category where id='$id'");

$sqlData = mysqli_fetch_array ($sql);

}

if(isset($_GET['status']))

{

$id      = $_GET['status'];

$val     = $_GET['val'];

$sql     = mysqli_query($cn, "update tbl_category SET `status`='$val' where id='$id'");

}

<h4 class="card-title">Category</h4>

<label for="exampleInputName1">Category Name <span style="color:#F00;">*</span></label>

<input type="text" class="form-control setslugUrl" value="<?php if(isset($_GET['edit_id'])) {echo $sqlData['name'];}?>" name="name" placeholder="Name" autocomplete="off" required>

</div>

<label for="exampleInputName1">Category Image <span style="color:#F00;">*</span></label>

<input type="file" class="form-control" name="image" id="fileToUpload" <?php if(isset($_GET['edit_id'])){}else{?> required <?php }?>>

<?php if(isset($_GET['edit_id'])) {?>

<img src="../categorys/<?php echo $sqlData['image'];?>" height="150" width="100">

<?php }?>

</div>

<label for="exampleInputName1">Sort Order <span style="color:#F00;">*</span></label>

<input type="text" class="form-control" value="<?php if(isset($_GET['edit_id'])) {echo $sqlData['sort_order'];}?>" name="sort_order" placeholder="Sort Order" autocomplete="off" required>

</div>

<label>Status <span style="color:#F00;">*</span></label>

</div>

</div>

<input type="text" class="form-control slugUrl" value="<?php if(isset($_GET['edit_id'])) {echo $sqlData['slug_url'];}?>" name="slug_url" placeholder="Slug Url" autocomplete="off" readonly="readonly" required>

</div>

<option value="">Select Type</option>

<option value="1" <?php if(isset($_GET['edit_id'])){if($sqlData['menu_type']==1){echo "selected";}}?>>Direct Menu</option>

<option value="2" <?php if(isset($_GET['edit_id'])){if($sqlData['menu_type']==2){echo "selected";}}?>>Shop Inner Menu</option>

</select>

</div>

<button type="submit" class="btn btn-success mr-2" name="<?php if(isset($_GET['edit_id'])) {echo "edit";}else{ echo "add";}?>">Submit</button>

</form>

</div>

<?php

if(isset($_GET['delete_id']))

{

$id      = $_GET['delete_id'];

$sql     = mysqli_query($cn, "update `tbl_category`  SET `status`=2 where id='$id'");

if($sql)

{

echo '<div class="alert alert-success"><strong>Success!</strong> Category Deleted Successfully.</div>';

}

else

{

echo "error: " . $sql . "<br>" . mysqli_error($conn);

}

<h4 class="card-title">Category List</h4>

<thead>

<tr>

<th>Image</th>

<th>Category Name</th>

<th>Sort Order</th>

<th>Status</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$i = 1;

$sqlEmployee = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1) order by `sort_order`");

while($sqlEmployeeData = mysqli_fetch_array($sqlEmployee))

{?>

<tr>

<td><img src="../categorys/<?php echo $sqlEmployeeData['image'];?>" height="150" width="200"></td>

<td>

<?php

if($sqlEmployeeData['status']==1){?>

<?php }else{?>

<?php }?>

</td>

<td><a href="home.php?pages=category&edit_id=<?php echo $sqlEmployeeData['id'];?>">Edit</a> | <a href="home.php?pages=category&delete_id=<?php echo $sqlEmployeeData['id'];?>" onclick="return deleteConfirm();">Delete</a></td>

</tr>

<?php } ?>

</tbody>

</table>

</div>