MAINHACK

Viewing / Editing File: edit_blog.php

<?php
include('header.php');
$insert=new Oops($db);
$show=new Oops($db);
?>
<?php
			
$count=1;
$stmt =$show->readwithdata('blog','id',$_REQUEST['id']);
$num = $stmt->rowCount();
     
     if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];
        $title=$row['title'];    
        $des=$row['des'];
        $img=$row['img'];

}
         
     }	
     ?>
<div id="page-wrapper">
<div class="main-page">
   <script src="tinymce/tinymce.min.js"></script>
  <script>tinymce.init({ selector:'textarea' });</script>   
 <div class="row">
 <div id="col-md-6">
    <div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
         <div class="form-title">
         <h4>Events  :</h4>
         </div>
         <div class="form-body">
        <form method="post" data-toggle="validator" enctype="multipart/form-data"> 
         
          
         
            <div class="form-group">
             <div class="col-md-4">
            	    <label>Title </label>
            	    <input type="text" name="title" class="form-control" value="<?=$title?>" placeholder="Title">
             </div>
             <div class="clearfix"></div>
            </div>
            
          
         
         <div class="form-group">
             <div class="col-md-12">
            	    <label>Description </label>
            	    <textarea name="des" class="form-control"  ><?=$des?></textarea>
             </div>
             <div class="clearfix"></div>
            </div>
            
            <div class="form-group">
             <div class="col-md-4">
            	   <img src="images/<?php echo $img; ?>" width="200">  <br>   
             </div>
             </div>
            <div class="form-group">
             <div class="col-md-2">
            	    <label>Update Image </label>
            	    <input type="file" name="file" class="form-control" >
             </div></div>
            
        <div class="form-group">
            <div class="col-md-6">
        <input type="submit" class="btn btn-info" name="sub" value="Submit">
         </div>	 
        	<div class="clearfix"></div>
         </div>		
          
    </form> 
<?php

if(isset($_POST['sub'])){
    
if ($_FILES['file']['size'] == 0 && $_FILES['file']['error'] == 4){
echo "";
    
}else{
if(isset($_FILES['file'])){
$extension = pathinfo($_FILES["file"]["name"], PATHINFO_EXTENSION);
$file=explode(".",$_FILES["file"]["name"]);
$filename = str_replace(" ", "_", $file[0]);
$pic=$filename.".".$extension;
$img1=date('dmY').$pic;
//echo $img1;
if(move_uploaded_file($_FILES['file']['tmp_name'],"images/".$img1))
{
    $path='images/'.$img;    
unlink($path);
$stmt=$con->prepare("update blog set img='".$img1."' where id='".$_REQUEST['id']."'");
$stmt->execute();

}
}
}
$allowed = ["title","img"];
$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "id")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars(strip_tags($_POST[$key]));
    }
}
$setStr = rtrim($setStr, ",");
$setStr .=",`des`=:des";
$params['des'] =$_POST['des'];
$params['id'] =$id;
$show->table ='blog';
$show->cols =$setStr;
$show->id_name ='id';
$show->params =$params;

if($show->update_all()){
		echo "<script>sweetAlert('Ok', 'Event has been updated','success');window.location.href='".$_SERVER['request_uri']."';</script>";
		}else{
		echo "<script>alert('Something went wrong');</script>";

}

}
?>				
     
         
         
         
         
         </div>
    </div>		
 </div>	
</div>	
</div>
 </div>
 
<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_blog.php

Server Info

System Features

User Info