PHP is an free, server-side web-scripting terminology that is appropriate with all the significant web hosts (most especially Apache) and data resource.
By the help of PHP value you can create energetic website content. Dynamic Web websites are versatile applications than merely websites.
If you know HTML, but you have no experience of selection, you can easily understand PHP and MySQL with the help of this course.
This course begins from the most easy, detailing the features of the PHP terminology, and then move on to details how to create PHP applications, how to fill the PHP applications, and to one more strategy more complicated items, such as SQL orders, utilizing MySQL data resource, using sessions and OOP (Object Focused Programming) in PHP.
The training protected in this course strategy in an easy and user-friendly style with several illustrations that create it simpler and more comprehension to understand PHP.
Lessons index
PHP Primary (beginner)
1. Composing PHP scripts
- Composing PHP applications, understand about PHP value framework, how to compose and perform a easy PHP program and to add feedback within your value.
2. Factors and Information Types
- Find out about Factors, principles and Information Kinds in PHP: boolean, integer, flow, sequence, range, item, Source, zero.
3. Statistics and statistical 0perators
- Presenting Statistics and statistical 0perators, some PHP features for more complicated features with numbers.
4. PHP Strings
- Operating with publish, using easy and increase quotations, getting out of quotations and other character types, concatenating publish, some features for publish.
5. Constants
- Presenting Always the same, format for interpreting constants, variations between aspects and identified constants.
6. Superglobal $_SERVER Array
- Get information such as headers, routes, and program destinations by using components from Superglobal $_SERVER Array.
7. PHP Mistake Managing and Debugging
- PHP MySQL course - Mistake Managing, debugging and lead to mistakes and how to modify the level of error confirming, handling exclusions.
8. If ... Else conditionals, Evaluation and Sensible operators
- Make PHP program takes selections with If, Else, Elseif depending claims. Evaluate two principles with Evaluation and Sensible employees. The ternary owner.
9. Using HTML Forms
- Using HTML Kinds, PHP type handling, get data sent from type job areas through GET and POST method, type approval.
10. $_GET, $_POST and $_REQUEST Variables
- How to deliver data with get and publish techniques to a PHP program and access it with superglobal $_GET, $_POST and $_REQUEST aspects.
11. Move ... Situation ...
- PHP MySQL course - Move ... Situation ... depending declaration, switch with crack and standard guidelines.
12. While Loops
- Using While and Do Wile Circles. End the While loops with the crack teaching. Format and illustrations.
13. For and Foreach Loops
- Using for() and foreach() Circles. End the "For" loops with the crack teaching. Format and illustrations.
14. PHP Arrays
- Developing Number (indexed) Arrays and Associative arrays. Opening, enhancing and traveling range components.
15. Multidimensional arrays and range functions
- Developing and utilizing multidimensional arrays, some range features, traveling and searching multidimensional range components.
16. PHP functions
- Developing and using your own features with or without guidelines, getting in touch with features, the come back declaration, recursive features.
17. Functions, Diverse opportunity and Moving past by Reference
- Diverse opportunity and Functions. Using GLOBAL and STATIC factors, passing factors by Referrals.
PHP Advanced
18. Include and Require
- Insert the content of external files into a PHP file with Include and Require functions, include_once, require_once.
19. File Handling with fopen
- File Handling with fopen(), create new file, write and read text file content with fopen(), fwrite(), fread() and fgets() functions. Moving the internal pointer, rewind() and fseek().
20. File Upload
- This lesson shows how to upload files on the server, with PHP and an HTML form. Uploading files script.
21. Exploring Folders
- Exploring the Folder system, creating folders with PHP, reading a directory content. Get information about a file path.
22. Cookies
- Setting and accesing cookies with PHP, retrieve a Cookie value, deleting cookies.
23. Sessions
- Setting and handling Session variables. Accessing and deleting session, destroy sessions. Store encrypted data in sessions.
24. RegExp - Frequent Expressions
- RegExp styles - Frequent Movement. Illustrations with preg_match, preg_match_all, and preg_replace features for sequence corresponding and sequence changing functions.
25. Period and Time
- Period and Time features, manage date and time details, UNIX timestamp, set and get time principles.
26. DateTime and DateTimeZone classes
- Handle date and time details with PHP DateTime and DateTimeZone sessions and things, totally recast /change Timezone, get the change between two times.
27. Submitting E-mails
- Submitting E-mails, mail() operate. Make a e-mail contact page program, examine e-mail deal with, narrow feedback e-mail data, and add the "From", "Conten-Type" (utf-8), and "Reply-To" headers in the e-mail.
PHP MySQL
28. PHP MySQL Introduction, Data Types
- PHP MySQL Introduction, database structure, tables. MySQL naming rules, and column's data types.
29. PHP MySQL - using MySQLi
- Using MySQLi object-oriented (MySQL Improved) to connect to MySQL server. Perform SQL queries to create a database and tables.
30. PHP MySQL - INSERT INTO
- Insert data in MySQL table with MySQLi object, INSERT INTO query. Get the auto ID from the last INSERT query with insert_id() method. Insert data from a form into a database.
31. PHP MySQL - SELECT, ORDER BY
- Retrieve and display data from a MySQL table, SELECT SQL command. Determine the number of records to return with the LIMIT option. Sort query results with ORDER BY clause (ASC and DESC).
32. PHP MySQL - WHERE and LIKE
- Selecting specific data from a database with the WHERE clause and Conditionals. Check for string matching with LIKE and NOT LIKE terms.
33. PHP MySQL - UPDATE
- UPDATE query to edit / change existing records in MySQL table.
34. PHP MySQL - DELETE
- The DELETE statement, used to entirely remove records from a database table.
35. MySQL Aliases and Functions
- Using MySQL Aliases and functions, text, numeric / mathematical, and date and time functions.
PHP PDO - MySQL
36. PHP PDO - Introduction and Connecting to Databases
- Introduction to PHP PDO, Connecting to various databases, MySQL, PostgreSQL, SQLite, Firebird, MS-Access.
37. PHP PDO - exec (INSERT, UPDATE, DELETE) MySQL
- Using the exec() method to perform MySQL query, INSERT, UPDATE, DELETE.
38. PHP PDO - Select query, fetch
- Select data in a MySQL table using the PDO query method, and FETCH constants.
39. PHP PDO - prepare and execute
- How to use the prepare() and execute() methods to perform SQL queries, bindParam, and bindValue.
40. PHP PDO - setAttribute, beginTransaction and commit
- setAttribute(), beginTransaction(), and commit(). Determine how to handle the errors, and execute multiple different SQL queries.
OOP - Sessions and Objects
41. OOP - Developing Sessions and Objects
- OOP (object-oriented programming), creating classes and things. Establishing qualities and techniques in a category, with community, personal or secured feature. Instantiate an item of a category.
42. OOP - Constructor Method
- Developing classes with a Constructor Strategy, __construct(). Establishing optionally available guidelines in a constructor method.
43. PHP OOP - Accessor and Destructor methods
- How to use Accessor techniques to set and get home principles, interpreting Destructor techniques. PHP features for verifying information kind.
44. OOP - Always the same, Fixed Properties and Methods
- Defining and opening category Always the same, Fixed Properties and Fixed Methods.
45. OOP - Monetary gift, category extends
- Monetary gift, understand how to give a category, make subclasses (child classes) that acquire all of the community and secured techniques from a parent or gaurdian or guardian category. Overriding techniques.
46. OOP - Ultimate Sessions and Methods
- OOP - Ultimate Sessions and Methods, how to make a category that cannot be prolonged, and techniques that cannot be overridden.
47. Miracle Methods __get, __set, __call, __toString
- About Miracle (or interceptor) Methods and their application in classes, __get, __set, __call, __toString.
48. OOP - Summary classes
- Developing Summary classes and techniques, expands an fuzy category.
49. PHP OOP - Interfaces
- Program, a unique category used like a design for classes, describes the techniques necessary in a number of identical classes.
50. Functions with Object and Range arguments
- How to set features to take only certain information kind for its guidelines, Object and Range justifications.
PHP - XML
51. XML Documents
- XML Details, a brief release of start, the framework and framework of an XML information. XML and DTD (Document Kind Definition).
52. PHP XML DOM
- Developing XML information with PHP XML DOM (Document Products or services Model), DomDocument product, analysis and change information in XML information.
53. SimpleXML
- PHP MySQL course - Using the SimpleXML features to analysis and change XML articles.
