1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / dev.mfmsbd.com /
Filename : branch_update.php
back
<?php 
require 'functions.php';
	checkLogin();
	$db_link = connect();
	$timestamp = time();



$branch_id = $_GET['branch'];
//Select Query
$select_sql = "SELECT * FROM branch WHERE branch_id='$branch_id'";
$query_update = mysqli_query($db_link, $select_sql)or die("Branch update query faild");

$row = mysqli_fetch_assoc($query_update);

if (isset($_POST['update_branch'])) {
	
	$branch_name = $_POST['branch_name'];
	$branch_code = $_POST['branch_code'];
	$branch_location = $_POST['branch_location'];
	$branch_description = $_POST['branch_description'];
	$hidden_id = $_POST['hidden_id'];


	//Update Queyr
	$update_sql ="UPDATE branch SET branch_name='$branch_name', branch_code='$branch_code', branch_location='$branch_location', branch_description='$branch_description'  WHERE branch_id='$hidden_id'";

	$save_query = mysqli_query($db_link, $update_sql);

	if($save_query){
	header("location: set_branch.php");
		}

}


?>

<?php headandmenu('Branch Update', '2brn'); ?>

<!--main content start-->
      <section id="main-content">
          <section class="wrapper" style="min-height: 850px;">


          <!--breadcrumbs start -->
          	<div class="row">
                  <div class="col-lg-12 pb-4">
                      <!--breadcrumbs start -->
                      <nav aria-label="breadcrumb">
                          <ol class="breadcrumb">
                              <li class="breadcrumb-item"><a href="start.php"><i class="fa fa-home"></i> Dashboard</a></li>
                              <li class="breadcrumb-item active" aria-current="page">Branches</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->


		<div class="row">
			<div class="col-sm-6 offset-3">
				<form action="branch_update.php" method="post" onSubmit="return validate(this)">
				
				<table id="tb_fields">
                <p class="heading_narrow">Update Branch</p>
                
					
					<tr>
						<input type="hidden" name="hidden_id" value="<?php echo $row['branch_id']; ?>"/>
						<td>Branch Name:</td>
						<td><input type="text" name="branch_name" value="<?php echo $row['branch_name']; ?>" /></td>
					</tr>
					<tr>
						<td>Branch Code:</td>
						<td><input type="text" name="branch_code" value="<?php echo $row['branch_code']; ?>"/></td>
					</tr>
					<tr>
						<td>Branch Location:</td>
						<td><input type="text" name="branch_location" value="<?php echo $row['branch_location']; ?>"/></td>
					</tr>
					<tr>
						<td>Description:</td>
						<td><textarea rows="4" cols="20" name="branch_description"><?php echo $row['branch_description']; ?></textarea></td>

					</tr>
					<tr>
						<td></td>
						<td><input type="submit" name="update_branch" value="Save Branch" class="btn btn-primary" /></td>
					</tr>
				</table>
				
			</form>
			</div>
		</div>





        </section>
      </section>
      <!--main content end-->
      
   <?php footer(); ?>