برنامه سازی و برنامه نویسی یکی از تخصص های مطرح در صنعت فناوری اطلاعات در ایران و خارج از کشور محسوب می شود و زبان برنامه سازی PHP یکی از پرکاربرد ترین زبانهای برنامه سازی برای وب سایتهای دینامیک است. به گزارش سایت NetCraft حدود ۲۴۴ میلیون سایت اینترنتی از PHP استفاده می کنند در حالیکه به گزارش w3techs، حدود ۸۰ درصد سایتهای دینامیک از زبان PHP استفاده کرده اند. دوره برنامه نویسی PHP و MySQL یا LAMP توسط فناوران آنیسا ارایه می شود.

محتوا:  برنامه نویسی به زبان PHP، کار با بانک اطلاعاتی MySQL، نصب و پیکربندی Apache و مدیریت آنها در لینوکس.

هدف:  هدف این دوره آماده سازی فرد برای برنامه نویسی وب به زبان PHP و ارتباط آن با MySQL در محیط Apache و لینوکس است.

مدت دوره: معمولا ۴۸ ساعت.

پیش نیاز: برای شرکت در این دوره تنها به دانش مطرح در سطح لینوکس مقدماتی و ترجیحا دورهLPIC1  و همچنین درک زبان HTML به صورت مقدماتی است.

مدرس:  متخصص سیستم عامل Gnu/Linux و برنامه نویسی تحت وب

 

 مباحث دوره مقدماتی به اختصار شامل موارد زیر است:

Introduction

What is Linux? (Linux Basic)

What is Apache? (Apache Basic)

What is MySQL? (Essential Training)

What is PHP? (Essential Training)

 

PHP Essential

 

Checking Your Setup

Running phpinfo() to check the PHP configuration

Changing configuration settings in php.ini

Alternative ways to change configuration settings

 

PHP Basics

PHP: The big picture

Choosing and naming variables

Displaying text and numbers

Comments and white space

What's the difference between single and double quotes?

Joining strings

Using heredoc syntax to avoid problems with quotes

Storing multiple values in an indexed array

Storing values in an associative array

Challenge: Embedding PHP in HTML

Solution: Embedding PHP in HTML

 

Making Decisions with Conditional Statements

The truth according to PHP

Making decisions with conditions and comparisons

Alternative syntax for conditional statements

Making decisions with a switch statement

Using the ternary operator as shorthand

Setting a default value

Challenge: Serving different content to members

Solution: Serving different content to members

 

Doing Calculations with PHP

Arithmetic operators

Reassigning the result of a calculation to the same variable

Increasing or decreasing a number by one

Challenge: Integer division

Solution: Integer division

 

Using Loops for Repetitive Actions

Repeating actions with while and do/while loops

Using a for loop

Looping through an array with foreach

Alternative syntax for loops

Challenge: Multiplication table

Solution: Multiplication table

 

Using Functions and Objects

Using PHP's built-in functions

Understanding PHP documentation

Creating custom functions

Passing arguments by value and reference to a function

Using an anonymous function as a callback

Understanding PHP objects and classes

Comparing the date() function with the DateTime class

Challenge: Create a function to display copyright years

Solution: Create a function to display copyright years

 

Including External Files

Using server-side includes

Using include and require

Using links in an include file

Examining the include_path

Challenge: Use server-side includes for common features

Solution: Use server-side includes for common features

 

Emailing the Contents of an Online Form

Understanding the difference between POST and GET

Displaying error messages conditionally

Making sure required fields aren't blank

Preserving user input when a form is incomplete

Blocking suspect phrases

Preparing to send email

Automating the reply address

Building the message body

Sending the email

Troubleshooting mail()

 

My SQL Essential

 

Introduction

 

Installing and Configuring the Test Environment

Installation overview

Installing XAMPP on Windows

Installing XAMPP on the Mac

Setting up MySQL users

Installing SID on Windows

Installing SID on the Mac

Installing time zone support in MySQL on Windows

 

Basic Syntax

The SELECT statement

Selecting rows

Selecting columns

Sorting results with ORDER BY

Filtering results with WHERE

Filtering results with LIKE and IN

Filtering results with regular expressions

Inserting rows

Updating rows

Deleting rows

Literal strings

Understanding NULL

 

Creating a Database

Creating a database

Creating a table

Creating indexes

Controlling column behavior with constraints

Creating an ID column

Using foreign key constraints

Altering a table

 

MySQL Data Types

What are data types?

Numeric types

String types

Date and time types

Bit type

Boolean values

Enumeration types

 

MySQL Functions

String functions

Numeric functions

Date and time functions

Time zones in MySQL

Formatting dates

Aggregate functions

Flow control with CASE

 

Transactions

Maintaining database integrity with transactions

Using transactions for performance

 

Triggers

Updating a table with a trigger

Preventing automatic updates with a trigger

Logging transactions with a trigger

 

Subselects and Views

Creating a simple subselect

Searching within a result set

Creating a view

Creating a joined view

 

Stored Routines

Understanding MySQL stored routines

Creating a stored function

Creating a stored procedure

 

PHP's PDO Interface with MySQL

The multi-platform PDO interface

Executing the SQL

Implementing auto-increment IDs

Using a stored function