Our Latest Offers

Core PHP and MySQL Training


About Core PHP and MySQL

PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. PHP is now installed on more than 244 million websites and 2.1 million web servers. Originally created by Rasmus Lerdorf in 1995, the reference implementation of PHP is now produced by The PHP Group. While PHP originally stood for Personal Home Page, it now stands for PHP: Hypertext Preprocessor, a recursive backronym. PHP code is interpreted by a web server with a PHP processor module, which generates the resulting web page: PHP commands can be embedded directly into an HTML source document rather than calling an external file to process data. It has also evolved to include a command-line interface capability and can be used in standalone graphical applications. PHP is free software released under the PHP License, which is incompatible with the GNU General Public License (GPL) due to restrictions on the usage of the term PHP. PHP can be deployed on most web servers and also as a standalone shell on almost every operating system and platform, free of charge. MySQL officially, but also called is (as of July 2013) the world's second most widely used open-source relational database management system (RDBMS). It is named after co-founder Michael Widenius's daughter, My. The SQL phrase stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured database management system often use MySQL. For commercial use, several paid editions are available, and offer additional functionality. Applications which use MySQL databases include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile, large-scale websites, including Wikipedia, Google (though not for searches), Facebook, Twitter, Flickr and YouTube.

Before you continue, you should have a basic understanding of the following:

