MAINHACK

Viewing / Editing File: edit_client.php

<?php
include('header.php');
?>
<script>
    function checkPass()
{
    var pass1 = document.getElementById('pass1');
    var pass2 = document.getElementById('pass2');
    var message = document.getElementById('error-nwl');
    var goodColor = "#66cc66";
    var badColor = "#ff6666";
 	
    if(pass1.value.length > 7)
    {
        message.style.color = goodColor;
        message.innerHTML = "character number ok!"
    }
    else
    {
        message.style.color = badColor;
        message.innerHTML = " you have to enter at least 8 digit!"
        return;
    }
  
    if(pass1.value == pass2.value)
    {
        message.style.color = goodColor;
        message.innerHTML = "ok!"
        document.getElementById("btn").disabled = false;
   
    }
	else
    {
        message.style.color = badColor;
        message.innerHTML = " These passwords don't match"
       document.getElementById("btn").disabled = true;

}
}
</script>
<div id="page-wrapper">
        
 <div class="row">
 <div class="col-md-12">
    <div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
         <div class="form-title">
         <h4>Edit  Client  :</h4>
         </div>
         <div class="form-body">

<form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" > 
<?php
			
$count=1;
$sr='client';
$stmt =$show->readwithdata($sr,'id',$_REQUEST['id']);
$num = $stmt->rowCount();
     
if($num>0){

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
extract($row);

$client_id=$row['client_id'];

?>
		<div class="card-body">
	
		      <div class="form-group">
		      <div class="col-lg-4 col-md-4 col-sm-12">
                <label>Name</label>
            	  <input type="text" name="name" placeholder="Name"  value="<?=$row['name']?>" class="form-control">
				</div>
			</div>	
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12">

<label>Email<span class="required-label">*</span></label>
            	  <input type="text" name="email" placeholder="Email"  value="<?=$row['email']?>" class="form-control">
				</div>
            </div>   
            	<div class="form-group">
	        <div class="col-lg-4 col-md-4 col-sm-12">
				 <label>Phone<span class="required-label">*</span></label>
            	  <input type="text" name="phone" placeholder="Phone"  value="<?=$row['phone']?>" class="form-control">
				</div>
				  <div class="clearfix"></div>
            </div>   
            	<div class="form-group">
	            <div class="col-lg-3 col-md-3 col-sm-12">
				 <label>Alt Phone</label>
			      <input type="text" name="alt_phone" placeholder="Alt Phone"  value="<?=$row['alt_phone']?>" class="form-control">
				</div>
				
	            <div class="col-lg-3 col-md-4 col-sm-12">
				 <label>Contact Person</label>
			      <input type="text" name="contact_person" placeholder="Contact Person"   value="<?=$row['contact_person']?>"class="form-control">
				</div>
            
				<div class="col-lg-2 col-md-4 col-sm-12">
				 <label>Country</label>
            	  <input type="text" name="country" placeholder="Country"   value="<?=$row['country']?>" class="form-control">
				</div>

</div> 
            
            	<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12">
				 <label>State<span class="required-label">*</span></label>
                <select name="state" class="form-control" required>  
              <option value="">Choose</option>

<?php
			
$sr='state_list';
$stmt1 =$show->state($sr);
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)){
        extract($row1);
        ?>
                <option value="<?=$row1['state']?>" <?php if($row['state']==$row1['state']) echo "selected"; ?>><?=$row1['state']?></option> 
                
        <?php } ?>
                
                 
              </select>			
              </div>
           <div class="clearfix"></div>

</div>    
              	<div class="form-group">
				<div class="col-lg-2 col-md-4 col-sm-12">

<label>Source<span class="required-label">*</span></label>
                <select name="source" class="form-control" required>  
              <option value="">Choose</option>

<?php
			
$stmt2 =$show->readAll('source');
        while ($row2 = $stmt2->fetch(PDO::FETCH_ASSOC)){
        extract($row2);
        ?>
                <option value="<?=$row2['source']?>" <?php if($row2['source']==$row['source']) echo "selected"; ?>><?=$row2['source']?></option> 
                
        <?php } ?>
                
                 
              </select>	
                      <div class="clearfix"></div>

</div>
            <br>
         <hr>  
         
         	<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>
    
        			<table class="table" id='example'>
							<thead>
								<tr>  
								 <th>Sl</th>
							      <th>Date</th>
								  <th>Client Details </th>
							      <th>Project Id </th>
							      <th> Project</th>
							      <th> Domain</th>
                                 <th>Action</th>
								</tr>
							 </thead>
			 <tbody>

<?php
			
    $count=1;
    $sr='project';
    $stmt =$show->readwithdata($sr,'client_id',$client_id);
    $num = $stmt->rowCount();
    if($num>0){
    $count=1;
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
    extract($row);
    $id=$row['id']; 
    echo "<tr>
    <td>$count</td>
 <td>".date('d-m-Y',strtotime($row['date']))."</td>    
 <td>".$row['client_id']."<br>".$row['name']."<br>".$row['email']."<br>".$row['phone']."</td>
 <td>".$row['project_id']."</td>
 <td>".$row['project']."</td>
 <td>".$row['domain']."</td>
   
 <td>
<a href='edit_project.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='label label-success'>Edit</a>
<a href='delete.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='label label-danger' onclick='return send();'>Delete</a>
</td>
</tr>";

++$count;
 }
}

?>							
</tbody>
</table>

</div>

<?php    
}
}
?>   
	</form>
			
     </div>
   
    </div>		
 </div>

</div>

<?php
if(isset($_POST['sub'])){

$allowed = ["name","email","phone","email","alt_phone","source","state","country"];
$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['id'] =$_REQUEST['id'];
$show->table ='client';
$show->cols =$setStr;
$show->id_name ='id';
$show->params =$params;

$r=$show->update_all();
if($r){
    echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "Your Blog has been updated",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
}

}
?>
</div>

<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_client.php

Server Info

System Features

User Info