Learn PHP & MySQL

PHP is the most popular server-side language used to build dynamic websites, and it is a very extensive language. Learn PHP & MySQL web development from understanding PHP functions and create your very own applications & projects using PHP & MySQL. The stateless web (HTML, CSS and JavaScript) can only do so much without a dynamic language such as PHP to add the ability to interact with the web server. Students will learn how to make pages dynamic based upon user interaction, interact with HTML forms and store and retrieve information from local data sources which include a database. During the course, students will walk through the development of a complete content management system Web application. They will receive clear, step-by-step, instructions demonstrating how to create a complete Web site capable of dynamically displaying data from a MySQL


Pre-Requisite

There is no previous knowledge required for this course.

Course Contents

1Introduction
Introduction to Web, Web applications
Introduction to Database and its types
Introduction languages, scripting languages
2Purpose of PHP MySQL
Why use PHP and MySQL?
The PHP programming environment
Overview of SQL
3Setting up the Environment
Decisions about a testing environment WAMP/MAMP/XAMPP
Installing Apache, PHP and MySQL on your computer
Testing on a remote Server
Deciding on Development tools
Using PHP MyAdmin
4Overview of PHP
Setting up a PHP page
The phpinfo() function
Learning basic syntax
Echoing HTML output to the browser
The importance of comments
Using single and double quotes/ Comments
5Variables in PHP
Using loose typed variables
Assigning variables
Overview of numeric, string and other types
Assigning a variable to itself
6Global Variables & Data Types
Global Variables in PHP
Data Types in PHP.
Types casting
7Super Global Variables in Php
$GLOBLAS
$SERVER
$_POST
$_GET
$_POST
8Php Operators
Arithmetic operators Logical operators
Comparisons
Operator precedence
9Numbers in PHP
Making calculations
Using built-in numeric functions
Incrementing and decrementing
10Introduction to Strings and its function
Concatenating strings
Trimming strings
Removing slashes and other harmful characters
String functions
11Introduction to Arrays and multidimensional Arrays
Numerically Indexed Array
Associative Arrays Sorting Arrays
Recording Arrays
12Control structures in PHP
The If statement
FOR loops
While loops
The Switch
13Transferring information between PHP pages
GET and POST
Different form field types
Self-referencing forms
Form handlers
14Database fundamentals/Databases with Php
Structuring a database
Using tables
Table relationships
Common data types
15Creating a database
Using PHP my Admin
Adding a table
Populating a table with types and data
Browsing a table
16Getting PHP to connect to MySQL
Using the MySQL connect () function
Using the mysql select_db () function
Testing a connection
Writing a sample error trap
17Querying MySQL using PHP/ Retrieving from database
Writing SQL queries
Using Select, Insert, Update and Delete
Querying MySQL and returning results
Interpreting the returned array
18Introduction to Cookies & Sessions in PHP
Differences
How sessions are more secure than cookie
Session needs extra spaces , unlike cookie
Session start ()
Creating cookies
19Project/ Building a Web Application
Creating pages to:
Add entries
Modify entries
List entries
Filter entries

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *