.-.-.-.-.-

<?php
$title = "Edit Franchise";
include 'header.php';
if(!isset($_GET['fid']) || $_GET['fid'] == '') redirect('franchise_list.php');
?>
<?php
$fid = $_GET['fid'];
if(isset($_POST['submit']))
{
//move_uploaded_file($_FILES["file"]["tmp_name"], "p_upload/" . $_FILES["file"]["name"]);
     //$path= "p_upload/" . $_FILES["file"]["name"];
    
 $sql = "UPDATE `franchise` SET
     name = '".$_POST['name']."',
     email =    '".$_POST['email']."',
          password =   '".$_POST['password']."',
                mobile = '".$_POST['mobile']."',
                   store_name =  '".$_POST['store_name']."',
                         address = '".$_POST['address']."',
                           city =  '".$_POST['city']."',
                              state =   '".$_POST['state']."',
                                   pin =  '".$_POST['pin']."',
                                      account_no =   '".$_POST['account_no']."',
                                           acc_holder_name =  '".$_POST['holder_name']."',
                                              bank_name =   '".$_POST['bank_name']."',
                                                  bank_branch_name =   '".$_POST['branch_name']."',
                                                       pan =  '".$_POST['pan']."',
                                                         ifse   = '".$_POST['ifse']."'
                                                             WHERE fid = '$fid'";   
 //echo $sql;
 $is_success = mysqli_query($connection, $sql);    
   if($is_success){
    setMessage('Save Successfully', 'succ');
   } 
   else{
   setMessage('Some error occured. Try again!', 'error');
   } 
  redirect('franchise_list.php');   
}

?>
<?php
$fid = $_GET['fid'];
$row = mysqli_fetch_object(mysqli_query($connection, "select * from franchise where fid = '$fid'"));
?>
<h3>Edit a franchise</h3>

<form action="" method="post">
<table border="1">
<tr>
<td>Name</td>
<td><input type="text" name="name" id="name" value="<?php echo $row->name;?>" size="40" required="required"/></td>
</tr>

<tr>
<td>Email</td>
<td><input type="text" name="email" value="<?php echo $row->email;?>" id="email" size="40" required="required"/></td>
</tr>

<tr>
<td>Password</td>
<td>
<input type="text" name="password" value="<?php echo $row->password;?>"  id="password" size="40" required="required"/></td>
</tr>

<tr>
<td>Mobile #</td>
<td><input type="text" name="mobile" value="<?php echo $row->mobile;?>"  id="mobile" size="40" required="required"/></td>
</tr>

<tr>
<td>Store name</td>
<td><input type="text" name="store_name" value="<?php echo $row->store_name;?>"  id="store_name" size="40" required="required"/></td>
</tr>

<tr>
<td>Address</td>
<td><input type="text" name="address" value="<?php echo $row->address;?>"  id="address" size="40"/></td>
</tr>
    <tr>
<td>City</td>
<td><input type="text" name="city" value="<?php echo $row->city;?>"  id="city" size="40" required="required"/></td>
</tr>

<tr>
<td>State</td>
<td><input type="text" name="state" value="<?php echo $row->state;?>"  id="state" size="40" required="required"/></td>
</tr>

<tr>
<td colspan="2">Bank details</td>
</tr>

<tr>
<td>Account #</td>
<td><input type="text" name="account_no"  value="<?php echo $row->account_no;?>"  id="account_no" size="40"/></td>
</tr>

<tr>
<td>Account holder name</td>
<td><input type="text" name="holder_name" value="<?php echo $row->acc_holder_name;?>"  id="holder_name" size="40"/></td>
</tr>

<tr>
<td>Branch name</td>
<td><input type="text" name="branch_name" value="<?php echo $row->bank_branch_name;?>"  id="branch_name" size="40"/></td>
</tr>

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

/home2/wtmwscom/mail/../.caldav/../public_html/admin/edit_franchise.php