[insert_php]
// Audition Roles********************************************************************************************
$parms = “yes”;
$parmgen = $_GET[‘Gender’] ;
$parmminage = $_GET[‘minage’] ;
$parmmaxage = $_GET[‘maxage’] ;
$parmsall = $parmgen . $parmminage . $parmmaxage;
if ($parmsall == NULL ) { $parms = “no”;}
if ($parmgen <> “”) {$parmgen = “‘” . $_GET[‘Gender’] . “‘”;}
$parmgen = str_replace(“~”,”/”,$parmgen);
$parmgenlike = “‘%” . $_GET[‘Gender’] .”%'”;
$parmgenlike = str_replace(“~”,”/”,$parmgenlike);
$today = date(“Y-m-d”);
if ($parms == “yes”) {
echo ”
Roles
“;
echo “
“;
echo “
“;
$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);
if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}
mysqli_set_charset($mysqli, ‘utf8mb4’);
if ($parmgen <> “‘All'” and $parmgen <> “”) {
$sql = “SELECT Role, RoleType, Gender, AgeMin, AgeMax, Description, Requirement, SongstoKnow, Ethnicity, Performances.ShowName, AuditionRoles.Production, AuditionInfo.LastDate
from `AuditionRoles`
INNER JOIN Performances
ON AuditionRoles.Production = Performances.Production
INNER JOIN AuditionInfo
ON AuditionRoles.Production = AuditionInfo.Production
where Gender like $parmgenlike AND $parmminage <= AgeMax AND $parmmaxage >= AgeMin AND LastDate >= ‘$today'”;
}
else {
$sql = “SELECT Role, RoleType, Gender, AgeMin, AgeMax, Description, Requirement, SongstoKnow, Ethnicity, Performances.ShowName, AuditionRoles.Production, AuditionInfo.LastDate
from `AuditionRoles`
INNER JOIN Performances
ON AuditionRoles.Production = Performances.Production
INNER JOIN AuditionInfo
ON AuditionRoles.Production = AuditionInfo.Production
where $parmminage <= AgeMAX AND $parmmaxage >= AgeMin AND LastDate >= ‘$today'”;
}
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
echo “
” .
“Role” . “ |
” .
“M/F” . “ |
” .
“Age” . “ |
” .
“Description” . “ |
” ;
while($row = $result->fetch_assoc()) {
// output data of each row
$agemin = $row[“AgeMin”];
$agemax = $row[“AgeMax”];
if($row[“AgeMin”] == “1”) {$agemin = “”;}
if($row[“AgeMax”] == “99”) {$agemax = “”;}
$ages = $agemin . “-” . $agemax;
if ($agemin == “”) {$ages= $agemax ;}
if ($agemax == “”) {$ages= $agemin . “+”;}
if ($agemin == “” and $agemax ==””) {$ages = “”;}
$showparm = “” ;
$desc = “” . $showparm . $row[“ShowName”] . “
” ;
if ($row[“Ethnicity”] <> “”) {$desc = $desc . “(” . $row[“Ethnicity”] . “) “;}
$desc = $desc . $row[“Description”];
if ($row[“Requirement”] <> “”) {$desc = $desc . “
” . $row[“Requirement”];}
if ($row[“SongstoKnow”] <> “”) {$desc = $desc . “
Songs to Know – ” . $row[“SongstoKnow”];}
$role = $row[“Role”] ;
if ($row[“RoleType”] <> “”) {
$role = $role . “(” . $row[“RoleType”] . “)” ;
}
echo “
” . $role . “ |
” .
“
” . $row[“Gender”]. “ |
” .
“
” . $ages . “ |
” .
“
” . $desc . “ |
” ;
}
} else { echo “0 results”;
}
echo “
“;
$mysqli->close();
}
[/insert_php]