New CPC Coding Batch Starting January 25, 2025! Enroll Now! Call +91-9416339111

Web Development with PHP, MySQL and WordPress

Course Components

  • Overview of web development technologies
  • Understanding client-server architecture
  • Introduction to HTML, CSS, and JavaScript
  • Setting up a local development environment (XAMPP/WAMP)
  • What is PHP?
  • PHP syntax, variables, and data types
  • Operators and expressions
  • Conditional statements (if, else, switch)
  • Loops (for, while, foreach)
  • Defining and calling functions
  • Function parameters and return values
  • Variable scope (local vs global)
  • Built-in PHP functions
  • Indexed and associative arrays
  • Array manipulation functions
  • Superglobal variables ($_GET, $_POST, $_SESSION, $_COOKIE, $_FILES)
  • Form handling in PHP
  • What is MySQL? Overview and importance in web development
  • Setting up MySQL database and tables
  • Introduction to SQL (Structured Query Language)
  • Basic CRUD operations (Create, Read, Update, Delete)
  • MySQL data types
  • Introduction to MySQLi and PDO
  • Connecting PHP to MySQL
  • Retrieving and displaying data from a database
  • Inserting, updating, and deleting data from a database
  • Error handling and exceptions in PHP
  • File handling in PHP (reading/writing files)
  • Sessions and cookies
  • Security best practices in PHP (SQL injection, XSS)
  • Overview of WordPress: What is it and why use it?
  • Installing WordPress locally and on a server
  • WordPress dashboard and basic settings
  • Understanding themes and plugins
  • Introduction to the WordPress theme structure
  • Creating a custom theme from scratch
  • Template files (header.php, footer.php, index.php, etc.)
  • WordPress Loop and displaying posts
  • Basic CSS and JavaScript for WordPress themes
  • Introduction to WordPress plugins
  • Creating a simple plugin
  • Working with WordPress hooks (actions and filters)
  • Adding custom functionality to WordPress using plugins
  • WordPress database structure
  • Querying the WordPress database with WP_Query
  • Using WordPress functions for database interaction
  • Best practices for handling database operations in WordPress
  • Building a dynamic website with PHP, MySQL, and WordPress
  • Final project: Create a blog or business website using WordPress
  • Review of key concepts: PHP, MySQL, WordPress
  • Final Q&A session
  • Weekly quizzes to test understanding of concepts
  • Mid-course practical assignment (PHP & MySQL project)
  • Final project (WordPress website development)

ENQUIRY FORM