MAINHACK

Viewing / Editing File: edit_recipient.php

<?php include 'header.php';?>

<div class="card-body">
		
<?php
$count=1;
$sr='recipient';
$stmt =$show->readwithdata($sr,'id',$_REQUEST['id']);
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];   
        ?>
		    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-1 col-sm-4 mt-sm-2 ">Name <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="name" value="<?=$row['name']?>" class="form-control" placeholder="Name">
            	    </div>
		        	<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Image</label>
				<div class="col-lg-3 col-md-12 col-sm-12">
				 	 <?php if($row['image']!=""){?>
				    <img src="<?=$pic_img?>/<?=$row['image']?>" width="50px">
				    <?php }?>
            	    <input type="file" name="image" placeholder="Image" >
				</div>
				<h6>OR</h6>
				
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Video </label>
				<div class="col-lg-2 col-md-12 col-sm-12">
				 <?php if($row['video']!=""){?>
				    <video controls=""  id="my-video" loop=""  width='100px' style="background-color: #fff;">
                        <source src="<?=$pic_img?>/<?=$row['video']?>" type="video/mp4">
                    </video>
                    <?php }?>
            	    <input type="file" name="video"  accept="video/*"  placeholder="Image" >
				</div>
			
			</div>
			
				    	<div class="form-group form-show-validation row">
		<label for="name" class="col-lg-2 col-md-1 col-sm-4 mt-sm-2 ">Year Sponsored  <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="year" value="<?=$row['year']?>" class="form-control" placeholder="Year Sponsored">
            	    </div>
            	    
    	<label for="name" class="col-lg-1 col-md-1 col-sm-4 mt-sm-2 ">DOB <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="dob" value="<?=date('d-m-Y',strtotime($row['dob']))?>" class="form-control" placeholder="DOB">
            	    </div>	      
        <label for="name" class="col-lg-2 col-md-1 col-sm-4 mt-sm-2 ">School & Board <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="school" value="<?=$row['school']?>" class="form-control" placeholder="School & Board">
            	    </div>	          	    
			</div>
			
				<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 ">Academic Record <span class="required-label">*</span></label>
				<div class="col-lg-12 col-md-12 col-sm-12">
            	    <input type="text" name="academic" value="<?=$row['academic']?>" class="form-control" placeholder="Academic Record ">
				</div>
			</div>
				<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Hobbies<span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="hobbies" value="<?=$row['aim_of_life']?>" class="form-control" placeholder="Hobbies">
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Aim of Life<span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="aim_of_life" value="<?=$row['aim_of_life']?>" class="form-control" placeholder="Aim of Life">
				</div>
			</div>
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Family Income<span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="income" value="<?=$row['income']?>" class="form-control" placeholder="Family Income">
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">College <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="college" value="<?=$row['college']?>" class="form-control" placeholder="College ">
				</div>
			</div>
			<hr>
			<h5>Scholarship</h5>
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">First Year Fee<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="first_fee" value="<?=$row['first_fee']?>" class="form-control" placeholder="First Year Fee">
				</div>
					<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Second Year Fee<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="second_fee" value="<?=$row['second_fee']?>" class="form-control" placeholder="First Year Fee">
				</div>
					<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Third Year Fee<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="third_fee" value="<?=$row['third_fee']?>" class="form-control" placeholder="First Year Fee">
				</div>
			</div>
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 ">Testimonial <span class="required-label">*</span></label>
				<div class="col-lg-12 col-md-12 col-sm-12">
            	    <textarea name="content" class="form-control"  rows="10"><?=$row['content']?></textarea>
				</div>
			</div>
		       
	
		<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<input class="btn btn-success" type="submit" name="sub" value="Submit">
				</div>										
			</div>
		</div>
		<?php } } ?>
</div>
	</form>
 <?php

if(isset($_POST['sub'])){

$allowed = ["name","year","school","academic","hobbies","aim_of_life","income","college","first_fee","second_fee","third_fee","content"];

$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "uid")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars($_POST[$key]);
    }
}
if(file_exists($_FILES['video']['tmp_name']) || is_uploaded_file($_FILES['video']['tmp_name'])) {   
 $setStr .= "`video` = :video,";
 $video=$show->imageEdit($_FILES['video']['name']);  
 move_uploaded_file($_FILES['video']['tmp_name'],"../product_img/".$video);
 $params['video'] =$video;

}
if(file_exists($_FILES['image']['tmp_name']) || is_uploaded_file($_FILES['image']['tmp_name'])) {   
 $setStr .= "`image` = :image,";
 $image=$show->imageEdit($_FILES['image']['name']);  
 move_uploaded_file($_FILES['image']['tmp_name'],"../product_img/".$image);
 $params['image'] =$image;

}
$setStr .= "`dob` = :dob,";

$setStr = rtrim($setStr, ",");
$params['id'] =$_REQUEST['id'];
$params['dob'] =date('Y-m-d',strtotime($_POST['dob']));
$show->table ='recipient';
$show->cols =$setStr;
$show->id_name ='id';
$show->params =$params;
//print_r($setStr);

//print_r($params);
if($show->update_all()){
   		
echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You ",
            text: "for Updating!",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
} else{
	echo "ss";
}

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

<?php include 'footer.php'; ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_recipient.php

Server Info

System Features

User Info