PHP and MySQL The Web Development course is designed for professionals with basic knowledge of HTML and work experience in programming in a modern programming language who have not necessarily programmed for the web or used a relational database.
PHP and MySQL The Web Development course is designed for professionals with basic knowledge of HTML and work experience in programming in a modern programming language who have not necessarily programmed for the web or used a relational database.
The course trains you on the topics of web development such as using arrays, storing and retrieving data, object-oriented PHP, advanced MySQL administration and programming, web applications, internationalization and localization, and many more.
Lesson 1: Introduction
Why You Should Read This Book
What You Will Learn from This Book
What Is PHP?
What Is MySQL?
Why Use PHP and MySQL?
Some of PHP's Strengths
Key Features of PHP 7
Some of MySQL's Strengths
What Is New in MySQL (8.x)?
How Is This Book Organized?
Finally
Lessons 2: PHP Crash Course
Before You Begin: Accessing PHP
Creating a Sample Application: Bob's Auto Parts
Embedding PHP in HTML
Adding Dynamic Content
Accessing Form Variables
Understanding Identifiers
Examining Variable Types
Declaring and Using Constants
Understanding Variable Scope
Using Operators
Working Out the Form Totals
Understanding Precedence and Associativity
Using Variable Handling Functions
Making Decisions with Conditionals
Repeating Actions Through Iteration
Breaking Out of a Control Structure or Script
Employing Alternative Control Structure Syntax
Using declare
Next
Programming Exercises
Lessons 3: Storing and Retrieving Data
Saving Data for Later
Storing and Retrieving Bob's Orders
Processing Files
Opening a File
Writing to a File
Closing a File
Reading from a File
Using Other File Functions
Locking Files
A Better Way: Databases
Further Reading
Next
Programming Exercises
Lesson 4: Using Arrays
What Is an Array?
Numerically Indexed Arrays
Arrays with Different Indices
Array Operators
Multidimensional Arrays
Sorting Arrays
Sorting Multidimensional Arrays
Reordering Arrays
Loading Arrays from Files
Performing Other Array Manipulations
Further Reading
Next
Programming Exercises
Lessons 5: String Manipulation and Regular Expressions
Creating a Sample Application: Smart Form Mail
Formatting Strings
Joining and Splitting Strings with String Functions
Comparing Strings
Matching and Replacing Substrings with String Functions
Introducing Regular Expressions
Finding Substrings with Regular Expressions
Replacing Substrings with Regular Expressions
Splitting Strings with Regular Expressions
Further Reading
Next
Programming Exercises
Lessons 6: Reusing Code and Writing Functions
The Advantages of Reusing Code
Using require() and include()
Using Functions in PHP
Defining Your Own Functions
Examining Basic Function Structure
Using Parameters
Understanding Scope
Passing by Reference Versus Passing by Value
Using the return Keyword
Implementing Recursion
Further Reading
Next
Programming Exercises
Lessons 7: Object-Oriented PHP
Understanding Object-Oriented Concepts
Creating Classes, Attributes, and Operations in PHP
Instantiating Classes
Using Class Attributes
Calling Class Operations
Controlling Access with private and public
Writing Accessor Functions
Implementing Inheritance in PHP
Using Traits
Designing Classes
Writing the Code for Your Class
Understanding Advanced Object-Oriented Functionality in PHP
Next
Programming Exercises
Lessons 8: Error and Exception Handling
Exception Handling Concepts
The Exception Class
User-Defined Exceptions
Exceptions in Bob's Auto Parts
Exceptions and PHP's Other Error Handling Mechanisms
Further Reading
Next
Programming Exercises
Lessons 9: Designing Your Web Database
Relational Database Concepts
Designing Your Web Database
Web Database Architecture
Further Reading
Next
Lessons 10: Creating Your Web Database
Using the MySQL Monitor
Logging In to MySQL
Creating Databases and Users
Setting Up Users and Privileges
Introducing MySQL's Privilege System
Setting Up a User for the Web
Using the Right Database
Creating Database Tables
Understanding MySQL Identifiers
Choosing Column Data Types
Further Reading
Next
Programming Exercises
Lessons 11: Working with Your MySQL Database
What Is SQL?
Inserting Data into the Database
Retrieving Data from the Database
Updating Records in the Database
Altering Tables After Creation
Deleting Records from the Database
Dropping Tables
Dropping a Whole Database
Further Reading
Next
Programming Exercises
Lessons 12: Accessing Your MySQL Database from the Web with PHP
How Web Database Architectures Work
Querying a Database from the Web
Putting New Information in the Database
Using Other PHP-Database Interfaces
Further Reading
Next
Programming Exercises
Lessons 13: Advanced MySQL Administration
Understanding the Privilege System in Detail
Making Your MySQL Database Secure
Getting More Information About Databases
Optimizing Your Database
Backing Up Your MySQL Database
Restoring Your MySQL Database
Implementing Replication
Further Reading
Next
Programming Exercises
Lessons 14: Advanced MySQL Programming
The LOAD DATA INFILE Statement
Storage Engines
Transactions
Foreign Keys
Stored Procedures
Triggers
Further Reading
Next
Programming Exercises
Lessons 15: Web Application Security Risks
Identifying the Threats We Face
Understanding Who We're Dealing With
Next
Lessons 16: Building a Secure Web Application
Strategies for Dealing with Security
Securing Your Code
Securing Your Web Server and PHP
Database Server Security
Protecting the Network
Computer and Operating System Security
Disaster Planning
Next
Programming Exercises
Lessons 17: Implementing Authentication Methods with PHP
Identifying Visitors
Implementing Access Control
Using Basic Authentication
Using Basic Authentication in PHP
Using Basic Authentication with Apache's .htaccess Files
Creating Your Own Custom Authentication
Further Reading
Next
Programming Exercises
Lessons 18: Interacting with the File System and the Server
Uploading Files
Using Directory Functions
Interacting with the File System
Using Program Execution Functions
Interacting with the Environment: getenv() and putenv()
Further Reading
Next
Programming Exercises
Lessons 19: Using Network and Protocol Functions
Examining Available Protocols
Sending and Reading Email
Using Data from Other Websites
Using Network Lookup Functions
Backing Up or Mirroring a File
Further Reading
Next
Programming Exercises
Lessons 20: Managing the Date and Time
Getting the Date and Time from PHP
Converting Between PHP and MySQL Date Formats
Calculating Dates in PHP
Calculating Dates in MySQL
Using Microseconds
Using the Calendar Functions
Further Reading
Next
Programming Exercises
Lessons 21: Internationalization and Localization
Localization Is More than Translation
Understanding Character Sets
Creating a Basic Localizable Page Structure
Using gettext() in an Internationalized Application
Further Reading
Next
Programming Exercises
Lesson 22: Generating Images
Setting Up Image Support in PHP
Understanding Image Formats
Creating Images
Using Automatically Generated Images in Other Pages
Using Text and Fonts to Create Images
Drawing Figures and Graphing Data
Using Other Image Functions
Next
Programming Exercises
Lesson 23: Using Session Control in PHP
What is session control?
Understanding Basic Session Functionality
Implementing Simple Sessions
Creating a Simple Session Example
Configuring Session Control
Implementing Authentication with Session Control
Next
Programming Exercises
Lesson 24: Integrating JavaScript and PHP
Understanding AJAX
A Brief Introduction to jQuery
Using jQuery in Web Applications
Using jQuery and AJAX with PHP
Further Reading
Next
Programming Exercises
Lesson 25: Other Useful Features
Evaluating Strings: eval()
Terminating Execution: die() and exit()
Serializing Variables and Objects
Getting Information About the PHP Environment
Temporarily Altering the Runtime Environment
Highlighting Source Code
Using PHP on the Command Line
Next
Programming Exercises
Lesson 26: Using PHP and MySQL for Large Projects
Applying Software Engineering to Web Development
Planning and Running a Web Application Project
Reusing Code
Writing Maintainable Code
Implementing Version Control
Choosing a Development Environment
Documenting Your Projects
Prototyping
Separating Logic and Content
Optimizing Code
Testing
Further Reading
Next
Lesson 27: Debugging and Logging
Programming Errors
Variable Debugging Aid
Error Reporting Levels
Altering the Error Reporting Settings
Triggering Your Own Errors
Logging Errors Gracefully
Logging Errors to a Log File
Next
Lesson 28: Building User Authentication and Personalization
Solution Components
Solution Overview
Implementing the Database
Implementing the Basic Site
Implementing User Authentication
Implementing Bookmark Storage and Retrieval
Implementing Recommendations
Considering Possible Extensions
Lessons 29: Building a Web-Based Email Service with Laravel Part I
Introducing Laravel
Lessons 30: Building a Web-Based Email Service with Laravel Part II
Building a Simple IMAP Client using Laravel
Pulling it All Together to Build a Web-based Email Client
Conclusion
Lessons 31: Social Media Integration Sharing and Authentication
Web Service Authentication with OAuth
Conclusion
Lessons 32: Building a Shopping Cart
Solution Components
Solution Overview
Implementing the Database
Implementing the Online Catalog
Implementing the Shopping Cart
Implementing Payment
Implementing an Administration Interface
Extending the Project
Lessons 33: Installing Apache, PHP, and MySQL
Installing Apache, PHP, and MySQL Under UNIX
Installing Apache, PHP, and MySQL for Windows and Mac OS X Using All-in-One Installation Packages
Installing PEAR
Installing PHP with Other Web Servers
Our Philosophy
At Calgary Learning we realize that quality of teaching and tutoring demands more than just academic expertise on the part of the teachers and tutors. The key to establishing a foundation for learning development is a warm and positive relationship with students without fostering dependency.
We provide them with clear structure, techniques, and strategies to approach challenging material. By stimulating the learning process, we are able to help students gain the self-awareness needed to succeed in applying strategies independently.
Teachers and Tutors at Calgary Learning focus on identifying the students’ strengths while addressing the areas that need attention. Our focus is a holistic approach to the total learning process, rather than solely on deficits. CLI students are motivated to learn and enjoy tackling challenging assignments.
They are actively involved in their own learning/tutoring program. Current assignments are addressed while students gain transferable skills. They are also encouraged to set attainable goals and to work towards meeting them.
Our History
In 1995 Sherma Jeffrey-Ryan started with the vision of reaching and empowering children through education. First, she focused on the underprivileged children who were failing in the traditional school system. She started tutoring at home and she quickly realized that the need was greater than she had envisioned. Later, Calgary Learning Institute moved to a larger educational facility with a computer lab and a library to accommodate and enhance the learning experience of many students.
In 2010 CLI partnered with a testing company to deliver the MCAT, and after a few years, the company expanded to add more tests. Today Calgary Learning has two fully equipped computer labs with 25 networked computers. It is a Select Testing Site for Pearson Vue and a preferred site for PAN, PSI, Kryterion, Prometric, Scranton, and Assessment Systems.
The company has also added external university and college proctoring services and online Information Technology online courses, practice tests, and labs. We provide excellent quality training and testing experience for all students.
Our goal is to eliminate poverty through education by offering individualized training programs in English, adult workplace training, computer skills and tutoring to help students and adults gain the skills and confidence to be successful.
Our training covers basic and advanced PLSQL, PLSQL programming, triggers, cursors, sequences, packages, stored procedures and functions, date and time management, string manipulation and more Again.Â
Learn how to manage large datasets and analyze real data using the standard data management language.
SQL is the standard language used to communicate with relational database management systems (RDBMS). Graduates of this course will manage data through SQL constructs such as CREATE Database, CREATE Table, CONSTRAINT, and INSERT statements.
The SQL Server courses at SETC Training Ottawa teach you how to install and configure SQL Server databases to offer enterprise-grade database services
MySQL is one of the simplest ways for you to store, manipulate and retrieve large amounts of different types of data. Let us show you the core aspects of the language including how to create a MySQL database, write SQL statements and integrate it with programming languages.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy