-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_places.php
71 lines (64 loc) · 1.9 KB
/
add_places.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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?php
require_once('db_fns.php');
require_once('user_auth_fns.php');
require_once('output_fns.php');
session_start();
try
{
if(!check_valid_user())
throw new Exception('Please log in');
if($_SESSION['type'] != 'master')
throw new Exception('User not allowed to add new place');
@$place = $_POST['tPlace'];
if($place == '')
throw new Exception('Please enter a valid place');
$conn = db_connect();
$query = "select place from places where place='".$place."';";
$result = $conn->query($query);
if($result->num_rows >0)
throw new Exception('Place already exists');
$query = "insert into places values('".$place."');";
$result = $conn->query($query);
if(!$result)
throw new Exception('Unable to add place .. please try later');
else
{
do_html_header('Add Place');
?>
<tr>
<td height = "400" >
<table width="800" align="center" cellpadding="0" border="0" cellspacing="0" >
<tr>
<td class = "box">
<table width = "800" border="0" cellpadding="0" cellspacing="4" align="center">
<tr>
<td height="30" align="left" valing="middle" class="heading">Add Places</td>
</tr>
<tr>
<td valing="middle" class="home_gallery_data">
<table width="100%" border="0" cellspacing="4" cellpadding="0" align="center">
<tr>
<td><? echo $place; ?> has been successfully added to the database</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="50"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<p> </p>
<?php
}
}
catch(Exception $e)
{
display_error($e->getMessage());
}
display_user_menu();
?>