Backend Developer Interview Cheatsheet (PHP/CodeIgniter)
1. Core PHP Concepts
- Data types, arrays, loops, functions, OOP (inheritance, traits, interfaces)
- Superglobals ($_POST, $_GET, $_SESSION)
- File handling, error handling, include vs require
Sample Questions:
* What is the difference between include and require?
* How does PHP manage sessions?
2. CodeIgniter Essentials
- MVC Architecture: Model, View, Controller separation
- Routing, URI segments, base_url()
- Using Libraries and Helpers (form, url, etc.)
- CSRF & XSS protection, Form Validation
Sample Questions:
* How do you load a model and use it in a controller?
* How does routing work in CI?
3. MySQL and Database Design
- CRUD operations, JOINs, indexing, normalization
- Query optimization and database relationships
Sample Questions:
* Write a query to fetch top 5 users by purchases.
* Difference between INNER JOIN and LEFT JOIN?
4. RESTful APIs
- HTTP methods: GET, POST, PUT, DELETE
- Status codes: 200, 201, 400, 401, 403, 500
- JWT/Auth, Postman testing
Sample Questions:
Backend Developer Interview Cheatsheet (PHP/CodeIgniter)
* What's the difference between PUT and PATCH?
* How do you secure APIs in CI?
5. Tools & Debugging
- Git & GitHub version control
- Postman for API testing
- Docker basics, VS Code extensions
Sample Questions:
* How do you handle Git merge conflicts?
* How do you debug slow-performing queries?
6. Behavioral Questions
- Talk about project experiences (Prohomez, RS Travel, Tech Destination)
- Discuss problem-solving, teamwork, and deadlines
Sample Questions:
* Tell us about a bug you fixed and how.
* Describe your experience with REST API integration.