/
'
executable file
·366 lines (256 loc) · 10.8 KB
/
'
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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3c.org/TR/xhtml 1/DTD/xhtml 1-transitional.dtd">
<?
session_start();
$_SESSION['mid']=1;
?>
<html><!--issues:The vehicle registration details have not been fully specified and implemented...later update:kinda solved with the fill one,fill all message.-->
<head>
<link rel="stylesheet" type="text/css" href="signup.css" >
<title>
The Sign Up
</title>
<style type="text/css">
.radio1{
position:relative;
left:130px;
}
</style>
</head>
<h1>We want to know you!</h1>
<form id="form" name="frmInput" method="post" onsubmit="return validation();" action="signup.php" >
<p ><font id="error" face="arial" size="3" color="red" style="position:relative; left:200px;"> </font></p>
<p><label for="name">*Name:</label><input title="Name" type="text" name="txtName"> </p>
<br>
<p><label for="sex">*Sex:</label>Male<input type="radio" name="radSex" value="M"><span class="radio">Female</span><input class="radio" type="radio" name="radSex" value="F"> </p>
<br>
<p><label for="mobile">*Mobile number:</label><input type="text" name="txtMob_no" id="txtMob_no" maxlength="10"> </p>
<br>
<p ><font id="numerror" face="arial" size="2" color="red" style="position:relative; left:220px;"> </font></p>
<p><label for="email">*Email id:</label><input type="text" name="txtEmail_id" maxlength="30"></p>
<br>
<p><label for="pass">*Password:</label><input type="password" name="txtPassword" maxlength="15"><font size="2">(this will be your username and password when you login)</font> </p>
<br>
<p ><font id="passerror" face="arial" size="2" color="red" style="position:relative; left:200px;"> </font></p>
<p><label for="confirm pass">*Confirm password:</label><input type="password" name="txtConfirmpass" maxlength="15"> </p>
<br>
<h1>Your wheels?</h1><a href="#Location"><font style="position:relative; ">Do not have one?</a>
<p><font size="2">Fill one,you fill all.</font></p>
<p><label for="regn no">Registration number:</label><input title="registration number" type="text" name="txtRegno"></p>
<br>
<p><label for="veh type">Vehicle type:</label>2-wheeler<input type="radio" name="radVehicle" value="2"><span class="radio">4-wheeler</span><input class="radio" type="radio" name="radVehicle" value="4"></p>
<br>
<p><label for="seats">Pool capacity:</label>1<input type="radio" name="radSeat" value="1"> <span class="radio">2</span><input class="radio" type="radio" name="radSeat" value="2"><span class="radio1">3</span><input class="radio1" type="radio" name="radSeat" value="3"><font size="2" style="position:relative; left:180px;">(only for 4-wheelers)</font></p>
<br>
<p><label for="model">Model:</label><input title="model" type="text" name="txtModel"></p>
<br>
<p><label for="colour">Colour:</label><input title="colour" type"text" name="txtColour"></p>
<br>
<h1><a name="Location">Where are you?</h1>
<p><label for="locn">*Locality:</label><input type="text" maxlength="25" name="txtLocn"><font size="2">(Eg:PESIT)</font></p>
<br>
<p><label for="area">*Area:</label><input type="text" maxlength="25" name="txtArea"><font size="2">(Eg:Banashankari)</font></p>
<br>
<p style="position:relative;left:270px;"><font size="2">*<Mark your location on the map></font></p>
<p><input type="hidden" name="txtLat" id="lat" value=""></p>
<br>
<p><input type="hidden" name="txtLng" id="lng" value=""></p>
<table style="padding-left:5%;">
<tr><td>
<div id="map" style="position:relative;bottom:50px; width:1100px; height:400px;"><br/></td></div>
</tr>
</table>
<p style="postion:relative; padding-left:30%; bottom:500px;" class="submit"><input class="submit" type="submit" name="submit" value="Submit" > </p>
<br>
</form>
<script type="text/javascript">
function validation()
{
var form=document.getElementById("form");
document.getElementById('error').value="";
document.getElementById('passerror').value="";
document.getElementById('numerror').value="";
for(var i=0;i<form.length;i++)
{
if(((form.elements[i]!=form.txtRegno && form.elements[i]!=form.txtModel && form.elements[i]!=form.txtColour && form.elements[i]!=form.radVehicle && form.elements[i] != form.radSeat) && form.elements[i].value=="")|| (form.radSex[0].checked==false && form.radSex[1].checked==false))
{
document.getElementById('error').innerHTML="***Fields marked * are compulsory ***";
form.elements[i].focus();
return false;
}
}
if(document.frmInput.txtPassword.value!=document.frmInput.txtConfirmpass.value)
{
document.getElementById('passerror').innerHTML="***Passwords do not match..please re-enter***";
form.txtPassword.focus();
return false;
}
var num=/\D/;//Invalid even if a single non-digit occurs.
var check=1;
if(document.getElementById("txtMob_no").value.match(num))
{
check=0;
}
if(document.frmInput.txtMob_no.value.length == 10 && check)
{
return true;
}
else
{
document.getElementById('numerror').innerHTML="***Invalid mobile number..please re-enter***";
form.txtMob_no.focus();
return false;
}
}
</script>
<form name="test" action="#" onsubmit="showAddress(this.address.value); return false">
<div style="position:relative; left:15%; top:30%;">
<table align="right" class="trouble" >
<tr>
<td><input type="text" size="20" name="address" value="pesit" /></td>
<td align="center"> <input type="submit" value="Search" /></td>
</tr>
</table>
</form>
</div>
<script src="http://maps.google.com/maps?file=api&v=2&key=ABQIAAAAgrj58PbXr2YriiRDqbnL1RRdqDCIfn-akWLPXbZqJg-hQ6eHehSRJ1rozvQIj0_jjwfMfzxMVY23oQ"
type="text/javascript"></script>
<script type="text/javascript">
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById("map"));
map.addControl(new GSmallMapControl());
map.addControl(new GMapTypeControl());
var center = new GLatLng(12.935440,77.535020);
map.setCenter(center, 15);
geocoder = new GClientGeocoder();
var marker = new GMarker(center, {draggable: true});
map.addOverlay(marker);
document.getElementById("lat").value = center.lat().toFixed(6);
document.getElementById("lng").value = center.lng().toFixed(6);
GEvent.addListener(marker, "dragend", function() {
var point = marker.getPoint();
map.panTo(point);
document.getElementById("lat").value = point.lat().toFixed(6);
document.getElementById("lng").value = point.lng().toFixed(6);
});
GEvent.addListener(map, "moveend", function() {
map.clearOverlays();
var center = map.getCenter();
var marker = new GMarker(center, {draggable: true});
map.addOverlay(marker);
document.getElementById("lat").value = center.lat().toFixed(6);
document.getElementById("lng").value = center.lng().toFixed(6);
GEvent.addListener(marker, "dragend", function() {
var point =marker.getPoint();
map.panTo(point);
document.getElementById("lat").value = point.lat().toFixed(6);
document.getElementById("lng").value = point.lng().toFixed(6);
});
});
}
}
function showAddress(address) {
address+=",bangalore";
var map = new GMap2(document.getElementById("map"));
map.addControl(new GSmallMapControl());
map.addControl(new GMapTypeControl());
if (geocoder) {
geocoder.getLatLng(
address,
function(point) {
if (!point) {
alert(address + " not found");
} else {
document.getElementById("lat").value = point.lat().toFixed(6);
document.getElementById("lng").value = point.lng().toFixed(6);
map.clearOverlays()
map.setCenter(point, 15);
var marker = new GMarker(point, {draggable: true});
map.addOverlay(marker);
GEvent.addListener(marker, "dragend", function() {
var pt = marker.getPoint();
map.panTo(pt);
document.getElementById("lat").value = pt.lat().toFixed(6);
document.getElementById("lng").value = pt.lng().toFixed(6);
});
GEvent.addListener(map, "moveend", function() {
map.clearOverlays();
var center = map.getCenter();
var marker = new GMarker(center, {draggable: true});
map.addOverlay(marker);
document.getElementById("lat").value = center.lat().toFixed(6);
document.getElementById("lng").value = center.lng().toFixed(6);
GEvent.addListener(marker, "dragend", function() {
var pt = marker.getPoint();
map.panTo(pt);
document.getElementById("lat").value = pt.lat().toFixed(6);
document.getElementById("lng").value = pt.lng().toFixed(6);
});
});
}
}
);
}
}
</script>
<body onload="load()" onunload="GUnload()" >
</body>
<?php
$flag=1;
error_reporting(~E_NOTICE);
if(isset($_POST["submit"]))
{
mysql_connect("localhost","pool","pool") or die(mysql_error()); //establish database connection
mysql_select_db("pool") or die(mysql_error());//select pool database
$name=$_POST["txtName"];
$email=$_POST["txtEmail_id"];
$mobile=$_POST["txtMob_no"];
$password=$_POST["txtPassword"];
$gender=$_POST["radSex"];
$getemail=mysql_query("Select * from member where email_id='$email'");
if(mysql_num_rows($getemail)!=0)
{
echo "<p style='position:relative; bottom:1590px; left:200px;'><font face='arial' size='2' color='red'>***User with the given email-id already exists***</font></p>";
$flag=0;
}
if($flag==1)
{
mysql_query("insert into member values ('-1','$name','$gender','$email','$mobile','$password')") or die("");
$result=mysql_query("select mid from member where name='$name' and mobile_no='$mobile'");
$row=mysql_fetch_array($result);
$mid=$row['mid'];
}
$regno=$_POST["txtRegno"];
$type=$_POST["radVehicle"];
$model=$_POST["txtModel"];
$colour=$_POST["txtColour"];
$capacity=$_POST["radSeat"];
if($regno!="" && $type !="" && $model !="" && $colour!="" && $capacity!="")
{
if($type==2)
$capacity=1;
$getregno=mysql_query("Select * from vehicle where reg_no='$regno'");
if(mysql_num_rows($getregno)!=0)
{
echo "<p style='position:relative; bottom:1230px; left:190px;'><font face='arial' size='2' color='red'>***User with the given vehicle registration number already exists***</p>";
$flag=0;
}
if($flag==1)
{
mysql_query("insert into vehicle values ('$regno','$model','$colour','$type','$mid','$capacity')") or die("");
}
}
$locality=$_POST["txtLocn"];
$area=$_POST["txtArea"];
$lat=$_POST["txtLat"];
$lng=$_POST["txtLng"];
mysql_query("insert into location values ('$mid','$lat','$lng','$locality','$area')") or die("");
$_SESSION['mid']=$mid;
?>
<script type="text/javascript">
window.location="home.php";
</script>
<?
}
?>
</html>