End to End Web Development using PHP, MySQL and Apache

---

PHP, Apache, and MySQL are the three key open source technologies that form the basis for most active Web servers. This course guides you through the entire process of setting up your own site and walks you through every step, from the installation of PHP, Apache, and MySQL to database management, security, and integration with other technologies. The multi-platform approach addresses installation and usage on both Linux® and Windows®, and two common-themed, reusable Web sites are examined. Upon completion of this course, you’ll be able to create well designed, dynamic Web sites using open source tools.

What you will learn from this course is Syntax, functions, and commands of PHP, Apache, and MySQL and how they can be used together in Web development The ins and outs of data manipulation The object-oriented programming advantages of PHP5 Ways of using PHP for connecting HTML-based Web pages to a backend database for dynamic content How MySQL easily stores, updates, and accesses information

---

 

Career benefit of this course

---

• Web Developer
• Back end web developer
• Front end Developer

Course Modules for Java Web Application Programming

---

Chapter 1: Configuring Your Installation

• Brief Intro to PHP, Apache, MySQL, and Open Source
• How the Pieces of the AMP Module Work Together
• Configuring Your Apache Installation
• Configuring Your PHP Installation
• Configuring Your MySQL Installation
• Where to Go for Help and Other Valuable Resources

 

Chapter 2: Creating PHP Pages Using PHP

• Overview of PHP Structure and Syntax
• Creating Your First Program
• Using HTML to Spice Up Your Pages
• Using Constants and Variables to add Functionality
• Passing Variables between Pages
• Using if/else Arguments
• Using Includes for Efficient Code
• Using Functions for Efficient Code
• All About Arrays
• While You’re Here …
• Alternative Syntax for PHP
• OOP Dreams

 

Chapter 3: Using PHP with MySQL

• Overview of MySQL Structure and Syntax
• How PHP Fits with MySQL
• Connecting to the MySQL Server
• Looking at a Ready-Made Database
• Querying the Database
• Helpful Tips and Suggestions

 

Chapter 4: Using Tables to Display Data

• Creating a Table
• Populating the Table
• Who’s the Master?
• A Lasting Relationship

 

Chapter 5: Form Elements: Letting the User Work with Data

• Your First Form
• Driving the User Input
• Using Form Elements Together

 

Chapter 6: Letting the User Edit the Database

• Preparing the Battlefield
• Inserting a Simple Record from phpMyAdmin
• Inserting a Record in a Relational Database
• Deleting a Record
• Editing Data in a Record

 

Chapter 7: Manipulating and Creating Images with PHP

• Working with the GD Library
• Allowing Users to Upload Images
• Converting Image file types
• Black and White
• Adding Captions
• Adding Watermarks and Merging Images
• Creating Thumbnails

 

Chapter 8: Validating User Input

• Users Are Users Are Users
• Incorporating Validation into the Movie Site
• Forgot Something?
• Checking for Format Errors

 

Chapter 9: Handling and avoiding Errors

• How the Apache Web Server Deals with Errors
• Error Handling and Creating Error Handling Pages with PHP
• Other Methods of Error Handling

 

Chapter 10: Building Databases

• Getting Started
• Designing Your Database
• Creating a Database in MySQL
• Creating the Comic Character Application

 

Chapter 11: Sending E-mail

• Setting Up PHP to Use E-mail
• Sending an E-mail
• Dressing Up Your E-mails with HTML
• Storing Images
• Getting Confirmation
• Creating a Reusable Mail Class

 

Chapter 12: User Logins, Profiles and Personalization

• The Easiest Way to Protect Your Files
• Friendlier Logins Using PHP’s Session and Cooking Functions
• Using Database-Driven Information

 

Chapter 13: Building a Content Management System

• Getting Your Users to Return
• Preparing the Database
• Coding for Reusability
• Transaction Pages
• User Interface

 

Chapter 14: Mailing Lists

• What Do You Want to Send Today?
• Coding the Administration Application
• Sign Me Up!
• Mailing List Ethics

 

Chapter 15: Online Stores

• Adding E-Commerce to the Comic Book Fan Site
• E-Commerce, Any Way You Slice It

 

Chapter 16: Creating a Bulletin Board System

• Your Bulletin Board
• Preparing the Database
• Reusable Code
• Transaction Pages
• Account Functionality
• Forum Functionality
• Afterthoughts

 

Chapter 17: Using Log Files to Improve Your Site

• Locating your Logs
• Analyzing Your Log Data
• Putting the Analysis to Work

 

Chapter 18: Troubleshooting

• Installation Troubleshooting
• Parse Errors
• Empty Variables
• “Headers Already Sent” Error
• General Debugging Tips
• Where to Go for Help

The strength in your qualification

---

On successful completion of this short programme, the learner will receive the Pine Valley Institute certificate in Web Development Programming .We are accredited by Micseta and  we also assist the learner  to seat for the ORACLE web component certification which guarantee the learners to work in any reputable company

For Career Guidance or not sure what to study complete the form below and Pine Valley Institute professional career adviser will call you back within an hour