1#@!#!123s

: / home / realadss / .trash / admin /
Filename : blog_edit.php
back
<?php include('include/header.php');



$id=$_GET['eid'];

$sql=mysqli_query($conn,"select * from blog where id='$id'"); 
$fetch=mysqli_fetch_array($sql);




if(isset($_POST['update']))
{
     $title =$_POST['title'];  
    $desc =$_POST['desc'];
    $date =$_POST['date']; 
    $author =$_POST['author'];
    $imgtitle =$_POST['imgtitle'];
    $imgalt =$_POST['imgalt'];
    $rimg1_alt =$_POST['rimg1alt'];
    $rimg2_alt =$_POST['rimg2alt'];
    $rimg3_alt =$_POST['rimg3alt'];
    $seosyntax = $_POST['syntax'];
    $rimage1_title =$_POST['rimage1_title'];
    $rimage2_title =$_POST['rimage2_title'];
    $rimage3_title =$_POST['rimage3_title'];
    
    
    $uniqe_image1 = $fetch['Image'];
    $image01 = $_FILES['image']['name'];
    if(!empty($image01)){
    $unique = uniqid()." ".$image01;    
    $image1 = "images/product/".$unique;
    $stmp_name1 = $_FILES['image']['tmp_name'];
    move_uploaded_file($stmp_name1, $image1);
    }else{
        $image1=$uniqe_image1;
    }
    
     $uniqe_image2 = $fetch['rimage1'];
    $image02 = $_FILES['rimage1']['name'];
    if(!empty($image02)){
    $unique2 = uniqid()." ".$image02;    
    $image2 = "images/product/".$unique2;
    $stmp_name2 = $_FILES['rimage1']['tmp_name'];
    move_uploaded_file($stmp_name2, $image2);
    }else{
        $image2=$uniqe_image2;
    }
    
    
     $uniqe_image3 = $fetch['rimage2'];
    $image03 = $_FILES['rimage2']['name'];
    if(!empty($image03)){
    $unique3 = uniqid()." ".$image03;    
    $image3 = "images/product/".$unique3;
    $stmp_name3 = $_FILES['rimage2']['tmp_name'];
    move_uploaded_file($stmp_name3, $image3);
    }else{
        $image3=$uniqe_image3;
    }
    
     $uniqe_image4 = $fetch['rimage3'];
    $image04 = $_FILES['rimage3']['name'];
    if(!empty($image04)){
    $unique4 = uniqid()." ".$image04;    
    $image4 = "images/product/".$unique4;
    $stmp_name4 = $_FILES['rimage3']['tmp_name'];
    move_uploaded_file($stmp_name4, $image4);
    }else{
        $image4=$uniqe_image4;
    }
    
    
    $meta_title = $_POST['metatitle'];
    $meta_desc = $_POST['metadesc'];
    $meta_key = $_POST['metakey'];
    
    $text = strtolower($title);
    
      $desc = $_POST['desc'];            
        $replaceArray1 = array(
            //  '"' => "&#34;",
            "'" => "&#39;",
           
        );
        
     $modifiedText1 = str_replace(array_keys($replaceArray1), array_values($replaceArray1), $desc);
      
     $slug = $_POST['slug'];            
     $replaceArray2 = array(
             ' ' => "-",  
        );
        
    $modifiedText2 = str_replace(array_keys($replaceArray2), array_values($replaceArray2), $slug);
  
	
    $updateData=mysqli_query($conn,"update blog set id='$id',title='$text',author='$author',createdate='$date',title='$text',description='$modifiedText1',`Image`='$image1',`imgtitle`='$imgtitle',`imgalt`='$imgalt',`rimage1`='$image2',`rimage2`='$image3',`rimage3`='$image4',meta_title='$meta_title',meta_desc='$meta_desc',meta_key='$meta_key',rimage1_alt='$rimg1_alt',rimage2_alt='$rimg2_alt',rimage3_alt='$rimg3_alt',slug='$modifiedText2',seo_syntax='$seosyntax',rimage1_title='$rimage1_title',rimage2_title='$rimage2_title',rimage3_title='$rimage3_title' where id='$id'");

  
	 
	 if($updateData)
	 {
		echo "<script>alert('Data Updated');window.location.href='blog.php';</script>";
	 }
	 else {
		 
		 echo mysqli_error($conn);
	 }
 }


