Original Work and Sources
  • This course is the web edition of the author’s e-book PHP: Basics to Advance – Core PHP to MySQLi Web Applications, a revised and enlarged edition of the author’s own course notes on Core PHP, PHP functions, state management, MySQL/ODBC and Advance PHP.
  • All PHP programs – including the MySQLi chapters in procedural and object-oriented style and the CMS project – were written or updated for PHP 8 and run on an Apache, PHP and MariaDB server; the outputs shown are the actual results of those runs.
  • The theoretical notes bring together and explain concepts gathered from publicly available sources. These sources are listed below, with the page(s) that cite each one, and credit for the original ideas belongs to their respective creators.
  • PHP is a trademark of The PHP Group; MySQL of Oracle Corporation; MariaDB of MariaDB plc; Apache of The Apache Software Foundation; XAMPP is a project of Apache Friends. Links lead to external websites.
Official PHP Documentation (133)
  1. The PHP Group. (n.d.). PHP Manual – $_COOKIE. https://www.php.net/manual/en/reserved.variables.cookies.php
    Cited in: Ch-30 : Cookies & Query Strings
  2. The PHP Group. (n.d.). PHP Manual – $_GET. https://www.php.net/manual/en/reserved.variables.get.php
    Cited in: Ch-11 : Form Handling
  3. The PHP Group. (n.d.). PHP Manual – $_POST. https://www.php.net/manual/en/reserved.variables.post.php
    Cited in: Ch-11 : Form Handling
  4. The PHP Group. (n.d.). PHP Manual – Alternative syntax for control structures. https://www.php.net/manual/en/control-structures.alternative-syntax.php
    Cited in: Ch-6 : Conditional Statements
  5. The PHP Group. (n.d.). PHP Manual – Anonymous functions. https://www.php.net/manual/en/functions.anonymous.php
    Cited in: Ch-10 : User-Defined Functions
  6. The PHP Group. (n.d.). PHP Manual – Apache Functions. https://www.php.net/manual/en/ref.apache.php
    Cited in: Ch-23 : Apache & Array Functions
  7. The PHP Group. (n.d.). PHP Manual – Array Functions. https://www.php.net/manual/en/ref.array.php
    Cited in: Ch-9 : Arrays, Ch-23 : Apache & Array Functions
  8. The PHP Group. (n.d.). PHP Manual – Arrays. https://www.php.net/manual/en/language.types.array.php
    Cited in: Ch-9 : Arrays
  9. The PHP Group. (n.d.). PHP Manual – Arrow Functions. https://www.php.net/manual/en/functions.arrow.php
    Cited in: Ch-10 : User-Defined Functions
  10. The PHP Group. (n.d.). PHP Manual – Autoloading Classes. https://www.php.net/manual/en/language.oop5.autoload.php
    Cited in: Ch-17 : OOP – Classes & Objects
  11. The PHP Group. (n.d.). PHP Manual – Backward incompatible changes (PHP 8.0). https://www.php.net/manual/en/migration80.incompatible.php
    Cited in: Ch-5 : Operators, Ch-17 : OOP – Classes & Objects, Ch-23 : Apache & Array Functions
  12. The PHP Group. (n.d.). PHP Manual – Basic syntax: PHP tags. https://www.php.net/manual/en/language.basic-syntax.phptags.php
    Cited in: Ch-3 : Introduction & Syntax
  13. The PHP Group. (n.d.). PHP Manual – break and continue. https://www.php.net/manual/en/control-structures.break.php
    Cited in: Ch-7 : Loops
  14. The PHP Group. (n.d.). PHP Manual – Calendar Functions. https://www.php.net/manual/en/ref.calendar.php
    Cited in: Ch-24 : Date / Time Functions
  15. The PHP Group. (n.d.). PHP Manual – Choosing an API (MySQL). https://www.php.net/manual/en/mysqlinfo.api.choosing.php
    Cited in: Ch-27 : MySQL → MySQLi Functions, Ch-33 : PHP/MySQL (classic API)
  16. The PHP Group. (n.d.). PHP Manual – Class Abstraction. https://www.php.net/manual/en/language.oop5.abstract.php
    Cited in: Ch-18 : OOP – Advanced
  17. The PHP Group. (n.d.). PHP Manual – Class/Object Functions. https://www.php.net/manual/en/ref.classobj.php
    Cited in: Ch-25 : Class, Directory & File Functions
  18. The PHP Group. (n.d.). PHP Manual – Classes and Objects. https://www.php.net/manual/en/language.oop5.php
    Cited in: Ch-17 : OOP – Classes & Objects
  19. The PHP Group. (n.d.). PHP Manual – Comments. https://www.php.net/manual/en/language.basic-syntax.comments.php
    Cited in: Ch-3 : Introduction & Syntax
  20. The PHP Group. (n.d.). PHP Manual – Comparison Operators. https://www.php.net/manual/en/language.operators.comparison.php
    Cited in: Ch-5 : Operators
  21. The PHP Group. (n.d.). PHP Manual – Constants. https://www.php.net/manual/en/language.constants.php
    Cited in: Ch-4 : Constants, Variables & Data Types
  22. The PHP Group. (n.d.). PHP Manual – Constructors and Destructors. https://www.php.net/manual/en/language.oop5.decon.php
    Cited in: Ch-17 : OOP – Classes & Objects
  23. The PHP Group. (n.d.). PHP Manual – Data Filtering. https://www.php.net/manual/en/book.filter.php
    Cited in: Ch-21 : Filters
  24. The PHP Group. (n.d.). PHP Manual – date. https://www.php.net/manual/en/function.date.php
    Cited in: Ch-24 : Date / Time Functions
  25. The PHP Group. (n.d.). PHP Manual – Date/Time Functions. https://www.php.net/manual/en/ref.datetime.php
    Cited in: Ch-24 : Date / Time Functions
  26. The PHP Group. (n.d.). PHP Manual – Dealing with Forms. https://www.php.net/manual/en/tutorial.forms.php
    Cited in: Ch-11 : Form Handling
  27. The PHP Group. (n.d.). PHP Manual – Defining multiple namespaces in the same file. https://www.php.net/manual/en/language.namespaces.definitionmultiple.php
    Cited in: Ch-16 : Namespaces
  28. The PHP Group. (n.d.). PHP Manual – Deprecated features in PHP 8.1. https://www.php.net/manual/en/migration81.deprecated.php
    Cited in: Ch-21 : Filters
  29. The PHP Group. (n.d.). PHP Manual – Deprecated features in PHP 8.2. https://www.php.net/manual/en/migration82.deprecated.php
    Cited in: Ch-29 : String & Variable Functions
  30. The PHP Group. (n.d.). PHP Manual – Deprecated features in PHP 8.3. https://www.php.net/manual/en/migration83.deprecated.php
    Cited in: Ch-28 : Network, Buffer, Config & Session Functions
  31. The PHP Group. (n.d.). PHP Manual – Directory Functions. https://www.php.net/manual/en/ref.dir.php
    Cited in: Ch-25 : Class, Directory & File Functions
  32. The PHP Group. (n.d.). PHP Manual – do-while. https://www.php.net/manual/en/control-structures.do.while.php
    Cited in: Ch-7 : Loops
  33. The PHP Group. (n.d.). PHP Manual – Document Object Model (DOM). https://www.php.net/manual/en/book.dom.php
    Cited in: Ch-38 : XML
  34. The PHP Group. (n.d.). PHP Manual – Dual procedural and object-oriented interface. https://www.php.net/manual/en/mysqli.quickstart.dual-interface.php
    Cited in: Ch-27 : MySQL → MySQLi Functions, Ch-35 : MySQLi – Object Oriented
  35. The PHP Group. (n.d.). PHP Manual – echo. https://www.php.net/manual/en/function.echo.php
    Cited in: Ch-3 : Introduction & Syntax
  36. The PHP Group. (n.d.). PHP Manual – Error Handling and Logging. https://www.php.net/manual/en/book.errorfunc.php
    Cited in: Ch-20 : Errors & Exceptions
  37. The PHP Group. (n.d.). PHP Manual – Error Handling Functions. https://www.php.net/manual/en/ref.errorfunc.php
    Cited in: Ch-26 : Error, HTTP, Mail & Math Functions
  38. The PHP Group. (n.d.). PHP Manual – Error Messages Explained (uploads). https://www.php.net/manual/en/features.file-upload.errors.php
    Cited in: Ch-14 : File System
  39. The PHP Group. (n.d.). PHP Manual – Errors in PHP 7. https://www.php.net/manual/en/language.errors.php7.php
    Cited in: Ch-20 : Errors & Exceptions
  40. The PHP Group. (n.d.). PHP Manual – Exceptions. https://www.php.net/manual/en/language.exceptions.php
    Cited in: Ch-20 : Errors & Exceptions
  41. The PHP Group. (n.d.). PHP Manual – extract. https://www.php.net/manual/en/function.extract.php
    Cited in: Ch-9 : Arrays
  42. The PHP Group. (n.d.). PHP Manual – Filesystem Functions. https://www.php.net/manual/en/ref.filesystem.php
    Cited in: Ch-14 : File System, Ch-25 : Class, Directory & File Functions
  43. The PHP Group. (n.d.). PHP Manual – filter_input_array. https://www.php.net/manual/en/function.filter-input-array.php
    Cited in: Ch-21 : Filters
  44. The PHP Group. (n.d.). PHP Manual – fopen. https://www.php.net/manual/en/function.fopen.php
    Cited in: Ch-14 : File System
  45. The PHP Group. (n.d.). PHP Manual – for. https://www.php.net/manual/en/control-structures.for.php
    Cited in: Ch-7 : Loops
  46. The PHP Group. (n.d.). PHP Manual – foreach. https://www.php.net/manual/en/control-structures.foreach.php
    Cited in: Ch-7 : Loops
  47. The PHP Group. (n.d.). PHP Manual – Function arguments. https://www.php.net/manual/en/functions.arguments.php
    Cited in: Ch-10 : User-Defined Functions
  48. The PHP Group. (n.d.). PHP Manual – Function handling Functions. https://www.php.net/manual/en/ref.funchand.php
    Cited in: Ch-25 : Class, Directory & File Functions
  49. The PHP Group. (n.d.). PHP Manual – get_included_files. https://www.php.net/manual/en/function.get-included-files.php
    Cited in: Ch-13 : include / require
  50. The PHP Group. (n.d.). PHP Manual – Global space. https://www.php.net/manual/en/language.namespaces.global.php
    Cited in: Ch-16 : Namespaces
  51. The PHP Group. (n.d.). PHP Manual – Handling file uploads. https://www.php.net/manual/en/features.file-upload.php
    Cited in: Ch-14 : File System
  52. The PHP Group. (n.d.). PHP Manual – header. https://www.php.net/manual/en/function.header.php
    Cited in: Ch-26 : Error, HTTP, Mail & Math Functions
  53. The PHP Group. (n.d.). PHP Manual – History of PHP. https://www.php.net/manual/en/history.php.php
    Cited in: Ch-3 : Introduction & Syntax
  54. The PHP Group. (n.d.). PHP Manual – htmlspecialchars. https://www.php.net/manual/en/function.htmlspecialchars.php
    Cited in: Ch-11 : Form Handling
  55. The PHP Group. (n.d.). PHP Manual – http_build_query. https://www.php.net/manual/en/function.http-build-query.php
    Cited in: Ch-30 : Cookies & Query Strings
  56. The PHP Group. (n.d.). PHP Manual – if. https://www.php.net/manual/en/control-structures.if.php
    Cited in: Ch-6 : Conditional Statements
  57. The PHP Group. (n.d.). PHP Manual – include. https://www.php.net/manual/en/function.include.php
    Cited in: Ch-13 : include / require
  58. The PHP Group. (n.d.). PHP Manual – JSON Functions. https://www.php.net/manual/en/ref.json.php
    Cited in: Ch-39 : AJAX
  59. The PHP Group. (n.d.). PHP Manual – json_encode. https://www.php.net/manual/en/function.json-encode.php
    Cited in: Ch-19 : MVC
  60. The PHP Group. (n.d.). PHP Manual – List of Supported Timezones (Asia). https://www.php.net/manual/en/timezones.asia.php
    Cited in: Ch-24 : Date / Time Functions
  61. The PHP Group. (n.d.). PHP Manual – Mail runtime configuration. https://www.php.net/manual/en/mail.configuration.php
    Cited in: Ch-15 : E-Mail
  62. The PHP Group. (n.d.). PHP Manual – mail. https://www.php.net/manual/en/function.mail.php
    Cited in: Ch-15 : E-Mail
  63. The PHP Group. (n.d.). PHP Manual – match. https://www.php.net/manual/en/control-structures.match.php
    Cited in: Ch-6 : Conditional Statements
  64. The PHP Group. (n.d.). PHP Manual – Math Functions. https://www.php.net/manual/en/ref.math.php
    Cited in: Ch-26 : Error, HTTP, Mail & Math Functions
  65. The PHP Group. (n.d.). PHP Manual – Migrating from PHP 7.2.x to PHP 7.3.x (flexible heredoc). https://www.php.net/manual/en/migration73.new-features.php
    Cited in: Ch-8 : Strings
  66. The PHP Group. (n.d.). PHP Manual – Misc. Functions. https://www.php.net/manual/en/ref.misc.php
    Cited in: Ch-29 : String & Variable Functions
  67. The PHP Group. (n.d.). PHP Manual – Multibyte String. https://www.php.net/manual/en/book.mbstring.php
    Cited in: Ch-8 : Strings
  68. The PHP Group. (n.d.). PHP Manual – Multiple Statements. https://www.php.net/manual/en/mysqli.quickstart.multiple-statement.php
    Cited in: Ch-34 : MySQLi – Procedural
  69. The PHP Group. (n.d.). PHP Manual – MySQL Improved Extension (MySQLi). https://www.php.net/manual/en/book.mysqli.php
    Cited in: Ch-27 : MySQL → MySQLi Functions
  70. The PHP Group. (n.d.). PHP Manual – MySQLi Quick start guide. https://www.php.net/manual/en/mysqli.quickstart.php
    Cited in: Ch-33 : PHP/MySQL (classic API), Ch-34 : MySQLi – Procedural
  71. The PHP Group. (n.d.). PHP Manual – mysqli::begin_transaction. https://www.php.net/manual/en/mysqli.begin-transaction.php
    Cited in: Ch-36 : Prepared Statements
  72. The PHP Group. (n.d.). PHP Manual – mysqli::execute_query. https://www.php.net/manual/en/mysqli.execute-query.php
    Cited in: Ch-36 : Prepared Statements, Project 1 : Mini CMS with PHP & MySQLi
  73. The PHP Group. (n.d.). PHP Manual – mysqli_connect / mysqli::__construct. https://www.php.net/manual/en/mysqli.construct.php
    Cited in: Ch-34 : MySQLi – Procedural
  74. The PHP Group. (n.d.). PHP Manual – mysqli_report. https://www.php.net/manual/en/mysqli-driver.report-mode.php
    Cited in: Ch-34 : MySQLi – Procedural
  75. The PHP Group. (n.d.). PHP Manual – mysqli_result class. https://www.php.net/manual/en/class.mysqli-result.php
    Cited in: Ch-34 : MySQLi – Procedural, Ch-35 : MySQLi – Object Oriented
  76. The PHP Group. (n.d.). PHP Manual – mysqli_result::fetch_object. https://www.php.net/manual/en/mysqli-result.fetch-object.php
    Cited in: Ch-35 : MySQLi – Object Oriented
  77. The PHP Group. (n.d.). PHP Manual – mysqli_stmt::bind_param. https://www.php.net/manual/en/mysqli-stmt.bind-param.php
    Cited in: Ch-36 : Prepared Statements
  78. The PHP Group. (n.d.). PHP Manual – namespace keyword and __NAMESPACE__ magic constant. https://www.php.net/manual/en/language.namespaces.nsconstants.php
    Cited in: Ch-16 : Namespaces
  79. The PHP Group. (n.d.). PHP Manual – Namespaces overview. https://www.php.net/manual/en/language.namespaces.rationale.php
    Cited in: Ch-16 : Namespaces
  80. The PHP Group. (n.d.). PHP Manual – Network Functions (header, setcookie). https://www.php.net/manual/en/ref.network.php
    Cited in: Ch-26 : Error, HTTP, Mail & Math Functions, Ch-28 : Network, Buffer, Config & Session Functions
  81. The PHP Group. (n.d.). PHP Manual – Object Interfaces. https://www.php.net/manual/en/language.oop5.interfaces.php
    Cited in: Ch-18 : OOP – Advanced
  82. The PHP Group. (n.d.). PHP Manual – Object Iteration. https://www.php.net/manual/en/language.oop5.iterations.php
    Cited in: Ch-18 : OOP – Advanced
  83. The PHP Group. (n.d.). PHP Manual – ODBC Functions (Unified). https://www.php.net/manual/en/ref.uodbc.php
    Cited in: Ch-37 : ODBC
  84. The PHP Group. (n.d.). PHP Manual – odbc_connect. https://www.php.net/manual/en/function.odbc-connect.php
    Cited in: Ch-37 : ODBC
  85. The PHP Group. (n.d.). PHP Manual – Operator Precedence. https://www.php.net/manual/en/language.operators.precedence.php
    Cited in: Ch-5 : Operators
  86. The PHP Group. (n.d.). PHP Manual – Operators. https://www.php.net/manual/en/language.operators.php
    Cited in: Ch-5 : Operators
  87. The PHP Group. (n.d.). PHP Manual – Original MySQL API (removed). https://www.php.net/manual/en/book.mysql.php
    Cited in: Ch-33 : PHP/MySQL (classic API)
  88. The PHP Group. (n.d.). PHP Manual – Output Control Functions. https://www.php.net/manual/en/ref.outcontrol.php
    Cited in: Ch-28 : Network, Buffer, Config & Session Functions
  89. The PHP Group. (n.d.). PHP Manual – Overloading. https://www.php.net/manual/en/language.oop5.overloading.php
    Cited in: Ch-18 : OOP – Advanced
  90. The PHP Group. (n.d.). PHP Manual – Password Hashing. https://www.php.net/manual/en/book.password.php
    Cited in: Ch-29 : String & Variable Functions, Project 1 : Mini CMS with PHP & MySQLi
  91. The PHP Group. (n.d.). PHP Manual – password_hash. https://www.php.net/manual/en/function.password-hash.php
    Cited in: Ch-36 : Prepared Statements
  92. The PHP Group. (n.d.). PHP Manual – PCRE Patterns. https://www.php.net/manual/en/reference.pcre.pattern.syntax.php
    Cited in: Ch-12 : Form Validation & RegEx
  93. The PHP Group. (n.d.). PHP Manual – PHP Options/Info Functions. https://www.php.net/manual/en/ref.info.php
    Cited in: Ch-28 : Network, Buffer, Config & Session Functions
  94. The PHP Group. (n.d.). PHP Manual – Predefined Constants (error levels). https://www.php.net/manual/en/errorfunc.constants.php
    Cited in: Ch-20 : Errors & Exceptions
  95. The PHP Group. (n.d.). PHP Manual – preg_match. https://www.php.net/manual/en/function.preg-match.php
    Cited in: Ch-12 : Form Validation & RegEx
  96. The PHP Group. (n.d.). PHP Manual – preg_replace_callback. https://www.php.net/manual/en/function.preg-replace-callback.php
    Cited in: Ch-12 : Form Validation & RegEx
  97. The PHP Group. (n.d.). PHP Manual – preg_split. https://www.php.net/manual/en/function.preg-split.php
    Cited in: Ch-12 : Form Validation & RegEx
  98. The PHP Group. (n.d.). PHP Manual – Prepared Statements (MySQLi). https://www.php.net/manual/en/mysqli.quickstart.prepared-statements.php
    Cited in: Ch-36 : Prepared Statements
  99. The PHP Group. (n.d.). PHP Manual – random_int. https://www.php.net/manual/en/function.random-int.php
    Cited in: Ch-26 : Error, HTTP, Mail & Math Functions
  100. The PHP Group. (n.d.). PHP Manual – Removed Extensions and SAPIs (PHP 7.0). https://www.php.net/manual/en/migration70.removed-exts-sapis.php
    Cited in: Ch-27 : MySQL → MySQLi Functions
  101. The PHP Group. (n.d.). PHP Manual – require. https://www.php.net/manual/en/function.require.php
    Cited in: Ch-13 : include / require
  102. The PHP Group. (n.d.). PHP Manual – require_once. https://www.php.net/manual/en/function.require-once.php
    Cited in: Ch-13 : include / require
  103. The PHP Group. (n.d.). PHP Manual – Returning values. https://www.php.net/manual/en/functions.returning-values.php
    Cited in: Ch-10 : User-Defined Functions
  104. The PHP Group. (n.d.). PHP Manual – Sanitize filters. https://www.php.net/manual/en/filter.filters.sanitize.php
    Cited in: Ch-21 : Filters
  105. The PHP Group. (n.d.). PHP Manual – Scope Resolution Operator (::). https://www.php.net/manual/en/language.oop5.paamayim-nekudotayim.php
    Cited in: Ch-17 : OOP – Classes & Objects
  106. The PHP Group. (n.d.). PHP Manual – Securing Session INI Settings. https://www.php.net/manual/en/session.security.ini.php
    Cited in: Ch-31 : Sessions
  107. The PHP Group. (n.d.). PHP Manual – Session Functions. https://www.php.net/manual/en/ref.session.php
    Cited in: Ch-28 : Network, Buffer, Config & Session Functions
  108. The PHP Group. (n.d.). PHP Manual – Session Runtime Configuration. https://www.php.net/manual/en/session.configuration.php
    Cited in: Ch-31 : Sessions
  109. The PHP Group. (n.d.). PHP Manual – session_start. https://www.php.net/manual/en/function.session-start.php
    Cited in: Ch-31 : Sessions
  110. The PHP Group. (n.d.). PHP Manual – Sessions. https://www.php.net/manual/en/book.session.php
    Cited in: Ch-31 : Sessions, Project 1 : Mini CMS with PHP & MySQLi
  111. The PHP Group. (n.d.). PHP Manual – set_error_handler. https://www.php.net/manual/en/function.set-error-handler.php
    Cited in: Ch-20 : Errors & Exceptions
  112. The PHP Group. (n.d.). PHP Manual – setcookie. https://www.php.net/manual/en/function.setcookie.php
    Cited in: Ch-30 : Cookies & Query Strings
  113. The PHP Group. (n.d.). PHP Manual – SimpleXML. https://www.php.net/manual/en/book.simplexml.php
    Cited in: Ch-38 : XML
  114. The PHP Group. (n.d.). PHP Manual – Sorting Arrays. https://www.php.net/manual/en/array.sorting.php
    Cited in: Ch-9 : Arrays, Ch-23 : Apache & Array Functions
  115. The PHP Group. (n.d.). PHP Manual – String Functions. https://www.php.net/manual/en/ref.strings.php
    Cited in: Ch-8 : Strings, Ch-29 : String & Variable Functions
  116. The PHP Group. (n.d.). PHP Manual – Strings. https://www.php.net/manual/en/language.types.string.php
    Cited in: Ch-8 : Strings
  117. The PHP Group. (n.d.). PHP Manual – Superglobals. https://www.php.net/manual/en/language.variables.superglobals.php
    Cited in: Ch-4 : Constants, Variables & Data Types
  118. The PHP Group. (n.d.). PHP Manual – switch. https://www.php.net/manual/en/control-structures.switch.php
    Cited in: Ch-6 : Conditional Statements
  119. The PHP Group. (n.d.). PHP Manual – The configuration file (php.ini). https://www.php.net/manual/en/configuration.file.php
    Cited in: Ch-2 : XAMPP
  120. The PHP Group. (n.d.). PHP Manual – The DateTime class. https://www.php.net/manual/en/class.datetime.php
    Cited in: Ch-24 : Date / Time Functions
  121. The PHP Group. (n.d.). PHP Manual – The mysqli class. https://www.php.net/manual/en/class.mysqli.php
    Cited in: Ch-35 : MySQLi – Object Oriented
  122. The PHP Group. (n.d.). PHP Manual – Traits. https://www.php.net/manual/en/language.oop5.traits.php
    Cited in: Ch-18 : OOP – Advanced
  123. The PHP Group. (n.d.). PHP Manual – Types. https://www.php.net/manual/en/language.types.php
    Cited in: Ch-4 : Constants, Variables & Data Types
  124. The PHP Group. (n.d.). PHP Manual – User-defined functions. https://www.php.net/manual/en/functions.user-defined.php
    Cited in: Ch-10 : User-Defined Functions
  125. The PHP Group. (n.d.). PHP Manual – Using namespaces: Aliasing/Importing. https://www.php.net/manual/en/language.namespaces.importing.php
    Cited in: Ch-16 : Namespaces
  126. The PHP Group. (n.d.). PHP Manual – Validate filters. https://www.php.net/manual/en/filter.filters.validate.php
    Cited in: Ch-15 : E-Mail, Ch-21 : Filters
  127. The PHP Group. (n.d.). PHP Manual – Variable handling Functions. https://www.php.net/manual/en/ref.var.php
    Cited in: Ch-29 : String & Variable Functions
  128. The PHP Group. (n.d.). PHP Manual – Variable scope. https://www.php.net/manual/en/language.variables.scope.php
    Cited in: Ch-4 : Constants, Variables & Data Types
  129. The PHP Group. (n.d.). PHP Manual – Variables. https://www.php.net/manual/en/language.variables.php
    Cited in: Ch-4 : Constants, Variables & Data Types
  130. The PHP Group. (n.d.). PHP Manual – Visibility. https://www.php.net/manual/en/language.oop5.visibility.php
    Cited in: Ch-17 : OOP – Classes & Objects
  131. The PHP Group. (n.d.). PHP Manual – What is PHP? https://www.php.net/manual/en/intro-whatis.php
    Cited in: Ch-1 : AMP Basics, Ch-3 : Introduction & Syntax
  132. The PHP Group. (n.d.). PHP Manual – while. https://www.php.net/manual/en/control-structures.while.php
    Cited in: Ch-7 : Loops
  133. The PHP Group. (n.d.). PHP Manual – XML Parser (Expat). https://www.php.net/manual/en/book.xml.php
    Cited in: Ch-38 : XML
XAMPP, Apache and Web Server (10)
  1. Apache Friends. (2023). New XAMPP release 8.2.12, 8.1.25 and 8.0.30. https://www.apachefriends.org/blog/new_xampp_20231119.html
    Cited in: Ch-2 : XAMPP
  2. Apache Friends. (n.d.). Download XAMPP. https://www.apachefriends.org/download.html
    Cited in: Ch-2 : XAMPP
  3. Apache Friends. (n.d.). XAMPP Installers and Downloads for Apache Friends. https://www.apachefriends.org/
    Cited in: Ch-2 : XAMPP
  4. The Apache Software Foundation. (n.d.). Apache Core Features – AllowOverride. https://httpd.apache.org/docs/2.4/mod/core.html#allowoverride
    Cited in: Ch-22 : .htaccess Security
  5. The Apache Software Foundation. (n.d.). Apache HTTP Server Tutorial: .htaccess files. https://httpd.apache.org/docs/2.4/howto/htaccess.html
    Cited in: Ch-22 : .htaccess Security
  6. The Apache Software Foundation. (n.d.). Apache HTTP Server Version 2.4 Documentation. https://httpd.apache.org/docs/2.4/
    Cited in: Ch-1 : AMP Basics, Ch-2 : XAMPP
  7. The Apache Software Foundation. (n.d.). Apache mod_rewrite Introduction. https://httpd.apache.org/docs/2.4/rewrite/intro.html
    Cited in: Ch-22 : .htaccess Security
  8. The Apache Software Foundation. (n.d.). Authentication and Authorization. https://httpd.apache.org/docs/2.4/howto/auth.html
    Cited in: Ch-22 : .htaccess Security
  9. The Apache Software Foundation. (n.d.). htpasswd – Manage user files for basic authentication. https://httpd.apache.org/docs/2.4/programs/htpasswd.html
    Cited in: Ch-22 : .htaccess Security
  10. Wikipedia contributors. (n.d.). XAMPP. Wikipedia, The Free Encyclopedia. https://en.wikipedia.org/wiki/XAMPP
    Cited in: Ch-1 : AMP Basics, Ch-2 : XAMPP
