MAINHACK

Viewing / Editing File: edit_client.php

<?php include 'header.php' ;

$show=new Oops($db);
?>
<?php
			
$count=1;
$stmt =$show->readwithdata('client','id',$_REQUEST['id']);
$num = $stmt->rowCount();
     
     if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
		
		$id=$row['id'];    
        $uid=$row['client_id'];    
        $email=$row['email'];     
        $city=$row['city'];
        $pincode=$row['pincode'];
		$com=$row['company_name'];
		$gstin=$row['gstin'];
		$address=$row['address'];
		$contact_person1=$row['contact_person1'];
		$phone1=$row['phone1'];
		$contact_person2=$row['contact_person2'];
		$address=$row['address'];

$phone2=$row['phone2'];
		$state=$row['state'];

$web=$row['company_website'];
		$reference=$row['reference'];
		$date_of_register=date('d-m-Y',strtotime($row['date_of_register']));

}
         
     }	
     ?>

<div id="page-wrapper">
			<div class="main-page">
				<div class="row">
                        <div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
						<div class="form-title">
							<h4>Client Edit :</h4>
						</div>
						<div class="form-body">
							<form method="post"  enctype="multipart/form-data">

<div class="col-md-4">
								<div class="form-group">
									<label>Company Name</label>
									<input type="text" class="form-control" id="com_name" name="company_name" value="<?=$com?>" placeholder="Company Name">
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label>Company Website</label>
									<input type="text" class="form-control" id="com_name" name="company_website" value="<?=$web?>" placeholder="Company Website">
								</div>
							</div>
								<div class="col-md-4">
								<div class="form-group">
									<label>GSTIN</label>
									<input type="text" class="form-control" name="gstin" id="gstin" value="<?=$gstin?>" placeholder="GSTIN">
								</div>
							</div>
								<div class="col-md-4">
								<div class="form-group">
									<label>Email ID</label>
									<input type="text" class="form-control" name="email" id="gstin" value="<?=$email?>" placeholder="Email ID">
								</div>
							</div>							
							<div class="col-md-4">
								<div class="form-group">
									<label>Contact Name 1</label>
									<input type="text" class="form-control" name="contact_person1"value="<?=$contact_person1?>" placeholder="Contact Name 1" >
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label for="exampleInputEmail1">Contact Phone 1</label>
									<input type="text" class="form-control" name="phone1"value="<?=$phone1?>" placeholder="Contact Phone 1">
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label>Contact Name 2</label>
									<input type="text" class="form-control" name="contact_person2"value="<?=$contact_person2?>" placeholder="Contact Name 2" >
								</div>
							</div>
							<div class="col-md-4">
								<div class="form-group">
									<label for="exampleInputEmail1">Contact Phone 2</label>
									<input type="text" class="form-control" name="phone2" value="<?=$phone2?>"placeholder="Contact Phone 2">
								</div>
							</div>
						
							<div class="col-md-12">
								<div class="form-group">
									<label>Address</label>
						<input type="text" class="form-control" name="address" id="address"value="<?=$address?>" placeholder=" Address" >
								</div>
							</div>
							<div class="col-md-4 pr-1">
								<div class="form-group">
									<label>State</label>
									<select name="state" required class="form-control">
									    <option value="">Choose</option>
									 <?php 
									 $stmt=$show->state('state_list');
									 $r=$stmt->rowCount();
									 if($r>0){
                                     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                echo "<option value='".$row['state']."'";
						if($state==$row['state']) echo "selected";
						echo ">".$row['state']."</option>";
						    									}
    									}
									 ?>   
									    
									</select>
								</div>
							</div>
							<div class="col-md-4 pr-1">
								<div class="form-group">
									<label>City</label>
									<input type="text" class="form-control" name="city" value="<?=$city?>" placeholder="City">
								</div>
							</div>
							<div class="col-md-4 pl-1">
								<div class="form-group">
									<label>Postal Code</label>
									<input type="number" class="form-control" value="<?=$pincode?>" name="pincode" placeholder="ZIP Code">
								</div>
							</div>
							<div class="col-md-4 pl-1">
								<div class="form-group">
									<label>Reference</label>
									<input type="text" class="form-control" name="reference" value="<?=$reference?>" placeholder="Reference">
								</div>
							</div>
						<div class="col-md-4 pl-1">
								<div class="form-group">
									<label>Date of Registration</label>
									<input type="text"  id="date" class="form-control" value="<?=$date_of_register?>" name="date_of_register" placeholder="Date of Registration">
								</div>
							</div>
						
						<button type="submit" class="btn btn-info btn-fill pull-right" name="sub">Submit</button>
						<div class="clearfix"></div>
                                    </form>
<?php
if(isset($_POST['sub'])){
	
	$table='client';

$allowed = ["company_name","company_website","gstin","email","contact_person1","phone1","contact_person2","phone2","address","state","city","pincode","city","reference","date_of_register"];

$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;

if($show->update_all()){
    		
echo "<script>sweetAlert('OK','Client has been updated','success');window.location.href='".$_SERVER['request_uri']."'</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