halohalo

<?php include "dbc.php"; page_protect(); ?> <?php if(isset($_POST['submit'])){ if($_POST['submit'] == "Submit"){ $id = mysqli_real_escape_string($link,$_POST['id']); $accountcategory_id = mysqli_real_escape_string($link,$_POST['accountcategory_id']); $accountcategory_name = mysqli_real_escape_string($link,$_POST['accountcategory_name']); $accountcategory_desc = mysqli_real_escape_string($link,$_POST['accountcategory_desc']); $accountcategory_type = mysqli_real_escape_string($link,$_POST['accountcategory_type']); $status = mysqli_real_escape_string($link,$_POST['status']); if(mysqli_query($link,"INSERT INTO `accountcategory_tbl` (`id`, `accountcategory_id`, `accountcategory_name`, `accountcategory_date`, `accountcategory_desc`, `accountcategory_type`, `status`) VALUES ('$id', '$accountcategory_id', '$accountcategory_name', NOW(), '$accountcategory_desc', '$accountcategory_type', '$status')")){ $msg[] = "Successfully Saved!"; } else { $err[] = "Error in saving data!"; } } ?> <?php if($_POST['submit'] == "Update"){ $id = mysqli_real_escape_string($link,$_POST['id']); $accountcategory_id = mysqli_real_escape_string($link,$_POST['accountcategory_id']); $accountcategory_name = mysqli_real_escape_string($link,$_POST['accountcategory_name']); $accountcategory_date = mysqli_real_escape_string($link,$_POST['accountcategory_date']); $accountcategory_desc = mysqli_real_escape_string($link,$_POST['accountcategory_desc']); $accountcategory_type = mysqli_real_escape_string($link,$_POST['accountcategory_type']); $status = mysqli_real_escape_string($link,$_POST['status']); if(mysqli_query($link,"UPDATE `accountcategory_tbl` SET `accountcategory_name` = '$accountcategory_name', `accountcategory_date` = NOW(), `accountcategory_desc` = '$accountcategory_desc', `accountcategory_type` = '$accountcategory_type', `date` = '$date', `created_by` = '$created_by', `approved_by` = '$approved_by', `status` = '$status', `sort_order` = '$sort_order' WHERE `accountcategory_id`='$accountcategory_id'")){$msg[] = "Successfully Saved!"; } else { $err[] = "Error in saving data!"; } } } ?> <?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; Accounts Category</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 Accounts Category</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" action=""> <div class="box-body"> <!-- Form Code Is Generated Here --> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <?php if(isset($_REQUEST['update'])){ $accountcategory_id = mysqli_real_escape_string($link,$_GET['accountcategory_id']); $update = mysqli_real_escape_string($link,$_GET['update']); if($update == "yes"){ $sel_row = mysqli_query($link,"select * from accountcategory_tbl where `accountcategory_id`='$accountcategory_id'"); $row = mysqli_fetch_object($sel_row); $upload_id = $row->accountcategory_id; } } else { list($max_id) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `accountcategory_tbl`")); $max_id=$max_id+1; $upload_id="acc-".$max_id; } ?><input type="hidden" class="form-control" name="id" id="id" placeholder="Enter the Id" value="<?php echo $row->id; ?>" readonly="readonly" required="required"> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="form-group"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label for="accountcategory_id">Account Category Id</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="form-control" name="accountcategory_id" id="accountcategory_id" placeholder="Enter the Account Category Id" value="<?php echo $upload_id; ?>" readonly="readonly"> </div> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="form-group"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label for="accountcategory_name">Account Category Name</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="form-control" name="accountcategory_name" id="accountcategory_name" placeholder="Enter the Account Category Name" value="<?php if(isset($_REQUEST['update'])){ echo $row->accountcategory_name; } ?> " required="required"> </div> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="form-group"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label for="accountcategory_desc">Account Category Description</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <textarea class="form-control" name="accountcategory_desc" id="accountcategory_desc" placeholder="Enter the Account Category Description" required="required"> <?php if(isset($_REQUEST['update'])){ echo $row->accountcategory_desc; } ?></textarea> </div> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="form-group"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label for="accountcategory_type">Account Category Type</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="text" class="form-control" name="accountcategory_type" id="accountcategory_type" placeholder="Enter the Account Category Type" value="<?php if(isset($_REQUEST['update'])){ echo $row->accountcategory_type; } ?>"> </div> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"> <div class="form-group"> <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad"> <label for="status">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="required"> <option value="active">Active</option> <option value="disable">Disable</option> </select> </div> </div> </div></div> </div> <!-- /.box-body --> <div class="box-footer"> <center> <?php if(isset($_REQUEST['update'])){ if($update == "yes"){ ?> <input type="submit" name="submit" id="submit" class="btn btn-primary" value="Update"> <?php } }else { ?> <input type="submit" name="submit" id="submit" class="btn btn-primary" value="Submit"> <?php } ?> </center> </div> </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"); }); </script> <?php include'footer.php';?>