1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

<?php
    require_once('check_login.php');

    $event = get_event(2);

    $player_list = $event["players_id"];

    $players_array = explode(",", $player_list);

    $count = 1;
    foreach($players_array as $player_id){
        //insert empty score record for each player
        $sql = "insert into scores set event_id=?, player_id=?, createdate=?, createby=?, lastupdate=?, lastupby=?";
        $parameters = array(2, $player_id, $nowdate, $_SESSION['cmsloginid'], $nowdate, $_SESSION['cmsloginid']);
        bind_pdo($sql, $parameters);

        $count++;
    }