ResultsAdmin.php
--------------------------------------------------------------------------------------------------
<?php
// Inialize session
session_start();
// Check, if username session is NOT set then this page will jump to login page
if (!isset($_SESSION['username'])) {
header('Location: index.php');
}
?>
<?php
error_reporting(E_ALL);
include("../includes/Header.html");
include("../includes/conn.php");
?>
<center><p><a href="Admin.php">Back To Admin Index</a></p></center>
<center><p><a href="logout.php">Logout</a></p></center>
<table width="930" align="center">
<tr>
<td valign="top">
<center><h2><u>Submit Race Results</u></h2></center>
<form action="insertresults.php" method="post">
<?php
if($updated===TRUE)
{echo '<div>Results Updated</div>';
}
?>
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>
Race Date:
</th>
<td colspan="2">
<?php
$query2="SELECT Race_Number, Date FROM Schedule ORDER BY Date";
$result3 = mysql_query($query2) or die("Error executing:<br>$query2<br>" . mysql_error() );
echo "<select name=\"Race_Number\">";
echo "<option></option>";
while ($row=mysql_fetch_assoc($result3)) {
echo "<option value=\"{$row['Race_Number']}\">{$row['Date']}</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr>
<th>
Event:
</th>
<td colspan="2">
<?php
$query3="SELECT Event FROM Events";
$result4 = mysql_query($query3) or die("Error executing:<br>$query3<br>" . mysql_error() );
echo "<select name=\"Event\">";
echo "<option></option>";
while ($row=mysql_fetch_assoc($result4)) {
echo "<option>".$row['Event']."</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr><td>1</td><td><input type="text" name="1" /></td></tr>
<tr><td>2</td><td><input type="text" name="2" /></td></tr>
<tr><td>3</td><td><input type="text" name="3" /></td></tr>
<tr><td>4</td><td><input type="text" name="4" /></td></tr>
<tr><td>5</td><td><input type="text" name="5" /></td></tr>
<tr><td>6</td><td><input type="text" name="6" /></td></tr>
<tr><td>7</td><td><input type="text" name="7" /></td></tr>
<tr><td>8</td><td><input type="text" name="8" /></td></tr>
<tr><td>9</td><td><input type="text" name="9" /></td></tr>
<tr><td>10</td><td><input type="text" name="10" /></td></tr>
<tr><td>11</td><td><input type="text" name="11" /></td></tr>
<tr><td>12</td><td><input type="text" name="12" /></td></tr>
<tr><td>13</td><td><input type="text" name="13" /></td></tr>
<tr><td>14</td><td><input type="text" name="14" /></td></tr>
<tr><td>15</td><td><input type="text" name="15" /></td></tr>
<tr><td>16</td><td><input type="text" name="16" /></td></tr>
<tr><td>17</td><td><input type="text" name="17" /></td></tr>
<tr><td>18</td><td><input type="text" name="18" /></td></tr>
<tr><td>19</td><td><input type="text" name="19" /></td></tr>
<tr><td>20</td><td><input type="text" name="20" /></td></tr>
<tr><td>21</td><td><input type="text" name="21" /></td></tr>
<tr><td>22</td><td><input type="text" name="22" /></td></tr>
<tr><td>23</td><td><input type="text" name="23" /></td></tr>
<tr><td>24</td><td><input type="text" name="24" /></td></tr>
<tr><td>25</td><td><input type="text" name="25" /></td></tr>
<tr><td>26</td><td><input type="text" name="26" /></td></tr>
<tr><td>27</td><td><input type="text" name="27" /></td></tr>
<tr><td>28</td><td><input type="text" name="28" /></td></tr>
<tr><td>29</td><td><input type="text" name="29" /></td></tr>
<tr> <td>30</td><td><input type="text" name="30" /></td></tr>
<tr><td>DNF1</td><td><input type="text" name="DNF1" /></td></tr>
<tr><td>DNF2</td><td><input type="text" name="DNF2" /></td></tr>
<tr><td>DNF3</td><td><input type="text" name="DNF3" /></td></tr>
<tr><td>DNF4</td><td><input type="text" name="DNF4" /></td></tr>
<tr><td>DNF5</td><td><input type="text" name="DNF5" /></td></tr>
<tr><td>DNF6</td><td><input type="text" name="DNF6" /></td></tr>
<tr><td>DNF7</td><td><input type="text" name="DNF7" /></td></tr>
<tr><td>DNF8</td><td><input type="text" name="DNF8" /></td></tr>
<tr><td>DNF9</td><td><input type="text" name="DNF9" /></td></tr>
<tr><td>DNF10</td><td><input type="text" name="DNF10" /></td></tr>
<tr><td>DNS1</td><td><input type="text" name="DNS1" /></td></tr>
<tr><td>DNS2</td><td><input type="text" name="DNS2" /></td></tr>
<tr><td>DNS3</td><td><input type="text" name="DNS3" /></td></tr>
<tr><td>DNS4</td><td><input type="text" name="DNS4" /></td></tr>
<tr><td>DNS5</td><td><input type="text" name="DNS5" /></td></tr>
<tr><td>NT1</td><td><input type="text" name="NT1" /></td></tr>
<tr><td>NT2</td><td><input type="text" name="NT2" /></td></tr>
<tr><td>NT3</td><td><input type="text" name="NT3" /></td></tr>
<tr><td>NT4</td><td><input type="text" name="NT4" /></td></tr>
<tr><td>NT5</td><td><input type="text" name="NT5" /></td></tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="submit" value="Submit Results" /></td>
</tr>
</table>
</form>
</td>
<td valign="top">
<center><h2><u>Edit Race Results</u></h2></center>
<form action="updateresults.php" method="post">
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>
Race Date:
</th>
<td colspan="2">
<?php
$query2="SELECT Race_Number, Date FROM Schedule ORDER BY Date";
$result3 = mysql_query($query2) or die("Error executing:<br>$query2<br>" . mysql_error() );
echo "<select name=\"Race_Number\">";
echo "<option></option>";
while ($row=mysql_fetch_assoc($result3)) {
echo "<option value=\"{$row['Race_Number']}\">{$row['Date']}</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr>
<th>
Event:
</th>
<td colspan="2">
<?php
$query3="SELECT Event FROM Events";
$result4 = mysql_query($query3) or die("Error executing:<br>$query3<br>" . mysql_error() );
echo "<select name=\"Event\">";
echo "<option></option>";
while ($row=mysql_fetch_assoc($result4)) {
echo "<option>".$row['Event']."</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr><td>1</td><td><input type="text" name="1" /></td></tr>
<tr><td>2</td><td><input type="text" name="2" /></td></tr>
<tr><td>3</td><td><input type="text" name="3" /></td></tr>
<tr><td>4</td><td><input type="text" name="4" /></td></tr>
<tr><td>5</td><td><input type="text" name="5" /></td></tr>
<tr><td>6</td><td><input type="text" name="6" /></td></tr>
<tr><td>7</td><td><input type="text" name="7" /></td></tr>
<tr><td>8</td><td><input type="text" name="8" /></td></tr>
<tr><td>9</td><td><input type="text" name="9" /></td></tr>
<tr><td>10</td><td><input type="text" name="10" /></td></tr>
<tr><td>11</td><td><input type="text" name="11" /></td></tr>
<tr><td>12</td><td><input type="text" name="12" /></td></tr>
<tr><td>13</td><td><input type="text" name="13" /></td></tr>
<tr><td>14</td><td><input type="text" name="14" /></td></tr>
<tr><td>15</td><td><input type="text" name="15" /></td></tr>
<tr><td>16</td><td><input type="text" name="16" /></td></tr>
<tr><td>17</td><td><input type="text" name="17" /></td></tr>
<tr><td>18</td><td><input type="text" name="18" /></td></tr>
<tr><td>19</td><td><input type="text" name="19" /></td></tr>
<tr><td>20</td><td><input type="text" name="20" /></td></tr>
<tr><td>21</td><td><input type="text" name="21" /></td></tr>
<tr><td>22</td><td><input type="text" name="22" /></td></tr>
<tr><td>23</td><td><input type="text" name="23" /></td></tr>
<tr><td>24</td><td><input type="text" name="24" /></td></tr>
<tr><td>25</td><td><input type="text" name="25" /></td></tr>
<tr><td>26</td><td><input type="text" name="26" /></td></tr>
<tr><td>27</td><td><input type="text" name="27" /></td></tr>
<tr><td>28</td><td><input type="text" name="28" /></td></tr>
<tr><td>29</td><td><input type="text" name="29" /></td></tr>
<tr> <td>30</td><td><input type="text" name="30" /></td></tr>
<tr><td>DNF1</td><td><input type="text" name="DNF1" /></td></tr>
<tr><td>DNF2</td><td><input type="text" name="DNF2" /></td></tr>
<tr><td>DNF3</td><td><input type="text" name="DNF3" /></td></tr>
<tr><td>DNF4</td><td><input type="text" name="DNF4" /></td></tr>
<tr><td>DNF5</td><td><input type="text" name="DNF5" /></td></tr>
<tr><td>DNF6</td><td><input type="text" name="DNF6" /></td></tr>
<tr><td>DNF7</td><td><input type="text" name="DNF7" /></td></tr>
<tr><td>DNF8</td><td><input type="text" name="DNF8" /></td></tr>
<tr><td>DNF9</td><td><input type="text" name="DNF9" /></td></tr>
<tr><td>DNF10</td><td><input type="text" name="DNF10" /></td></tr>
<tr><td>DNS1</td><td><input type="text" name="DNS1" /></td></tr>
<tr><td>DNS2</td><td><input type="text" name="DNS2" /></td></tr>
<tr><td>DNS3</td><td><input type="text" name="DNS3" /></td></tr>
<tr><td>DNS4</td><td><input type="text" name="DNS4" /></td></tr>
<tr><td>DNS5</td><td><input type="text" name="DNS5" /></td></tr>
<tr><td>NT1</td><td><input type="text" name="NT1" /></td></tr>
<tr><td>NT2</td><td><input type="text" name="NT2" /></td></tr>
<tr><td>NT3</td><td><input type="text" name="NT3" /></td></tr>
<tr><td>NT4</td><td><input type="text" name="NT4" /></td></tr>
<tr><td>NT5</td><td><input type="text" name="NT5" /></td></tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="submit" value="Edit Results" /></td>
</tr>
</table>
</form>
</td>
</tr>
---------------------------------------------------------------------------------------------------
InsertResults.php
---------------------------------------------------------------------------------------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>InsertResults.php</title>
</head>
<body>
<?php
mysql_connect("mysql", "********", "********") or die ('Could not connect: ' . mysql_error());
mysql_select_db("RMDCRA");
$Race_Number = $_POST['Race_Number'];
$Event = $_POST['Event'];
$one=$_POST['1'];
$two=$_POST['2'];
$three=$_POST['3'];
$four=$_POST['4'];
$five=$_POST['5'];
$six=$_POST['6'];
$seven=$_POST['7'];
$eight=$_POST['8'];
$nine=$_POST['9'];
$ten=$_POST['10'];
$eleven=$_POST['11'];
$twelve=$_POST['12'];
$thirteen=$_POST['13'];
$fourteen=$_POST['14'];
$fifteen=$_POST['15'];
$sixteen=$_POST['16'];
$seventeen=$_POST['17'];
$eighteen=$_POST['18'];
$nineteen=$_POST['19'];
$twenty=$_POST['20'];
$twentyone=$_POST['21'];
$twentytwo=$_POST['22'];
$twentythree=$_POST['23'];
$twentyfour=$_POST['24'];
$twentyfive=$_POST['25'];
$twentysix=$_POST['26'];
$twentyseven=$_POST['27'];
$twentyeight=$_POST['28'];
$twentynine=$_POST['29'];
$thirty=$_POST['30'];
$DNF1=$_POST['DNF1'];
$DNF2=$_POST['DNF2'];
$DNF3=$_POST['DNF3'];
$DNF4=$_POST['DNF4'];
$DNF5=$_POST['DNF5'];
$DNF6=$_POST['DNF6'];
$DNF7=$_POST['DNF7'];
$DNF8=$_POST['DNF8'];
$DNF9=$_POST['DNF9'];
$DNF10=$_POST['DNF10'];
$DNS1=$_POST['DNS1'];
$DNS2=$_POST['DNS2'];
$DNS3=$_POST['DNS3'];
$DNS4=$_POST['DNS4'];
$DNS5=$_POST['DNS5'];
$NT1=$_POST['NT1'];
$NT2=$_POST['NT2'];
$NT3=$_POST['NT3'];
$NT4=$_POST['NT4'];
$NT5=$_POST['NT5'];
$sql = mysql_query("INSERT INTO Race_Results (`Race_Number`, `Event`, `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`, `DNF1`, `DNF2`, `DNF3`, `DNF4`, `DNF5`, `DNF6`, `DNF7`, `DNF8`, `DNF9`, `DNF10`, `DNS1`, `DNS2`, `DNS3`, `DNS4`, `DNS5`)
VALUES ('$Race_Number', '$Event', '$one', '$two', '$three', '$four', '$five', '$six', '$seven','$eight','$nine','$ten','$eleven','$twelve','$thirteen','$fourteen','$fifteen','$sixteen', '$seventeen','$eighteen','$nineteen','$twenty','$twentyone','$twentytwo','$twentythree','$twentyfour','$twentyfive','$twentysix','$twentyseven','$twentyeight','$twentynine','$thirty','$DNF1','$DNF2','$DNF3','$DNF4','$DNF5','$DNF6','$DNF7','$DNF8','$DNF9','$DNF10','$DNS1','$DNS2','$DNS3','$DNS4','$DNS5','$NT1','$NT2','$NT3','$NT4','$NT5')") or die(mysql_error());
header('Location: http://rmdcra.org/admin/Admin.php');
?>
</body>
</html>
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
TRUSTED BY
ASKER