The part1 of the admin panel has been shown in the previous tutorial. The ways of inserting new product, category and subcategory have been shown in this tutorial.
Steps:
01. Create insert-product.php file inside the admin folder and add the following content.
<?php session_start(); include('../includes/config.php'); if(strlen($_SESSION['alogin'])==0) { header('location:index.php'); } else{ if(isset($_POST['submit'])) { $category=$_POST['category']; $subcat=$_POST['subcategory']; $productname=$_POST['productName']; $productcompany=$_POST['productCompany']; $productprice=$_POST['productprice']; $productpricebd=$_POST['productpricebd']; $productdescription=$_POST['productDescription']; $productscharge=$_POST['productShippingcharge']; $productavailability=$_POST['productAvailability']; $productimage1=$_FILES["productimage1"]["name"]; $query=mysqli_query($con,"select max(id) as pid from products"); $result=mysqli_fetch_array($query); $productid=$result['pid']+1; $dir="productimages/$productid"; if(!is_dir($dir)) { mkdir("productimages/".$productid); } move_uploaded_file($_FILES["productimage1"]["tmp_name"],"productimages/$productid/".$_FILES["productimage1"]["name"]); $sql=mysqli_query($con,"insert into products(category,subCategory,productName,productCompany,productPrice,productDescription,shippingCharge,productAvailability,productImage,productPriceBeforeDiscount) values('$category','$subcat','$productname','$productcompany','$productprice','$productdescription','$productscharge','$productavailability','$productimage1','$productpricebd')"); $_SESSION['msg']="Product Inserted Successfully !!"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Admin| Insert Product</title> <link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet"> <link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet"> <link type="text/css" href="css/theme.css" rel="stylesheet"> <link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet"> <link type="text/css" href='http://fonts.googleapis.com/css?family=Open+Sans:400italic,600italic,400,600' rel='stylesheet'> <script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script> <script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script> <script> function getSubcat(val) { $.ajax({ type: "POST", url: "get_subcat.php", data:'cat_id='+val, success: function(data){ $("#subcategory").html(data); } }); } function selectCountry(val) { $("#search-box").val(val); $("#suggesstion-box").hide(); } </script> </head> <body> <?php include('includes/header.php');?> <div class="wrapper"> <div class="container"> <div class="row"> <?php include('includes/sidebar.php');?> <div class="span9"> <div class="content"> <div class="module"> <div class="module-head"> <h3>Insert Product</h3> </div> <div class="module-body"> <?php if(isset($_POST['submit'])) { ?> <div class="alert alert-success"> <button type="button" class="close" data-dismiss="alert">×</button> <strong>Well done!</strong> <?php echo htmlentities($_SESSION['msg']);?> <?php echo htmlentities($_SESSION['msg']="");?> </div> <?php } ?> <?php if(isset($_GET['del'])) { ?> <div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> <strong>Oh snap!</strong> <?php echo htmlentities($_SESSION['delmsg']);?> <?php echo htmlentities($_SESSION['delmsg']="");?> </div> <?php } ?> <br /> <form class="form-horizontal row-fluid" name="insertproduct" method="post" enctype="multipart/form-data"> <div class="control-group"> <label class="control-label" for="basicinput">Category</label> <div class="controls"> <select name="category" class="span8 tip" onChange="getSubcat(this.value);" required> <option value="">Select Category</option> <?php $query=mysqli_query($con,"select * from category"); while($row=mysqli_fetch_array($query)) {?> <option value="<?php echo $row['id'];?>"> <?php echo $row['categoryName'];?></option> <?php } ?> </select> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Sub Category</label> <div class="controls"> <select name="subcategory" id="subcategory" class="span8 tip" required> </select> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Name</label> <div class="controls"> <input type="text" name="productName" placeholder="Enter Product Name" class="span8 tip" required> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Company</label> <div class="controls"> <input type="text" name="productCompany" placeholder="Enter Product Comapny Name" class="span8 tip" required> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Price Before Discount</label> <div class="controls"> <input type="text" name="productpricebd" placeholder="Enter Product Price" class="span8 tip" required> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Price After Discount(Selling Price)</label> <div class="controls"> <input type="text" name="productprice" placeholder="Enter Product Price" class="span8 tip" required> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Description</label> <div class="controls"> <textarea name="productDescription" placeholder="Enter Product Description" rows="6" class="span8 tip"> </textarea> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Shipping Charge</label> <div class="controls"> <input type="text" name="productShippingcharge" placeholder="Enter Product Shipping Charge" class="span8 tip" required> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Availability</label> <div class="controls"> <select name="productAvailability" id="productAvailability" class="span8 tip" required> <option value="">Select</option> <option value="In Stock">In Stock</option> <option value="Out of Stock">Out of Stock</option> </select> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Image1</label> <div class="controls"> <input type="file" name="productimage1" id="productimage1" value="" class="span8 tip" required> </div> </div> <!-- <div class="control-group"> <label class="control-label" for="basicinput">Product Image2</label> <div class="controls"> <input type="file" name="productimage2" class="span8 tip" required> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Product Image3</label> <div class="controls"> <input type="file" name="productimage3" class="span8 tip"> </div> </div> --> <div class="control-group"> <div class="controls"> <button type="submit" name="submit" class="btn">Insert</button> </div> </div> </form> </div> </div> </div><!--/.content--> </div><!--/.span9--> </div> </div><!--/.container--> </div><!--/.wrapper--> <?php include('includes/footer.php');?> <script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script> <script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script> <script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script> <script src="scripts/flot/jquery.flot.js" type="text/javascript"></script> <script src="scripts/datatables/jquery.dataTables.js"></script> <script> $(document).ready(function() { $('.datatable-1').dataTable(); $('.dataTables_paginate').addClass("btn-group datatable-pagination"); $('.dataTables_paginate > a').wrapInner('<span />'); $('.dataTables_paginate > a:first-child').append('<i class="icon-chevron-left shaded"></i>'); $('.dataTables_paginate > a:last-child').append('<i class="icon-chevron-right shaded"></i>'); } ); </script> </body> <?php } ?>
02. Create category.php file inside the admin folder and add the following content.
<?php session_start(); include('../includes/config.php'); if(strlen($_SESSION['alogin'])==0){ header('location:index.php'); } else{ date_default_timezone_set('Asia/Dhaka');// change according timezone $currentTime = date( 'd-m-Y h:i:s A', time () ); if(isset($_POST['submit'])) { $category=$_POST['category']; $description=$_POST['description']; $sql=mysqli_query($con,"insert into category(categoryName,categoryDescription) values('$category','$description')"); $_SESSION['msg']="Category Created !!"; } if(isset($_GET['del'])) { mysqli_query($con,"delete from category where id = '".$_GET['id']."'"); $_SESSION['delmsg']="Category deleted !!"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Admin| Category</title> <link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet"> <link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet"> <link type="text/css" href="css/theme.css" rel="stylesheet"> <link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet"> <link type="text/css" href='http://fonts.googleapis.com/css?family=Open+Sans:400italic,600italic,400,600' rel='stylesheet'> </head> <body> <?php include('includes/header.php');?> <div class="wrapper"> <div class="container"> <div class="row"> <?php include('includes/sidebar.php');?> <div class="span9"> <div class="content"> <div class="module"> <div class="module-head"> <h3>Category</h3> </div> <div class="module-body"> <?php if(isset($_POST['submit'])) {?> <div class="alert alert-success"> <button type="button" class="close" data-dismiss="alert">×</button> <strong>Well done!</strong> <?php echo htmlentities($_SESSION['msg']);?><?php echo htmlentities($_SESSION['msg']="");?> </div> <?php } ?> <?php if(isset($_GET['del'])) {?> <div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> <?php echo htmlentities($_SESSION['delmsg']);?><?php echo htmlentities($_SESSION['delmsg']="");?> </div> <?php } ?> <br /> <form class="form-horizontal row-fluid" name="Category" method="post" > <div class="control-group"> <label class="control-label" for="basicinput">Category Name</label> <div class="controls"> <input type="text" placeholder="Enter category Name" name="category" class="span8 tip" required> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">Description</label> <div class="controls"> <textarea class="span8" name="description" rows="5"></textarea> </div> </div> <div class="control-group"> <div class="controls"> <button type="submit" name="submit" class="btn">Create</button> </div> </div> </form> </div> </div> <div class="module"> <div class="module-head"> <h3>Manage Categories</h3> </div> <div class="module-body table"> <table cellpadding="0" cellspacing="0" border="0" class="datatable-1 table table-bordered table-striped display" width="100%"> <thead> <tr> <th>#</th> <th>Category</th> <th>Description</th> <th>Creation date</th> <th>Last Updated</th> <th>Action</th> </tr> </thead> <tbody> <?php $query=mysqli_query($con,"select * from category"); $cnt=1; while($row=mysqli_fetch_array($query)) { ?> <tr> <td><?php echo htmlentities($cnt);?></td> <td><?php echo htmlentities($row['categoryName']);?></td> <td><?php echo htmlentities($row['categoryDescription']);?></td> <td> <?php echo htmlentities($row['creationDate']);?></td> <td><?php echo htmlentities($row['updationDate']);?></td> <td> <a href="edit-category.php?id=<?php echo $row['id']?>" ><i class="icon-edit"></i></a> <a href="category.php?id=<?php echo $row['id']?>&del=delete" onClick="return confirm('Are you sure you want to delete?')"><i class="icon-remove-sign"></i></a></td> </tr> <?php $cnt=$cnt+1; } ?> </table> </div> </div> </div><!--/.content--> </div><!--/.span9--> </div> </div><!--/.container--> </div><!--/.wrapper--> <?php include('includes/footer.php');?> <script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script> <script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script> <script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script> <script src="scripts/flot/jquery.flot.js" type="text/javascript"></script> <script src="scripts/datatables/jquery.dataTables.js"></script> <script> $(document).ready(function() { $('.dataTables_paginate').addClass("btn-group datatable-pagination"); $('.dataTables_paginate > a').wrapInner('<span />'); $('.dataTables_paginate > a:first-child').append('<i class="icon-chevron-left shaded"></i>'); $('.dataTables_paginate > a:last-child').append('<i class="icon-chevron-right shaded"></i>'); } );$('.data$('.datatable-1').dataTable({ "pageLength": 5, "lengthMenu": [5, 10, 20, 25, 50] }); </script> </body> <?php } ?>
03. Create subcategory.php file inside the admin folder and add the following content.
<?php session_start(); include('../includes/config.php'); if(strlen($_SESSION['alogin'])==0){ header('location:index.php'); } else{ if(isset($_POST['submit'])) { $category=$_POST['category']; $subcat=$_POST['subcategory']; $sql=mysqli_query($con,"insert into subcategory(categoryid,subcategory) values('$category','$subcat')"); $_SESSION['msg']="SubCategory Created !!"; } if(isset($_GET['del'])) { mysqli_query($con,"delete from subcategory where id = '".$_GET['id']."'"); $_SESSION['delmsg']="SubCategory deleted !!"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Admin| SubCategory</title> <link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet"> <link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet"> <link type="text/css" href="css/theme.css" rel="stylesheet"> <link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet"> <link type="text/css" href='http://fonts.googleapis.com/css?family=Open+Sans:400italic,600italic,400,600' rel='stylesheet'> </head> <body> <?php include('includes/header.php');?> <div class="wrapper"> <div class="container"> <div class="row"> <?php include('includes/sidebar.php');?> <div class="span9"> <div class="content"> <div class="module"> <div class="module-head"> <h3>Sub Category</h3> </div> <div class="module-body"> <?php if(isset($_POST['submit'])) {?> <div class="alert alert-success"> <button type="button" class="close" data-dismiss="alert">×</button> <?php echo htmlentities($_SESSION['msg']);?><?php echo htmlentities($_SESSION['msg']="");?> </div> <?php } ?> <?php if(isset($_GET['del'])) {?> <div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> <strong>Oh snap!</strong> <?php echo htmlentities($_SESSION['delmsg']);?><?php echo htmlentities($_SESSION['delmsg']="");?> </div> <?php } ?> <br /> <form class="form-horizontal row-fluid" name="subcategory" method="post" > <div class="control-group"> <label class="control-label" for="basicinput">Category</label> <div class="controls"> <select name="category" class="span8 tip" required> <option value="">Select Category</option> <?php $query=mysqli_query($con,"select * from category"); while($row=mysqli_fetch_array($query)) {?> <option value="<?php echo $row['id'];?>"><?php echo $row['categoryName'];?></option> <?php } ?> </select> </div> </div> <div class="control-group"> <label class="control-label" for="basicinput">SubCategory Name</label> <div class="controls"> <input type="text" placeholder="Enter SubCategory Name" name="subcategory" class="span8 tip" required> </div> </div> <div class="control-group"> <div class="controls"> <button type="submit" name="submit" class="btn">Create</button> </div> </div> </form> </div> </div> <div class="module"> <div class="module-head"> <h3>Sub Category</h3> </div> <div class="module-body table"> <table cellpadding="0" cellspacing="0" border="0" class="datatable-1 table table-bordered table-striped display" width="100%"> <thead> <tr> <th>#</th> <th>Category</th> <th>Description</th> <th>Creation date</th> <th>Last Updated</th> <th>Action</th> </tr> </thead> <tbody> <?php $query=mysqli_query($con,"select subcategory.id,category.categoryName,subcategory.subcategory,subcategory.creationDate,subcategory.updationDate from subcategory join category on category.id=subcategory.categoryid"); $cnt=1; while($row=mysqli_fetch_array($query)) { ?> <tr> <td><?php echo htmlentities($cnt);?></td> <td><?php echo htmlentities($row['categoryName']);?></td> <td><?php echo htmlentities($row['subcategory']);?></td> <td> <?php echo htmlentities($row['creationDate']);?></td> <td><?php echo htmlentities($row['updationDate']);?></td> <td> <a href="edit-subcategory.php?id=<?php echo $row['id']?>" ><i class="icon-edit"></i></a> <a href="subcategory.php?id=<?php echo $row['id']?>&del=delete" onClick="return confirm('Are you sure you want to delete?')"><i class="icon-remove-sign"></i></a></td> </tr> <?php $cnt=$cnt+1; } ?> </table> </div> </div> </div><!--/.content--> </div><!--/.span9--> </div> </div><!--/.container--> </div><!--/.wrapper--> <?php include('includes/footer.php');?> <script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script> <script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script> <script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script> <script src="scripts/flot/jquery.flot.js" type="text/javascript"></script> <script src="scripts/datatables/jquery.dataTables.js"></script> <script> $(document).ready(function() { $('.data$('.datatable-1').dataTable({ "pageLength": 5, "lengthMenu": [5, 10, 20, 25, 50] }); Tables_paginate').addClass("btn-group datatable-pagination"); $('.dataTables_paginate > a').wrapInner('<span />'); $('.dataTables_paginate > a:first-child').append('<i class="icon-chevron-left shaded"></i>'); $('.dataTables_paginate > a:last-child').append('<i class="icon-chevron-right shaded"></i>'); } ); </script> </body> <?php } ?>
04. Create get_subcat.php file inside the admin folder and add the following content.
<?php include('../includes/config.php'); if(!empty($_POST["cat_id"])) { $id=intval($_POST['cat_id']); $query=mysqli_query($con,"SELECT * FROM subcategory WHERE categoryid=$id"); ?> <option value="">Select Subcategory</option> <?php while($row=mysqli_fetch_array($query)) { ?> <option value="<?php echo htmlentities($row['id']); ?>"><?php echo htmlentities($row['subcategory']); ?></option> <?php } } ?>
05. Now, login to the admin panel and check the output.
Next tutorial–>