how would I do this?

peanutgallery83

Ok, I'm a self proclaimed noob at this php thing. I'm trying to learn as I go...so far it's been going pretty smoothly, but I've gotten stuck....hopefully someone here can help!

For reference, you can log in to the site:
http://www.refphotos.com/referee_menu.php

Username: admin
Password: abc123

Anyways...everything on there is working. What I am trying to do is to set up an online referee assignment program where individuals will be able to log in and view games that they are assigned to.

Through this admin screen, the referee assignor will be able to add games to the schedule (in the database as a table named "schedule"). This is done through "Add a Game". As you can see, if you look, there is info for the game itself, then 3 more openings for "Referee", "AR1" and "AR2".

In the main admin menu, you can see where I am calling all of the games up for display"Display All Games"....but the referee, ar1, and ar2 spots are empty. This is because I need to be able to enter in the games by themselves, then assign referees at a later time.

How would I go about setting it up so that in the "Display All Games" display, I could enter in a Referee, AR1, and AR2 for all of the games on the schedule, then press a submit button and have the names added to the table? If possible, I would rather be able to have drop-down menus for the 3 referees positions where I could choose a referee from a list of referees in another table.

Thank you very very much in advance if you can help me with this. As I said, things have been going very well, but now I'm stuck on what's really a very crucial part of this project!

If it would help for me to send/post the code, please let me know.
Landis

Shrike

It should be pretty simple. On the Display All Games screen, run a query or queries which gets the list of referees and assistant referees. All you really need is the row ID and their name. Then create dropdown lists for each, e.g.

//$referees is the result of a query
$refereedropdown = "<select name=\"game$gameid[]\">";
foreach($referees as $referee)
{
  $refereedropdown = "<option value=\"".$referee['id']."\">".$referee['name']."</option";
}
$refereedropdown = "</select>";

Rinse and repeat for the assistants. This makes use of the ability to combine lots of POST values into a PHP array (the "[]" in the select name). $gameid is the row ID for the game.

Then when you come to submit the data, you can iterate through the POST array gamen (n being the game ID) and update the game in the database with the ID for the referee (which is the value portion in the dropdown lists). You would need to check that the same value had not been entered for the two assistants, if necessary.

pseudonym

//$referees is the result of a query
$refereedropdown = "<select name=\"game$gameid[]\">";
foreach($referees as $referee)
{
  $refereedropdown .= "<option value=\"".$referee['id']."\">".$referee['name']."</option";
}
$refereedropdown .= "</select>";

Edited slightly to add the . (concat) operator 🙂

peanutgallery83

Hey thanks guys. Now my question becomes...where do I put that in the code?

Code for "Display All Games" page follows:

$db_name ="refphoto_testdb";

$table_name ="schedule";

$connection = @mysql_connect("localhost","dbusername","dbpw") or die(mysql_error());

$db = @mysql_select_db($db_name,$connection) or die(mysql_error());

$sql = "SELECT id, date, time, trim(concat(date, ' ' ,time)) as datetime, location, home, visitor, league, referee, ar1, ar2 FROM $table_name ORDER BY datetime";

$result = @($sql,$connection) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {

$id = $row['id'];
$datetime = $row['datetime'];
$date = $row['date'];
$time = $row['time'];
$location = stripslashes($row['location']);
$home = stripslashes($row['home']);
$visitor = stripslashes($row['visitor']);
$league = stripslashes($row['league']);
$referee = stripslashes($row['referee']);
$ar1 = $row['ar1'];
$ar2 = stripslashes($row['ar2']);

if ($date_acq == "0000-00-00") {
	$date_acq ="[unknown]";
}

$display_block .= "
<table cellspacing=0 cellpadding=1 border=1 bordercolor=000000>

<tr>
<td valign=top width=85>
$date
</td>
<td valign=top width=75>
$time
</td>
<td valign=top width=150>
$location
</td>
<td valign=top width=150>
$home
</td>

<td valign=top width=150>
$visitor
</td>
<td valign=top width=150>
$league
</td>
<td valign=top width=150>
$referee
</td>
<td valign=top width=150>
$ar1
</td>
<td valign=top width=150>
$ar2
</td>
</tr>

</TABLE>
";
}

<HTML>
<HEAD>
<TITLE>ECISOA Game Assignments</TITLE>
</HEAD>
<BODY>
<H1>ECISOA Game Assignments</H1>

<table border=1 cellpadding=1 cellspacing=0 bordercolor=000000 bgcolor="#CC0000">
<tr>
<td valign=top width=85> Date:
</td>
<td valign=top width=75> Time:
 </td>
<td valign=top width=150> Location:
</td>
<td valign=top width=150> Home:
</td>
<td valign=top width=150> Visitor:</td>
<td valign=top width=150> League:
</td>
<td valign=top width=150> Referee:</td>
<td valign=top width=150> AR1:
</td>
<td valign=top width=150> AR2:
</td>
</tr>
</TABLE>
<? echo "$display_block"; ?>

<a href="referee_menu.php">Return
to Menu</a>
</BODY>
</HTML>