delete.php
changeset 1 29ae580f12bd
parent 0 a4bc6ef5dbfe
equal deleted inserted replaced
0:a4bc6ef5dbfe 1:29ae580f12bd
     1 <?php
     1 <?php
     2 	// get request ID to delete
     2 	// get request ID to delete
     3 	$req_ID = $_GET['req_id'];
     3 	$req_ID = $_GET['req_id'];
     4 	
     4 	
     5 	$conn = mysql_connect('localhost','root','') or die(mysql_error());
     5 	$conn = mysql_connect('localhost','www-data','www-data') or die(mysql_error());
     6 	mysql_select_db('h4c_db');
     6 	mysql_select_db('members');
     7 	
     7 	
     8 	// retrieve cookie if it exists
     8 	// retrieve cookie if it exists
     9 	if ($req_ID != "") 
     9 	if ($req_ID != "") 
    10 	{	
    10 	{	
    11 		$query = mysql_query("DELETE FROM requests_tbl WHERE (req_ID = '$req_ID')");
    11 		$query = mysql_query("DELETE FROM requests_tbl WHERE (req_ID = '$req_ID')");
    16 ?>
    16 ?>
    17 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    17 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    18 <html xmlns="http://www.w3.org/1999/xhtml">
    18 <html xmlns="http://www.w3.org/1999/xhtml">
    19 <head>
    19 <head>
    20 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    20 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    21 <title>H4C - deleting request information...</title>
    21 <title>N4C - deleting request information...</title>
    22 <link href="files/h4c_main.css" rel="stylesheet" type="text/css" media="screen" />
    22 <link href="files/n4c_main.css" rel="stylesheet" type="text/css" media="screen" />
    23 </head>
    23 </head>
    24 
    24 
    25 <body>
    25 <body>
    26 <?php
    26 <?php
    27 	// FOR TEST PURPOSES - CHECK QUERYSTRING
    27 	// FOR TEST PURPOSES - CHECK QUERYSTRING