Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads
<?php
include "db.php";
echo "<h1>Setting Up Profile Photo Feature</h1>";
// Function to check and fix directory permissions
function checkAndSetPermissions($dir) {
if (!file_exists($dir)) {
if (mkdir($dir, 0755, true)) {
echo "✅ Created directory: $dir<br>";
} else {
echo "❌ Failed to create directory: $dir<br>";
return false;
}
} else {
echo "✅ Directory already exists: $dir<br>";
}
// Check if directory is writable
if (!is_writable($dir)) {
// Try to make it writable
if (chmod($dir, 0755)) {
echo "✅ Set correct permissions for: $dir<br>";
} else {
echo "❌ Failed to set permissions for: $dir. Please set directory permissions to 755 manually.<br>";
return false;
}
} else {
echo "✅ Directory has correct permissions: $dir<br>";
}
return true;
}
// Create uploads directory if it doesn't exist
$uploadsDir = __DIR__ . '/uploads';
$profilePhotosDir = $uploadsDir . '/profile_photos';
checkAndSetPermissions($uploadsDir);
checkAndSetPermissions($profilePhotosDir);
// Add profile_photo column to users table if it doesn't exist
try {
// Check if column exists
$result = $conn->query("SHOW COLUMNS FROM users LIKE 'profile_photo'");
if ($result->rowCount() == 0) {
$conn->exec("ALTER TABLE users ADD COLUMN profile_photo VARCHAR(255) DEFAULT NULL");
echo "✅ Added profile_photo column to users table<br>";
} else {
echo "✅ profile_photo column already exists<br>";
}
} catch (PDOException $e) {
echo "❌ Error checking/adding profile_photo column: " . $e->getMessage() . "<br>";
}
// Display PHP upload settings
echo "<h2>PHP File Upload Configuration</h2>";
echo "upload_max_filesize: " . ini_get('upload_max_filesize') . "<br>";
echo "post_max_size: " . ini_get('post_max_size') . "<br>";
echo "max_file_uploads: " . ini_get('max_file_uploads') . "<br>";
echo "<p>Setup complete! You can now <a href='profile.php'>visit your profile</a> to upload a photo.</p>";
?>