PHP

Details Snippets MySQL

Core

Definition

PHP (Personal Home Page): free open source server-side scripting language (InstallationAndConfiguration), tool for making dynamic and interactive Web pages. PHP 7 is the latest stable release (21 January 2020).

On the browser request a PHP script is executed on the server, and the plain HTML result is sent back to the browser. Try to practice PHP script code in Tryit (w3schools).

Elements

PHP element: instruction for an execution. Start width <?php and end with ?>.

Example:

<?php
 echo "My first PHP script!";
 ?>

Clarifications

PHP properties:

  • php file (file_name.php) contain: HTML, CSS, JavaScript and PHP code
  • core of the WordPress, run the Facebook
  • runs on various platforms (Windows, Linux, Unix, Mac OS X, etc.)
  • compatible with almost all servers
  • supports a wide range of databases

PHP application:

  • create, open, read, write, delete, and close files on the server
  • collect form data
  • send and receive cookies
  • add, delete, modify data in the database
  • be used to control user-access
  • encrypt data

Topics

PHP Topics Links (to the w3schools)

PHP Basic

Install Syntax Comments Variables Echo / Print Data Types Strings Numbers Constants Operators If…Else…Elseif Switch Loops Functions Arrays Superglobals

PHP Forms

Form Handling Form Validation Form Required Form URL/E-mail Form Complete

PHP Advanced

Date and Time Include File Handling File Open/Read File Create/Write File Upload Cookies Sessions Filters Filters Advanced JSON

PHP OOP

What is OOP Classes/Objects Constructor Destructor Access Modifiers Inheritance Constants Abstract Classes Traits Static Methods Static Properties

PHP Topics Overview

Basics

Sources

Useful links

Learn

(a) tutorialsphp w3schools tutorialrepublic tutorialspoint tutorialspointPHP7 landofcode linda-videos video01 video02 techaltum
(b) ebooksrightway devdocs  
(c) exercises/examtutorialspoint codecademy w3schools.com – quiz w3schools – certificate (online certification, $95);

Practice

(a) documentsPHP
(b) toolsmanual 10tools
(c) best practicesecurity bestpractice 10tips 12tips ZendZone 

Selected Books (ebooks collected)

author, title, edition, pages, publisher, ISBN, Amazon: price, evaluation / reviewes, record date

  1. Ullman L.: PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, 5th. 704. Peachpit Press, 2017. 0134301846. $28.99. 4.4 / 48. 2020 03 11.
  2. Lockhart J.: Modern PHP: New Features and Good Practices, 1st. 270. O’Reilly Media 2015. 1491905018. $26.49. 4.4 / 95. 2020 03 11.
  3. Sklar D., Trachtenberg A.: PHP Cookbook, 3rd. 820. O’Reilly Media 2014. 144936375X. $28.65. 4.4 / 27. 2018 01 30.
  4. McLaughlin B.: PHP and MySQL: The Missing Manual, 2nd. 546. O’Reilly Media, 2012. 1449325572. $23.94. 3.4 / 35. 2018 01 30.
  5. Nixon R.: Learning PHP, MySQL, and JavaScript: With jQuery, CSS & HTML5, 4th. 812. O’Reilly Media, 2014. 1491918667. $32.72. 4.3 / 85. 2018 01 30.
  6. Yank K.: PHP and MySQL: Novice to Ninja, 5th. 481. SitePoint, 2012. 0987153080. $35.43. 4.3 / 38. 2018 01 30.
  7. Ullman L.: Effortless E-Commerce with PHP and MySQL, 2nd. 552. New Riders, 2013. 0321949366. $40.08. 4.3 / 20. 2018 01 30.
  8. Ullman L.: PHP for the Web: Visual QuickPro Guide, 5th. 528. Peachpit Press, 2016. 0134291255. $15.65. 4.3 / 23. 2018 03 08.
  9. Doyle M.: Beginning PHP 5.3, 1st. 840. Wrox, 2009. 0470413964. $28.85. 4.5 / 36. 2018 03 08.
  10. Welling L., Thomson L.: PHP and MySQL Web Development, 4th. 1008. Addison-Wesley Professional, 2008. 0672329166. $9.63. 4.3 / 413. 2018 03 08.
  11. Gilmore J. W.: Beginning PHP Beginning PHP and MySQL: From Novice to Professional, 824. Apress, 2010. 1430231149. $38.04. 3.2 / 21. 2018 03 08.
  12. Beighley L., Morrison M.: Head First PHP and MySQL: A Brain-Friendly Guide, 1st Editon. 814. O’Reilly Media, 2009. 0596006306. $25.86. 3.9 / 107. 2018 03 08.
  13. Murach J.: Murach’s PHP and MySQL, 2nd. 878. Mike Murach & Associates, 2014. 1890774790. $35.49. 4.0 / 109. 2018 03 08.
  14. Forbes A.: The Joy of PHP: : A Beginner’s Guide to Programming Interactive Web Applications with PHP and mySQL, 1st. 182. CreateSpace Independent Publishing Platform, 2015. 1522792147. $18.95. 4.1 / 104. 2018 03 08.
  15. Brooks D. R.: Programming in HTML and PHP: Coding for Scientists and Engineers, 1st. 293. Springer, 2017. 3319569724. $69.99. – / -. 2018 03 08.
  16. Alvin C.: PHP: Learn PHP In 2 Hours And Start Programming Today! . 77. Amazon Digital Services LLC, 2018. B078ZKZFZK. $4.99. 4.7 / 42. 2019 03 19.

Details Snippets MySQL