?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
	  <div class="container-full">

	<!-- Main content -->
		<section class="content">
		<div class="box">
				<div class="box-header with-border">
				  <h4 class="box-title">Edit Blog </h4>
				</div>
				<!-- /.box-header -->
				<div class="box-body">
				  <form role="form" method="POST" enctype="multipart/form-data">
					<!-- text input -->
				
						<div class="form-group">
					  <label class="form-label">Meta Title</label>
					  <input type="text" class="form-control" value="<?php echo $fetch['meta_title'];?>" name="metatitle" >
					</div>
					
					<div class="form-group">
					  <label class="form-label">Meta Description</label>
					  <input type="text" class="form-control" value="<?php echo $fetch['meta_desc'];?>"  name="metadesc"  maxlength="180">
					</div>
					
					<div class="form-group">
					  <label class="form-label">Meta Keywords</label>
					  <input type="text" class="form-control" value="<?php echo $fetch['meta_key'];?>" name="metakey" >
					</div>
					
					<div class="form-group">
					  <label class="form-label">Slug</label>
					  <input type="text" class="form-control" value="<?php echo $fetch['slug'];?>" name="slug" required>
					</div>
					
				    <div class="form-group">
					  <label class="form-label">SEO Syntax</label>
					  <textarea class="form-control" name="syntax"><?php echo $fetch['seo_syntax'];?></textarea>
					</div>
					
				    <div class="row">
				        <div class="col-6">
    				    <div class="form-group">
    					  <label class="form-label">Title</label>
    					  <input type="text" class="form-control"  value="<?php echo $fetch['title'];?>" name="title" >
    					</div>
    					</div>
    					<div class="col-6">
    				    <div class="form-group">
    					  <label class="form-label">Author</label>
    					  <input type="text" class="form-control"  value="<?php echo $fetch['author'];?>" name="author" >
    					</div>
    					</div>
    					<div class="col-6">
    				    <div class="form-group">
    					  <label class="form-label">Date</label>
    					  <input type="date" class="form-control"  value="<?php echo $fetch['createdate'];?>" name="date">
    					</div>
    					</div>
    					
    					<div class="col-6">
    					    <div class="form-group">
        					  <label class="form-label">Image</label>
        					  <input type="file" class="form-control" accept="image/png, image/jpeg, image/jpg" name="image"   onchange="ShowImage(event)"  >
        					   <img src='<?php echo $fetch['Image'];?>' value=""  width="200"  id="image" />
        					</div>
    					</div>
    					
    						<div class="col-6">
        					   <div class="form-group">
        					  <label class="form-label">Image Title</label>
        					  <input type="text" class="form-control"  value="<?php echo $fetch['imgtitle'];?>" placeholder="Enter ..." name="imgtitle" >
        					</div>
    					</div>
    					
    					<div class="col-6">
        					   <div class="form-group">
        					  <label class="form-label">Image Alt</label>
        					  <input type="text" class="form-control" placeholder="Enter ..."  value="<?php echo $fetch['imgalt'];?>" name="imgalt" >
        					</div>
    					</div>
    					
    					
    						
    					 <div class="col-4">
    					   <div class="form-group">
    					  <label class="form-label">Related Image1</label>
    					  <input type="file" class="form-control" accept="image/png, image/jpeg, image/jpg" name="rimage1" onchange="ShowImage2(event)" >
    					   <img src="<?php echo $fetch['rimage1'];?>" width="200" height="100" id="image2" />
    					</div> 
    			    	</div>
    				
    				     <div class="col-4">
        					   <div class="form-group">
        					  <label class="form-label">Related Image1 Alt</label>
        					  <input type="text" class="form-control" placeholder="Enter ..."  value="<?php echo $fetch['rimage1_alt'];?>" name="rimg1alt" >
        					</div>
    					</div>
				        
				         <div class="col-4">
        					   <div class="form-group">
        					  <label class="form-label">Related Image1 Title</label>
        					  <input type="text" class="form-control" placeholder="Enter ..." value="<?php echo $fetch['rimage1_title'];?>"  name="rimage1_title" >
        					</div>
    					</div>
				    	<div class="col-4">
    					    <div class="form-group">
    					  <label class="form-label">Related Image2 </label>
    					  <input type="file" class="form-control" accept="image/png, image/jpeg, image/jpg" name="rimage2" onchange="ShowImage3(event)" >
    					   <img src="<?php echo $fetch['rimage2'];?>" width="200" height="100" id="image3" />
    					</div>
    			    	</div>
    				
    			    	<div class="col-4">
        					  <div class="form-group">
        					  <label class="form-label">Related Image2 Alt</label>
        					  <input type="text" class="form-control" placeholder="Enter ..."  value="<?php echo $fetch['rimage2_alt'];?>" name="rimg2alt" >
        					</div>
    					</div>
    					<div class="col-4">
        					   <div class="form-group">
        					  <label class="form-label">Related Image2 Title</label>
        					  <input type="text" class="form-control" placeholder="Enter ..." value="<?php echo $fetch['rimage2_title'];?>"  name="rimage2_title" >
        					</div>
    					</div>
    				<div class="col-4">
    					    <div class="form-group">
    					  <label class="form-label">Related Image3 </label>
    					  <input type="file" class="form-control" accept="image/png, image/jpeg, image/jpg" name="rimage3" onchange="ShowImage4(event)" >
    					   <img src="<?php echo $fetch['rimage3'];?>" width="200" height="100" id="image4" />
    					</div>
    				</div>
    				
    				<div class="col-4">
        					<div class="form-group">
        					  <label class="form-label">Related Image3 Alt</label>
        					  <input type="text" class="form-control" placeholder="Enter ..."  value="<?php echo $fetch['rimage3_alt'];?>" name="rimg3alt" >
        					</div>
    					</div>
    				
    				    <div class="col-4">
        					   <div class="form-group">
        					  <label class="form-label">Related Image3 Title</label>
        					  <input type="text" class="form-control" placeholder="Enter ..." value="<?php echo $fetch['rimage3_title'];?>"  name="rimage3_title" >
        					</div>
    					</div>
    				
				    </div>
					
					<div class="form-group">
					  <label class="form-label">Description</label>
					  <textarea name="desc" id="editor"><?php echo $fetch['description'];?></textarea>
					</div>
					
				
					
		           <div class="box-footer">
					<button type="submit" class="btn btn-success" name="update">Update</button>
					</div>
				  </form>
				  
	         <div class="error"><?php if(!empty($msg)){ echo $msg; } ?></div>
				
			
				
			
				</div>
				
				
				<!-- /.box-body -->
			  </div>

				  
				</div>
				<!-- /.box-body -->
			  </div>
		</section>
		<!-- /.content -->

