𝔖 Scriptorium
✦   LIBER   ✦

πŸ“

The Joy of PHP: A Beginner's Guide to Programming Interactive Web Applications with PHP and MySQL

✍ Scribed by Alan Forbes


Publisher
Createspace Independent Publishing Platform
Year
2015
Tongue
English
Leaves
128
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


Third Edition now with bonus chapters. Have you ever wanted to design your own website or browser application but thought it would be too difficult or just didn't know where to start? Have you found the amount of information on the Internet either too daunting or not geared for your skill set or worse-- just plain boring? Are you interested in learning to program PHP and have some fun along the way? If so, then The Joy of PHP by Alan Forbes is the book for you!! Alan starts with some basic HTML so the absolute beginner can catch up quickly and then goes step by step on how PHP works. You start with the easy stuff--like how to create and run simple PHP scripts that modify web pages-- and then build on what you've learned through a series of cohesive (and fun) exercises that carry over from lesson to lesson. As the chapters progress you begin to build a web site for a growing used car dealership business. This approach keeps the material fun and challenging-- and gives what you've learned a context to be relevant. A car dealership needs a constantly changing web site because the inventory of cars is always changing. HTML is not the answer for this kind of web site-- but PHP and mySQL are! Throughout the book you will be working with the web site for the car dealership and adding features and modifying it as the needs of the business (and your knowledge) grow. This writing style reinforces the previous lessons and keeps you engaged in a "real" project -- giving you both a sense of accomplishment and an opportunity to apply what you've learned to a realistic scenario. You are far more likely to retain what you've learned using this approach than just reading dry syntax documentation. The author has an easy and fun style of writing that teaches you PHP in a simple, matter of fact manner while showing you the most common uses of the commands you need to get the job done. This keeps your learning pace quick and uncluttered. If you need it, he also points you to several resources where you can learn more about the other options a PHP function can offer and-- even better--how to read and understand those resources. If you want to learn the PHP language in an easy, enjoyable, well laid out manner and to learn why PHP and mySQL are so powerful and fun to use then buy this book!! Do not buy this book if you are looking for a comprehensive reference of boring PHP syntax. This book does not attempt to cover everything about PHP. What it does do-- and does well-- is take you from being a beginner who isn't even sure what PHP is to someone who knows the sheer joy that only programming dynamic sites can provide. You will become someone who can read, write, and modify PHP scripts and you will be able make your website come alive. Bonus Code All the source code referenced in the book is available for easy download and well organized. You don't have to cut and paste out of Kindle or retype code, unless you want to. There is even a video tutorial showing how to get started. Topics Covered... - Installing and configuring PHP - Introduction to HTML - Basic PHP Syntax - Some Fun Right Away - Editors and Staying Organized - Variables, Numbers, Dates and Strings - Control Structures - How to use a database, such as mySQL - Using PHP and mySQL Together - How to create forms to Display, Add, Edit, and Delete data - Session Variables - Working with Images - PHP File Uploads - PHP Quirks and Tips - Security Considerations This book is NOT the only book you'll ever need to read to master PHP. The book is a gentle introduction to a very rich topic. The hope of the author is to show you that PHP isn't really that scary after all, it is something YOU can do, and it can even bring you joy once you get it.

✦ Table of Contents


