halohalo
bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry
/
home
/
aramiyarkai
/
public_html
/
admin
/
Upload FileeE
HOME
<?php include 'dbc.php'; page_protect(); ?> <?php if($_POST['submit'] == "Submit"){ $id = mysqli_real_escape_string($link,$_POST['id']); $autoid = mysqli_real_escape_string($link,$_POST['autoid']); $State = mysqli_real_escape_string($link,$_POST['State']); $amount = mysqli_real_escape_string($link,$_POST['amount']); $weight = mysqli_real_escape_string($link,$_POST['weight']); $desc = mysqli_real_escape_string($link,$_POST['desc']); $status = mysqli_real_escape_string($link,$_POST['status']); $sort_order = mysqli_real_escape_string($link,$_POST['sort_order']); $date = mysqli_real_escape_string($link,$_POST['date']); if(mysqli_query($link,"INSERT INTO `delivery_tbl` (`id`, `autoid`, `State`, `amount`, `weight`, `desc`, `status`, `sort_order`, `ip_address`, `browser`, `date`) VALUES ('$id', '$autoid', '$State', '$amount', '$weight', '$desc', '$status', '$sort_order', '$ip_address', '$browser', '$date')")){ $msg[] = "Successfully Saved!"; } else { $err[] = "Error in saving data!"; } } ?> <?php if($_POST['submit'] == "Update"){ $id = mysqli_real_escape_string($link,$_POST['id']); $autoid = mysqli_real_escape_string($link,$_POST['autoid']); $State = mysqli_real_escape_string($link,$link,$_POST['State']); $amount = mysqli_real_escape_string($link,$_POST['amount']); $weight = mysqli_real_escape_string($link,$_POST['weight']); $desc = mysqli_real_escape_string($link,$_POST['desc']); $status = mysqli_real_escape_string($link,$_POST['status']); $sort_order = mysqli_real_escape_string($link,$_POST['sort_order']); $date = mysqli_real_escape_string($link,$_POST['date']); if(mysqli_query($link,"UPDATE `delivery_tbl` SET `id` = '$id', `autoid` = '$autoid', `State` = '$State', `amount` = '$amount', `weight` = '$weight', `desc` = '$desc', `status` = '$status', `sort_order` = '$sort_order', `ip_address` = '$ip_address', `browser` = '$browser', `date` = '$date' WHERE `id`='$id'")){$msg[] = "Successfully Saved!"; } else { $err[] = "Error in saving data!"; } } ?> <?php include 'header.php'; ?> <body class="hold-transition skin-blue sidebar-mini"> <div class="wrapper"> <?php include 'top_header.php'; ?> <!-- Left side column. contains the logo and sidebar --> <?php include 'side_menu.php'; ?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <h1> Delivery <small>Add / Update Delivery Details</small> </h1> <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li> <li><a href="#">Delivery</a></li> <li class="active">Add / Update Delivery Details</li> </ol> </section> <!-- Main content --> <section class="content"> <div class="row"> <!-- left column --> <div class="col-md-12"> <!-- general form elements --> <div class="box box-primary"> <div class="box-header with-border"> <h3 class="box-title">Add / Update Delivery Details</h3> </div> <!-- /.box-header --> <!-- form start --> <div class="col-md-12"> <?php foreach($err as $err_msg){ ?> <div class="alert alert-danger alert-dismissible"> <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> <h4><i class="icon fa fa-ban"></i> Alert!</h4> <?php echo $err_msg; ?> </div> <?php } ?> <?php foreach($msg as $new_msg){ ?> <div class="alert alert-success alert-dismissible"> <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> <h4><i class="icon fa fa-check"></i> Alert!</h4> <?php echo $new_msg; ?> </div> <?php } ?> </div> <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 $id = mysqli_real_escape_string($link,$_GET['id']); $update = mysqli_real_escape_string($link,$_GET['update']); if($update == "yes"){ $sel_row = mysqli_query($link,"select * from delivery_tbl where `id`='$id'"); $row = mysqli_fetch_object($sel_row); $upload_id = $row->id; } else { $max_id = $db->maxOfAll("id","delivery_tbl"); $max_id=$max_id+1; $upload_id="del-".$max_id; } ?><input type="hidden" class="form-control" name="id" id="id" placeholder="Enter the Id" value="<?php echo $row->id; ?>" readonly="readonly" > <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="autoid">Autoid</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="autoid" id="autoid" placeholder="Enter the delivery id" value="<?php echo $upload_id; ?>" readonly="readonly" 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="State">State</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="State" id="State" placeholder="Select the state" value="<?php echo $row->State; ?>" 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="amount">Amount</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="amount" id="amount" placeholder="Enter the amount" value="<?php echo $row->amount; ?>" 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="weight">Weight</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="weight" id="weight" placeholder="Enter the weight" value="<?php echo $row->weight; ?>" 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="desc">Desc</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <textarea class="form-control" name="desc" id="desc" placeholder="Enter the desc" required="required"> <?php echo $row->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="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 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="sort_order">Sort Order</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="sort_order" id="sort_order" placeholder="Enter the Order" value="<?php echo $row->sort_order; ?>" > </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="date">Date</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="datetime-local" class="form-control" name="date" id="date" placeholder="" value="<?php echo $row->date; ?>" > </div> </div> </div></div> </div> <!-- /.box-body --> <div class="box-footer"> <center> <?php 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> <!-- /.box --> </div> </div> <!-- /.row --> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <?php include 'footer.php'; ?>