function updateRoot($canon, $active)
{
global $connection;
global $DBErrorMsg;
$query = "UPDATE...";
if ($result = $connection->query($query)) {
return true;
} else {
echo databaseErrorMsg($DBErrorMsg);
}
}
function getCanonId($canon)
{
global $connection;
global $DBErrorMsg;
$query = "SELECT...";
if ($result = $connection->query($query)) {
while ($row = $result->fetch_assoc()) {
return $row['navcat_id'];
}
} else {
echo databaseErrorMsg($DBErrorMsg);
}
}
protected function insertDBdata($file, $filename)
{
//upload to DB
global $connection;
global $DBErrorMsg;
$navID;
$query = "SELECT...";
if ($result = $connection->query($query)) {
while ($row = $result->fetch_assoc()) {
$navID = $row['navcat_id'];
}
} else {
echo databaseErrorMsg($DBErrorMsg);
}
//get image type
$extension = pathinfo($filename, PATHINFO_EXTENSION);
//file name is the name that the radio button is given for POST
//POST converts . and spaces to _ , convert name to use _
$temp = str_replace('.' . $extension, '_' . $extension, $file['name']);
//check for other periods and spaces
$temp = str_replace('.', '_', $temp);
$temp = str_replace(' ', '_', $temp);
//gets the image type number stored in POST
$imgType = $_POST[$temp];
$imgViewType = $_POST[$temp . '_sel'];
$relOrder;
$query = "SELECT...";
if ($result = $connection->query($query)) {
while ($row = $result->fetch_assoc()) {
$relOrder = $row['rel'];
}
} else {
echo databaseErrorMsg($DBErrorMsg);
}
$relOrder = is_numeric($relOrder) ? $relOrder + 1 : 1;
$query = "INSERT INTO... \n\t\t\t\t\tVALUES...";
if (!($result = $connection->query($query))) {
echo databaseErrorMsg($DBErrorMsg);
}
}
function getAllViews()
{
global $connection;
global $DBErrorMsg;
$query = "SELECT...";
if ($result = $connection->query($query)) {
$list = array();
while ($row = $result->fetch_assoc()) {
$list[$row['id']] = $row['view'];
}
} else {
echo databaseErrorMsg($DBErrorMsg);
}
return $list;
}
