Welcome to the world of dynamic web creation using PHP and MySQL! This book will introduce you to the powerful combination of PHP, a versatile server-side programming language, and MySQL, a trustworthy relational database management system. As you embark on this journey, you will master the principles of web development, database connectivity, and the seamless integration of PHP and MySQL to create dynamic and interactive web applications. This book is intended to cover the most significant topics for all university BCA and BSC students.
Contents –
1. INTRODUCTION TO PHP
1.1 History
1.2 Features of PHP
1.4 Embedding PHP Code in your Web Pages
1.5 Understanding PHP, HTML and White Space
1.6 Writing Comments in PHP
1.7 Sending Data to the Web Browser
1.8 Model Questions
2. DATA TYPES AND OPERATORS IN PHP
2.1 Keywords in PHP
2.2 Using Variables
2.3 Constants in PHP
2.4 Expressions in PHP
2.5 Operators in PHP
2.6 Model Questions
3. PROGRAMMING WITH PHP
3.1 Conditional and Operators
3.2 PHP If Clause
3.3 PHP If…. Else Clause
3.4 PHP If…else If…else Clause
3.5 PHP Switch Statement
3.6 The ? Operator: (Ternary Operator)
3.7 Looping Statements
3.8 PHP While Loop
3.9 PHP Do…while Loop
3.10 PHP for Loop
3.11 Model Questions
4. ARRAYS IN PHP
4.1 Introduction
4.2 What is an Array?
4.3 Creating Arrays in PHP
4.4 Accessing Array Elements in PHP
4.5 Types of Arrays in PHP
4.6 Indexed v/s Associative Arrays
4.7 Multidimensional Arrays
4.8 Creating Multidimensional Array
4.9 Accessing Elements in Multidimensional Array
4.10 Manipulating Multidimensional Arrays
4.11 Displaying Multidimensional Array
4.12 Using Array Functions
4.13 Including and Requiring Files ‒ Use of Include() and Require()
4.14 Implicit and Explicit Casting in PHP
4.15 Model Questions
5. PHP USING FUNCTIONS
5.1 Functions in PHP
5.2 Function Definition
5.3 Types of Functions
5.4 Creating and Invoking User-defined Functions
5.5 Formal Parameters Versus Actual Parameters
5.6 Function and Variable Scope
5.7 Recursion
5.8 Library Functions
5.9 Date and Time Functions
5.10 Model Questions
6. STRINGS IN PHP
6.1 What is String?
6.2 Creating and Declaring String
6.3 String Functions
6.4 Model Questions
7. CLASS AND OBJECTS
7.1 What is Class and
7.2 Creating and Accessing
7.3 Object Properties
7.4 Object Methods
7.5 Overloading
7.6 Inheritance
7.7 Constructors
7.8 Destructor
7.9 Model Questions
8. PHP FORM HANDLING
8.1 Creating HTML Form
8.2 Handling HTML Form Data in PHP
8.3 Model Questions
9. DATABASE HANDLING USING PHP WITH MySQL
9.1 Introduction to MySQL
9.2 Naming Database Components
9.3 Database Terms
9.4 Data Types
9.5 Model Questions
10. ACCESSING MySQL AND USING PHP WITH MySQL
10.1 Using the MySQL Client
10.2 Using PHP MyAdmin
10.3 MySQL Commands, Using PHP with MySQL
10.4 PHP MySQL Functions
10.5 Connecting to MySQL
10.6 Selecting the Database
10.7 Executing Simple Queries
10.8 Retrieving Query Results
10.9 Counting Returned Records
10.10 Updating Records with PHP
10.11 Model Questions
PHP & MySQL LAB MANUAL
MODEL QUESTIONS
UNIVERSITY MODEL QUESTION PAPER
