halohalo

<?php include "dbc.php"; page_protect(); if(isset($_POST['Submit'])){ if($_POST['Submit'] == 'Save') { $id = mysqli_real_escape_string($link,$_POST['id']); $product_id = mysqli_real_escape_string($link,$_POST['product_id']); $group_proid = mysqli_real_escape_string($link,$_POST['group_proid']); $barcode = mysqli_real_escape_string($link,$_POST['barcode']); $product_name = mysqli_real_escape_string($link,$_POST['product_name']); $product_name_en = mysqli_real_escape_string($link,$_POST['product_name_en']); $cat_id = mysqli_real_escape_string($link,$_POST['cat_id']); $subcat_id = mysqli_real_escape_string($link,$_POST['subcat_id']); $childcat_id = mysqli_real_escape_string($link,$_POST['childcat_id']); list($cat_name,$cat_name_en) = mysqli_fetch_row(mysqli_query($link,"select `cat_name_tamil`, `cat_name` from category_tbl where cat_id='$cat_id'")); list($subcat_name,$subcat_name_en) = mysqli_fetch_row(mysqli_query($link,"select `subcat_name_tamil`, `subcat_name` from subcategory_tbl where subcat_id='$subcat_id'")); list($childcat_name,$childcat_name_en) = mysqli_fetch_row(mysqli_query($link,"select `childcat_name_tamil`, `childcat_name` from childcategory_tbl where childcat_id='$childcat_id'")); $mrp_price = mysqli_real_escape_string($link,$_POST['selling_price']); //$mrp_price = mysqli_real_escape_string($link,$_POST['mrp_price']); $selling_price = mysqli_real_escape_string($link,$_POST['selling_price']); $cost_price = mysqli_real_escape_string($link,$_POST['cost_price']); $tax = mysqli_real_escape_string($link,$_POST['tax']); //$other_tax = mysqli_real_escape_string($link,$_POST['other_tax']); $full_image = mysqli_real_escape_string($link,$_POST['product_upload']); $size = mysqli_real_escape_string($link,$_POST['size']); $shipping_weight = mysqli_real_escape_string($link,$_POST['shipping_weight']); $unit = mysqli_real_escape_string($link,$_POST['unit']); $quantity = mysqli_real_escape_string($link,$_POST['quantity']); $minq = 1; $maxq = 10; //$minq = mysqli_real_escape_string($link,$_POST['minq']); //$maxq = mysqli_real_escape_string($link,$_POST['maxq']); $stock_avail = mysqli_real_escape_string($link,$_POST['stock_avail']); $small_des = mysqli_real_escape_string($link,$_POST['small_des']); //$full_desc = mysqli_real_escape_string($link,$_POST['full_desc']); //$created_on = mysqli_real_escape_string($link,$_POST['created_on']); //$sort = mysqli_real_escape_string($link,$_POST['sort']); //$type = mysqli_real_escape_string($link,$_POST['type']); $type = "New"; $status = mysqli_real_escape_string($link,$_POST['status']); $short_tamil = mysqli_real_escape_string($link,$_POST['short_tamil']); $short_en = mysqli_real_escape_string($link,$_POST['short_en']); $desc_tamil = $_POST['desc_tamil']; $ins_query = mysqli_query($link,"INSERT INTO `product_tbl` ( `id`, `product_id`, `group_proid`, `barcode`, `product_name`, `product_name_en`, `cat_id`, `cat_name`, `cat_name_en`, `subcat_id`, `subcat_name`, `subcat_name_en`, `childcat_id`, `childcat_name`, `childcat_name_en`, `mrp_price`, `selling_price`, `cost_price`, `tax`, `other_tax`, `full_image`, `shipping_weight`, `size`, `unit`, `quantity`, `minq`, `maxq`, `stock_avail`, `small_des`, `full_desc`, `created_on`, `type`, `status`, `desc_tamil`, `short_tamil`, `short_en`) VALUES ( '$id', '$product_id', '$group_proid', '$barcode', '$product_name', '$product_name_en', '$cat_id', '$cat_name', '$cat_name_en', '$subcat_id', '$subcat_name', '$subcat_name_en', '$childcat_id', '$childcat_name', '$childcat_name_en', '$mrp_price', '$selling_price', '$cost_price', '$tax', '$other_tax', '$full_image', '$shipping_weight', '$size', '$unit', '$quantity', '$minq', '$maxq', '$stock_avail', '$small_des', '$full_desc', NOW(), '$type', '$status','$desc_tamil','$short_tamil','$short_en')"); $product_upload = $_FILES['product_upload']['name']; if($product_upload != "") { //echo "entered"; list($max_id) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `product_tbl`")); $max_id=$max_id+1; $upload_id="U-".$max_id; $filename = $_FILES['product_upload']['name']; $filename_part = explode(".", $filename); $upload_name = $filename_part[0]; $ext = $filename_part[1]; $upload_dir = "uploads/products/"; $new_filename = $upload_dir.$upload_name."_".$upload_id.".".$ext; move_uploaded_file($_FILES['product_upload']["tmp_name"],$new_filename); mysqli_query($link,"update product_tbl set `full_image`='$new_filename' where product_id='$product_id'"); } $msg[] = "Sucessfully Saved! "; } if($_POST['Submit'] == 'Update') { $id = mysqli_real_escape_string($link,$_POST['id']); $product_id = mysqli_real_escape_string($link,$_POST['product_id']); $group_proid = mysqli_real_escape_string($link,$_POST['group_proid']); $barcode = mysqli_real_escape_string($link,$_POST['barcode']); $product_name = mysqli_real_escape_string($link,$_POST['product_name']); $product_name_en = mysqli_real_escape_string($link,$_POST['product_name_en']); $cat_id = mysqli_real_escape_string($link,$_POST['cat_id']); $subcat_id = mysqli_real_escape_string($link,$_POST['subcat_id']); $childcat_id = mysqli_real_escape_string($link,$_POST['childcat_id']); list($cat_name,$cat_name_en) = mysqli_fetch_row(mysqli_query($link,"select `cat_name_tamil`, `cat_name` from category_tbl where cat_id='$cat_id'")); list($subcat_name,$subcat_name_en) = mysqli_fetch_row(mysqli_query($link,"select `subcat_name_tamil`, `subcat_name` from subcategory_tbl where subcat_id='$subcat_id'")); list($childcat_name,$childcat_name_en) = mysqli_fetch_row(mysqli_query($link,"select `childcat_name_tamil`, `childcat_name` from childcategory_tbl where childcat_id='$childcat_id'")); //$mrp_price = mysqli_real_escape_string($link,$_POST['mrp_price']); $mrp_price = mysqli_real_escape_string($link,$_POST['selling_price']); $selling_price = mysqli_real_escape_string($link,$_POST['selling_price']); $cost_price = mysqli_real_escape_string($link,$_POST['cost_price']); $tax = mysqli_real_escape_string($link,$_POST['tax']); $shipping_weight = mysqli_real_escape_string($link,$_POST['shipping_weight']); $size = mysqli_real_escape_string($link,$_POST['size']); $unit = mysqli_real_escape_string($link,$_POST['unit']); $quantity = mysqli_real_escape_string($link,$_POST['quantity']); $minq = 1; $maxq = 10; $stock_avail = mysqli_real_escape_string($link,$_POST['stock_avail']); $small_des = mysqli_real_escape_string($link,$_POST['small_des']); $type = "New"; $status = mysqli_real_escape_string($link,$_POST['status']); $short_tamil = mysqli_real_escape_string($link,$_POST['short_tamil']); $short_en = mysqli_real_escape_string($link,$_POST['short_en']); $desc_tamil = $_POST['desc_tamil']; $ins_query = mysqli_query($link,"UPDATE `product_tbl` SET `barcode` = '$barcode', `product_name` = '$product_name', `product_name_en` = '$product_name_en', `cat_id`='$cat_id', `cat_name` = '$cat_name', `cat_name_en` = '$cat_name_en', `subcat_id`='$subcat_id', `subcat_name` = '$subcat_name', `subcat_name_en` = '$subcat_name_en', `childcat_id`='$childcat_id', `childcat_name` = '$childcat_name', `childcat_name_en` = '$childcat_name_en', `mrp_price` = '$mrp_price', `selling_price` = '$selling_price', `cost_price` = '$cost_price', `tax` = '$tax', `shipping_weight`='$shipping_weight', `size` = '$size', `unit`='$unit', `quantity` = '$quantity', `minq` = '$minq', `maxq` = '$maxq', `stock_avail` = '$stock_avail', `small_des` = '$small_des', `created_on` = NOW(), `type` = '$type', `status` = '$status', `desc_tamil` = '$desc_tamil', `short_tamil` = '$short_tamil', `short_en` = '$short_en' WHERE id = $id"); $product_upload = $_FILES['product_upload']['name']; if($product_upload != "") { //echo "entered"; list($max_id) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `product_tbl`")); $max_id=$max_id+1; $upload_id="U-".$max_id; $filename = $_FILES['product_upload']['name']; $filename_part = explode(".", $filename); $upload_name = $filename_part[0]; $ext = $filename_part[1]; $upload_dir = "uploads/products/"; $new_filename = $upload_dir.$upload_name."_".$upload_id.".".$ext; move_uploaded_file($_FILES['product_upload']["tmp_name"],$new_filename); mysqli_query($link,"update product_tbl set `full_image`='$new_filename' where product_id='$product_id'"); } $msg[] = "Sucessfully Updated! "; } } ?> <?php include'header.php';?> <script type="text/javascript" src="js/jquery.1.8.3.min.js"></script> <div class="main-bar"> <h3> <i class="fa fa-plus"></i>&nbsp; Products</h3> </div><!-- /.main-bar --> </header><!-- /.head --> </div><!-- /#top --> <?php include'admin_admin.php';?><!-- /#left --> <div id="content"> <div class="outer"> <div class="inner bg-light lter"> <style> .form-control.col-lg-6 { width: 50% !important; } </style> <div class="row"> <div class="col-lg-12"> <div class="box"> <header class="dark"> <div class="icons"> <i class="fa fa-check"></i> </div> <h5>Add / Update Products</h5> <div class="toolbar"> <div class="btn-group"> </div> </div> </header> <div class="box-content"> <?php include 'msg_display.php'; ?> <form class="form-horizontal" method="post" enctype="multipart/form-data" > <fieldset> <?php if($_GET['action']=="Save"){ list($max) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `product_tbl`")); $id = $max+1; $pid = "PID".$id.""; $gpid = "GPID".$id.""; $barcode = "BC".$id.""; } if($_GET['action']=="Update"){ $pid = $_GET['pid']; $sel_rw = mysqli_query($link,"select * from product_tbl where product_id='$pid'"); $row = mysqli_fetch_object($sel_rw); $id = $row->id; $pid = $row->product_id; $gpid = $row->group_proid; $barcode = $row->barcode; } ?> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <input type="hidden" class="validate[required] form-control" name="id" id="id" value="<?php echo $id; ?>"> <input type="hidden" class="validate[required] form-control" name="group_proid" id="group_proid" value="<?php echo $gpid; ?>"> <input type="hidden" class="validate[required] form-control" name="barcode" id="barcode" value="<?php echo $barcode; ?>"> <input type="hidden" class="validate[required] form-control" name="mrp_price" id="mrp_price" value="<?php echo $row->mrp_price; ?>"> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Product id</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="product_id" id="product_id" value="<?php echo $pid; ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">&nbsp;</div> <div class="clearfix"></div> <div class="col-md-12">&nbsp;</div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Product Name (Tamil)</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="product_name" id="product_name" value="<?php if(isset($_REQUEST['pid'])){ echo $row->product_name; } ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Product Name</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="product_name_en" id="product_name_en" value="<?php if(isset($_REQUEST['pid'])){ echo $row->product_name_en; } ?>"> </div> </div> <div class="clearfix"></div> <div class="col-md-12">&nbsp;</div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Category</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <select name="cat_id" id="cat_id" class="form-control"> <option value="">Please Select </option> <?php $sel_category = mysqli_query($link,"select * from category_tbl where status='Active'"); while($rw_ctegory = mysqli_fetch_object($sel_category)){?> <option <?php if(isset($_REQUEST['pid'])){ if($row->cat_id == $rw_ctegory->cat_id){ echo "selected"; } } ?> value="<?php echo $rw_ctegory->cat_id;?>"><?php echo $rw_ctegory->cat_name;?> </option> <?php }?> </select> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Sub Category</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <select name="subcat_id" id="subcat_id" class="form-control"> <option value="">Please Select </option> <?php $sel_category1 = mysqli_query($link,"select * from subcategory_tbl where status='Active'"); while($rw_ctegory1 = mysqli_fetch_object($sel_category1)){?> <option <?php if(isset($_REQUEST['pid'])){ if($row->subcat_id == $rw_ctegory1->subcat_id){ echo "selected"; } } ?> value="<?php echo $rw_ctegory1->subcat_id;?>"><?php echo $rw_ctegory1->subcat_name;?> </option> <?php }?> </select> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Child Category</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <select name="childcat_id" id="childcat_id" class="form-control" > <option value="">Please Select</option> <?php $sel_category = mysqli_query($link,"select * from childcategory_tbl where status='Active'"); while($rw_ctegory = mysqli_fetch_object($sel_category)){?> <option <?php if(isset($_REQUEST['pid'])){ if($row->childcat_id == $rw_ctegory->childcat_id){ echo "selected"; } } ?> value="<?php echo $rw_ctegory->childcat_id;?>"><?php echo $rw_ctegory->childcat_name;?> </option> <?php }?> </select> </div> </div> <div class="col-md-12">&nbsp;</div> <div class="clearfix"></div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Selling price</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="selling_price" id="selling_price" value="<?php if(isset($_REQUEST['pid'])){ echo $row->selling_price; } ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Cost price</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="cost_price" id="cost_price" value="<?php if(isset($_REQUEST['pid'])){ echo $row->cost_price; } ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>GST Percentage</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="tax" id="tax" value="<?php if(isset($_REQUEST['pid'])){ echo $row->tax; } ?>"> </div> </div> <div class="col-md-12">&nbsp;</div> <div class="clearfix"></div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Shipping Weight</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="shipping_weight" id="shipping_weight" value="<?php if(isset($_REQUEST['pid'])){ echo $row->shipping_weight; } ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Size</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="size" id="size" value="<?php if(isset($_REQUEST['pid'])){ echo $row->size; } ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Unit</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="unit" id="unit" value="<?php if(isset($_REQUEST['pid'])){ echo $row->unit; } ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Quantity</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="validate[required] form-control" name="quantity" id="quantity" value="<?php if(isset($_REQUEST['pid'])){ echo $row->quantity; }else{ echo "100"; } ?>"> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Stock avail</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <select name="stock_avail" id="stock_avail" class="form-control" required > <option <?php if(isset($_REQUEST['pid'])){ if($row->stock_avail == '2-3 Days'){ echo "selected"; } } ?> value="2-3 Days">2-3 Days</option> <option <?php if(isset($_REQUEST['pid'])){ if($row->stock_avail == 'In Stock'){ echo "selected"; } } ?> value="In Stock">In Stock</option> <option <?php if(isset($_REQUEST['pid'])){ if($row->stock_avail == 'Out Of Stock'){ echo "selected"; } } ?> value="Out Of Stock">Out Of Stock</option> <option <?php if(isset($_REQUEST['pid'])){ if($row->stock_avail == 'Pre-Order'){ echo "selected"; } } ?> value="Pre-Order">Pre-Order</option> </select> </div> </div> <div class="col-md-12">&nbsp;</div> <div class="clearfix"></div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Product Image</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <?php if(isset($_REQUEST['pid'])){ $product_img = $row->full_image; } if(!empty($product_img)){ $required = "yes"; } else { $required = "no"; } if(!empty($product_img)){ ?> <img src="<?php echo $product_img; ?>" class="img-responsive" style="width:200px;" /> <?php } ?> <input type="file" id="product_upload" name="product_upload" class="form-control" <?php if($_GET['action']=="Save"){ ?>required=""<?php } ?>> Note:(Image size should be width:368px; height:250px;)<br> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label>Status</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <select name="status" id="status" class="form-control" required > <option value="Active" selected>Active</option> <option value="Disabled">Disabled</option> </select> </div> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <br> <label>Short Description Tamil</label> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <textarea rows="3" name="short_tamil" id="short_tamil" class="form-control"><?php if(isset($_REQUEST['pid'])){ echo $row->short_tamil; } ?></textarea> </div> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <br> <label>Short Description English</label> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <textarea rows="3" name="short_en" id="short_en" class="form-control"><?php if(isset($_REQUEST['pid'])){ echo $row->short_en; } ?></textarea> </div> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <br> <label>Product Description Tamil</label> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <textarea rows="3" name="desc_tamil" id="desc_tamil" class="ckeditor"><?php if(isset($_REQUEST['pid'])){ echo $row->desc_tamil; } ?></textarea> </div> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <br> <label>Product Description English</label> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <textarea rows="3" name="small_des" id="small_des" class="ckeditor"><?php if(isset($_REQUEST['pid'])){ echo $row->small_des; } ?></textarea> </div> </div> </div> <center> <div class="form-actions no-margin-bottom"> <?php if($_GET['action']=="Save"){ ?> <input type="submit" name="Submit" id="savebutton" value="Save" class="btn btn-primary"> <?php } ?> <?php if($_GET['action']=="Update"){ ?> <input type="submit" name="Submit" id="savebutton" value="Update" class="btn btn-primary"> <?php } ?> </div> </center> </fieldset> </form> </div><!--/row--> </div><!--/.fluid-container--> <!-- end: Content --> </div><!--/#content.span10--> </div><!--/fluid-row--> <div class="modal hide fade" id="myModal"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h3>Settings</h3> </div> <div class="modal-body"> <p>Here settings can be configured...</p> </div> <div class="modal-footer"> <a href="#" class="btn" data-dismiss="modal">Close</a> <a href="#" class="btn btn-primary">Save changes</a> </div> </div> <!-- /.row --> </div><!-- /.inner --> </div><!-- /.outer --> </div><!-- /#content --> <?php include "right-side.php";?> <!-- /#right --> </div><!-- /#wrap --> <script src="js/jquery-1.9.1.min.js"></script> <script> $(document).ready(function() { $("#stock_avail option[value='<?php echo $row->stock_avail; ?>']").attr("selected", "selected"); $("#status option[value='<?php echo $row->status; ?>']").attr("selected", "selected"); $("#type option[value='<?php echo $row->type; ?>']").attr("selected", "selected"); $("#cat_id option[value='<?php echo $row->cat_id; ?>']").attr("selected", "selected"); $("#subcat_id option[value='<?php echo $row->subcat_id; ?>']").attr("selected", "selected"); $("#childcat_id option[value='<?php echo $row->childcat_id; ?>']").attr("selected", "selected"); }); <script> $(document).ready(function(){ //alert("OK"); $("#cat_id").change(function() { var cat_id = $("#cat_id").val(); $.ajax({ type: "POST", url: "get_subcategory.php", // data: "category="+ category+"&category1="+category, data: "cat_id="+ cat_id, success: function(msg){ if(msg == 'Not Available') { $("#postalcode").removeClass('object_error'); $("#mobile").addClass("object_ok"); $("#err_subcat_name").html(msg); $("#err_subcat_name").show(); } else { $("#cat_id").removeClass('object_ok'); $("#cat_id").addClass("object_error"); $("#subcat_id").html(msg); } } }); }); $("#subcat_id").change(function() { var cat_id = $("#cat_id").val(); var subcat_id = $("#subcat_id").val(); $.ajax({ type: "POST", url: "get_childcategory.php", // data: "category="+ category+"&category1="+category, data: "cat_id="+ cat_id + "& subcat_id="+ subcat_id, success: function(msg){ //alert("Sucess"); //alert(cat_id); //alert(data); if(msg == 'Not Available') { $("#err_childcat_name").html(msg); $("#err_childcat_name").show(); } else { $("#subcat_id").removeClass('object_ok'); $("#subcat_id").addClass("object_error"); $("#childcat_id").html(msg); } } }); }); </script> <?php include'footer.php';?>