</div>

</div>


<link rel="stylesheet" href="https://cdn.ckeditor.com/ckeditor5/42.0.1/ckeditor5.css">
	<script type="importmap">
            {
                "imports": {
                    "ckeditor5": "https://cdn.ckeditor.com/ckeditor5/42.0.1/ckeditor5.js",
                    "ckeditor5/": "https://cdn.ckeditor.com/ckeditor5/42.0.1/"
                }
            }
        </script>
        
         <script type="module">
            import {
                ClassicEditor,
                Essentials,
                Paragraph,
                Bold,
                Italic,
                Font,
                Alignment,
                CodeBlock,
                Code
            } from 'ckeditor5';

            ClassicEditor
                .create( document.querySelector( '#editor' ), {
                    plugins: [ Essentials, Paragraph, Bold, Italic, Font, CodeBlock, Code, Alignment ],
                    toolbar: [
						'undo', 'redo', '|', 'bold', 'italic', '|',
						'fontSize', 'fontFamily', 'fontColor', 'fontBackgroundColor', '|',
                        'alignment', '|',
                        'code', 'codeBlock'
                    ]
                } )
                .then( editor => {
                    window.editor = editor;
                } )
                .catch( error => {
                    console.error( error );
                } );
        </script>
<!--<script src="//cdn.ckeditor.com/4.22.1/standard/ckeditor.js"></script>-->

  <script>
  
  CKEDITOR.replace( 'editor');
  

 </script>

  <script>
  
  CKEDITOR.replace( 'editor2');

</script>

<?php include('include/footer.php');?>