ABOUT PHP WITH MYSQL SERVER TRAINING
97% of worlds web sites are build using php, mysql, css, javascript, html including facebook , linkedin and yahoo If you search on naukri, monster or times job, you will see hundreds of jobs requiring 0 to 2 year experience for php, mysql, css skills in Bengalore.MNC's are looking for these skills but can't find enough MCAs and engineers who are trained in this.
PHP WITH MYSQL SERVER COURSE HIGHLIGHTS
PHP is a powerful language for writing server-side Web applications, while MYSQL is the popular open source database. These two applications together helps building database-driven Web applications. During this course students and professional will learn a range of advanced PHP and MySQL techniques, including sticky forms and database design, creation, and optimization.
Course Outcome-PHP WITH MYSQL SERVER
Course Outcome-MY SQL SERVER
WHO WILL BENEFIT
PHP WITH MYSQL SERVER COURSE CURRICULUM
Introduction to PHP
From c/c++ programming to PHP programming
PHP Introduction
PHP Inventions and Versions
PHP with other other technologies
Scope of PHP
PHP in LAMP Programming and Open Source Programming
How PHP work with frontend and backend
Applications which can be created using PHP
XAMPP , WAMP and MAMP server installation on operating system like
window xp , window 7 , ubuntu (linux operating system)
( IDE )Editors for writing PHP code based on operating system
- PHP History and Founder of PHP and regarding Zend Company
Other Dynamic Scripting Languages comparison ( Like ASP , PHP , JSP , Perl etc… )
Important tools and software require ( like Editors , Web Server , Database , Important libraries etc …)
Understand the importance php.ini file and httpd.conf file during apache , mysql and php installation
Understand the basic of root folder ( htdocs or www ) from php.ini file and how to tune it.
Configure Port number while running mysql and apache in php.ini file
Know the basics of Linux command to run LAMP on linux platform
Install procedure of LAMP on Windows and Linux
Run Xampp , Lamp or Mamp Software on different operating system
- PHP Arithmetic Operators
PHP Assignment Operators
PHP Incrementing/Decrementing Operators
PHP Relational (Comparison) Operators
PHP Logical Operators
PHP Array Operators
PHP Bitwise Operators
PHP Error Suppression Operator
PHP Ternary Operator
PHP Default Operator
PHP Associative Operator
PHP MOD Operator
PHP Operators
- PHP IF Condition with optional Else
PHP IF and Else with condition and example
PHP multiple IF with else condition
TRUE and FALSE test with If Condition
PHP Nested IF and Else Condition
PHP Nested IF Mod Operator
PHP IF condition with Ternary Operator
Identify Odd and Even no with IF and Else
Flow Diagram for Nested IF and simple IF condition
Alternative for Nested IF
PHP Switch case in replacement of Nested IF
Default case in Switch Case
PHP Conditional Events and Switch case
- Understand what is function
Need of Function in PHP
Advantage of Function over statements
PHP Function declaration with Example
PHP Function Calling
PHP Function with arguments
Default Arguments in Function
Types of arguments in Function
Function argument with call by value
Function argument with call by reference
Function with Return keyword
Scope of Function Global and Local
Recursive Function
Types of Function ( e.g. Static Function )
PHP Function , PHP Function with Argument
- Understand the need of Array
Difference between Array and Variables
How to define an Array and when to use
What is an index in array
How to store value in array using index
How and when to use arrays
Indexing arrays, numeric and hashes
How to intialize an Array
Print array using print_r() Function
Difference between echo and print_r() Function
Associative Operator in Array ( => )
Numeric Array in PHP
Associative Array in PHP
Mixed Array in PHP
One -Dimensional Array
PHP Array , Types of Array , Foreach Loop
- Multi-Dimensional Array
Extract Array value using index
Extract array value using count() function with While loop , For loop
What is Foreach loop in PHP ?
Extract Array using Foreach loop
Foreach loop with key and without key definition
One-dimensional arrays
Multi-dimensional arrays
PHP String Manipulation and Regular Expression
- Types of characters during user input
How to handle single quote ( ‘ ) and double quote ( ” )
String function like substr() to extract certain characters
Use of trim() function to avoid trailing spaces and leading spaces
strtolower() and strtoupper() function for string case conversion
Format output using printf() , sprintf() function
Use of addslashes() and stripslashes() function to handle sensitive characters like quotes
extract tags from given string using strip_tags() function
What is Regular expression in PHP ?
Use and advantage of regular expression over inbuilt function
^ symbol in regular expression
[ ] symbol ( types of character) in regular expression
{ } symbol ( range of character) in regular expression
- + , \ , ? and many more special characters with example in regular expression
Create a function for only alphabets validation using regular expression
Create a function for alphanumeric validation using regular expression
Create a function for only numeric validation using regular expression
Create a function for emailid validation using regular expression
Create a function for username validation using regular expression
Create a function for IP validation using regular expression
Create a function for URL validation using regular expression
Create a function for strong password validation using regular expression
and many more ….
Use of preg_match() function in regular expression
Use of preg_replace() function in regular expression
Use of preg_split() function in regular expression
PHP Global Array
- $_POST :variable is a superglobal Array that contains data from a form sent with method=”post”.Information sent from a form with the POST method is invisible ( can be changed from the post_max_size in the php.ini file ).
post_max_size in PHP
$_GET :variable is a superglobal Array that contains data from a form sent with method=”get” or from URL.Information sent from a form with the GET method will be displayed in the browser’s address bar. Have Limited data .
$_REQUEST : variable is a superglobal Array that contains the contents of both $_GET, $_POST, and $_COOKIE arrays. It can be used to collect data sent with both the GET and POST methods.
Difference Between $_POST and $_GET , $_REQUEST method
$_COOKIE is temporary stored simple files or simple data in the web site browser
How to set cookie name , cookie value , cookie expiry , cookie domain etc …
$_SESSION : As associative superglobal Array. This is where you both store and retrieve session data.
$_SERVER :superglobal array defined in PHP and it stores information about your server and execution environment information.
$_SERVER variables : PHP_SELF, REQUEST_METHOD, REQUEST_TIME , DOCUMENT_ROOT , HTTP_HOST ,HTTP_REFERER, HTTP_USER_AGENT, REMOTE_ADDR, SCRIPT_FILENAME, SERVER_ADDR, SERVER_NAME, SERVER_PROTOCOL SERVER_PORT, REQUEST_URI and more ……
$_FILES : superglobal PHP array $_FILES to upload files from a client computer to the remote server.
1. $_FILES[“name”] -Filename which is to be upload
2. $_FILES[“type”] – mime type of uploaded file
3. $_FILES[“size”] -size of uploaded file in bytes
4. $_FILES[“tmp_name”] -temporary buffer path to hold current file
5. $_FILES[“error”] – the error code resulting from the file upload
Importance of post method in html , enctype attribute with multipart/form-data during file upload
Types of error in file uploading : UPLOAD_ERR_OK, UPLOAD_ERR_INI_SIZE, UPLOAD_ERR_FORM_SIZE, UPLOAD_ERR_PARTIAL,UPLOAD_ERR_NO , TMP_DIR, UPLOAD_ERR_CANT_WRITE ,UPLOAD_ERR_EXTENSION
PHP Session and COOKIE in Depth
- What is a session and why it is required?
Understand the basics of session with browser example
Intialization of session with session_start() function
Understand session_id() with practical example
Usage of session variable with $_SESSION global array
Check availability of session variable with isset() function
Understand session temporary directory in php.ini file
Understand session max_life_time with php.ini file
PHP session_regenerate_id() for login and logout system
PHP session_destroy() function
PHP unset() function to remove data from session variables
- Retrieving PHP SESSION variable data
Register and modify PHP session variables
Putting PHP session IDs in pages
Good Practise with sessions and PHP
Understand the difference between session and cookie
cookie as local variable
Initialization of cookie variable
setcookie() function with different properties
Cookie properties
Setting a cookie in PHP
Retrieving PHP cookies
Expiring/Deleting PHP cookies
Drawbacks to cookies
Cookie Security Issues
- Overall knowledge on inbuilt important libraries in PHP:
php gd library
php zip library
php curl library
php mysql library
php mysqli ( improved version ) library
php PEAR library
php pdo library and more…
Types of programming with different architectures:
Advantage and functionalty of the architecture
PHP : procedure oriented programming
PHP : Object Oriented programming
PHP : MVC Architecture (3-tier architecture)
Other architecture like : SOAP , REST etc…
PHP and list of libraries supported in Lamp Programming
- What is Class in PHP
Define Class and Initialization of class
Create an object of class
PHP accesss specifier : private , protected and public in OOPS
Inbuilt Object in PHP Class ( $this object )
Accessor in PHP OOPS
PHP OOPS Polymorphism
Encapsulation in PHP Object Oriented programming
__construct() function ( i.e. constructor in OOPS )
__destruct() function ( i.e destructor in OOPS )
Final class in OOPS
Abstract class in OOPS
PHP5 inheritance
PHP OOPS Multilevel Inheritance
__autoload() in PHP OOPS
__sleep() function in PHP OOPS
__wakeup() function in PHP OOPS
Scope resolution Operator ( :: ) in PHP
Parent Keyword in PHP OOPS
Self Keyword in PHP OOPS
This Keyword in PHP OOPS
PHP OOPS Inbuilt properties and methods in
PHP Object Oriented Programming in Depth
PHP string Inbuilt function
- addcslashes
addslashes
chop
chr
chunk_split
echo
explode
html_entity_decode
htmlentities
htmlspecialchars_decode
htmlspecialchars
implode
lcfirst
ltrim
md5
nl2br
number_format
ord
print
- printf
rtrim
setlocale
sha1
similar_text
soundex
str_ireplace
str_pad
str_repeat
str_replace
str_split
str_word_count
strcasecmp
strchr
strcmp
strip_tags
stripos
stripslashes
- stristr
strlen
strncmp
strpos
strrchr
strstr
strtolower
strtoupper
strtr
substr_compare
substr_count
substr_replace
substr
trim
ucfirst
ucwords
wordwrap
PHP Array Inbuilt function
- array_change_key_case
array_chunk
array_combine
array_count_values
array_diff_assoc
array_diff_key
array_diff_uassoc
array_diff_ukey
array_diff
array_fill_keys
array_fill
array_filter
array_flip
array_intersect
array_key_exists
array_keys
array_map
array_merge_recursive
array_merge
array_pad
array_pop
array_product
- array_push
array_rand
array_replace
array_reverse
array_search
array_shift
array_slice
array_splice
array_sum
array_udiff_assoc
array_udiff_uassoc
array_udiff
array_uintersect_assoc
array_uintersect_uassoc
array_uintersect
array_unique
array_unshift
array_values
array_walk
arrayasort
count
- current
each
end
extract
in_array
key
krsort
ksort
list
next
pos
prev
range
reset
rsort
shuffle
sizeof
sort
uasort
uksort
usort
- basename
chgrp
chmod
chown
clearstatcache
copy
delete
dirname
fclose
feof
fflush
file_exists
file_get_contents
file_put_contents
file
filesize
filetypefopen
fputs
freadfwrite
is_dir
is_executable
is_file
is_link
is_readable
is_uploaded_file
is_writable
is_writeablelink
mkdir
move_uploaded_file
pathinforenamermdir
umask
unlink
PHP Filesystem Inbuilt function
- gd_info
getimagesize
getimagesizefromstring
image_type_to_extension
image_ type_ to_ mime_ type
imagecolorallocate
imagecopy
imagecopyresampled
imagecopyresized
imagecreate
imagecreatetruecolor
imagedestroy
imagefill
imagefilter
imagefontheight
imagefontwidth
imagefttext
imagegd2
imagegd
imagegif
imagejpeg
imageline
imageloadfont
imagepng
imagerectangle
imagerotate
imagesetbrush
imagesetpixel
imagestring
imagesx
imagesy
imagettftext
imagetypes
PHP GD Library and Image Functions
- abs
round
round with decimal
ceil
floor
power
rand
pi
pow
min
max
sqrt
is_nan
PHP Session functions
- session_start
session_id
session_destroy
session_regenerate_id
session_register
session_unregister
session_unset
session_is_register
session_encode
session_decode
session_status
PHP Math functions
- define
die
exit
eval
constant
php_check_syntax
php_strip_whitespace
urlencode
urldecode
parse_url
preg_match
preg_replace
empty
floatval
gettype
is_array
is_bool
is_double
is_float
is_int
- is_integer
is_ long
is_null
is_numeric
is_object
is_real
is_resource
is_scalar
is_string
isset
print_r
serialize
settype
strval
unserialize
unset
var_dump
var_export
Some Miscellaneous PHP functions
- short_open_tag
output_buffering
max_execution_time
memory_limit
error_reporting
display_errors
error_log
register_globals
post_max_size
extension_dir
file_uploads
upload_tmp_dir
upload_max_filesize
max_file_uploads
extension
date.timezone
mysql.default_port
session.save_path
session.name
session.gc_maxlifetime
Important parameter of php.ini
MySQL Training Syllabus
- Client/Server Concepts
Database and Database Objects
2. Data Definition using SQL Databases
Data Types
Tables
Constraints and Indexes
Views
1. Theory, Terminology and Concepts
- Recurring SQL Constructs
Adding data
Modifying data
Removing data
Searching data
3. Basic Data Manipulation using SQL
- Expressions
Grouping and Aggregate Functions
Joining Tables
5. Data Definition using SQL Transaction Concepts
SQL for working with Transaction
4. Advanced Data Manipulation using SQL
- Tools for Import/Export
SQL for Import/Export
6. Basic Data Manipulation using SQL