function MASTER_RUN_IMC_TIMES()
{
$link = new con();
$i = 0;
$query = "TRUNCATE table times";
$result = mysqli_query($link->getConnection(), $query);
$query2 = "SELECT venue, id FROM films";
$result2 = mysqli_query($link->getConnection(), $query2);
while ($row = mysqli_fetch_array($result2)) {
$i += 1;
$run[$i] = new MysqlTimes(strtoupper($row['venue']), $row['id']);
$run[$i]->printTime();
if (mysqli_error($link->getConnection())) {
echo "You have an error";
print_r(mysqli_error($link->getConnection()));
}
}
mysqli_close($link->getConnection());
}
function imcEntry()
{
$link = new con();
$con = $link->getConnection();
$array = [];
$i = 0;
$query = 'select times.* , cinejoin.title
from times
inner join cinejoin
on times.id = cinejoin.id;';
$result = mysqli_query($con, $query);
while ($row = mysqli_fetch_array($result)) {
$arrayT[$i]['title'] = preg_replace("~FLS~", "", $row['title']);
$arrayB[$i]['title'] = preg_replace("~\\s~", "", $arrayT[$i]['title'], 1);
$trimmedString = rtrim($arrayB[$i]['title']);
$array[$i]['title'] = preg_replace('~\\s~', '_', $trimmedString);
//capitalise first letter
$array[$i]['venue'] = ucfirst(strtolower($row['venue']));
$arrayT[$i]['time'] = preg_replace('~:~', "", $row['time']);
$array[$i]['time'] = intval($arrayT[$i]['time']);
$array[$i]['day'] = $row['day'];
$array[$i]['month'] = $row['month'];
$array[$i]['year'] = $row['year'];
if ($array[$i]['title'] === "Batman_Vs_Superman_Dawn_Of_Justice__" || $array[$i]['title'] === "Batman_Vs_Superman_Dawn_Of_Justice") {
$array[$i]['title'] = "Batman_V_Superman:_Dawn_Of_Justice";
} else {
if ($array[$i]['title'] === "Grimsby__" || $array[$i]['title'] === "Grimbsy_" || $array[$i]['title'] === "Grimbsy") {
$array[$i]['title'] = "The_Brothers_Grimsby";
} else {
if ($array[$i]['title'] === "Hail_Caeser__" || $array[$i]['title'] === "Hail_Caeser_" || $array[$i]['title'] === "Hail_Caeser") {
$array[$i]['title'] = "Hail,_Caesar!";
} else {
if ($array[$i]['title'] === "Zootropolis" || $array[$i]['title'] === "Zootropolis_" || $array[$i]['title'] === "Zootropolis__") {
$array[$i]['title'] = "Zootopia";
}
}
}
}
$i++;
}
$content = "";
$z = 1;
for ($i = 0; $i < count($array); $i++) {
$content .= "('" . $array[$i]['title'] . "','" . $array[$i]['venue'] . "','" . $array[$i]['time'] . "'," . $array[$i]['year'] . "," . $array[$i]['day'] . "," . $array[$i]['month'] . ", 'Imc')";
if ($z < count($array)) {
$content .= ",";
}
$z++;
}
$query = "insert into catalog (title, venue, time, year, day, month, cinema) values " . $content;
#print_r($content);
$result = mysqli_query($con, $query);
}
