Learn the basics of PHP and MySQL programming
You want to pimp up your private or business website with dynamic features using PHP and MySQL, but you don’t have any programming knowledge? Good news: this course has been designed for you. The second module of the seminar “Practical Path of Exercises for Beginners” is a very special thing. You will learn the basic principles of programming by doing one exercise after the other. Most of the knowledge behind these concepts is hidden from you. You learn only a little theory at a time and immediately afterwards you will have to put it into practice by performing an programming exercise. Don’t worry. After we have accomplished the whole path of exercises we will be introduced to the remaining concepts in the next lesson “Language Basics” to get the big picture. Once the foundation has been laid, we can proceed to topics like “Using the PHP Standard Functions”, that will make our programming live easier helping us format and process strings and dates, to manipulate arrays, create user sessions, store data in files … Then I will introduce you to the object oriented theory and how to implement it with PHP. We have already learned how to store information in server side files in the “Using the PHP Standard Functions” lesson. However for larger amounts of data it is more recommendable to use a database for this purpose. That’s why I will finally show you how to use a MySQL Database together with your PHP Scripts. There is a lot of theory to know about relational databases. I will try to explain to you only the most basic theories. That should be sufficient for small and middle sized web projects. We will learn how to administrate the database, creating users and privileges. Then we will create and manipulate tables and data rows to store and retrieve our web data via PHP.
Duration:
ca. 60 training units à 45 minutes
Target audience:
Those who want to want to gain the basic knowledge for creating a PHP generated Website
Prerequisites:
Basic computer and HTML knowledge could be helpful, this course is designed for bloody programming beginners
Introduction:
- Technical Background of dynamic Web pages
- History of PHP
Practical path of exercises for beginners:
- PHP and HTML
- Sending Data from a Web Form
- Storing Data in Variables
- Making Decisions with if-else
- Making Comparisons
- Repeating Code with while and for Loops
- Making Logical Decisions
- Storing Data in Arrays
- Defining and Calling Functions
Language basics:
- How the Preprocessor works
- Processing Form Data
- Variables and Data Types
- Constants
- Strings
- Control Structures
- Operators
- Arrays
- Functions
- PHP Variables and Visibility
- Including external PHP or HTML Code in our scripts
Using the PHP standard functions:
- Organizing Array Data
- Manipulating Strings
- Using Date and Time Functions
- Dealing with Directories and Files
- Using Sessions
PHP and object orientation:
- Classes and Objects
- Designing Class Libraries with Inheritance
- Overriding and Polymorphism
- Constructors and Destructors
- Access Control and Encapsulation
- Serializing PHP Objects
MySQL database programming:
- Basic Relational Database Concepts and Terminology
- Understanding the Architecture of MySQL Databases
- SQL Basic Commands and Syntax
- Creating and Destroying Databases and Tables
- Defining Column Types and Indexes
- Users and Privileges
- Establishing a Database Connection via PHP
- Making Database Queries
- Retrieving and Managing Query Results
