ShootReportSystem/selectShoot.php at master · peteritism/ShootReportSystem · 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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php

include ('config.php');
include ('init.php');
include ('include.php');

$clubId = $_GET['clubId'];

?>

<!DOCTYPE html>
<html>
<head>

	<title>Shoot Selector</title>

	<?php
		include 'header.php';
	?>

</head>

<body>

	<h1>Select Shoot</h1>
	<h2>Click Shoot to see Events</h2>
	<?php

		$query = 	'SELECT *
					FROM registeredshoot
					WHERE clubId =' . $clubId;
		$result = dbquery($query);
		if(!mysqli_fetch_array($result)){
			echo 'This club has not added any shoots yet';
		}else {
			mysqli_data_seek($result,0);
			while($row = mysqli_fetch_array($result)){
				echo $row['shootDate'] . ' <a href=\'selectEvent.php?shootId=' . $row['id'] . '\'>' . $row['shootName'] . '</a>';
				echo '<br/>';
			}
		}


	?>

</body>

<?php

	include 'footer.php';

?>


<script type="text/javascript">

</html>