book

PHP & MySQL: Novice to Ninja, 7th Edition

Name: PHP & MySQL: Novice to Ninja, 7th Edition
Author: Tom Butler
ISBN: 9781925836462

by Tom Butler

February 2022

Beginner

680 pages

11h 34m

English

SitePoint

Read now

Unlock full access

PHP & MySQL: Novice to Ninja, 7th Edition
Notice of RightsNotice of LiabilityTrademark NoticeAbout SitePointAbout the Author
Preface
Who Should Read This BookProgramming Has ChangedIt Takes 10,000 Hours to Become an ExpertResist the Temptation to Skip AheadThe Concorde FallacyYou’re Not Learning PHPGetting Braces and Semicolons in the Right Place Is the Easy PartYou Won’t Get Anything Done by PlanningOkay, Design Isn’t All BadConventions UsedCode SamplesTips, Notes, and WarningsWhere to Find HelpThe SitePoint ForumsThe Code ArchiveYour FeedbackLet’s Go
Chapter 1: Installation
Your Own Web ServerServer Setup 1: Manually Installing All the Software ComponentsServer Setup 2: Pre-packaged InstallationsServer Setup 3: Virtual ServersServer Setup 4: DockerGetting StartedInstallation on WindowsInstallation on macOSInstallation on LinuxGetting Started with DockerConnecting to the Server and Creating Your First FileWe’re All Set Up
Chapter 2: Introducing PHP
Basic Syntax and StatementsVariables, Operators, and CommentsVariablesOperatorsControl StructuresIf StatementsLoopsArraysUser Interaction and FormsPassing Variables in LinksPassing Variables in FormsHiding the SeamsPHP TemplatesSecurity ConcernsMany Templates, One ControllerBring On the Database
Chapter 3: Introducing MySQL
An Introduction to DatabasesMySQLUsing MySQL Workbench to Run SQL QueriesCreating a DatabaseStructured Query LanguageCreating a TableAdding DataA Word of WarningViewing Stored DataModifying Stored DataDeleting Stored DataLet PHP Do the Typing
Chapter 4: Publishing MySQL Data on the Web
The Big PictureCreating a MySQL User AccountConnecting to MySQL with PHPA Crash Course in Object-oriented ProgrammingConfiguring the ConnectionSending SQL Queries with PHPHandling SELECT Result SetsThinking AheadInserting Data into the DatabaseMagic QuotesPrepared StatementsDeleting Data from the DatabaseMission Accomplished
Chapter 5: Relational Database Design
Giving Credit Where Credit Is DueRule of Thumb: Keep Entities SeparateSELECT with Multiple TablesSimple RelationshipsMany-to-many RelationshipsOne for Many, and Many for One
Chapter 6: Structured PHP Programming
Include FilesIncluding HTML ContentIncluding PHP CodeTypes of IncludesCustom Functions and Function LibrariesVariable ScopeBreaking Up Your Code into Reusable FunctionsUsing Functions to Replace QueriesUpdating JokesEditing Jokes on the WebsiteDelete FunctionSelect FunctionThe Best Way
Chapter 7: Improving the Insert and Update Functions
Improving the Update FunctionImproving the Insert FunctionHandling DatesDisplaying the Joke DateMaking Your Own ToolsGeneric FunctionsUsing These FunctionsRepeated Code Is the EnemyCreating a Page for Adding and EditingFurther PolishingMoving Forward
Chapter 8: Objects and Classes
Time for ClassPublic vs PrivateProtectedObjectsClass VariablesConstructorsType HintingPrivate VariablesConstructor Property PromotionUsing the DatabaseTable ClassUpdating the Controller to Use the ClassDRYCreating a Controller ClassSingle Entry PointKeeping it DRYTemplate VariablesBe Careful with extractSummary

Chapter 9: Creating an Extensible Framework
Search Engine OptimizationThinking Ahead: User Registration1. Include the Relevant Controller2. Create an Instance of the ControllerDependencies3. Call the Action on the Correct ControllerDoneURL RewritingTidying UpMake it OOPReusing Code on Different WebsitesGeneric or Project-specific?Making EntryPoint GenericAutoloadingCase SensitivityImplement an AutoloaderRedecoratingNamespacesAutoloading with PSR-4And the RESTNon-web ApplicationsEnforcing Dependency Structure with InterfacesError HandlingYour Own Framework
Chapter 10: Allowing Users to Register Accounts
Validating Email AddressesPreventing the Same Person from Registering TwiceSecurely Storing PasswordsRegistration CompleteChapter Summary
Chapter 11: Cookies, Sessions, and Access Control
CookiesPHP SessionsCounting Visits with SessionsAccess ControlLogging InProtected PagesCreating a Login FormLogging OutAssigning Added Jokes to the Logged-in UserUser PermissionsMission Accomplished?The Sky’s the Limit
Chapter 12: Relationships
Object Relational MappersPublic PropertiesMethods in Entity ClassesUsing Entity Classes from the DatabaseTable ClassJoke ObjectsUsing the Joke ClassReferencesSimplifying the List Controller ActionTidying UpCachingJoke CategoriesList PageAssigning Jokes to CategoriesAssigning Categories to JokesDisplaying Jokes by CategoryEditing JokesUser RolesCreating a Form to Assign PermissionsAuthor ListEdit Author PermissionsSetting PermissionsStoring Permissions in the DatabaseA Crash Course in BinaryBe Bit-wiseBack to PHPStoring Bitwise Permissions in the DatabaseJoin Table and Bitwise Approaches: Pros and ConsCleaning UpEditing Other People’s JokesPhew!
Chapter 13: Content Formatting and Pagination
Regular ExpressionsString Replacement with Regular ExpressionsEmphasized TextParagraphsHyperlinksPutting It All TogetherSorting, Limiting and OffsetsSortingPagination with LIMIT and OFFSETPagination in CategoriesAchievement Unlocked: NinjaWhat Next?

Content preview from PHP & MySQL: Novice to Ninja, 7th Edition

Chapter 4: Publishing MySQL Data on the Web

This is it—the stuff you signed up for! In this chapter, you’ll learn how to take information stored in a MySQL database and display it on a web page for all to see.

So far, you’ve written your first PHP code and learned the basics of MySQL, a relational database engine, and PHP, a server-side scripting language.

Now you’re ready to learn how to use these tools together to create a website where users can view data from the database and even add their own.

MySQL and MariaDB

As in Chapter 3, I’m using “MySQL” here to refer to the database protocol. Your PHP scripts will do the same. There are numerous references in this chapter—and in the PHP code you’ll write—to “MySQL”, even though we’re actually ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Beginning PHP and MySQL: From Novice to Professional

Publisher Resources

ISBN: 9781098129552Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

PHP & MySQL: Novice to Ninja, 7th Edition

by Tom Butler