MySQL, MariaDB and Databases (12)
  1. MariaDB Foundation. (n.d.). Data Types. MariaDB Knowledge Base. https://mariadb.com/kb/en/library/data-types/
    Cited in: Ch-32 : MySQL Fundamentals
  2. MariaDB Foundation. (n.d.). FOREIGN KEY. MariaDB Knowledge Base. https://mariadb.com/kb/en/foreign-keys/
    Cited in: Project 1 : Mini CMS with PHP & MySQLi
  3. MariaDB Foundation. (n.d.). MariaDB Error Codes. https://mariadb.com/kb/en/mariadb-error-codes/
    Cited in: Ch-35 : MySQLi – Object Oriented
  4. MariaDB Foundation. (n.d.). MariaDB Server Documentation. https://mariadb.com/kb/en/documentation/
    Cited in: Ch-1 : AMP Basics
  5. MariaDB Foundation. (n.d.). SELECT. MariaDB Knowledge Base. https://mariadb.com/kb/en/select/
    Cited in: Ch-32 : MySQL Fundamentals
  6. MariaDB plc. (n.d.). InnoDB Storage Engine. https://mariadb.com/docs/storage-engines/innodb/
    Cited in: Ch-32 : MySQL Fundamentals
  7. MariaDB plc. (n.d.). MariaDB Connector/ODBC. https://mariadb.com/kb/en/mariadb-connector-odbc/
    Cited in: Ch-37 : ODBC
  8. Microsoft. (n.d.). ODBC Data Source Administrator. Microsoft Learn. https://learn.microsoft.com/en-us/sql/odbc/admin/odbc-data-source-administrator
    Cited in: Ch-37 : ODBC
  9. Oracle Corporation. (n.d.). MySQL 8.0 Reference Manual – Data Types. https://dev.mysql.com/doc/refman/8.0/en/data-types.html
    Cited in: Ch-32 : MySQL Fundamentals
  10. Oracle Corporation. (n.d.). MySQL 8.0 Reference Manual – What is MySQL? https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html
    Cited in: Ch-32 : MySQL Fundamentals
  11. Oracle Corporation. (n.d.). MySQL Connector/PHP – Overview of the MySQL PHP drivers. https://dev.mysql.com/doc/apis-php/en/
    Cited in: Ch-33 : PHP/MySQL (classic API)
  12. unixODBC Project. (n.d.). unixODBC. https://www.unixodbc.org/
    Cited in: Ch-37 : ODBC
