$stmt = $conn->prepare('select * from leagues_config where id = :i'); $stmt->bindParam(':i', $league_id); $stmt->execute(); $league = $stmt->fetchAll(); $league = $league[0]; ?> <div class="modal-dialog" style="width:1600px"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title" id="myModalLabel"> <?php echo $league['name']; ?> - <?php echo GlobalGetLeagueType($league['type']); ?> </h4> </div> <div class="modal-body"> <div class="nav-tabs-custom"> <ul class="nav nav-tabs"> <li data-name="configuration" class="active tab_links"><a href="#tab_1" data-toggle="tab">Main configuration</a></li> <li data-name="brackets" class="tab_links"><a href="#tab_2" data-toggle="tab">Brackets</a></li> <li data-name="results" class="tab_links"><a href="#tab_2" data-toggle="tab">Match results</a></li> </ul> <div class="tab-content" id="tab_content"> </div><!-- /.tab-content --> </div><!-- nav-tabs-custom --> </form> </div>
$rResultTotal = sql($sQuery) or fatal_error('MySQL Error: ' . mysqli_errno()); $aResultTotal = mysqli_fetch_array($rResultTotal); $iTotal = $aResultTotal[0]; /* * Output */ $output = array("iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array()); while ($aRow = mysqli_fetch_array($rResult)) { $row = array(); foreach ($columns as $key => $value) { switch ($key) { case "name": $row[] = $aRow['name']; break; case "type": $row[] = GlobalGetLeagueType($aRow['type']); break; case "current_week": $row[] = 'Week ' . $aRow['current_week']; break; case "weeks": $row[] = $aRow['weeks'] . ' Weeks'; break; case 'actions': if ($aRow['type'] == 3) { $row[] = '<button type="button" data-id="' . $aRow['id'] . '" class="btn btn-danger delete"><i class="fa fa-times"></i></button> <button type="button" data-id="' . $aRow['id'] . '" class="btn btn-warning edit_league_rr"><i class="fa fa-cog"></i></button>'; } break; } }