php - unit-1
UNIT–I
INTRODUCTION TO PHP (DETAILED THEORY NOTES)
1. Introduction to PHP
PHP stands for PHP: Hypertext Preprocessor. It is a server-side scripting
language designed primarily for web application development. PHP scripts
are executed on the server, and the result is sent to the client’s browser as
plain HTML.
Unlike client-side languages such as JavaScript, PHP code is not visible to the
user, which makes it more secure for handling sensitive data such as login
7
credentials and database operations.
PHP can be embedded directly into HTML code, making it easy to mix
presentation and logic. It is widely used for developing dynamic websites,
6
content management systems, e-commerce applications, and web-based
software.
5
2. Evaluation (Advantages and Importance) of PHP
PHP has gained popularity due to several reasons:
4
. Open Source
PHP is free to use and distributed under an open-source license,
reducing development costs.
3
. Ease of Learning
PHP syntax is simple and similar to C and Java, making it easy for
beginners.
2
. Platform Independent
PHP runs on different operating systems such as Windows, Linux, and
macOS.
1
. Server Compatibility
PHP works with most popular web servers like Apache and IIS.
. Database Support
PHP supports a wide range of databases including MySQL, Oracle,
PostgreSQL, and SQLite.
. Performance
PHP scripts execute quickly and efficiently on the server.
. Large Community Support
Extensive documentation, frameworks, and community forums are
available.
3. Basic Syntax of PHP
PHP code is written inside special PHP tags. Anything outside these tags is
treated as HTML.
PHP Opening and Closing Tags
<?php
// PHP code
?>
Syntax Rules
● Each PHP statement must end with a semicolon (;)
● PHP keywords are not case-sensitive
● Variable names are case-sensitive
● Whitespace does not affect execution
Output Statements
The echo and print statements are used to display output.
echo "Welcome to PHP";
4. Defining Variables and Constants
Variables in PHP
A variable is a named memory location used to store data temporarily during
program execution.
Characteristics:
● Variable names start with $
● No need to declare data type
● Dynamic typing (type is decided at runtime)
● Case-sensitive
$city = "Delhi";
$population = 20000000;
Constants in PHP
A constant is a fixed value that cannot be changed during execution.
Constants are useful for storing values like configuration settings.
Characteristics:
● Defined using define() or const
● Do not start with $
● Global scope by default
define("SITE_NAME", "My Website");
5. PHP Data Types
PHP supports loosely typed variables, meaning the type of variable is
determined automatically.
Major Data Types:
. Integer – Whole numbers without decimals
. Float (Double) – Numbers with decimal points
. String – Sequence of characters
. Boolean – True or False
. Array – Collection of values
. Object – Instance of a class
. NULL – Variable with no value
Understanding data types is essential for memory usage and correct program
logic.
6. Operators and Expressions
An operator performs operations on operands (variables or values). An
expression is a combination of operators and operands that produces a result.
Types of Operators:
Arithmetic Operators
Used for mathematical calculations such as addition, subtraction,
multiplication, division, and modulus.
Relational Operators
Used to compare two values and return a boolean result.
Logical Operators
Used to combine conditional expressions, especially in decision-making
statements.
Assignment Operators
Used to assign values to variables and modify existing values.
Operators play a crucial role in forming conditions, calculations, and control
structures.
7. Decision Making Statements
Decision-making statements control the flow of execution based on conditions.
if Statement
Executes code only when the condition is true.
if–else Statement
Provides alternative execution paths when the condition is false.
if–elseif–else Statement
Used when multiple conditions need to be tested sequentially.
switch Statement
Used as an alternative to multiple if–else conditions when comparing a single
variable against many values.
Decision-making statements are fundamental for implementing logic such as
validation, authentication, and grading systems.
8. Looping Statements (Repetition)
Loops are used to execute a block of code repeatedly until a condition is
satisfied.
Types of Loops:
. for Loop
Used when the number of iterations is known in advance.
. while Loop
.
Executes as long as a condition remains true.
. do–while Loop
Executes the loop body at least once, even if the condition is false.
. foreach Loop
Specifically designed to iterate over arrays.
Loops reduce code repetition and improve efficiency.
9. Mixing Decisions and Looping with HTML
PHP allows seamless integration with HTML. This feature is especially useful for
generating dynamic content such as tables, lists, and forms.
By embedding PHP logic inside HTML, developers can control content display
based on conditions and loops, enabling dynamic web pages.
Example use cases include:
● Displaying user data from a database
● Showing menus conditionally
● Generating reports and tables dynamically
10. Functions in PHP
Definition of Function
A function is a self-contained block of code that performs a specific task and
can be reused multiple times.
Advantages of Functions
● Code reusability
● Improved readability
● Easier debugging
● Modular programming
Functions help in dividing a large program into smaller manageable units.
11. Call by Value and Call by Reference
Call by Value
In this method, a copy of the variable is passed to the function. Changes inside
the function do not affect the original variable.
Call by Reference
In this method, the address of the variable is passed. Any modification inside
the function affects the original value.
Understanding this concept is important for memory management and
performance optimization.
12. Recursive Functions
A recursive function is a function that calls itself to solve a problem. It must
contain:
. A base condition
. A recursive call
Recursive functions are commonly used for problems like factorial calculation,
Fibonacci series, and tree traversal.
13. String Handling in PHP
A string is a sequence of characters enclosed in single or double quotes. PHP
provides extensive support for string manipulation.
String operations are essential for:
● Input validation
● Text formatting
● Searching and replacing content
● Data processing
14. String Searching and Replacing
PHP provides built-in functions to search for substrings and replace text within
strings. These functions are widely used in text processing, form validation, and
content filtering.
15. Formatting Strings
String formatting functions allow developers to:
● Change case
● Extract substrings
● Remove unwanted spaces
● Format output for display
Formatting improves readability and presentation of data.
16. String Related Library Functions
PHP includes a rich string library that supports:
● Length calculation
● Comparison
● Searching
● Replacing
● Splitting and joining strings
These library functions reduce development time and increase reliability.
UNIT–II
ARRAYS AND FORM HANDLING IN PHP (DETAILED THEORY)
1. Introduction to Arrays
In PHP, an array is a complex data type that allows storing multiple values
under a single variable name. Each value in an array is associated with a
unique key or index, which helps in identifying and accessing the element.
Arrays are essential in PHP because web applications frequently deal with
collections of data, such as lists of users, form inputs, database records, and
configuration values. Without arrays, handling such data would require
numerous individual variables, leading to inefficient and unmanageable code.
Arrays provide:
● Organized data storage
● Efficient access and manipulation
● Improved readability
● Support for bulk operations
2. Anatomy (Structure) of an Array
The internal structure of an array consists of:
. Array Name – Identifier for the array
. Key (Index) – Used to locate the value
. Value – Actual data stored
Each array element is stored as a key–value pair. The key can be numeric or
string-based, depending on the type of array.
Conceptually, an array can be visualized as a table where:
● Keys act as row identifiers
● Values act as data entries
This structure allows PHP to efficiently manage large sets of data.
3. Classification of Arrays in PHP
PHP supports different types of arrays to accommodate different programming
needs:
. Indexed (Numeric) Arrays
. Associative Arrays
. Multidimensional Arrays
Each type differs in the nature of its keys and the complexity of data it stores.
4. Indexed (Index-Based) Arrays
Definition
An indexed array is an array in which each element is identified by a numeric
index, starting from 0 by default.
Characteristics
● Indexes are automatically assigned if not specified
● Order of insertion is preserved
● Suitable for sequential data
Indexed arrays are commonly used when dealing with simple lists such as
names, numbers, or items.
Advantages
● Easy to create and use
● Simple looping using numeric counters
● Efficient memory usage
5. Accessing Indexed Array Elements
Accessing array elements involves specifying the index of the desired element.
Correct indexing is critical because accessing an undefined index results in
runtime warnings.
From a theoretical perspective, indexed arrays provide direct access to
elements, which makes them efficient for iterative processing.
6. Looping Through Indexed Arrays
Looping is essential for processing array elements.
Use of for Loop
The for loop is most appropriate for indexed arrays because:
● Index values are numeric
● Loop counter directly corresponds to array indexes
Looping through arrays enables:
● Data display
● Calculations on array elements
● Searching and filtering operations
7. Associative Arrays
Definition
An associative array uses string-based keys instead of numeric indexes. Each
key is associated with a specific value.
Purpose
Associative arrays are designed to store structured or related data, such as:
● Student records
● Product details
● Configuration settings
Characteristics
● Keys are descriptive
● Improves code readability
● Flexible data representation
8. Accessing Associative Array Elements
Accessing elements in associative arrays requires the use of key names. This
allows direct access to meaningful data without relying on numeric positions.
From a conceptual viewpoint, associative arrays function similarly to
dictionaries or maps, where each key uniquely identifies a value.
9. Looping Through Associative Arrays
Since associative arrays do not rely on numeric indexes, special looping
mechanisms are used.
each() Function
The each() function retrieves the current key–value pair and advances the
internal pointer. It demonstrates how PHP internally manages array pointers.
Although deprecated in newer PHP versions, it remains important for
theoretical understanding and examination purposes.
foreach() Loop
The foreach() loop is the most powerful and commonly used method for
iterating associative arrays.
Advantages of foreach()
● Eliminates manual index handling
● Automatically retrieves keys and values
● Improves clarity and maintainability
From a theoretical perspective, foreach() abstracts the internal pointer
mechanism, simplifying iteration.
10. Array Library Functions
PHP provides a comprehensive set of built-in array functions that perform
common operations such as sorting, searching, adding, and removing
elements.
Importance of Array Functions
● Reduce coding effort
● Improve performance
● Ensure reliability
Categories of Array Functions
● Sorting functions
● Searching functions
● Stack and queue functions
● Key and value manipulation functions
Understanding these functions is important for writing optimized PHP
programs.
11. HTML Form Handling in PHP
Forms are the primary method of user interaction in web applications. PHP is
extensively used to process form data submitted from HTML pages.
Form handling involves:
● Accepting user input
● Validating data
● Processing or storing data
● Generating responses
PHP acts as the server-side processor, ensuring data integrity and security.
12. Capturing Form Data in PHP
PHP uses superglobal variables to capture form data.
Superglobals Characteristics
● Accessible anywhere in the script
● Automatically populated by PHP
● Secure when properly validated
The most commonly used superglobals for form handling are $_GET, $_POST,
and $_REQUEST.
13. GET and POST Methods (Detailed Comparison)
GET Method
● Appends data to the URL
● Limited data size
● Less secure
● Used for non-sensitive data
POST Method
● Sends data in HTTP body
● No size limitation
● More secure
● Suitable for confidential data
Understanding the difference is essential for designing secure web
applications.
14. Handling Multi-Value Form Fields
Certain form elements allow users to select multiple values, such as:
● Checkboxes
● Multiple select lists
When submitted, these values are received in PHP as arrays.
This feature demonstrates the importance of arrays in form processing and
highlights PHP’s seamless integration between HTML and server-side scripting.
15. File Upload Handling in PHP
File uploading enables users to submit documents, images, and media files to
the server.
Theory of File Upload Process
. User selects a file
. File is temporarily stored on server
. PHP validates file information
. File is moved to a permanent location
PHP stores uploaded file details in the $_FILES superglobal array.
16. Redirecting a Form After Submission
Redirection is an important technique used after form submission to:
● Prevent duplicate submissions
● Improve user experience
● Implement Post/Redirect/Get (PRG) pattern
Using redirection ensures clean application flow and avoids accidental data
duplication.
UNIT–III
FILE HANDLING, DIRECTORY MANAGEMENT, SESSIONS, AND
COOKIES IN PHP
(EXTENSIVE THEORY NOTES)
PART A: FILE AND DIRECTORY MANAGEMENT
1. Concept of Files in Web Applications
A file is a structured collection of data stored permanently on secondary
storage media. In the context of web applications, files serve as a means of
persistent storage, allowing data to be retained beyond the execution cycle of
a program.
In PHP-based applications, files are frequently used for:
● Storing configuration settings
● Maintaining system logs
● Saving user-generated content
● Handling uploads such as images and documents
Files allow PHP scripts to interact directly with the server’s file system,
enabling long-term data retention without relying solely on databases.
2. Concept of Directories
A directory (or folder) is a logical container that organizes files in a hierarchical
structure. Directories improve data management by grouping related files and
simplifying navigation within the file system.
From a PHP application perspective, directories are important for:
● Organizing uploaded files
● Structuring application resources
● Separating public and private data
Proper directory management enhances scalability, maintainability, and
security.
3. File System Interaction in PHP
PHP provides built-in functions to interact with the operating system’s file
system. These functions act as an abstraction layer, allowing PHP scripts to
perform file operations without needing direct OS-level commands.
Key benefits of PHP file system interaction:
● Platform independence
● Controlled access to server resources
● Simplified data storage mechanisms
4. File Opening Mechanism
Before performing any operation on a file, PHP must establish a connection
between the script and the file. This process is known as opening a file.
Opening a file involves:
● Locating the file on the server
● Assigning it to a file handle
● Specifying an access mode
The access mode defines whether the file can be read, written, or appended.
Proper selection of file modes is essential to prevent data corruption or
unauthorized access.
5. Importance of Closing Files
Closing a file terminates the connection between the PHP script and the file
system. Although PHP may close files automatically at script termination,
explicitly closing files is considered best practice.
Closing files:
● Releases system resources
● Ensures data integrity
● Prevents file locking issues
Failure to close files can lead to performance degradation and unexpected
behavior in high-traffic applications.
6. Conceptual Understanding of File Reading
File reading allows PHP applications to retrieve data stored in files. This is
particularly useful for:
● Displaying stored information
● Processing configuration files
● Analyzing logs
From a theoretical perspective, file reading converts stored data into a usable
format for program execution.
7. Conceptual Understanding of File Writing
File writing enables PHP scripts to create or modify files. Writing operations
allow applications to:
● Store user inputs
● Generate reports dynamically
● Maintain system logs
Writing to files is a critical feature for applications that require data persistence
without continuous database access.
8. Copying Files
File copying creates an exact duplicate of an existing file at a specified location.
This operation is important for:
● Backup creation
● File version management
● Data redundancy
Copying files helps ensure data availability in case of accidental deletion or
corruption.
9. Renaming Files
Renaming a file changes its name or storage path. This operation is often used
to:
● Organize files systematically
● Avoid filename conflicts
● Implement version control mechanisms
Renaming plays a crucial role in managing uploaded files dynamically.
10. Deleting Files
File deletion permanently removes a file from the file system. PHP supports file
deletion to:
● Clear obsolete data
● Free storage space
● Enhance application security
Theoretical understanding of file deletion emphasizes cautious implementation
due to its irreversible nature.
11. Directory Handling in PHP
PHP allows programs to interact with directories similarly to files. Directory
handling includes:
● Opening directories
● Reading directory contents
● Closing directories
Directory traversal enables applications to dynamically process multiple files,
such as listing uploaded documents.
12. Creating Directories
Directory creation allows PHP applications to build folder structures
dynamically. This is especially useful in:
● User-based file storage systems
● Content management systems
● Upload-heavy applications
Dynamic directory creation supports scalable system architecture.
13. Deleting Directories
Directory deletion removes an empty directory from the file system. This
operation is typically used during:
● Cleanup processes
● User account deletion
● Temporary data removal
Proper directory deletion ensures organized storage and efficient resource
utilization.
14. File Uploading: Conceptual Overview
File uploading is the process of transferring a file from a client system to the
server. PHP enables file uploading through HTML forms combined with server-
side processing.
File uploading is commonly used for:
● Profile pictures
● Document submissions
● Media sharing
Security considerations such as file validation and size limits are critical in file
upload operations.
15. File Downloading: Conceptual Overview
File downloading allows users to retrieve server-stored files. PHP scripts
control the download process to:
● Restrict unauthorized access
● Monitor usage
● Protect sensitive files
Downloading ensures controlled and secure file distribution.
PART B: SESSION AND COOKIE MANAGEMENT
16. Stateless Nature of HTTP
HTTP is a stateless protocol, meaning each request is independent and does
not retain information about previous interactions. This creates challenges for
applications that require continuity, such as login systems.
Sessions and cookies are introduced to overcome this limitation.
17. Concept of Session Control
Session control refers to techniques used to maintain state information across
multiple HTTP requests. Sessions enable PHP applications to remember user-
specific data temporarily.
Typical session-based features include:
● Authentication systems
● Shopping carts
● Personalized dashboards
18. Internal Working of Sessions in PHP
A PHP session works by:
● Generating a unique session ID
● Storing data on the server
● Associating the session ID with the client
The session ID is usually stored in a cookie, allowing PHP to retrieve the correct
session data for each request.
19. Session Lifecycle
A session has a defined lifecycle:
. Session creation
. Data storage
. Session usage
. Session expiration or destruction
Understanding the session lifecycle is important for managing resources and
maintaining security.
20. Cookies: Conceptual Explanation
A cookie is a small data file stored on the client’s browser. Cookies allow
websites to store limited information on the user’s device.
Cookies are used for:
● Remembering preferences
● Tracking user behavior
● Maintaining login states
21. Characteristics and Limitations of Cookies
Cookies have certain limitations:
● Small storage capacity
● Stored on client side
● Vulnerable to tampering
Despite limitations, cookies remain useful for lightweight data storage.
22. Relationship Between Cookies and Sessions
Cookies and sessions often work together:
● Cookie stores session ID
● Session stores actual data
This hybrid approach combines client-side identification with server-side
security.
23. Setting Cookies in PHP (Conceptual)
Cookies are set by sending HTTP headers to the browser. Cookies can have
attributes such as:
● Expiration time
● Path
● Domain
Proper cookie management ensures controlled data storage.
24. Deleting Cookies
Cookies are deleted by instructing the browser to remove them. This is typically
done by setting the cookie’s expiration time to a past date.
Cookie deletion is essential for:
● Logout functionality
● Privacy compliance
● Clearing saved data
25. Session Variables
Session variables store data on the server associated with a session ID. These
variables allow data sharing across multiple pages during a session.
Session variables are preferred for storing sensitive data due to server-side
storage.
26. Destroying Session Variables
Specific session variables can be removed when they are no longer required.
This allows fine-grained control over stored session data.
27. Destroying a Session
Destroying a session completely removes all associated data and terminates
the user’s session. This is typically done during logout or session timeout.
Session destruction is a critical security practice.
UNIT – IV
RDBMS AND DATABASE OPERATIONS WITH PHP
(ULTRA-DETAILED THEORY NOTES)
1. Introduction to Database Systems
A database is an organized collection of related data stored electronically in a
structured format. Databases are designed to efficiently store, retrieve,
manipulate, and manage large volumes of information.
In traditional file-based systems, data redundancy, inconsistency, and lack of
security were major problems. To overcome these limitations, Database
Management Systems (DBMS) were introduced.
2. Relational Database Management System (RDBMS)
An RDBMS is a type of DBMS that follows the relational model proposed by E.
F. Codd. In this model, data is represented in the form of relations (tables).
Each table consists of:
● Rows (Tuples): Represent records
● Columns (Attributes): Represent fields
Relationships between tables are established using keys, which enable data
integrity and consistency.
3. Core Principles of RDBMS
3.1 Tables and Relations
Each table represents a real-world entity such as Student, Employee, or
Product.
3.2 Keys in RDBMS
● Primary Key: Uniquely identifies each record
● Foreign Key: Establishes relationship between tables
● Candidate Key: Possible keys that can uniquely identify records
3.3 Integrity Constraints
Constraints ensure correctness and validity of data:
● Entity integrity
● Referential integrity
● Domain integrity
4. Advantages of RDBMS
An RDBMS offers several advantages over traditional file systems:
. Reduced Data Redundancy
. Improved Data Consistency
. Data Integrity Enforcement
. Security and Authorization
. Concurrent Multi-User Access
. Data Backup and Recovery
. Scalability and Flexibility
These advantages make RDBMS the backbone of modern web applications.
5. MySQL as an RDBMS
MySQL is one of the most widely used open-source RDBMSs, especially in web
development.
Reasons for Popularity:
● Open source and free
● High performance
● Supports large databases
● Easy integration with PHP
● Cross-platform compatibility
MySQL uses Structured Query Language (SQL) to manage and manipulate
data.
6. PHP–MySQL Architecture
In a typical PHP–MySQL web application:
. User interacts with a web page
. Data is sent to the PHP script
. PHP connects to the MySQL database
. SQL queries are executed
. Results are returned to PHP
. Output is displayed to the user
This architecture enables dynamic, data-driven websites.
7. Concept of Database Connectivity
Database connectivity refers to the process of establishing a communication
channel between an application and a database server.
Purpose of Connectivity:
● Authenticate access credentials
● Select the required database
● Execute SQL queries
● Fetch and manipulate results
A stable and secure connection is essential for reliable application behavior.
8. Data Manipulation Language (DML)
DML commands are used to manipulate data stored in database tables.
Unlike DDL (which defines structure), DML focuses on actual data operations.
The main DML commands are:
● INSERT
● SELECT
● UPDATE
● DELETE
These commands form the operational core of database-driven applications.
9. INSERT Operation (Detailed Theory)
The INSERT command is used to add new records into a table.
Theoretical Importance:
● Enables data entry
● Used during user registration, form submission, and logging
● Maintains database growth
INSERT operations must satisfy:
● Data type rules
● Constraint conditions
● Referential integrity
10. SELECT Operation (Detailed Theory)
SELECT is the most frequently used SQL command.
Purpose:
● Retrieve data from one or more tables
● Generate reports
● Display user-specific information
Conceptual Features:
● Projection (selecting columns)
● Selection (filtering rows)
● Sorting and grouping
SELECT forms the foundation of decision-making in applications.
11. UPDATE Operation (Detailed Theory)
UPDATE is used to modify existing records.
Use Cases:
● Updating profiles
● Changing status or settings
● Correcting data
Conceptual Considerations:
● Must target correct records
● Overuse without conditions may corrupt data
● Requires transactional control
12. DELETE Operation (Detailed Theory)
DELETE removes records permanently from a table.
Characteristics:
● Irreversible without backups
● Used for cleanup and maintenance
● Must be used cautiously
DELETE operations affect data availability and must respect referential
integrity.
13. Query Parameters and Parameterized Queries
Concept of Query Parameters
Query parameters are placeholders that allow SQL queries to accept external
input safely.
Importance:
● Prevent SQL Injection
● Improve application security
● Enhance query reusability
● Separate logic from data
Parameterized queries are a best practice in modern web development.
14. Executing Queries in PHP (Conceptual View)
Executing a query involves:
● Sending SQL command to the database engine
● Parsing and validating the query
● Optimizing execution plan
● Returning results or execution status
Efficient query execution ensures high application performance.
15. Concept of JOIN in Relational Databases
In a normalized database, data is spread across multiple related tables. To
retrieve meaningful information, tables must be combined logically.
This is achieved using JOIN operations.
JOINs allow:
● Combining related data
● Eliminating redundancy
● Supporting normalization
16. Cross Join (Extended Theory)
A Cross Join produces a Cartesian product of two tables.
Characteristics:
● No join condition
● Output size = rows of table A × rows of table B
● Rare in practical systems
Cross joins are primarily used for theoretical understanding and test cases.
17. Inner Join (Extended Theory)
An Inner Join retrieves records that have matching values in both tables.
Conceptual Importance:
● Filters unrelated records
● Produces meaningful datasets
● Most commonly used join
Inner joins represent the logical intersection of two tables.
18. Outer Join (Extended Theory)
Outer joins retrieve matched and unmatched records.
Types:
● Left Outer Join
● Right Outer Join
Use Cases:
● Handling optional relationships
● Reporting missing data
● Data completeness analysis
Outer joins enhance data visibility.
19. Self Join (Extended Theory)
A Self Join relates a table to itself.
Purpose:
● Hierarchical data representation
● Comparative analysis within same entity
Examples include:
● Employee–Manager relationships
● Category hierarchies
Self joins require aliases to avoid ambiguity.
20. Role of Joins in Web Applications
Joins:
● Enable complex queries
● Reduce storage redundancy
● Support relational integrity
● Enhance reporting capabilities
Without joins, relational databases lose their core strength.
21. Database-Driven Web Applications
In PHP applications:
● HTML collects input
● PHP processes logic
● SQL manages data
● RDBMS ensures consistency
This synergy enables:
● User authentication systems
● E-commerce platforms
● Content management systems
22. Advantages of Using RDBMS with PHP
● Structured and organized data storage
● Efficient querying and indexing
● Secure data access
● Transaction management
● Scalability and reliability
RDBMS with PHP forms a complete server-side development stack.