-
Notifications
You must be signed in to change notification settings - Fork 1
/
requestdup.php
31 lines (24 loc) · 999 Bytes
/
requestdup.php
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
<?php
define('db_host','localhost');
define('db_user' ,'balaji');
define('db_pass', 'spiderman');
define('db_name','copper');
$link = mysql_connect(db_host, db_user, db_pass) or die('unable to connect'.mysql_error());
$db_selected=mysql_select_db(db_name,$link) or die('cant use'.db_name.':'.mysql_error());
$value=$_POST['request_id'];
$value1=$_POST['name'];
$value2=$_POST['area'];
$value3=$_POST['phone_number'];
$value5=$_POST['description'];
echo" <center>Registered successfully <br> YOUR ID is $value </center><br><br>";
$sql="insert into request(`REQUEST_ID`,`NAME`,`AREA`,`PHONE_NUMBER`,`DESCRIPTION`) values ('$value','$value1','$value2','$value3','$value5')";
if(!mysql_query($sql))
{echo "failure";
die('error: '.mysql_error());
}
$TEMP=mysql_query("CALL priorityforrequest()");
$TEMP=mysql_query("CALL delreq()");
?>
<form name="backhome" action="requesthome.html" method="POST">
<center><input type="submit" value="Back"></center><br>
</form>