Php Developer

PHP

• What is the difference between require and include in PHP? (Learn)
• What is the purpose of sessions in PHP? (Learn)

SQL

• Write an SQL query to count the number of employees in each department using GROUP BY.
• Which JOIN is used to fetch only matching rows from both tables?

JavaScript

• What is the output of console.log(typeof null) in JavaScript?
• Which method is used to convert a JSON string into a JavaScript object?

HTML/CSS

• Which HTML tag is used to create a dropdown list? (Learn)
• What is the difference between <div> and <span>? (Learn)

Core OOP Concepts

• What is the difference between abstraction and encapsulation? (Learn)
• What is method overloading and overriding? (Learn)

CRUD Operations

• How do you perform a CREATE operation in MySQL?
• How do you implement UPDATE functionality in a PHP–MySQL project?
• What is the DELETE query in SQL?

Write a PHP program to check whether a given string is a palindrome.
Example:
Input: "madam" → Output: Palindrome
Input: "hello" → Output: Not Palindrome

1. Explain how sessions and cookies work in PHP. What is the difference between them? When should each be used? (Learn)
2. Write an SQL query to fetch the second-highest salary.
3. Create a simple HTML form and explain how you would handle its data in PHP.
4. Basic OOP in PHP concepts: What is inheritance? What is an abstract class? What is an interface?
5. Practical Web Concepts: What is AJAX? What is the difference between GET and POST? How do you connect PHP to MySQL?

Write a PHP program to print the Fibonacci series.

• What will be the output of echo 5 . "5";?
• Which HTTP method is more secure for sending data?
• What is the default value of an uninitialized PHP variable?
• What does JOIN do in SQL? (Learn)
• Solve: A sells a product for 20% profit (an aptitude-style question he asked).