MAINHACK

Viewing / Editing File: edit-social-links.php

<?php include('header.php');$cid=$_REQUEST['cid'];
?>

<div class="inner-banner">
	<img src="images/user-bg.jpg" alt="banner">
</div>

<div class="company-details">
	<div class="container">
		<h1>Update Social Media Links</h1>
		<br>
	    <div class="theme-box aos-init aos-animate" data-aos="fade-down" style="transition:all 1600ms ease-in-out;text-align: center;display: block;">
            <form method="post" action="">
    <?php
			
$count=1;
$sr='visit_card';
$stmt =$show->readwithdata('visit_card','card_id',$cid);
$num = $stmt->rowCount();
     
     while ($row1 = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row1);
        $id=$row1['id'];     
 ?>   
               	<div class="form-left-to-w3l " id="b_name">
               	    <label>Facebook Link</label>
		            <input type="text" placeholder="Facebook Link" value="<?=$row1['facebook']?>" name="facebook" >
	            </div>
	        	<div class="form-left-to-w3l " id="b_name">
	        	    <label>Twitter Link</label>
		            <input type="text" placeholder="Twitter Link" name="twitter" value="<?=$row1['twitter']?>" >
	            </div>
	        	<div class="form-left-to-w3l " id="b_name">
	        	    <label>Instagram Link</label>
		            <input type="text" placeholder="Instagram Link" name="instagram" value="<?=$row1['instagram']?>" >
	            </div>	            
	        	<div class="form-left-to-w3l " id="b_name">
	        	    <label>LinkedIn Link</label>
		            <input type="text" placeholder="LinkedIn Link" name="linkedin" value="<?=$row1['linkedin']?>" >
	            </div>
	        	<div class="form-left-to-w3l " id="b_name">
	        	    <label>Youtube Link</label>
		            <input type="text" placeholder="Youtube Link" name="youtube_link"value="<?=$row1['youtube_link']?>" >
	            </div>
	<?php } ?>            
	        	
	  <h2>Youtube Video Links</h2>
    <?php
			
$count=1;$total=0;
$sr='video';$s='';$ids='';
$stmt =$show->readwithdata('video','card_id',$cid);
$num = $stmt->rowCount();
     
     while ($row1 = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row1);
        $id=$row1['id'];
        $url=$row1['url'];
       $s=$s .",".$url;
       $ids=$ids .",".$id;
        
       
     //echo $s;
/*$s=ltrim($s,",");
$urlval=explode(',',$s);
$allid=ltrim($ids,",");
$idval=explode(',',$allid);
$total=count($idval);
foreach($urlval as $key=>$val){
$id_value=$idval[$key]==''?'':$idval[$key];
*/
$link=$row1['url']==''?'':"https://www.youtube.com/watch?v=".$row1['url']."";

?>
                <div class="form-left-to-w3l " id="b_name">
		            <input type="text" placeholder="Youtube Video Link" value="<?=$link?>" name="video_link[]" >
		            <input type="hidden"  value="<?=$row1['id']?>" name="id[]" >
	            </div>
<?php  ++$count; }   $run_loop=5-$count;       
	    for($i=0;$i<=$run_loop;$i++){ ?>
	     <div class="form-left-to-w3l " id="b_name">
		            <input type="text" placeholder="Youtube Video Link"  name="video_link_add[]" >
	            </div>
	    <?php } ?>
				<div class="form-sub-acc">
	    			<div class="form-sub">
	    			    <input type="submit" class="" name="sub" id="sub" value="Save & Next">
	    			    <a href="edit-payment-details.php?cid=<?=base64_encode($cid)?>" class="btn btn-success">Skip</a>

</div>
	    			
				</div>
			</form>
<?php 
if(isset($_POST['sub'])){
	
	$table='visit_card';

$allowed = ["facebook","twitter","instagram","linkedin","youtube_link"];

$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "uid")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars(strip_tags($_POST[$key]));
    }
}
$setStr = rtrim($setStr, ",");
$params['card_id'] =$cid;
$show->table ='visit_card';
$show->cols =$setStr;
$show->id_name ='card_id';
$show->params =$params;
//print_r($params);
if($show->update_all()){

foreach($_POST['video_link'] as $key=>$url){
 
    $video=$_POST['video_link'][$key];
    $id=$_POST['id'][$key];
    $vid=explode('=',$video);   
 
   $update="update video set url='".$vid[1]."' where id=".$id."";
    $r1=$con->prepare($update);
    $r1->execute();

}
foreach($_POST['video_link_add'] as $url){
   if($url!=NULL){
    $video=htmlentities(strip_tags($url));
    $vid=explode('=',$video);   
     // echo  $vid[1];
	$data=array(
    'client_id'=>$_SESSION['login_id'],
    'url'=>$vid[1],
    'date'=>date('Y-m-d'),
    'card_id'=>$cid
	);
	print_r($data);
	$r1=$show->insert('video',$data);
}
}
 echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You ",
            text: " Social Media details updated. ",
            type: "success"
        }, function() {

window.location = "edit-payment-details.php?cid='.base64_encode($cid).'";
        });
    }, 1000);
</script>';
} else{
	echo "ss";
}

}
?>

</div>

</div>  
</div>

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

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit-social-links.php

Server Info

System Features

User Info