Enhance Security and Error Handling in File Upload and Database Operations in app.py

[Amansingh0807]

The current codebase lacks comprehensive error handling and file upload validation, which may lead to security vulnerabilities.

Tasks:

• Add MIME type validation to restrict file uploads to specific types (e.g., JPG, PNG).
• Implement finally blocks to ensure database connections close properly, preventing potential resource leaks.
• Improve SQL query handling by using parameterized queries to avoid SQL injection risks.
• Update logging to provide clearer error messages for debugging.

Benefits:

• Increases security against malicious file uploads.
• Improves error management, making the app more reliable.
• Enhances code readability and maintainability.

[github-actions]

👋 Thank you for raising an issue! We appreciate your effort in helping us improve. Our Fest Registration team will review it shortly. Stay tuned!