File size: 2.47Kb
<?php
// Include coredb.php for database connection
require_once('config/core.php');
// Create database connection
$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Function to get the company logo
function getCompanyLogo($conn) {
$sql = "SELECT company_logo FROM site_settings LIMIT 1";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
return $row['company_logo'];
} else {
return 'default_logo.png'; // Default logo URL if not found in the database
}
}
$companyLogo = getCompanyLogo($conn);
// Close the database connection
$conn->close();
?>
<ul class="navbar-nav bg-dark sidebar sidebar-dark accordionsidebar" id="Sidebarmenu">
<li class="nav-item sm-none">
<span class="sidebar-brand d-flex align-items-center justify-content-center">
<span class="sidebar-brand-text mx-3"><img src="<?php echo $companyLogo; ?>" alt="logo" class="img-fluid"></span>
</span>
</li>
<li class="nav-item cursor-pointer">
<a class="nav-link" href="webpages-list.php">
<i class="fas fa-clipboard-list me-2"></i>
<span>Webpages List </span></a>
</li>
<li class="nav-item cursor-pointer">
<a class="nav-link" href="google_adsense.php">
<i class="fas fa-fw fa-code me-2"></i>
<span>Google Adsense</span></a>
</li>
<li class="nav-item cursor-pointer">
<a class="nav-link" href="google_analytics.php">
<i class="fas fa-fw fa-code me-2"></i>
<span>Google Analytics</span></a>
</li>
<li class="nav-item cursor-pointer">
<a class="nav-link" href="files.php">
<i class="fas fa-file-upload me-2"></i>
<span>.xml and .txt Files</span></a>
</li>
<li class="nav-item cursor-pointer">
<a class="nav-link" href="social-media.php">
<i class="fas fa-globe"></i>
<span>Social Media</span></a>
</li>
<li class="nav-item cursor-pointer">
<a class="nav-link" href="settings.php">
<i class="fas fa-cogs"></i>
<span>Settings</span></a>
</li>
<li class="nav-item cursor-pointer">
<a class="nav-link" href="logout.php">
<i class="fas fa-sign-out-alt"></i>
<span>Logout</span></a>
</li>
</ul>