WELCOME TO PHP!
Become an CertAdda certified PHP & MySQL Professional. An online course designed to make you an expert in using PHP & MySQL and learn all that is required to create real world web applications with PHP & MySQL.
WHAT YOU SHOULD ALREADY
Before you continue you should have a basic understanding of the following:
- HTML
- CSS
- JavaScript
WHAT IS PHP?
- PHP is an acronym for “PHP: Hypertext Preprocessor”
- PHP is a widely-used, open source scripting language
- PHP scripts are executed on the server
- PHP is free to download and use
 |
PHP is an amazing and popular language!It is powerful enough to be at the core of the biggest blogging system on the web (WordPress)! It is deep enough to run the largest social network (Facebook)! It is also easy enough to be a beginner’s first server side language! |
|---|
WHAT IS A PHP FILE ?
- PHP files can contain text, HTML, CSS, JavaScript, and PHP code
- PHP code are executed on the server, and the result is returned to the browser as plain HTML
- PHP files have extension “.php”
WHAT CAN PHP DO?
- PHP can generate dynamic page content
- PHP can create, open, read, write, delete, and close files on the server
- PHP can collect form data
- PHP can send and receive cookies
- PHP can add, delete, modify data in your database
- PHP can be used to control user-access
- PHP can encrypt data
With PHP you are not limited to output HTML. You can output images, PDF files, and even Flash movies. You can also output any text, such as XHTML and XML.
WHY PHP?
- PHP runs on various platforms (Windows, Linux, Unix, Mac OS X, etc.)
- PHP is compatible with almost all servers used today (Apache, IIS, etc.)
- PHP supports a wide range of databases
- PHP is free. Download it from the official PHP resource: www.php.net
- PHP is easy to learn and runs efficiently on the server side
Now it’s time to check out of this course. Have fun!
Course Features
- Lecture 0
- Quiz 0
- Duration 30 hours
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
- 10 Sections
- 0 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- PHP Basics and Conditional LogicLearning Objectives: In this module, we will understand what PHP &MySQL is and why it is so popular. You will learn PHP basics, installation setup, data types, arrays and decision making statements. Topics: PHP introduction Environment setup in different platforms Script syntax How to declare variable and data types Constants Arrays Strings Web concepts Decision making statements Loop types Operators Annie’s Quizzes LAB Q & A Quick Recap0
- Functions and Error HandlingLearning Objectives: In this module, we will learn about the functions. Next, we will learn about how to send mails using PHP. In addition, we will learn regular expressions, predefined functions and its uses. We will also understand how to manipulate with system files, error handling and debugging. Topics: What is Functions Creating PHP functions PHP functions with parameters Argument by reference Setting default values for function parameters Dynamic function calls PHP mails How to send text mail How to send html emails How to send attachments with emails Regular expressions POSIX regular expressions Predefined character ranges Regexp POSIX functions PERL style regular expressions Regexp PERL compatible functions Date and time functions Built-in functions File inclusion File manipulations Exception handling Bugs debugging Annie’s Quizzes LAB Q & A Quick Recap0
- Object Oriented ProgrammingLearning Objectives: In this module, we will learn how to define classes, how to create object for the class and how to invoke methods and functions. Next, we will learn the object oriented functionalities like inheritance, method overriding, interfaces, constants, Access Specifiers and abstract classes. Topics: What is Object Oriented Concepts Defining classes Creating Objects Member functions Constructor and Destructor Inheritance Function overriding Access Specifiers- private, public and protected members Interfaces Constants Abstract Classes Static keyword Final keyword Calling parent constructors Annie’s Quizzes LAB Q & A Quick Recap0
- MySQL Installation and BasicsLearning Objectives: In this Module, We will discuss what is database and database terminology. Then we will see how to install MySQL in our system. We will see how to connect with MySQL. Then we will discuss about syntax, database creation and create tables inside database and database manipulations like add, edit, and delete. Topics: Database Introduction MySQL installation on various platforms MySQL connection Database creation Database Manipulations- Add, Edit, Retrieve and Delete Table creation and table manipulations- Add Edit, Retrieve and Delete Annie’s Quizzes LAB Q & A Quick Recap0
- Advance Queries and Data Manipulation using PHPLearning Objectives: In this module, we will learn advanced queries and SQL injection concepts. We will discuss about Like clause, how to sort values, how to fetch using joins, how to handle NULL values, Regular expressions, Transactions and alter command. We will also discuss Indexes of the table, temporary tables and clone tables. Then we will see duplicate tables and SQL Injection. We will learn how to retrieve and manipulate data using PHP. Topics: LIKE clause Sorting Joins Handling NULL Values Regular Expressions Transactions ALTER Command Indexes Temporary Tables Clone Tables Database Information Sequences Handling Duplicates SQL Injections Select, insert, update and delete using PHP script Annie’s Quizzes Q & A Quick Recap0
- MVC Infrastructure Basics & Introduction to CakePHPLearning Objectives: In this module we will learn the MVC terminology, advantages of MVC. We will learn how to install and configure CakePHP on top of existing PHP apache web server we will also see CakePHP folder structure and important configuration. Topics: Introduction to MVC What are Model-View-Controller Why use framework in the project (conventional vs. MVC project) Installation of CakePHP CakePHP folder structure File naming conventions Important config file (core.php, database.php) Annie’s Quizzes Q & A Quick Recap0
- CakePHP Controller, Views and LayoutLearning Objectives: In this module we will learn how to create controllers and views. We will learn how URLs are mapped to the controllers and views. We will learn how the controller and view interacts and exchanges data between them. Topics: Application flow – How Controller and view interacts/ exchanges data What are CakePHP helpers? Most commonly used helpers like Form, HTML, Session, Cookie etc Create a controller and how URLs mapped to controller and views Create views and layouts Annie’s Quizzes Q & A Quick Recap0
- Models and Database Interaction in CakePHPLearning Objectives: In this module we will learn models in detail. How to define models, use it for database access and manipulation. How to use basic SQL queries in models. Topics: Models: What are models and how they interact with database? Accessing and manipulating table data using find, save, update methods of the model Joining tables Conditions Conditions other than =(LIKE, BETWEEN,) Order by in CakePHP models Change database dynamically using the definitions in database.php config file Annie’s Quizzes Q & A Quick Recap0
- Creating Dynamic Forms using CakePHP Html HelpersLearning Objectives: In this module, we will learn about how to generate forms using CakePHP html helper, validate forms using model definitions, difference between get and post methods, cookies , uses of cookies, how to set and retrieve cookies, what is sessions, how to start and destroy sessions, automatically start sessions and use sessions without cookies, file uploading and predefined variables. Topics: Introduction to basic html form, get, post methods Generate form elements like input boxes, dropdowns, radio buttons, and links using CakePHP html helper Form validation using Model validation definitions Create, retrieve and delete cookies Create, retrieve and delete session variables File handling in CakePHP (create, delete, read files) CakePHP Global variables and their use Annie’s Quizzes Q & A Quick Recap0
- Using MVC & CakePHP to develop a websiteLearning Objectives: In this module we will see some other frameworks available in PHP like Zend, CodeIgniter, Laravel. We will see the comparison between the frameworks. We will also discuss the project details.0
