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

Course Duration

2 Months

Learners

50000

Delivery Mode

Classroom Training

Apply Online

Click Now

WHO WILL BENEFIT

Students perusing a Career in Web Technologies
Web designers
Online Content Managers
E-Publishers
Entrepreneurs

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
Feature Image

    PHP Operators

  • 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 Conditional Events and Switch case
  • 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 Function , PHP Function with Argument
  • 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 Array , Types of Array , Foreach Loop
  • 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
  •  
  •  
  •  
  • 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
Feature Image
Feature Image
    PHP and list of libraries supported in Lamp Programming
  • 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 Object Oriented Programming in Depth
  • 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 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
    PHP Filesystem Inbuilt function
  • 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 GD Library and Image Functions
  • 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 Math 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
    Some Miscellaneous PHP 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
    Important parameter of php.ini
  • 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

MySQL Training Syllabus

    1. Theory, Terminology and Concepts
  • Client/Server Concepts
  • Database and Database Objects
    2. Data Definition using SQL
  • Databases
  • Data Types
  • Tables
  • Constraints and Indexes
  • Views
    3. Basic Data Manipulation using SQL
  • Recurring SQL Constructs
  • Adding data
  • Modifying data
  • Removing data
  • Searching data
Feature Image
Feature Image
    4. Advanced Data Manipulation using SQL
  • Expressions
  • Grouping and Aggregate Functions
  • Joining Tables
    5. Data Definition using SQL
  • Transaction Concepts
  • SQL for working with Transaction
    6. Basic Data Manipulation using SQL
  • Tools for Import/Export
  • SQL for Import/Export