Scouting-2015/form.php at master · Yingste/Scouting-2015 · 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
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
<?php


	$team = "";
	$test = "";
	$keyold = "";
	$row = "0";


function console($ctext)
{
	$time = time();
	$console = $time . " : " . $ctext . "\n";
	file_put_contents('console.txt',$console, FILE_APPEND);
}


// Create connection
$con=mysqli_connect("mysql.hostinger.co.uk","u730988852_scout","scouting" , "u730988852_scout");

// Check connection
if (mysqli_connect_errno())
  {
  console( "Failed to connect to MySQL: " . mysqli_connect_error());
  }

	if (!mysqli_connect_errno())
  {
  console( "Connection successful or something" . mysqli_connect_error());
  }


foreach ($_POST as $key => $value)
{
	if ($key == 'team')
		{
			//echo "$value";
			$team = $value;
			if (strlen($team) == 1)
			{
			$team = "000" . "$team" ;
			}
			if (strlen($team) == 2)
			{
			$team = "00" . "$team" ;
			}
			if (strlen($team) == 3)
			{
			$team = "0" . "$team" ;
			}


		}
	if ($key == 'match')
		{
			$match = $value;
		}


}

/*
$sql = "INSERT INTO scout (`team`, `match`, `id`, `value`) VALUES ('1','2','3','4')";
		if (mysqli_query($con, $sql)) {
			echo "New record created successfully";
		} else {
			echo mysqli_error($con);
		}
*/


foreach ($_POST as $key => $value)
{
	if (($key == "match") || ($key == "team"))
	{

	}else
	{
		//mysqli_query($con,"INSERT INTO scout (team, match, id, value) VALUES ('$team', '$match', '$key', $value)");
		//mysqli_query($con,"INSERT INTO `scout`(`team`, `match`, `id`, `value`) VALUES ($team,$match,$key,$value)");

		$sql = "INSERT INTO scout (`team`, `match`, `id`, `value`) VALUES ('$team','$match','$key','$value')";
		if (mysqli_query($con, $sql)) {
			echo "New record created successfully";
		} else {
			echo mysqli_error($con);
		}
		$response[$row] .= $team . "," . $match . "," . $key . "," . $value . "\n";
		file_put_contents('scouting.csv',$response[$row], FILE_APPEND);
		$row += 1;
	}


}


// auto go back to scouting interface
header('Location: ' . $_SERVER['HTTP_REFERER']);


?>