Web Standards and Other Sources (26)
  1. Barth, A. (2011). RFC 6265: HTTP State Management Mechanism. IETF. https://www.rfc-editor.org/rfc/rfc6265
    Cited in: Ch-30 : Cookies & Query Strings
  2. Drupal Association. (n.d.). Drupal. https://www.drupal.org/
    Cited in: Ch-40 : CMS Concepts
  3. ECMA International. (2017). ECMA-404: The JSON Data Interchange Syntax. https://www.ecma-international.org/publications-and-standards/standards/ecma-404/
    Cited in: Ch-39 : AJAX
  4. Fowler, M. (2002). Patterns of Enterprise Application Architecture. Addison-Wesley.
    Cited in: Ch-19 : MVC
  5. Gamma, E., Helm, R., Johnson, R., & Vlissides, J. (1994). Design Patterns: Elements of Reusable Object-Oriented Software. Addison-Wesley.
    Cited in: Ch-18 : OOP – Advanced
  6. Garrett, J. J. (2005). Ajax: A New Approach to Web Applications. Adaptive Path.
    Cited in: Ch-39 : AJAX
  7. Google. (n.d.). Sign in with app passwords. Google Account Help. https://support.google.com/accounts/answer/185833
    Cited in: Ch-15 : E-Mail
  8. Laravel. (n.d.). Laravel Documentation. https://laravel.com/docs
    Cited in: Ch-19 : MVC
  9. MDN contributors. (n.d.). Client-side form validation. MDN Web Docs. https://developer.mozilla.org/en-US/docs/Learn/Forms/Form_validation
    Cited in: Ch-12 : Form Validation & RegEx
  10. MDN contributors. (n.d.). MVC. MDN Web Docs Glossary. https://developer.mozilla.org/en-US/docs/Glossary/MVC
    Cited in: Ch-19 : MVC
  11. MDN contributors. (n.d.). Using HTTP cookies. MDN Web Docs. https://developer.mozilla.org/en-US/docs/Web/HTTP/Cookies
    Cited in: Ch-30 : Cookies & Query Strings
  12. MDN contributors. (n.d.). Using the Fetch API. MDN Web Docs. https://developer.mozilla.org/en-US/docs/Web/API/Fetch_API/Using_Fetch
    Cited in: Ch-39 : AJAX
  13. MDN contributors. (n.d.). XML introduction. MDN Web Docs. https://developer.mozilla.org/en-US/docs/Web/XML/XML_introduction
    Cited in: Ch-38 : XML
  14. Open Source Initiative. (n.d.). The Open Source Definition. https://opensource.org/osd
    Cited in: Ch-1 : AMP Basics
  15. Open Source Matters. (n.d.). Joomla!. https://www.joomla.org/
    Cited in: Ch-40 : CMS Concepts
  16. OWASP Foundation. (n.d.). Cross Site Scripting (XSS). https://owasp.org/www-community/attacks/xss/
    Cited in: Ch-11 : Form Handling
  17. OWASP Foundation. (n.d.). Cross-Site Request Forgery Prevention Cheat Sheet. https://cheatsheetseries.owasp.org/cheatsheets/Cross-Site_Request_Forgery_Prevention_Cheat_Sheet.html
    Cited in: Project 1 : Mini CMS with PHP & MySQLi
  18. OWASP Foundation. (n.d.). File Upload Cheat Sheet. https://cheatsheetseries.owasp.org/cheatsheets/File_Upload_Cheat_Sheet.html
    Cited in: Ch-14 : File System
  19. OWASP Foundation. (n.d.). Session Management Cheat Sheet. https://cheatsheetseries.owasp.org/cheatsheets/Session_Management_Cheat_Sheet.html
    Cited in: Ch-31 : Sessions
  20. OWASP Foundation. (n.d.). SQL Injection Prevention Cheat Sheet. https://cheatsheetseries.owasp.org/cheatsheets/SQL_Injection_Prevention_Cheat_Sheet.html
    Cited in: Ch-36 : Prepared Statements
  21. PHPMailer contributors. (n.d.). PHPMailer. GitHub. https://github.com/PHPMailer/PHPMailer
    Cited in: Ch-15 : E-Mail
  22. phpMyAdmin contributors. (n.d.). phpMyAdmin Documentation. https://docs.phpmyadmin.net/
    Cited in: Ch-2 : XAMPP, Ch-32 : MySQL Fundamentals
  23. W3C. (2008). Extensible Markup Language (XML) 1.0 (Fifth Edition). https://www.w3.org/TR/xml/
    Cited in: Ch-38 : XML
  24. WHATWG. (n.d.). XMLHttpRequest Standard. https://xhr.spec.whatwg.org/
    Cited in: Ch-39 : AJAX
  25. Wikipedia contributors. (n.d.). Content management system. Wikipedia, The Free Encyclopedia. https://en.wikipedia.org/wiki/Content_management_system
    Cited in: Ch-40 : CMS Concepts
  26. WordPress.org. (n.d.). WordPress. https://wordpress.org/
    Cited in: Ch-40 : CMS Concepts