PHP Programming

  1. Interacting with Databases
    1. Database Fundamentals
      1. Relational Database Concepts
        1. Tables
          1. Rows and Columns
            1. Primary Keys
              1. Foreign Keys
                1. Relationships
                2. Database Management Systems
                  1. MySQL
                    1. PostgreSQL
                      1. SQLite
                        1. MariaDB
                        2. Basic SQL Commands
                          1. SELECT Statements
                            1. INSERT Statements
                              1. UPDATE Statements
                                1. DELETE Statements
                                  1. CREATE TABLE
                                    1. ALTER TABLE
                                      1. DROP TABLE
                                    2. Database Connection Methods
                                      1. PHP Data Objects (PDO)
                                        1. PDO Overview
                                          1. Creating PDO Instance
                                            1. Connection Strings
                                              1. Connection Options
                                                1. Error Handling Modes
                                                2. MySQLi Extension
                                                  1. Procedural Style
                                                    1. Object-Oriented Style
                                                      1. Prepared Statements
                                                    2. Working with PDO
                                                      1. Connection Management
                                                        1. Establishing Connections
                                                          1. Connection Persistence
                                                            1. Connection Pooling
                                                            2. Executing Queries
                                                              1. Direct Queries
                                                                1. Prepared Statements
                                                                  1. Parameter Binding
                                                                    1. Named Parameters
                                                                      1. Positional Parameters
                                                                      2. Statement Execution
                                                                      3. Fetching Results
                                                                        1. fetch() Method
                                                                          1. fetchAll() Method
                                                                            1. fetchColumn() Method
                                                                              1. Fetch Modes
                                                                                1. FETCH_ASSOC
                                                                                  1. FETCH_NUM
                                                                                    1. FETCH_BOTH
                                                                                      1. FETCH_OBJ
                                                                                        1. FETCH_CLASS
                                                                                      2. Error Handling
                                                                                        1. Exception Mode
                                                                                          1. Error Codes
                                                                                            1. Error Messages
                                                                                          2. CRUD Operations
                                                                                            1. Create Operations
                                                                                              1. INSERT Queries
                                                                                                1. Bulk Inserts
                                                                                                  1. Auto-increment Handling
                                                                                                  2. Read Operations
                                                                                                    1. SELECT Queries
                                                                                                      1. WHERE Clauses
                                                                                                        1. JOIN Operations
                                                                                                          1. Sorting and Limiting
                                                                                                          2. Update Operations
                                                                                                            1. UPDATE Queries
                                                                                                              1. Conditional Updates
                                                                                                                1. Bulk Updates
                                                                                                                2. Delete Operations
                                                                                                                  1. DELETE Queries
                                                                                                                    1. Conditional Deletes
                                                                                                                      1. Soft Deletes
                                                                                                                    2. Advanced Database Operations
                                                                                                                      1. Transactions
                                                                                                                        1. Transaction Concepts
                                                                                                                          1. Beginning Transactions
                                                                                                                            1. Committing Transactions
                                                                                                                              1. Rolling Back Transactions
                                                                                                                                1. ACID Properties
                                                                                                                                2. Stored Procedures
                                                                                                                                  1. Calling Procedures
                                                                                                                                    1. Parameter Handling
                                                                                                                                    2. Database Schema Management
                                                                                                                                      1. Connection Pooling
                                                                                                                                        1. Query Optimization

                                                                                                                                      Previous

                                                                                                                                      6. Object-Oriented Programming in PHP

                                                                                                                                      Go to top

                                                                                                                                      Next

                                                                                                                                      8. State and Session Management