1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / goldenvillage.mfmsbd.com /
Filename : set_branch.php
back
<?php

	require 'functions.php';
	checkLogin();
	$db_link = connect();
	$timestamp = time();
    $demo_version = true;

	if (isset($_POST['add_branch'])) {
		
			$branch_name = sanitize($db_link, $_POST['branch_name']);
			$branch_code = sanitize($db_link, $_POST['branch_code']);
			$branch_location = sanitize($db_link, $_POST['branch_location']);
			$branch_description = sanitize($db_link, $_POST['branch_description']);


			//Insert Branche
			$sql = "INSERT INTO branch (branch_name, branch_code, branch_location, branch_description) VALUES ('$branch_name', '$branch_code ', '$branch_location', '$branch_description')";

			$query = mysqli_query($db_link, $sql) or die("Branch query faild!");

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


	//Show Branch
	$sql_show = "SELECT * FROM branch";
	$query_show = mysqli_query($db_link, $sql_show);

 ?>

<?php headandmenu('Branches', '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 -->
		
			
		<!-- LEFT SIDE: Form for entering new expense -->
		<div class="row">
		<div class="col-md-4 mb-3">
			
			<p class="heading_narrow">Add New Branch</p>
			<form action="set_branch.php" method="post" onSubmit="return validate(this)">
				
				<table id="tb_fields">
					
					<tr>
						<td>Branch Name:</td>
						<td><input type="text" class="form-control" name="branch_name" required /></td>
					</tr>
					<tr>
						<td>Branch Code:</td>
						<td><input type="text" class="form-control" name="branch_code"/></td>
					</tr>
					<tr>
						<td>Branch Location:</td>
						<td><input type="text" class="form-control" name="branch_location" required /></td>
					</tr>
					<tr>
						<td>Description:</td>
						<td><textarea rows="4" cols="20" class="form-control" name="branch_description"></textarea></td>
					</tr>
					<tr>
						<td></td>
						<td><input type="submit" name="add_branch" class="btn btn-primary" value="Save Branch" /></td>
					</tr>
				</table>
				
			</form>
		</div>
		
		<!-- RIGHT SIDE: Recent Expenses -->
		<div class="col-md-8">
			<table id="tb_table">
				<tr>
					<th class="title" colspan="7">Branches</th>
				</tr>
				<tr>
					<th>Branch Name</th>
					<th>Branch Code</th>
					<th>Branch Location</th>
					<th>Action</th>
					
				</tr>

				<?php while ($row = mysqli_fetch_assoc($query_show)) {?>
				
				<tr>
					<td><?php echo $row['branch_name'];?></td>
					<td><?php echo $row['branch_code'];?></td>
					<td><?php echo $row['branch_location'];?></td>
					<td>
					    <?php if(!$demo_version){ ?>
						<a class="btn btn-sm btn-info text-light" href="branch_update.php?branch=<?php echo $row['branch_id']?>"> <?php } ?>
						    
                        <i class="fa-solid fa-pen-to-square"></i></a>
						
                            <?php if(!$demo_version){ ?>						
						    <a onclick="return confirm('Are you sure to delete?')" class="btn btn-sm btn-danger text-light" href="delete_branch.php?id=<?php echo $row['branch_id']?>">
						        <?php } ?>
						        <i class="fa-solid fa-trash"></i></a>
						    
					    
						
					</td>
				</tr>

				<?php } ?>

			</table>
		</div>

	</div>


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