bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
include "dbc.php"; 
page_protect();
if(isset($_POST['Submit'])){
if($_POST['Submit'] == 'Save') 	
{ 
    
    $title = mysqli_real_escape_string($link,$_POST['title']);
    $sub_title =  mysqli_real_escape_string($link,$_POST['sub_title']);
    $bid =  mysqli_real_escape_string($link,$_POST['bid']);
    $date = $_POST['date'];  
    $short_desc =  mysqli_real_escape_string($link,$_POST['short_desc']);
    $description = $_POST['description'];
    $category = $_POST['category'];
    $status = $_POST['status'];
    $og_url = $_POST['og_url'];
    
  /*  echo "INSERT INTO `blog` (`title`, `sub_title`, `date`, `bid`, `short_desc`, `description`, `category`,`status`) VALUES ('$title', '$sub_title', '$date', '$bid', '$short_desc', '$description', '$category', '$status')";	
   exit();*/
    $ins_query = mysqli_query($link,"INSERT INTO `blog` (`title`, `sub_title`, `date`, `bid`, `short_desc`, `description`, `cat_id`,`status`,`og_url`) VALUES ('$title', '$sub_title', '$date', '$bid', '$short_desc', '$description', '$category', '$status','$og_url')");
    $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/blog/";
            $new_filename = $upload_dir.$upload_name."_".$bid.".".$ext;
            move_uploaded_file($_FILES['image']["tmp_name"],$new_filename);
            mysqli_query($link,"update blog set `image`='$new_filename' where id='$id'");
		}
	      $og_image = $_FILES['og_image']['name'];

if($og_image != "")
		{
		
            $filename1 = $_FILES['og_image']['name'];
            $filename_part1 = explode(".", $filename1);
            $upload_name1 = $filename_part1[0];
            $ext1 = $filename_part1[1];
            $upload_dir1 = "images/blog/og-image/";
            $new_filename1 = $upload_dir1.$upload_name1."_".$bid.".".$ext1;
            move_uploaded_file($_FILES['og_image']["tmp_name"],$new_filename1);
            mysqli_query($link,"update blog set `og_image`='$new_filename1' where id='$id'");
		}
	header('location:add_blog.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']);
        $sub_title = mysqli_real_escape_string($link,$_POST['sub_title']);
        $bid = mysqli_real_escape_string($link,$_POST['bid']);
        $date = $_POST['date'];
        $short_desc = mysqli_real_escape_string($link,$_POST['short_desc']);
        $description = $_POST['description'];
        $category = $_POST['category'];
        $status = $_POST['status'];
        $og_url = $_POST['og_url'];
     /*echo "UPDATE `blog` SET  `title` = '$title', `sub_title` = '$sub_title', `bid`='$bid', `date` = '$date', `short_desc` = '$short_desc', `description` = '$description', `cat_id` = '$category', `status` = '$status' WHERE id = '$id'";
        exit();	*/
        $ins_query = mysqli_query($link,"UPDATE `blog` SET  `title` = '$title', `sub_title` = '$sub_title', `bid`='$bid', `date` = '$date', `short_desc` = '$short_desc', `description` = '$description', `cat_id` = '$category', `status` = '$status',`og_url`='$og_url' 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/blog/";
            $new_filename = $upload_dir.$upload_name."_".$bid.".".$ext;
            move_uploaded_file($_FILES['image']["tmp_name"],$new_filename);
            mysqli_query($link,"update blog set `image`='$new_filename' where id='$id'");
        }
	  $og_image = $_FILES['og_image']['name'];

if($og_image != "")
		{
		
            $filename1 = $_FILES['og_image']['name'];
            $filename_part1 = explode(".", $filename1);
            $upload_name1 = $filename_part1[0];
            $ext1 = $filename_part1[1];
            $upload_dir1 = "images/blog/og-image/";
            $new_filename1 = $upload_dir1.$upload_name1."_".$bid.".".$ext1;
            move_uploaded_file($_FILES['og_image']["tmp_name"],$new_filename1);
            mysqli_query($link,"update blog set `og_image`='$new_filename1' 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>&nbsp; Blog</h3>
          </div>
        </header>
      </div>
      <?php include'admin_admin.php';?>
      <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 Blog</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 `blog`"));
                        $id = $max+1;
                        $bid = "BID".$id."";
						
						}
						if($_GET['action']=="Update"){
							$id = $_GET['id'];
							$sel_rw = mysqli_query($link,"select * from blog 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>Blog 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>Blog Category</label>
                            </div>
                            <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
                                <select name="category" class="form-control" required>
                                    <option value="">Please Select</option>
                                    <?php $sblog = mysqli_query($link,"select * from blog_category");
                                    while ($blog = mysqli_fetch_array($sblog)) { ?>
                                        <option <?php if(!empty($row->cat_id)){ if($blog['cat_id']==$row->cat_id){ echo "selected"; } } ?> value="<?php echo $blog['cat_id']; ?>"><?php echo $blog['cat_name']; ?></option>
                                    <?php } ?>
                                </select>
                               
                            </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>Blog 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">&nbsp;</div>

<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
                            <label>Home Page</label>
                        </div>
                        <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
                            <select class="form-control" name="status">
                                <option value="">Please Select</option>
                                <option value="Enable" <?php if($_GET['action']=="Update"){ if($row->status=='Enable'){ echo "selected"; } } ?>>Enable</option>
                                <option value="Disable" <?php if($_GET['action']=="Update"){ if($row->status=='Disable'){ echo "selected"; } } ?>>Disable</option>
                            </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>Blog 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="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>Blog Sub 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="sub_title" value="<?php if(!empty($row->sub_title)){ echo $row->sub_title; } ?>">
                        </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>Meta Og 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="og_image">
                        <span style="color: red">Image Height: 330 , width: 570 </span><br>
                        <?php if(!empty($row->og_image)){
                        ?><img src="<?php echo $row->og_image; ?>" width="100" height="100"><?php
                        } ?>
                        </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>Meta Og Url</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="og_url" value="<?php if(!empty($row->og_url)){ echo $row->og_url; } ?>">
                        </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>Blog 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">&nbsp;</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">&nbsp;</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">&nbsp;</div>   
			</div>

</div>
	
			
		</div>
		</div>
		
	   
            
          </div>
        </div>
      </div>
      
            <?php include "right-side.php";?>

    </div>
    <script src="js/jquery-1.9.1.min.js"></script>
    
    <?php include'footer.php';?>