1#@!#!123s

22527 1#@!#!123s
: / home / parchhayin / www / admin /
Filename : news_update.php
back
<?php 
include('main.php'); 

 if(isset($_GET['id'])) {
	 
	$id = $_GET['id'];
$query =mysqli_query($con, "select * from news where id=$id");  
$row = mysqli_fetch_array($query);
 }
extract($_REQUEST);
if(isset($update)) {
	
	if (!empty($news_cat)) {
foreach ($news_cat as $selected) {
      
      $chk .= $selected.",";  
   }
}  
		$date= date("F j Y");
	  
        $string="1234567890abcdefghijklmnopgrs";
        $string_shuffled= str_shuffle($string);
        $rename=substr($string_shuffled, 0,2);
        $allowed = array('jpg','png','gif','jpeg','JPG','PNG','GIF','JPEG');
        
        if($image=$_FILES['image']['name'] !==""){

        $image=$_FILES['image']['name'];
         $extension=pathinfo($image, PATHINFO_EXTENSION);
         $image_tmp = $_FILES['image']['tmp_name'];
         $image = $rename . ($image);
         
         if(!in_array($extension, $allowed)) {
		
		 echo "<script>alert('Sorry, only JPG, JPEG, PNG, Doc & PDF files are allowed.');</script>";
		}
		else {
	move_uploaded_file($image_tmp,"../images/$image");
	
	$news_img=mysqli_query($con, "update news set news_image='$image' where id=$id");
	
	}
}
	$news_update=mysqli_query($con, "update news set news_title='".mysqli_real_escape_string($con, $_POST['title'])."', news_cat='$chk', news_desc='".mysqli_real_escape_string($con, $_POST['desc'])."', date='$date' where id=$id");
	
  if($news_update) {

    echo "<script>alert('News update succesfully');</script>";
     echo "<script>window.open('news_list.php','_self');</script>";
   }
  else {
	   
	   echo "<script>alert('Not added please try again')</script>";
		}
  
}
?>
 <div class="content-page">
                <!-- Start content -->
                <div class="content">
                    <div class="container">

                        <!-- Page-Title -->
                        <div class="row">
                            <div class="col-sm-12">
                               
                             <!--   <h4 class="pull-left page-title">Welcome !</h4>-->
                                <ol class="breadcrumb pull-right">
                                
                                    
                                        <li><a href="index.php">Dashboard</a></li>
                                    <li class="active">News Edit</li>
                                </ol>
                            </div>
                        </div>



                        <div class="row">
                            <div class="col-lg-12">
                                <div class="portlet"><!-- /portlet heading -->
                                    <div class="portlet-heading">
                                        <h4 class="hed">Edit News Here</h4></br>
                                        <form class="form-horizontal m-t-20" action="" method="post" enctype="multipart/form-data">
                                            <div class="row">
                                                <div class="col-md-2"> News Title :</div>
                                                <div class="col-md-10">   
                                                <p style="color:#f00; font-weight: bold;">News title should be unique not use -,+,&, '',symbols</p>
                                                <input type="text" name="title" class="form-control input-lg" value="<?php echo $row['news_title']; ?>" >
                                                </div>
                                            </div>
                                            <div class="row">  
                                                <div class="col-md-2">News Image:</div>
                                                <div class="col-md-10">  
                                                <input type="file" name="image" class="form-control input-lg"><br/>
                                                <?php  echo"<img src='../images/".$row['news_image']."' width='135' height='100' style='border:2px solid;' />"; ?><br/><br/>
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-md-2"> Category:</div>
                                                <div class="col-md-10" >
                                                 <?php 
                                                	 $get_cats = "select * from category";
                                                
                                                	$run_cats = mysqli_query($con, $get_cats);
                                                
                                                    while ($row_cats=mysqli_fetch_array($run_cats))
                                                         {
                                                         $cat_id= $row_cats['id'];
                                                        $cat_title = $row_cats['category'];
                                                        
                                                        $iparr = explode(",", $row['news_cat']); 
                                                	
                                                		$last_att=count($iparr);
                                                		echo ' <label style="margin-right:15px;"> ';
                                                		for($i = 0; $last_att > $i; $i++)
                                                	
                                                			{
                                                						
                                                      ?>
                                                
                                                         <input type='checkbox' name='news_cat[]' value='<?php echo $cat_title ?>' <?php if($iparr[$i] =="$cat_title") { ?> checked="checked"<?php } }?>  style='margin-left:15px;'> <?php echo $cat_title ?>
                                                        </label>
                                                	<?php  } ?>
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-md-2">Description:</div>
                                                <div class="col-md-10">
                                                <textarea name="desc" class="form-control ckeditor" id="js-my-textarea1" ><?php echo $row['news_desc']; ?></textarea><br/>
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-md-12 text-right">
                                                <input type="submit" name="update" value="Update" class="btn-lg btn-success" />     
                                                </div>
                                            </div>
                                        </form>
                                     </div>
                                </div> <!-- /Portlet -->
                            </div>   
                         </div>  
<?php
 include('footer.php');
 ?>