<?php
//include 'security.php';
include 'commonVariables.php';

 $divPK = $_GET['q'];

 // Create Mysqli object
 $db = new mysqli($db_host, $db_username, $db_password, $database);
 /* check connection */
 if (mysqli_connect_errno()) {
  printf("Connect failed: %s\n", mysqli_connect_error());
  exit();
 }

 //SET CONNECTION COLLATION
 $stmt = $db->stmt_init();
 $stmt->prepare("SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
 $stmt->execute();
 $stmt->close();

 $query = "SELECT * FROM `teams` WHERE `div` = ?;";
 $stmt = $db->stmt_init();
 if($stmt->prepare($query)) {
    $stmt->bind_param('i',$divPK);
    if (!$stmt->execute()) {
        echo "\nPDO::errorInfo():\n";
        print_r($db->error);
        exit();
    }
    $result = iimysqli_stmt_get_result($stmt);
    $respStr = "";
    while($teamListData = iimysqli_result_fetch_assoc($result)) {
        $respStr .= "<option value=\"".$teamListData['teamPK']."\">".$teamListData['name']."</option>";
    }
    $stmt->close();
 }
 else {
    $test = sprintf("Prepared Statement Error: %s\n", $db->error);
    echo($test);
    exit();
 }
 $db->close();
 echo($respStr);

?>