Indie-Resource.com

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' />";

    }


}
?>

Code: Select all

$('.add_player').click(function() {  //assigns click event to each tag with class 'add_player'  try 'input.add_player' if you want to specify
  var player_id = $(this).attr('data-player-id');
  $.post('add_player.php',{player_id: player_id}, function(data){
    var div_name = "div#action_"+player_id;
    $(div_name).html(data);
  });
});

Code: Select all

                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' data-player-id='$row[0]' class='add_player'/>";
                }

Code: Select all

  $.post('add_player.php',{player_id: player_id}, function(data){
    var div_name = "div#action_"+player_id;
    $(div_name).html(data);
    $(div_name).find('.add_player').click(...);
  });

Code: Select all

$(function() { //a function to be called once the page is ready, if you didn't know
  $('.add_player').click(addPlayer);  //register's the click event to trigger the addPlayer function
});

function addPlayer() {
  var player_id = $(this).attr('data-player-id');
  $.post('add_player.php',{player_id: player_id}, function(data){
    var div_name = "div#action_"+player_id;
    $(div_name).html(data);
    $(div_name).find('.add_player').click(addPlayer); //register the new button with this method.
  });
}

Code: Select all

echo "<input type='button' name='remove_player' value='Remove' data-player-id='$player_id' class='remove_player' />";