1#@!#!123s

: / home3 / antlerworldwide / public_html / admin /
Filename : magazine_edit.php
back
<?php include('checklogin.php')?>
<?php include('include/header.php')?>
            <!--// top-bar -->

          
            <!-- Forms content -->
            <section class="forms-section">
<?php
include('include/conectdb.php');
$error='';
$pid=$_GET['id'];
   
               if(isset($_POST['vchangeProfile']))
{
	
	$name=$_POST['name'];
	$country=$_POST['country'];
	$circulation=$_POST['circulation'];
	$frequency=$_POST['frequency'];
	$language=$_POST['language'];
	$readership=$_POST['readership'];
	$subscriber=$_POST['subscriber'];
	$category=$_POST['category'];
	$price=$_POST['price'];
	
  
		$text=$_POST['text'];
	$text=str_replace("'","\'",$text);
	
	
	if(empty($error))
	{
    $target = "upload/"; 
    $home_image=$_FILES['uploaded']['name'];
    $target = $target . basename($_FILES['uploaded']['name']) ; 
    $ok=1; 
	
	if($home_image!='')
	{ 
	
	     //$res=mysqli_query("SELECT `tlb_image` FROM `tlb_cms` WHERE `tlb_cms_id`=$pid");
		 //$row=mysqli_fetch_array($res);
	  
        //   if ($home_image > 1200000) 
        //     { 
        //      echo "Your file is too large.<br>"; 
        //      $ok=0; 
        //     } 
 
 //This is our limit file type condition 
            if ($home_image =="text/php") 
            { 
            echo "No PHP files<br>"; 
            $ok=0; 
            } 
 
 //Here we check that $ok was not set to 0 by an error 
           if ($ok==0) 
           { 
            echo "Sorry your file was not uploaded"; 
            } 
 
 //If everything is ok we try to upload it 
			else 
			{ 
			if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) 
			{ 
			
			
			
			$sql=mysqli_query($dbc,"UPDATE `magazine` SET `name`='$name',`country`='$country',`circulation`='$circulation',`frequency`='$frequency',`language`='$language',`readership`='$readership',`subscriber`='$subscriber',`category`='$category',`price`='$price',`tlb_image`='$home_image',`tlb_des`='$text' WHERE `id`='$pid'");
			
			if($row['trr_url'])
			{
			 unlink('upload/'.$row[0]);
			}
			else
			{
				echo '';
			}
			
			if($sql)
			{
			 echo'<span class="successmssg">Content succeessfully added to the website, <br/> <a href="magazine.php" class="btn btn-primary">click to add more</a> <b></span>';
	 exit();
			}
			else
			{
			echo 'Database Problem';
			}
			} 
			else 
			 { 
			 echo "Sorry, there was a problem uploading your file."; 
			 }
	      }
	}
	   else
	   {
		  	$sql=mysqli_query($dbc,"UPDATE `magazine` SET `name`='$name',`country`='$country',`circulation`='$circulation',`frequency`='$frequency',`language`='$language',`readership`='$readership',`subscriber`='$subscriber',`category`='$category',`price`='$price',`tlb_des`='$text' WHERE `id`='$pid'");
		   
		   echo'<span class="successmssg">Content succeessfully added to the website, <br/> <a href="magazine.php" class="btn btn-primary">click to add more</a> <b></span>';
	 exit();
	   }
 } 
	
}
	

else
{
	$sql=mysqli_query($dbc,"SELECT * FROM `magazine` WHERE `id`=$pid");
	if(mysqli_num_rows($sql)==1)
	{
	$row=mysqli_fetch_array($sql);
	mysqli_free_result($sql);
	}
	else
	{
		echo'<span class="warn">Sorry no such Content exists.</span>';
		exit();
	}
}

?>


<div class="outer-w3-agile mt-3">
                    <h4 class="tittle-w3-agileits mb-4">Edit Detail</h4>
                    <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                        <div class=" table-responsive">


 <form action="" method="post"  enctype="multipart/form-data">
                        <div class="form-row">
                            
                             <div class="form-group col-md-4">
                                <label for="inputCity">Name</label>
                                <input type="text" name="name" value="<?php echo $row['name']; ?>" class="form-control">
                            </div>
                            
                            
                             <div class="form-group col-md-2">
                                <label for="inputCity">Country Orgin</label>
                                <input type="text" name="country" value="<?php echo $row['country']; ?>"  class="form-control">
                            </div>
                            
                            
                               <div class="form-group col-md-2">
                                <label for="inputCity">Circulation</label>
                                <input type="text" name="circulation" value="<?php echo $row['circulation']; ?>"  class="form-control">
                            </div>
                            
                             <div class="form-group col-md-2">
                                <label for="inputCity">Frequency</label>
                                <input type="text" name="frequency" value="<?php echo $row['frequency']; ?>"  class="form-control">
                            </div>
                            
                            
                             <div class="form-group col-md-2">
                                <label for="inputCity">Language</label>
                                <input type="text" name="language" value="<?php echo $row['language']; ?>"  class="form-control">
                            </div>
                            
                              <div class="form-group col-md-3">
                                <label for="inputCity">Readership</label>
                                <input type="text" name="readership" value="<?php echo $row['readership']; ?>"  class="form-control">
                            </div>
                            
                                <div class="form-group col-md-3">
                                <label for="inputCity">Subscriber</label>
                                <input type="text" name="subscriber" value="<?php echo $row['subscriber']; ?>"  class="form-control">
                            </div>
                            
                            
                             <div class="form-group col-md-3">
                                <label for="inputCity">category</label>
                                <input type="text" name="category" value="<?php echo $row['category']; ?>"  class="form-control">
                            </div>
 
                             <div class="form-group col-md-3">
                                <label for="inputCity">Cover Price</label>
                                <input type="text" name="price" value="<?php echo $row['price']; ?>"  class="form-control">
                            </div>

                           
                           
                            
                            <div class="form-group col-md-6">
                                <label for="inputCity">Image</label>
                            <div class="row">
                                <div class="col-md-8"><input type="file" name="uploaded" class="form-control" accept="image/*" onchange="loadFile(event)"></div>
                                <div class="col-md-4 text-right"><img src="upload/<?=$row['tlb_image'];?>" class="img-preview" id="output"></div>
                            </div>                           
                            </div>
                            
                              <div class="form-group col-md-12">
                                <label for="inputCity">Desicription</label>
                                <textarea  name="text" id="summernote"><?php echo $row['tlb_des']; ?></textarea>
                            </div>
                            
                          
                          
                            
                         
                        </div>
                       
                        
                       
                        <div class="form-group col-md-12 text-center mt-4">
                    <button type="submit" name="vchangeProfile" id="vchangeProfile" class="btn btn-primary" data-dismiss="modal" aria-hidden="true" title="submit">Update</button>
                    <!--<button type="submit" name="vchangeProfile" id="vchangeProfile" class="btn btn-primary" data-dismiss="modal" aria-hidden="true" title="cancel">Cancel</button>--> 
                        <a href="magazine.php" class="btn btn-primary" data-dismiss="modal" aria-hidden="true" title="cancel">Cancel</a> 					
                    </div>
                    </form>
					</div>
					</div>
					</div>


		</section>

            <!--// Forms content -->
<?php include('include/footer.php') ?>