JavaScript Help [Solved]
Posted: Mon Feb 25, 2013 3:19 am
Been at this for a little bit, I made a script in JS to update the points available to use.
Here's the PHP, sorry if it's a bit ugly.
Basically what I want is for JS to take the values of the Batting, Fielding, Pitching for each row, and when they are changed, update the points available in the points avail column. If the total is over 10, I want it to say "Error"
And here's the Javascript
Here's the PHP, sorry if it's a bit ugly.
Basically what I want is for JS to take the values of the Batting, Fielding, Pitching for each row, and when they are changed, update the points available in the points avail column. If the total is over 10, I want it to say "Error"
Code: Select all
for ($i = 1; $i <= 10; $i++){
if ($i == 10){
$inning = "Extra";
} else {
switch($i){
case 1:
$inning = $i."st";
break;
case 2:
$inning = $i."nd";
break;
case 3:
$inning = $i."rd";
break;
default:
$inning = $i."th";
break;
}
}
switch($i){
case 1:
case 3:
case 5:
case 7:
case 9:
echo "<tr>";
break;
default:
echo "<tr class='alt'>";
break;
}
echo "<td>".$inning."</td>";
$Get_Info = mysqli_query($db,"SELECT `team_id`,`sp_rotation`,`roster_view` FROM `coaches` WHERE `coach_id`='$player->coach_id'") or die (mysqli_error($db));
$coach_info = mysqli_fetch_array($Get_Info);
$team_id = $coach_info['team_id'];
$one = $i."B";
$two = $i."F";
$three = $i."P";
$Get_Setting = mysqli_query($server,"SELECT `$one`,`$two`,`$three` FROM `coll_team_strategy` WHERE `team_id`='$team_id'");
$Setting = mysqli_fetch_array($Get_Setting);
switch ($i){
case 1:
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('first')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('first')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('first')'>";
$div = "first";
break;
case 2:
$div = "second";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('second')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('second')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('second')'>";
break;
case 3:
$div = "third";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('third')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('third')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='batting_".$i."' onchange='CalcPoints('third')'>";
break;
case 4:
$div = "fourth";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('fourth')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('fourth')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('fourth')'>";
break;
case 5:
$div = "fifth";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('fifth')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('fifth')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('fifth')'>";
break;
case 6:
$div = "sixth";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('sixth')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('sixth')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('sixth')'>";
break;
case 7:
$div = "seventh";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('seventh')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('seventh')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('seventh')'>";
break;
case 8:
$div = "eighth";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('eighth')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('eighth')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('eighth')'>";
break;
case 9:
$div = "ninth";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('ninth')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('ninth')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('ninth')'>";
break;
case 10:
$div = "tenth";
$Bat_Select = "<select name='batting_".$i."' id='batting_".$i."' onchange='CalcPoints('tenth')'>";
$Field_Select = "<select name='fielding_".$i."' id='fielding_".$i."' onchange='CalcPoints('tenth')'>";
$Pitch_Select = "<select name='pitching_".$i."' id='pitching_".$i."' onchange='CalcPoints('tenth')'>";
break;
}
echo "<td> <div class='$div'>".(10 - $Setting[$one] - $Setting[$two] - $Setting[$three])."</div> </td>";
echo "<td>";
echo $Bat_Select;
for ($b = 0; $b<= 10; $b++){
if ($b == $Setting[$one]){
echo "<option selected='selected' value='$b'>$b</option>";
} else {
echo "<option value='$b'>$b</option>";
}
}
echo "</select>";
echo "</td>";
echo "<td>";
echo $Field_Select;
for ($b = 0; $b<= 10; $b++){
if ($b == $Setting[$two]){
echo "<option selected='selected' value='$b'>$b</option>";
} else {
echo "<option value='$b'>$b</option>";
}
}
echo "</select>";
echo "</td>";
echo "<td>";
echo $Pitch_Select;
for ($b = 0; $b<= 10; $b++){
if ($b == $Setting[$three]){
echo "<option selected='selected' value='$b'>$b</option>";
} else {
echo "<option value='$b'>$b</option>";
}
}
echo "</select>";
echo "</td>";
echo "</tr>";
}Code: Select all
function CalcPoints(inning){
switch(inning){
case 'first':
batting = parseInt($('#batting_1').val());
fielding = parseInt($('#fielding_1').val());
pitching = parseInt($('#pitching_1').val());
break;
case 'second':
batting = parseInt($('#batting_2').val());
fielding = parseInt($('#fielding_2').val());
pitching = parseInt($('#pitching_2').val());
break;
case 'third':
batting = parseInt($('#batting_3').val());
fielding = parseInt($('#fielding_3').val());
pitching = parseInt($('#pitching_3').val());
break;
case 'fourth':
batting = parseInt($('#batting_4').val());
fielding = parseInt($('#fielding_4').val());
pitching = parseInt($('#pitching_4').val());
break;
case 'fifth':
batting = parseInt($('#batting_5').val());
fielding = parseInt($('#fielding_5').val());
pitching = parseInt($('#pitching_5').val());
break;
case 'sixth':
batting = parseInt($('#batting_6').val());
fielding = parseInt($('#fielding_6').val());
pitching = parseInt($('#pitching_6').val());
break;
case 'seventh':
batting = parseInt($('#batting_7').val());
fielding = parseInt($('#fielding_7').val());
pitching = parseInt($('#pitching_7').val());
break;
case 'eighth':
batting = parseInt($('#batting_8').val());
fielding = parseInt($('#fielding_8').val());
pitching = parseInt($('#pitching_8').val());
break;
case 'ninth':
batting = parseInt($('#batting_9').val());
fielding = parseInt($('#fielding_9').val());
pitching = parseInt($('#pitching_9').val());
break;
case 'tenth':
batting = parseInt($('#batting_10').val());
fielding = parseInt($('#fielding_10').val());
pitching = parseInt($('#pitching_10').val());
break;
}
points = ".".inning;
total = 10 - (batting + fielding + pitching);
if (total < 0){
total = "Error";
}
$(points).html(total);
}