halohalo
bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry
/
home
/
aramiyarkai
/
public_html
/
admin
/
Upload FileeE
HOME
<?php include "dbc.php"; page_protect(); if(isset($_POST['Submit'])){ if($_POST['Submit'] == 'Save') { $title = mysqli_real_escape_string($link,$_POST['title']); $heading = mysqli_real_escape_string($link,$_POST['heading']); $bid = mysqli_real_escape_string($link,$_POST['bid']); $date = $_POST['date']; $short_desc = mysqli_real_escape_string($link,$_POST['short_desc']); $description = $_POST['description']; $ins_query = mysqli_query($link,"INSERT INTO `event` (`title`, `heading`, `date`, `bid`, `short_desc`, `description`) VALUES ('$title', '$heading', '$date', '$bid', '$short_desc', '$description')"); $id = mysqli_insert_id($link); $image = $_FILES['image']['name']; if($image != "") { $filename = $_FILES['image']['name']; $filename_part = explode(".", $filename); $upload_name = $filename_part[0]; $ext = $filename_part[1]; $upload_dir = "images/event/"; $new_filename = $upload_dir.$upload_name."_".$bid.".".$ext; move_uploaded_file($_FILES['image']["tmp_name"],$new_filename); mysqli_query($link,"update event set `image`='$new_filename' where id='$id'"); } header('location:add_event.php?action=Save&msg=1'); } if($_POST['Submit'] == 'Update') { $id = mysqli_real_escape_string($link,$_POST['id']); $title = mysqli_real_escape_string($link,$_POST['title']); $heading = mysqli_real_escape_string($link,$_POST['heading']); $bid = mysqli_real_escape_string($link,$_POST['bid']); $date = $_POST['date']; $short_desc = mysqli_real_escape_string($link,$_POST['short_desc']); $description = $_POST['description']; $ins_query = mysqli_query($link,"UPDATE `event` SET `title` = '$title', `heading` = '$heading', `bid`='$bid', `date` = '$date', `short_desc` = '$short_desc', `description` = '$description' WHERE id = '$id'"); $image = $_FILES['image']['name']; if($image != "") { $filename = $_FILES['image']['name']; $filename_part = explode(".", $filename); $upload_name = $filename_part[0]; $ext = $filename_part[1]; $upload_dir = "images/event/"; $new_filename = $upload_dir.$upload_name."_".$bid.".".$ext; move_uploaded_file($_FILES['image']["tmp_name"],$new_filename); mysqli_query($link,"update event set `image`='$new_filename' where id='$id'"); } // header('location:add_blog.php?action=Update&id='.$id.'&msg=2'); $msg[] = "Successfully 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> Event</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 Event</h5> <div class="toolbar"> <div class="btn-group"> </div> </div> </header> <div class="box-content"> <?php include 'msg_display.php'; ?> <br><br> <form class="form-horizontal" method="post" enctype="multipart/form-data" > <fieldset> <?php if(isset($_GET['action'])){ if($_GET['action']=="Save"){ list($max) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `event`")); $id = $max+1; $bid = "E".$id.""; } if($_GET['action']=="Update"){ $id = $_GET['id']; $sel_rw = mysqli_query($link,"select * from event where id='$id'"); $row = mysqli_fetch_object($sel_rw); $id = $row->id; $bid = $row->bid; } } ?> <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 if(!empty($id)){ echo $id; } ?>"> <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>Event 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="bid" value="<?php if(!empty($row->bid)){ echo $row->bid; }else{ echo $bid; } ?>"> </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>Heading</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="heading" value="<?php if(!empty($row->heading)){ echo $row->heading; } ?>"> </div> </div> <div class="clearfix"></div> <div class="col-md-12"> </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> Title</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="title" value="<?php if(!empty($row->title)){ echo $row->title; } ?>"> </div> <div class="clearfix"></div> <div class="col-md-12"> </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> Image</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="file" class="validate[required] form-control" name="image"> <span style="color: red">Image Height: 330 , width: 570 </span><br> <?php if(!empty($row->image)){ ?><img src="<?php echo $row->image; ?>" width="100" height="100"><?php } ?> </div> </div> <div class="clearfix"></div> <div class="col-md-12"> </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> Date</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <input type="date" class="validate[required] form-control" name="date" value="<?php if(!empty($row->date)){ echo $row->date; } ?>"> </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>Short Description</label> </div> <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad"> <textarea class="validate[required] form-control" name="short_desc"><?php if(!empty($row->short_desc)){ echo $row->short_desc; } ?></textarea> </div> </div> <div class="clearfix"></div> <div class="col-md-12"> </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"> <label> Description</label> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad"> <textarea rows="3" name="description" id="full_desc" class="ckeditor"><?php if(isset($_REQUEST['id'])){ echo $row->description; } ?></textarea> </div> </div> </div> <div class="clearfix"></div> <div class="col-md-12"> </div> <center> <div class="form-actions no-margin-bottom"> <br> <br> <?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 class="clearfix"></div> <div class="col-md-12"> </div> </div><!--/row--> <div class="clearfix"></div> <div class="col-md-12"> </div> </div><!--/.fluid-container--> <!-- end: Content --> </div><!--/#content.span10--> </div><!--/fluid-row--> <!-- /.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> <?php include'footer.php';?>