connect_error) { throw new Exception("Error: " . $connection->connect_error); } } catch (Exception $e) { exit($e->getMessage()); } $Username = $_SESSION['Username']; // Initialize $user_data $user_data = array(); // Check if the form was submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { // Check if the update button was clicked if (isset($_POST['update_profile'])) { // Handle the form submission for updating user data $Username = $_POST['Username']; // Updated to match the input name attribute $BusinessName = $_POST['BusinessName']; $Phone = $_POST['Phone']; // Updated to match the input name attribute $Email = $_POST['Email']; // Updated to match the input name attribute $Location = $_POST['Location']; $updateStmt = $connection->prepare("UPDATE business_records SET Username = ?, BusinessName = ?, Phone = ?, Email = ?, Location = ? WHERE Username = ?"); $updateStmt->bind_param('ssssss', $Username, $BusinessName, $Phone, $Email, $Location, $Username); if ($updateStmt->execute()) { // Database update was successful echo "User data updated successfully."; } else { echo "Error updating user data: " . $updateStmt->error; } } // Check if the upload button was clicked if (isset($_POST['upload_photo'])) { // Handle image upload handleImageUpload($connection, $Username); } } // Fetch user records based on their Username $selectStmt = $connection->prepare('SELECT * FROM business_records WHERE Username = ?'); $selectStmt->bind_param('s', $Username); $selectStmt->execute(); $result = $selectStmt->get_result(); if ($result->num_rows > 0) { $user_data = $result->fetch_assoc(); } else { echo "User not found in the database."; } // Function to handle image upload function handleImageUpload($connection, $Username) { // Check if a file was uploaded if (isset($_FILES["profile_image"]) && $_FILES["profile_image"]["error"] === 0) { // Define allowed file extensions and file size limit (adjust as needed) $allowed_extensions = ["jpg", "jpeg", "png", "gif"]; $max_file_size = 5 * 1024 * 1024; // 120 MB // Get the file details $file_name = $_FILES["profile_image"]["name"]; $file_tmp = $_FILES["profile_image"]["tmp_name"]; $file_size = $_FILES["profile_image"]["size"]; $file_extension = strtolower(pathinfo($file_name, PATHINFO_EXTENSION)); // Check file extension and size if (in_array($file_extension, $allowed_extensions) && $file_size <= $max_file_size) { // Generate a unique filename (you can use a better method for this) $unique_filename = uniqid() . "." . $file_extension; // Define the upload directory $upload_dir = "uploads/"; // Move the uploaded file to the upload directory $upload_path = $upload_dir . $unique_filename; if (move_uploaded_file($file_tmp, $upload_path)) { // Update the profile_image column in the business_records table $updateImageStmt = $connection->prepare("UPDATE business_records SET profile_image = ? WHERE Username = ?"); $updateImageStmt->bind_param("ss", $upload_path, $Username); if ($updateImageStmt->execute()) { echo "File uploaded and database updated successfully."; } else { echo "Error updating the database: " . $updateImageStmt->error; } } else { echo "Error moving the uploaded file to the server."; } } else { echo "Invalid file. Please upload a valid image file (JPG, JPEG, PNG, GIF) up to 5 MB in size."; } } else { echo "No file was uploaded."; } } // Close the database connection $connection->close(); ?> Admin Profile - Sales Pilot

Menu

Avatar

'; } elseif (isset($_FILES['profile_image']) && $_FILES['profile_image']['error'] == UPLOAD_ERR_OK) { // Move the uploaded file to the destination directory move_uploaded_file($_FILES['profile_image']['tmp_name'], $uploadFile); // Display the uploaded image echo 'Avatar'; } else { // Display the default image if no new image is uploaded echo 'Avatar'; } ?>
" class="tm-signup-form row" method="post" enctype="multipart/form-data">