PHP and MySQL

Sinet has well experienced academic team to deliver Web Server programming technologies..



COURSE DETAILS

Duration: 60 hours *

Class: Regular / Week ends / Evening / Sundays

Daily Time: 1.5 hours / 3 hours / half day / Full day

Certification: Sinet Merit Certification

JOIN NOW
* Sinet course can be customized as per student requirement.

JOB PROFILE

Web Application Developer

PHP Programmer

Responsive Web Designer

mySQL Data Manager




PHP MySQL COURSE CONTENTS

( Can be customized )



1. Introduction to PHP

History, Features and characteristics, Alternatives(Jsp,Asp,Asp.net), Client side technologies(Applet, JavaScript, VBScript), Server side scripting, What is server side scripting good, WAMP server, configure WAMP server, Access applications

2. Sample program in PHP

Canonical PHP tag, Sample program, Comments in PHP code

3. built-in methods in PHP

echo(), isset(), unset(), getType(), var_dump(), header(), Include() and Requir()

4. Tokens in PHP

Tokens: Keyword, Identifiers, Literals, punctuators, operators. Supporting Datatypes

5. Variable Types in PHP

Variable Naming, PHP is case sensitive, Local variables, global varaiable,static variable, Different Errors.

6. CONSTANTS in PHP

constant(), Differences between constants and variables

7. OPERATOR TYPES in PHP

Different type operators, Arithmetic Operators, Comparison Operators, Logical Operators, Assignment Operators, Conditional Operator

8. Selection Control Statements

Decision Making-if, if….else, nested if, else if…laddrer

9. Selection Control Statements in PHP

Decision Making switch…case, Conditional operators

10. Loops in PHP

While loop, do….while loop, for loop

11. Loops in PHP

Nested loops, break & continue statement.

12. Arrays

Creating arrays, Access array elements using index/key. Two type arrays Single dimensional, Multidimensional arrays

13. Arrays in PHP

Array functions, Foreach loop

14. Functions in PHP

Define functions, function calling, type of functions, function category, string and mathematical functions.

15. OOP Concept in PHP

What is OOP, Class, Object, and Encapsulation.

16. Object Oriented Programing in PHP

Polymorphism, Inheritance, Interface, Abstract class.

17. Super global array in PHP

POST, GET, REQUEST, SESSION, COOKIE, SERVER, FILES

18. File handling in PHP

File operations, Open file, close file, Read and write functions-fgetc(), fgets(), fread(), fwrite(). Random access using fseek(). ftell(), rewind().

19. XMLin PHP

Xml file read/ write . DOMDocument(), createElement(), appendChild(), createTextNode(), save()

20. Regular expressions in PHP in PHP

POSIX expression- preg_match(),preg_match_all(), preg_replace(), preg_split(), preg_grep(), preg_quote()

21. MYSQL in PHP

What is a database .Choosing a database (RDBMS), GUI(DB Creation, Table creation, Privilege, Import, Export) Foreign key and Integrity constraints. SQL commands-Select ,Insert, Update, Delete

22. connecting to MYSQL in PHP

Connecting mysql database with PHP. Function for connecting Database-mysqli_connect(), mysqli_select_db().Making MySQL Queries using –mysqli_query(), Fetching Data Set-mysqli_fetch_row(), mysqli_fetch_array(), mysqli_fetch_assoc(),mysqli_fetch_object().

23. Login Form in PHP

Login using database table.

24. CRUD in PHP (1)

CRUD Create, Read data from database.

25. CRUD in PHP (2)

CRUD Update, Delete from database

26. Read and Write image in PHP

Insert image file to database and read image from database.

27. upload file in PHP

Upload image to folder using move_uploaded_file(), write filename to database and display image

28. email in PHP

Configure PHP extensions and apache module .Send email using smtp and PHPmailer class.

29. project design in PHP

Create web application- Design page using html, css, bootstrap, jquery

30. Project design in PHP

Create web application Design page using html, css, bootstrap, jquery

31. Project Coding in PHP (1)

Create web Application use PHP and MYSQL

32.Project Coding in PHP (2)

Create web Application use PHP and MYSQL

33.Project Coding in PHP (3)

Create web Application use PHP and MYSQL

34. Project Coding in PHP (4)

Create web Application use PHP and MYSQL

35.Project Coding in PHP (5)

Create web Application-use PHP and MYSQL




SINET IS AN ISO 9001 : 2015 CERTIFIED SOFTWARE TRAINING INSTITUTE

(Division of Sinet Education)

www.sinetedu.com