NARMADA COLLEGE OF SCIENCE AND COMMERCE
Zadeshwar, Bharuch.
Theory Assignment -3
Subject: Web Framework and Services
Given Date: 20-08-2025 Submission Date:15/09/2025.
Short Questions (20)
1. How do you connect PHP to MySQL using mysqli?
2. Differentiate between mysqli and PDO.
3. Write SQL syntax for creating a database.
4. How do you insert data into a table using PHP?
5. Explain UPDATE query with an example.
6. What is the use of ORDER BY clause?
7. Explain LIMIT clause with example.
8. What is AJAX?
9. How does AJAX improve performance?
10. How do you send an AJAX request to PHP?
11. Define JSON data exchange.
12. Write one use case of real-time search.
13. What is CodeIgniter?
14. Write steps for installing CodeIgniter 4.
15. Explain MVC architecture.
16. What is the role of a Model in CI4?
17. Define URL routing in CodeIgniter.
18. What is default controller in CI4?
19. What are helpers in CodeIgniter?
20. What is flashdata in CI?
Long Questions (10)
1. Explain connecting PHP with MySQL using mysqli and PDO.
2. Discuss CRUD operations with PHP and MySQL with examples.
3. Write a PHP program to implement a student database with insert and display.
4. Explain AJAX with diagram and working.
5. Write a program for real-time search using AJAX and PHP.
6. Explain JSON handling between JavaScript and PHP.
7. Explain installation and configuration of CodeIgniter 4.
8. Write a short note on MVC architecture in CI.
9. Explain form validation and session management in CI4 with examples.
10. Write a CodeIgniter program to upload a file.