date_default_timezone_set(“America/New_York”);

$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);

if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}

$today = date(“Y-m-d”);
$date = strtotime(“+5 day”);
$wkend = date(“Y-m-d”, $date);

if ($compparm != “”) {
echo “

” . “Click on date range to see show dates, times and location.   Click on show name for performance details.

” . “

“;
$sql = “SELECT Production, Company, ShowName, Type, Venue, Town, Opens, Closes from `Performances`
where Closes >= ‘$today’ and Opens <= '$wkend' and Status = 'active' and Company = $company order by ShowName, Company"; } else { echo "” .”Click show name for performance details.  Click on company name to see shows performed by that company.  Click on date range to see show dates, times and location.

” ;
$sql = “SELECT Production, Company, ShowName, Type, Venue, Town, Opens, Closes from `Performances`
where Closes >= ‘$today’ and Opens <= '$wkend' and Status = 'active' order by ShowName, Company"; } $result = $mysqli->query($sql);
$olddate = “old”;

echo “

“;
if ($result->num_rows > 0) {

echo “

Now Playing

“;

if ($compparm == “”) {
echo “

“;
} else {
echo “

“;
}

// output data of each

while($row = $result->fetch_assoc()) {

$showfix = str_replace(” “,”~”,$row[“ShowName”]);
$showfix = str_replace(“&”,”^”,$showfix);
$showparm = ““;
$persparm = ““;

$opens = $row[“Opens”];
$openm = substr($opens, 5, 2) . “/” . substr($opens, 8, 2) ;
$closes = $row[“Closes”];
$closesm = substr($closes, 5, 2) . “/” . substr($closes, 8, 2) ;
$dates = $openm . “-” . $closesm;

$comp = $row[“Company”];
$comp = trim($comp,” “);
$comp = str_replace(” “,”~”,$comp);
$companyparm = “” ;

if ($compparm == “”) {
echo “

“;
} else {
echo “

“;
}
}
} else {
// 0 results
}
echo “

“;
$mysqli->close();

//COMING SOON *******************************************************************

//Coming Soon

$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);

if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}

$today = date(“Y-m-d”);
$oldmonth = “Start”;

if ($compparm != “”) {
$sql = “SELECT Production, Company, ShowName, Type, Venue, Town, Opens, Closes from `Performances`
where Closes >= ‘$today’ and Opens > ‘$wkend’ and Status = ‘active’ and Company = $company order by Opens”;
} Else {
$sql = “SELECT Production, Company, ShowName, Type, Venue, Town, Opens, Closes from `Performances`
where Closes >= ‘$today’ and Opens > ‘$wkend’ and Status = ‘active’ order by Opens, ShowName”;
}

$result = $mysqli->query($sql);
$olddate = “old”;

if ($result->num_rows > 0) {
//echo “

“;
echo “

Coming Soon

“;
//echo

“;

if ($compparm == “”) {
echo “

“;
} else {
echo “

“;
}

// output data of each row

while($row = $result->fetch_assoc()) {
$showfix = str_replace(” “,”~”,$row[“ShowName”]);
$showfix = str_replace(“&”,”^”,$showfix);
$showparm = ““;
$persparm = ““;

$opens = $row[“Opens”];
$openm = substr($opens, 5, 2) . “/” . substr($opens, 8, 2) ;
$closes = $row[“Closes”];
$closesm = substr($closes, 5, 2) . “/” . substr($closes, 8, 2) ;
$dates = $openm . “-” . $closesm;
$openmonth = date(“F”, strtotime($opens));

$comp = $row[“Company”];
$comp = trim($comp,” “);
$comp = str_replace(” “,”~”,$comp);
$companyparm = “” ;

if ($compparm == “”) {
if ($openmonth <> $lastmonth) {
echo “

“;
$lastmonth = $openmonth ;
}
echo “

“;
} else {
echo “

“;
}
}
} else {
// 0 results
}
echo “

“;
$mysqli->close();

//Previous Shows ************************************************************
if ($compparm <> “”) {

$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);

if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}

$today = date(“Y-m-d”);
$oldmonth = “Start”;

if ($compparm != “”) {
$sql = “SELECT Production, Company, ShowName, Type, Venue, Town, Opens, Closes from `Performances`
where Closes < '$today' and Status = 'active' and Company = $company order by Opens DESC"; } Else { $sql = "SELECT Production, Company, ShowName, Type, Venue, Town, Opens, Closes from `Performances` where Closes < '$today' and Status = 'active' order by Opens DESC, ShowName"; } $result = $mysqli->query($sql);
$olddate = “old”;

if ($result->num_rows > 0) {
//echo “

“;
echo “

Past Shows

“;
//echo

“;

if ($compparm == “”) {
echo “

“;
} else {
echo “

“;
}

// output data of each row

while($row = $result->fetch_assoc()) {
$showfix = str_replace(” “,”~”,$row[“ShowName”]);
$showfix = str_replace(“&”,”^”,$showfix);
$showparm = ““;
$persparm = ““;

$opens = $row[“Opens”];
$openm = substr($opens, 5, 2) . “/” . substr($opens, 8, 2) ;
$openmy = substr($opens, 5, 2) . “/” . substr($opens, 0, 4) ;
$closes = $row[“Closes”];
$closesm = substr($closes, 5, 2) . “/” . substr($closes, 8, 2) ;
$dates = $openm . “-” . $closesm;
$openmonth = date(“F”, strtotime($opens));
$openmon3 = date(“M”, strtotime($opens));
$openm3y = $openmon3 . ” ” . substr($opens, 0, 4) ;

$comp = $row[“Company”];
$comp = trim($comp,” “);
$comp = str_replace(” “,”~”,$comp);
$companyparm = “” ;

if ($compparm == “”) {
if ($openmonth <> $lastmonth) {
echo “

“;
$lastmonth = $openmonth ;
}
echo “

“;
} else {
echo “

“;
}
}
} else {
// 0 results
}
echo “

“;
$mysqli->close();
}

if ($compparm != “”) {
echo “Back “;
}
[/insert_php]