Learning PHP, MySQL & JavaScript

✍ Scribed by Robin Nixon

• Publisher: O'Reilly Media
• Year: 2024
• Tongue: English
• Leaves: 132
• Edition: 7
• Category: Library

✦ Synopsis

Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. With the latest edition of this popular hands-on guide, you'll tackle dynamic web programming using the most recent versions of today's core technologies: PHP, MySQL, JavaScript, CSS, HTML5, jQuery, Node.js, and the powerful React library.

Web designers will learn how to use these technologies together while picking up valuable web programming practices along the way, including how to optimize websites for mobile devices. You'll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers.

Explore MySQL from database structure to complex queries
Use the MySQL PDO extension, PHP's improved MySQL interface
Create dynamic PHP web pages that tailor themselves to the user
Manage cookies and sessions and maintain a high level of security
Enhance JavaScript with the React library
Use Ajax calls for background browser-server communication
Style your web pages by acquiring CSS skills
Implement HTML5 features including geolocation, audio, video, and the canvas element
Reformat your websites into mobile web apps

✦ Table of Contents

Learning PHP, MySQL JavaScript
Learning PHP, MySQL JavaScript
Brief Table of Contents (Not Yet Final)
1. Introduction to Dynamic Web Content
HTTP and HTML: Berners-Lee’s Basics
The Request/Response Procedure
The Benefits of PHP, MySQL, JavaScript, CSS, and HTML
MariaDB: The MySQL Clone
Using PHP
Using MySQL
Using JavaScript
Using CSS
And Then There’s HTML5
The Apache Web Server
Node.js: An Alternative to Apache
About Open Source
Bringing It All Together
Questions
2. Setting Up a Development Server
What Is a WAMP, MAMP, or LAMP?
Installing AMPPS on Windows
Testing the Installation
Accessing the Document Root (Windows)
Alternative WAMPs
Installing AMPPS on macOS
Accessing the Document Root (macOS)
Installing a LAMP on Linux
Working Remotely
Logging In
Using SFTP or FTPS
Using a Code Editor
Questions
3. Introduction to PHP
Incorporating PHP Within HTML
This Book’s Examples
The Structure of PHP
Using Comments
Basic Syntax
Variables
Operators
Variable Assignment
Multiline Commands
Variable Typing
Constants
Predefined Constants
The Difference Between the echo and print Commands
Functions
Variable Scope
Questions
4. Expressions and Control Flow in PHP
Expressions
TRUE or FALSE?
Literals and Variables
Operators
Operator Precedence
Associativity
Relational Operators
Conditionals
The if Statement
The else Statement
The elseif Statement
The switch Statement
The ? (or ternary) Operator
Looping
while Loops
do...while Loops
for Loops
Breaking Out of a Loop
The continue Statement
Implicit and Explicit Casting
PHP Dynamic Linking
Dynamic Linking in Action
Questions
5. PHP Functions and Objects
PHP Functions
Defining a Function
Returning a Value
Returning an Array
Passing Arguments by Reference
Returning Global Variables
Recap of Variable Scope
Including and Requiring Files
The include Statement
Using include_once
Using require and require_once
PHP Version Compatibility
PHP Objects
Terminology
Declaring a Class
Creating an Object
Accessing Objects
Cloning Objects
Constructors
Destructors
Writing Methods
Declaring Properties
Declaring Constants
Property and Method Scope
Static Methods
Static Properties
Inheritance
Questions
About the Author