1#@!#!123s

��JFIF�� 1#@!#!123s

: / home / mfms22 / prothito.mfmsbd.com /

Filename : delete_cust.php

back

<?php 
require 'functions.php';
	checkLogin();
	$db_link = connect();


$id = $_GET['id'];

$loan_sql = "SELECT loans.cust_id FROM loans WHERE cust_id= $id";
$loan_query = mysqli_query($db_link, $loan_sql)or die("Query Faild");
$row = mysqli_fetch_assoc($loan_query);


if($row['cust_id']==$id){

// $sql = "DELETE FROM customer, savings WHERE `customer.cust_id`='$id' AND savings.cust_id=$id";
$sql = "DELETE c.*, l.*, s.* FROM customer c INNER JOIN loans l ON c.cust_id=l.cust_id INNER JOIN savings s ON c.cust_id=s.cust_id WHERE c.cust_id='$id'";
$query = mysqli_query($db_link, $sql) OR die ("QUERY FAILD");

}else{
	$sql = "DELETE FROM customer WHERE cust_id=$id";
	$query = mysqli_query($db_link, $sql);
}

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


?>