Table of Contents
Introduction
Introduction
What is PHP?
Introducing PHP
Example
A little history
Installing and Configuring PHP
Introduction
Windows Users
Using Wampserver
Mac Users
How Do I Know it is Working?
Oracle VM Virtual Box
Installing for a Web Site
Exercise
Introduction to HTML
Introduction
Basic HTML
Basic Elements of HTML
Tags
Nested Tags
Required tags
DocType
Head
Optional Tags
Meta Tags
Useful Tags
Headers
DIV
Images/Picture
Links
Lists
Exercise
HTML Tables
HTML Table Headers
HTML Forms
The Input tag
HTML Form Actions & Methods
Introduction - Basic PHP Syntax
Your first PHP-enabled page – Hello World!
Some Fun Right Away
A Countdown Counter
Exercise
Editors and Staying Organized
Editors
Microsoft Expression Web
PhpDesigner
EditRocket
Free Editors
Includes
Basic example
HTML example
Code example
Best Practices
Variables, Numbers, Dates, and Strings
Variables
Variable Naming Conventions and Best Practices
Numbers
Basic Arithmetic
Common Arithmetic Shortcuts
Useful Numeric Functions
Strings
Useful String Functions
Sources of Documentation
Exercise
How to Interpret PHP.NET documentation
Return Value
Function Name
Parameters
Dates
Example: Calculating Age in Years
Variable Scope
Control Structures
Introduction
if
if... else
Exercise: Open Hours
PHP Switch
PHP Looping
PHP while
PHP for
How to use a database, such as mySQL
Introduction
What are Databases?
Getting Started with phpMyAdmin
What is phpMyAdmin?
Using phpMyAdmin to create a database
Introduction to SQL
Using phpMyAdmin to create a Table in a database
Defining our first table
What defines an automobile?
Datatypes
Numbers
Characters
Dates
Exercise: Create a Table
Working with SQL Statements
INSERT Statements
SELECT Statements
WHERE Statements
Comparison Operators
ORDER BY
UPDATE Statements
DELETE Statements
Using mySQL and PHP Together
Introduction
Code!
Code Listing: createdb.php
Code Explained: createdb.php
Hey, where's the HTML?
Creating forms to Display, Add, Edit, and Delete data
Introduction
Forms that Add Data to a Database
A Basic Form
HTML Code
Form Action
PHP Code
A Brief Time Out...include files and SQL Injection
Include Files
SQL Injection
Forms that Display Summary Data
Code
Code Explained
Exercise: Tweaking the SELECT
Improving the look of the table with CSS
CSS Explained
Modifying the form to link to the detail page
Forms that Display Detail Data
Code
Code Explained
Forms that Edit Data
Forms that Delete Data
Code to delete data
Code Explained
Exercise
Session Variables
Introduction
Sessions
Starting a PHP Session
Using Session Variables
Store a variable
Retrieve a variable
Checking for a variable
Destroying a Session
Working with Images
Introduction
Exercise: Viewing Images
Pulling an unknown number of images from a database
Exercise: Create a Database Table to store images
Exercise: Modify the viewcar.php page to show multiple images
Code explained
PHP File Uploads
Introduction
Create an Upload File form
Create a Script to Process the Uploaded File
Code: ViewCarsAddImage.php
Code Explained
PHP Quirks and Tips
Introduction
Single Quotes vs Double Quotes
The Equal Sign
Comparison Operators
Security Considerations
Introduction
Balancing Security and Usability
SQL Injection
Additional Resources
Appendix A: Installing PHP on a Website
How to install on a Windows Server
How to install on a Linux Server
Author's Note
A Note from one of my Kickstarter Backers....
- Pasha Kagan, soon-to-be PHP Developer


πŸ“œ SIMILAR VOLUMES


Web Programming with PHP and MySQL: A Pr
✍ Max Bramer πŸ“‚ Library πŸ“… 2015 πŸ› Springer 🌐 English

Introductory textbook covering all the main features of the 'web programming' languages PHP and MySQL together with detailed examples that will enable readers (whether students on a taught course or independent learners) to use them to create their own applications or understand existing ones. A par

Web Programming with PHP and MySQL: A Pr
✍ Max Bramer (auth.) πŸ“‚ Library πŸ“… 2015 πŸ› Springer International Publishing 🌐 English

<p>Introductory textbook covering all the main features of the 'web programming' languages PHP and MySQL together with detailed examples that will enable readers (whether students on a taught course or independent learners) to use them to create their own applications or understand existing ones. A

PHP Programming for Beginners. Key Progr
✍ Skudaev, Sergey πŸ“‚ Library 🌐 English

In this book, you will find practical solutions that can be used for your own website.The book includes instructions for installation of Apache, PHP, MySQL, and Oracle and provides many tips for using MySQL and the Oracle database. The code examples include access to MySQL using PDO; access to Oracl