芝麻web文件管理V1.00

编辑当前文件:/home/disqkgca/public_html/ksmicc/getsportsslots.php

<?php include "config.php";?>
<?php $con =@mysqli_connect($config->db_host,$config->db_user,$config->db_pass,$config->db_name);
					if (mysqli_connect_errno())
					  {
					  echo "Failed to connect to MySQL: " . mysqli_connect_error();
					  }
$sportid = $_POST['sportid'];
$sportdate = $_POST['sportdate'];
$sqlbookslots = "Select * from khs_sportsbooked_slots where sportid = '".mysqli_real_escape_string($con,$sportid)."' and sportdate = '".mysqli_real_escape_string($con,$sportdate)."' and noofpeoplebooked = noofpeopleallow";

$resbookslots = mysqli_query($con,$sqlbookslots) or die(mysqli_error($con));
$bookedslots[] = array();
if(mysqli_num_rows($resbookslots)>0)
{
	$counter = 0;
	while($row = mysqli_fetch_array($resbookslots))
	{
		$counter++;
		$bookedslots[$counter] = $row['slotid'];
	}
}

$sql = "Select * from khs_sports_slots";
$res = mysqli_query($con,$sql) or die(mysqli_error($con));
if(mysqli_num_rows($res)>0)
{
	while($row = mysqli_fetch_array($res))
	{
		if (!in_array($row['id'], $bookedslots)) 
		{
	?>
    <input type="checkbox" name="slot[]" value="<?php echo $row['id'];?>" /> <?php echo $row['slot'];?>
    <br />
    <?php 
		}
	}
}
else
{
	echo '<div class="alert alert-info">No Playing Slot Available</div>';
}