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