1. Basic Knowledge of HTML and CSS.
2. Knowledge of javascript
3. Knowledge of C languages
4. Knowledge of object oriented languages(C#, C++ etc)

Benefits of Courses:

1. Website Developer
2. Web Services Developer
3. Web Application Developer

Projects

1. We will provide real time project training with code explanation and implementation.
2. Our training modules are completely designed according to current IT market.
3. After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
4. Student will go through the training of HTML, CSS and JavaScript as a complimentary package before starting of SQL Server.
5. We offer regular, fast track and weekend training in SQL Server course.
6. Study material is provided with the course which consist of concepts, examples and real time examples.

Core PHP MySql Overview Use of Dreamweaver
1. How PHP Works 1. MySql Methods and Properties 1. Using Dreamweaver to automatically generate a form for updating the record
2. The php.ini File 2. Inserting and Updating Records 2. Validating the edited information using JavaScript behaviors
3. Basic PHP Syntax 3. MySql Prepared Statements 3. Building a confirmation page to display the result of updating the record
4. PHP Tags 4. Authentication with PHP and MYSQL 4. Deleting records
5. PHP Statements and Whitespace 5. A Database-less Login Form 5. Precautions to take to ensure that records are not inadvertently deleted
6. Comments 6. Session Control and Cookies 6. Building an appropriate record deletion interface, complete with confirmation dialog
7. PHP Functions 7. Sessions 7. Implementing user login/logout with Dreamweaver
8. Variables 8. Configuring Sessions 8. Overview of Web application security issues
9. Variable Types 9. Session Functions 9. Preferred approach: configuring the Web server to manage security
10. Variable Names (Identifiers) 10. Cookies 10. Alternative approach: having Dreamweaver automatically generate code for logging users in, authenticating them, and logging them out
11. Type Strength 11. Sending Email with PHP 11. In-depth instruction on using Dreamweaver with PHP to implement user login/logout and page-by-page authentication.
12. Variable Scope 12. mail()

AJAX

13. Constants 13. Shortcomings of mail() 1. Ajax with PHP
14. Variable-Testing and Manipulation Functions 14. PHPMailer 2. Ajax Overview
15. PHP Operators 15. File System Management 3. Ajax Technology Stack
16. Creating Dynamic Pages 16. Opening a File 4. Ajax Implementations
17. Single Quotes vs. Double Quotes 17. fopen() 5. Installing and configuring HTML_Ajax Pear Module
18. Flow Control 18. Reading from a File 6. Ajax Server
19. Conditional Processing 19. fgets() 7. Ajax Client
20. If Conditions 20. Writing to a File

JQUERY

21. Loops 21. fwrite() 1. What Are Javascript And Jquery?
22. while 22. File Locking 2. Document Object Model (DOM) And Jquery
23. do...while 23. flock() 3. Document Object Model (DOM) And Jquery
24. for 24. Uploading Files via an HTML Form 4. Programming/Coding Principles
25. break and continue 25. Getting File Information 5. Separation Of Structure (HTML), Style (CSS) A
26. Arrays 26. More File Functions 6. Behaviors (Javscript/Jquery)
27. Enumerated Arrays 27. Directory Functions 7. Jquery Wrapper – DOM Elements As Array - $( )
28. Initializing Arrays 28. Getting a Directory Listing 8. Selecting And Manipulating Elements
29. Appending to an Array 29. Getting a File Listing 9. Jquery API
30. Reading from Arrays 30. Database connections 10. Element Properties And Attributes
31. Looping through Arrays 31. Database basics 11. Browser Event Model
32. Associative Arrays 32. Introduction to MYSQL 12. Jquery Event Model
33. Initializing Associative Arrays 33. Server behaviors 13. Putting Events To Work
34. Reading from Associative Arrays 34. Querying the database 14. Animation And Effects Overview
35. Looping through Associative Arrays 35. Building a MYSQL query using the Simple view 15. Sliders, Tabs, Accordians
36. Two-dimensional Arrays 36. Building a MYSQL query using the Advanced view 16. Progress Bars
37. Reading from Two-dimensional Arrays 37. Adding fields from the resulting records to your page 17. Forms/Auto Completers
38. Looping through Two-dimensional Arrays 38. Displaying and formatting query results 18. Date Pickers
39. Array Manipulation Functions 39. Using Repeat Region to display multiple records 19. Dialog Boxes
40. PHP and HTML Forms 40. Formatting results  
41. HTML Forms 41. Paging through records  
42. How HTML Forms Work 42. Schemes for record set navigation  
43. A Sample HTML Form 43. Paging to first, last, previous, and next records  
44. Form Variables 44. Show region if...  
45. String Manipulation 45. Selectively displaying information based on a conditional  
46. Formatting Strings 46. Disabling the first and previous record links if the first page of results is displayed  
47. Concatenation 47. Disabling the last and next record links if the last page of results is displayed  
48. String Manipulation Functions 48. Displaying the count of the number of records returned  
49. Examples of String Functions 49. Creating master-detail views  
50. Magic Quotes 50. Overview of the importance of master-detail views and how they convey information  
51. magic_quotes_gpc 51. Creating a master-detail view  
52. magic_quotes_runtime 52. Advanced record sets and multi-table queries  
53. Recommendation on Magic Quotes 53. Method 1 - Simple record set with filter  
54. Reusing Code and Writing Functions 54. Method 2 - Advanced record set  
55. Including Files 55. Method 3 - Advanced record set and multi-table Queries  
56. Require 56. Dynamically populating forms  
57. require_once 57. Populating text fields, text areas, and hidden fields  
58. auto_prepend_file and auto_append_file 58. Populating selection lists, radio button lists, and checkboxes  
59. User Functions 59. Building record insertion forms  
60. Defining and Calling Functions 60. Building the insertion form by hand  
61. Default Values 61. Allowing Dreamweaver to generate the record insertion form automatically  
62. Variable Scope 62. Creating a page that confirms the record insertion  
63. By Reference vs. By Value 63. Validating form entries using JavaScript behaviors  
64. Form Processing 64. Understanding stored procedures  
65. Code Organization 65. How they are created in the database  
66. Simple SELECTs 66. Advantages/disadvantages of stored procedures versus MYSQL  
67. Introduction to the Northwind Database 67. Calling a stored procedure without passing parameters  
68. Some Basics 68. Passing input parameters to a stored procedure  
69. Comments 69. Manually constructing a form that allows the user to update a record  
70. Whitespace and Semi-colons 70. Retrieving parameters from a stored procedure  
71. Case Sensitivity 71. Updating records  
72. Selecting All Columns in All Rows    
73. Selecting Specific Columns    
74. Sorting Records    
75. Sorting By a Single Column    
76. Sorting By Multiple Columns    
77. Sorting By Column Position    
78. Ascending and Descending Sorts    
79. The WHERE Clause and Operator Symbols    
80. Checking for Equality    
81. Checking for Inequality    
82. Checking for Greater or Less Than    
83. Checking for NULL    
84. WHERE and ORDER BY    
85. The WHERE Clause and Operator Words    
86. The BETWEEN Operator    
87. The IN Operator    
88. The LIKE Operator    
89. The NOT Operator    
90. Checking Multiple Conditions    
91. AND    
92. OR    
93. Order of Evaluation    
94. Sub queries, Joins and Unions    
95. Sub queries    
96. Joins    
97. Table Aliases    
98. Multi-table Joins    
99. Outer Joins    
100. Unions    
101. UNION ALL    
102. UNION Rules    
103. Inserting, Updating and Deleting Records    
104. INSERT    
105. UPDATE    
106. DELETE    
107. Managing Data    
108. Querying a Database