[RESOLVED] Form Multidimensional Array

beernut

Hi All

I am trying to create a player rating form for a youth soccer club, I can get the players out of the database and into a table but I am having trouble understanding how the form is going to link fields to players and how to go about this. Below is what my table looks like, where the 0 are I want to have drop down boxes with a 1 to 5 rating. Then the form has to insert the values into the players table according to the player ID.

Select players field rating for each category.
Player ID First Name Last Name Aggressiveness Soccer Sense Speed

ADAMS#000207MAK0 Makayla Adams 0 0 0 0 0
HOLTHA000211HOL0 Hollie Holthaus 0 0 0 0 0

I hope this isn't too confusing if someone can even point me to some code which is similar or can give me an example I can probably figure out how to modify it for my needs. Below is how I am creating the table.

 // Display all the players.
$result = mysql_query ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

// Display each record for field ratings.
echo " <tr>
<td align=\"left\">{$row['players_id']}</td>
<td align=\"left\">{$row['players_fname']}</td>
<td align=\"left\">{$row['players_lname']}</td>
<td align=\"left\">{$row['players_fpaggressiveness']}</td>
<td align=\"left\">{$row['players_fpsense']}</td>
<td align=\"left\">{$row['players_fpspeed']}</td>
<td align=\"left\">{$row['players_fptrapping']}</td>
<td align=\"left\">{$row['players_fpkicking']}</td>
<td align=\"left\">{$row['players_fpdribbling']}</td>
</form></tr>\n";

} // End of while loop.

bogu

Something like this:

$rating_arr = array(1,2,3,4,5);
$result = mysql_query ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

// Display each record for field ratings.
echo "<tr>\r\n";
echo "<td align=\"left\">{$row['players_id']}</td>\r\n";
echo "<td align=\"left\">{$row['players_fname']}</td>\r\n";
echo "<td align=\"left\">{$row['players_lname']}</td>\r\n";

/* your aggressiveness listbox*/
echo "<td align=\"left\">";
echo "<select name=\"selAggresiv[{$row['players_id']}]\">";
foreach ($rating_arr as $value) {
	$selected = "";
	if ($value==$row['players_fpaggressiveness']) $selected = "selected";
	echo "<option value={$value} {$selected}>{$value}</option>";
}
echo "</select>";
echo "</td>\r\n";

/* your sense listbox*/
echo "<td align=\"left\">";
echo "<select name=\"selSense[{$row['players_id']}]\">";
foreach ($rating_arr as $value) {
	$selected = "";
	if ($value==$row['players_fpsense']) $selected = "selected";
	echo "<option value={$value} {$selected}>{$value}</option>";
}
echo "</select>";
echo "</td>\r\n";

/* your speed listbox*/
echo "<td align=\"left\">";
echo "<select name=\"selSpeed[{$row['players_id']}]\">";
foreach ($rating_arr as $value) {
	$selected = "";
	if ($value==$row['players_fpspeed']) $selected = "selected";
	echo "<option value={$value} {$selected}>{$value}</option>";
}
echo "</select>";
echo "</td>\r\n";

/* your trapping listbox*/
echo "<td align=\"left\">";
echo "<select name=\"selTrapping[{$row['players_id']}]\">";
foreach ($rating_arr as $value) {
	$selected = "";
	if ($value==$row['players_fptrapping']) $selected = "selected";
	echo "<option value={$value} {$selected}>{$value}</option>";
}
echo "</select>";
echo "</td>\r\n";

/* your kicking listbox*/
echo "<td align=\"left\">";
echo "<select name=\"selKicking[{$row['players_id']}]\">";
foreach ($rating_arr as $value) {
	$selected = "";
	if ($value==$row['players_fpkicking']) $selected = "selected";
	echo "<option value={$value} {$selected}>{$value}</option>";
}
echo "</select>";
echo "</td>\r\n";

/* your dribbling listbox*/
echo "<td align=\"left\">";
echo "<select name=\"selDribbling[{$row['players_id']}]\">";
foreach ($rating_arr as $value) {
	$selected = "";
	if ($value==$row['players_fpdribbling']) $selected = "selected";
	echo "<option value={$value} {$selected}>{$value}</option>";
}
echo "</select>";
echo "</td>\r\n";
echo "</tr>\r\n";

}

u should get the idea ...

beernut

Thanks bogu that worked great now all I have to do is figure out the query to insert this into the database, keeping my fingers crossed on that one. I am sure you will be hearing from if I have troubles again.

Below is what I ended up with for anyone else looking to do something similar.

      //This allows the select box to have names but they still have a value  ranging from 1 to 5


 $rating_arr = array(0 => " ", 'Weak','Below Average','Average','Above Average','Strong');
$result = mysql_query ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

// Display each record for field ratings.
echo "<tr>\r\n";
   // echo "<td align=\"left\">{$row['players_id']}</td>\r\n";
    echo "<td align=\"left\">{$row['players_fname']}</td>\r\n";
    echo "<td align=\"left\">{$row['players_lname']}</td>\r\n";

/*  aggressiveness listbox*/
echo "<td align=\"left\">";
echo "<select name=\"selAggresiv[{$row['players_id']}]\">";
foreach ($rating_arr as $key => $value) {
         $selected = "";
    if ($value==$row['players_fpaggressiveness']) $selected = "selected";
    echo "<option value={$key} {$selected}>{$value}</option>";
}
echo "</select>";
echo "</td>\r\n";

beernut

Well everytime I start working on this I find something else I want to do different but now it's time to just get it done. I am having a hard time with the database update query.

//Create the form.
?>
<form action="./process_form.php" method="post">
<input type="hidden" name="team_complete" value="1" />

Then in a the page process_form.php I have:

/ Set the page title and include the HTML header.
$page_title = 'BMYSA Player Rating Form';
include_once ('includes/header.html');

require_once ('./includes/config.php'); // Connect to the database.

// Update players field ratings

foreach ($_POST['selAggresiv'] as $id => $pid) {
	$query = "UPDATE players SET players_fpaggressiveness = selAggresiv[$pid]
  Where  players_id = $pid and team.team_id = players.team_id";
}

?>

Before I go to far I load the form select some ratings for Aggressivness > submit the form I get no errors then I check the database and nothing is updated. I am at a lost I have searched all over the internet and a PHP book I have for examples trying to find what I am doing wrong but nothing is sticking out.

bogu

In witch book did u see this?

players_fpaggressiveness = selAggresiv[$pid]

who is "selAggresiv[$pid]"? Did u echo it to see what is the value?

I strongly suggest u to leave that book of yours alone and try to read something from here, and maybe try some examples too, to understand the array a little better and how to debug your code...