query("UPDATE `logo_setting` SET `logo` = '".$upload_logo['file_name']."' WHERE `id` = 1");
echo '';
exit;
}
}
// Check if Favicon is uploaded
if(isset($_FILES['favicon']['name']) && !empty($_FILES['favicon']['name'])){
$upload_favicon = photo_upload('favicon','logo');
if($upload_favicon['status'] == 1)
{
$con->query("UPDATE `logo_setting` SET `favicon` = '".$upload_favicon['file_name']."' WHERE `id` = 1");
echo '';
exit;
}
}
// Check if Footer Logo is uploaded
if(isset($_FILES['footer_logo']['name']) && !empty($_FILES['footer_logo']['name'])){
$upload_footer_logo = photo_upload('footer_logo','logo');
if($upload_footer_logo['status'] == 1)
{
$con->query("UPDATE `logo_setting` SET `footer_logo` = '".$upload_footer_logo['file_name']."' WHERE `id` = 1");
echo '';
exit;
}
}
}
// Fetch current settings
$logo_data = $con->query("SELECT * FROM logo_setting where id = 1")->fetch_assoc();
// Check if footer_logo column exists, if not add it
$check_column = $con->query("SHOW COLUMNS FROM logo_setting LIKE 'footer_logo'");
if($check_column->num_rows == 0) {
$con->query("ALTER TABLE logo_setting ADD COLUMN footer_logo VARCHAR(255) DEFAULT NULL AFTER favicon");
}
?>