Inventory-Management-System/loan2RCV.php at main · Shigal/Inventory-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?php
include('db_conn.php');
?>

<?php

	$rcvdate = $_POST['field1'];
	$id  = $_POST['field2'];
	$type = $_POST['field3'];
	$givendept = $_POST['field4'];
	$rmrk  = $_POST['field5'];

	$query10 = "SELECT * FROM `loan-rcv` WHERE `idno`='$id'";
			$result10 = mysql_query($query10);
			$count10 = mysql_num_rows($result10);
			if($count10!=0){


				 $message = "Entry already exist";
echo "<script type='text/javascript'>window.confirm('$message');</script>";
					/* exit("<script type='text/javascript'>alert('$message');</script>"); */
					/* header('location:add_lab.html'); */
					echo "<script type='text/javascript'>window.location.href=\"loanRCV_add.html\";</script>";

					die();
			}

			else
			{

	$query6 = "INSERT INTO `loan-rcv`(rcvdate,idno,type,givendept,remark) VALUES('$rcvdate','$id','$type','$givendept','$rmrk')";

	$result6 = mysql_query($query6);

	if($result6)
	{
		header('location:loanRCV_add.html');
	}
			}
?>