MAINHACK

Viewing / Editing File: edit_client.php

<?php include 'header.php';?>
<style>
    
    .col-md-3,.col-md-2,.col-md-6{
        display:inline-block !important;
    }
</style>
<script>
    
      $(document).ready(function(){
        // Add more
        $('#type').change(function(){
            
         var type = $('#type').val(); 
       //  alert(type);
         if(type=='Direct'){
             $('#direct').show(); 
             $('#agent').hide(); 
 
         }else{
           $('#direct').hide(); 
             $('#agent').show();

}
        });
      });
</script>
		<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="row">
<div class="col-md-12">
<div class="card">
	<div class="card-header">
		<div class="card-title">Edit Customer</div>
	</div>
 	<form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" > 
<?php
$count=1;
$sr='client';
$stmt =$show->readwithdata('client','id',$_REQUEST['id']);
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];  
    //  echo $row['name'];
      
     ?>
		<div class="card-body">
		    	<div class="form-group form-show-validation row">
				<div class="col-lg-3 col-md-12 col-sm-12">
				    	<label>Source Type <span class="required-label">*</span></label>
			            	    <input type="text" value="<?=$row['type']?>" class="form-control" placeholder="Name" readonly>

</div>
		<?php if($row['type']=='Direct'){?>		
				<div class="col-lg-3 col-md-12 col-sm-12" id="direct" >

<label>Source  <span class="required-label">*</span></label>
            	    <select name="source" class="form-control">
            	       
            	        
		
			  <?php  
        $stmt12=$show->readAll('source');
        while($row12=$stmt12->fetch(PDO::FETCH_ASSOC)){
        
        echo "<option value='".$row12['source']."'";if($row['source']==$row12['source']) echo "selected"; echo ">".$row12['source']."</option>";	}
        
     
        ?>			</select>
				</div>
		<?php }else{ ?>
				<div class="col-lg-3 col-md-12 col-sm-12" id="agent" style="">

<label>Choose Agent   <span class="required-label">*</span></label>
            	    <select name="agent" class="form-control" >
        <option value="">Agent</option>
        <?php  
        $table1='agent';
        $stmt11=$show->readAll($table1);
        $num11=$stmt11->rowCount();
        if($num11>0){
        while($row1=$stmt11->fetch(PDO::FETCH_ASSOC)){
        
        echo "<option value='".$row1['agent_id'].":".$row1['name'].":".$row1['phone']."'";if($row['agent_id']==$row1['agent_id']) echo "selected"; echo ">".$row1['name']."</option>";	}
        
        }
        
        ?>
        </select>
				</div>	
				<?php } ?>
			</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 ">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 ">Phone <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="phone" class="form-control" value="<?=$row['phone']?>"  placeholder="Phone" required>
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Alt Phone </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="alt_phone" value="<?=$row['alt_phone']?>"  class="form-control" placeholder="Phone" >
				</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 ">Email </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="email" name="email" value="<?=$row['email']?>" class="form-control" placeholder="Email">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Address</label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="address" value="<?=$row['address']?>" class="form-control" placeholder="Address">
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Location </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="location" value="<?=$row['location']?>" class="form-control" placeholder="Location">
				</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 ">Country </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="country" value="<?=$row['country']?>" class="form-control" placeholder="Country">
				</div>
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Company Name </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="company_name" value="<?=$row['company_name']?>" class="form-control" placeholder="Company Name">
				</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 ">Company Address</label>
				<div class="col-lg-6 col-md-12 col-sm-12">
            	    <input type="text" name="company_address" value="<?=$row['company_address']?>" class="form-control" placeholder="Company Address">
				</div>
			<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">State</label>
           				<div class="col-lg-3 col-md-12 col-sm-12">

<select  name="state" class="form-control" >
                        <option value="">State</option>
                        <?php  
                        $table1='state_list';
                        $stmt1=$show->state($table1);
                        $num1=$stmt1->rowCount();
                        if($num1>0){
                        while($row1=$stmt1->fetch(PDO::FETCH_ASSOC)){
                        
        echo "<option value='".$row1['state']."'";if($row['state']==$row1['state']) echo "selected"; echo ">".$row1['state']."</option>";	}
                        
                        }
                        
                        ?>
                         </select>	
                         	</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 ">GSTIN</label>
		<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="gstin" value="<?=$row['gstin']?>" class="form-control" placeholder="GSTIN">
				</div>
					<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Other Details</label>
		<div class="col-lg-5 col-md-12 col-sm-12">
            	    <input type="text" name="others" value="<?=$row['others']?>" class="form-control" placeholder="Other Details">
				</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 ">Description </label>
				<div class="col-lg-9 col-md-12 col-sm-12">
            	    <textarea name="description" class="form-control" placeholder="Country"><?=$row['description']?></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>
</div>
<?php } } ?>
	</form>
			
<?php

if(isset($_POST['sub'])){
  $client=explode(':',$_POST['agent']);
	
$allowed = ["name","email","phone","address","country","location","alt_phone","company_name","company_address","description","others","gstin"];

$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "uid")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars($_POST[$key]);
    }
}
 $setStr .= "`source` = :source,`agent_id` = :agent_id,`agent_name` = :agent_name,`agent_phone` = :agent_phone,";
$setStr = rtrim($setStr, ",");
$params['source'] =$_POST['source'];
$params['agent_id'] =$client[0];
$params['agent_name'] =$client[1];
$params['agent_phone'] =$client[2];
$params['id'] =$_REQUEST['id'];
$show->table ='client';
$show->cols =$setStr;
$show->id_name ='id';
$show->params =$params;
//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_client.php

Server Info

System Features

User Info