I have this working how I want in entering something into the DB.
What I want is after JQuery calls the PHP script, for the Submit button to change. It's just returning plain text.
Here's the PHP part.
Code: Select all
echo "<td>";
echo "<div id='action_$row[0]'>";
echo "<input type='hidden' value='$row[0]' name='player_id' id='player_id'/>";
$Get_Board = mysqli_query($server,"SELECT `player_id` FROM `recruiting_board` WHERE `player_id`='$row[0]' AND `team_id`='$team_id'") or die(mysqli_error($server));
if (mysqli_num_rows($Get_Board) == 1){
echo "<input type='submit' name='remove_player' value='Remove' />";
} else {
echo "<input type='submit' name='add_player' value='Add' id='add_player' />";
}
echo "</div>";
echo "</td>";
Code: Select all
$('input#add_player').on('click', function(){
var player_id = $('input#player_id').val();
$.post('add_player.php',{player_id: player_id}, function(data){
var div_name = "div#action_"+player_id;
$(div_name).text(data);
});
});
Code: Select all
<?php
function random($array, $counter){
shuffle($array);
for($i=0;$i<$counter;$i++){
$newarray[$i]=$array[$i];
}
return $newarray;
}
include_once 'includes/global_include.php';
$Get_Info = mysqli_query($db,"SELECT `team_id`,`server_id` 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'];
list($server) = ServerConnect($coach_info['server_id']);
if(isset($_POST['player_id'])){
$player_id = mysqli_real_escape_string($server,$_POST['player_id']);
$Get_Board = mysqli_query($server,"SELECT `player_id` FROM `recruiting_board` WHERE `player_id`='$player_id' AND `team_id`='$team_id'") or die(mysqli_error($server));
if (mysqli_num_rows($Get_Board) == 1){
mysqli_query($server,"UPDATE `recruiting_board` SET `active`=1 WHERE `player_id`='$player_id' AND `team_id`='$team_id'") or die (mysqli_error($server));
echo "<input type='submit' name='remove_player' value='Remove' />";
} else {
$pitches_array = array(1,2,3,4,5,6,7);
$promises_array = array(1,2,3,4,5,6,7,8,9);
list ($most,$high,$like,$avg,$low,$dislike,$hate) = random($pitches_array,7);
list ($pmost,$phigh,$plike,$pavg,$pnormal,$pmediocre,$plow,$pverylow,$pdislike) = random($promises_array,9);
mysqli_query($server,"INSERT INTO `recruiting_board` (`team_id`,`player_id`,`most`,`high`,`like`,`avg`,`low`,`dislike`,`hate`,`promise_most`,`promise_high`,`promise_like`,`promise_avg`,`promise_normal`,`promise_mediocre`,`promise_low`,`promise_dislike`,`promise_hate`)VALUES('$team_id','$player_id','$most','$high','$like','$avg','$low','$dislike','$hate','$pmost','$phigh','$plike','$pavg','$pnormal','$pmediocre','$plow','$pverylow','$pdislike')") or die(mysqli_error($server));
######## Pitches
# 1 = Coach Prestige
# 2 = School Prestige
# 3 = Conf Prestige
# 4 = Playtime
# 5 = Pro Potential
# 6 = Fan Base
# 7 = Contender
########
######## Promises
# 1 = No Redshirt
# 2 = Playtime
# 3 = Rivals
# 4 = Conf Title
# 5 = National Title
# 6 = Facility Upgrades
# 7 = Playoffs
# 8 = Training Time
# 9 = Winning Record
########
echo "<input type='submit' name='remove_player' value='Remove' />";
}
}
?>
Here's a pic of what it returns.
http://gyazo.com/5042344bf8eb3eeecdb4655a1fa52e82
I'm sure it's something simple, but I know about 0 JS lol.