book

PHP & MySQL: Novice to Ninja, 6th Edition

by Tom Butler, Kevin Yank

October 2017

Beginner

690 pages

12h 43m

English

SitePoint

Read now

Unlock full access

PHP & MySQL: Novice to Ninja, 6th Edition
Notice of RightsNotice of LiabilityTrademark NoticeAbout Tom ButlerAbout Kevin YankAbout SitePoint
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 UsedTips, Notes, and WarningsSupplementary Materials
Installation
Your Own Web ServerServer Setup 1: Manually Installing All the Software ComponentsServer Setup 2: Pre-packaged InstallationsServer Setup 3: Virtual ServersYour Own Virtual ServerInstallation on WindowsInstallation on macOSInstallation on LinuxGetting Started with Vagrant
Introducing PHP
Basic Syntax and StatementsVariables, Operators, and CommentsVariablesOperatorsCommentsControl StructuresIf StatementsLoopsArraysUser Interaction and FormsPassing Variables in LinksPassing Variables in FormsGET or POST?Hiding the SeamsPHP TemplatesSecurity ConcernsMany Templates, One ControllerBring on the Database
Introducing MySQL
An Introduction to DatabasesUsing 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
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 DatabaseDeleting Data from the DatabaseMission Accomplished
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
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
Improving the Insert and Update Functions
Improving the Update FunctionStripping the Trailing CommaImproving 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
Objects and Classes
Time for ClassPublic vs PrivateObjectsClass VariablesConstructorsType HintingPrivate VariablesUsing the DatabaseTable ClassUpdating the Controller to Use the ClassDRYCreating a Controller ClassSingle Entry PointKeeping it DRYTemplate VariablesBe Careful With Extract

Creating an Extensible Framework
Search EnginesMake Things GenericThinking Ahead: User RegistrationDependenciesURL RewritingTidying UpMake it OOPReusing Code on Different WebsitesGeneric or Project Specific?Making EntryPoint GenericAutoloading and NamespacesCase SensitivityImplement an AutoloaderRedecoratingNamespacesAutoloading with PSR-4A Note on ComposerAnd the RESTEnforcing Dependency Structure with InterfacesYour Own Framework
Allowing Users to Register Accounts
Validating Email AddressesPreventing the Same Person from Registering TwiceSecurely Storing PasswordsRegistration Complete
Cookies, Sessions, and Access Control
CookiesPHP SessionsCounting Visits with SessionsAccess ControlLogging InProtected PagesInterfaces and Return TypesMaking Use of the Authentication ClassLogin Error MessageCreating a Login FormLogging OutAssigning Added Jokes to the Logged-in UserUser PermissionsMission Accomplished?The Sky’s the Limit
MySQL Administration
Backing Up MySQL DatabasesDatabase Backups Using MySQL WorkbenchDatabase Backups Using mysqlpumpIncremental Backups Using Binary LogsMySQL Access Control TipsHost Name IssuesLocked Out?IndexesMulticolumn IndexesForeign KeysBetter Safe than Sorry
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 PermissionsA Different ApproachA Crash Course in BinaryBe Bit-WiseBack to PHPStoring Bitwise Permissions in the DatabaseJoin Table or BitwiseCleaning UpEditing Others’ JokesPhew!
Content Formatting with Regular Expressions
Regular ExpressionsString Replacement with Regular ExpressionsEmphasized TextParagraphsHyperlinksPutting It All TogetherSorting, Limiting and OffsetsSortingPagination with LIMIT and OFFSETPagination in CategoriesAchievement Unlocked: NinjaWhat Next?
Using The Sample Code Repository
Some CaveatsWhen You Switch to a Sample, Any Files in the Project Directory Will Be RemovedSample Database
Linux Troubleshooting

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

Appendix A: Using The Sample Code Repository

Each code sample in this book is provided in a GitHub repository at https://github.com/spbooks/phpmysql6. Where a set of code for an example is available in the archive, it is either captioned with its name over the code sample itself (for example PHP-Loops), or I’ll let you know the name of the set of code in the text. You can find the complete sample code on the GitHub repository. In Git’s terminology, each set of code is known as a branch.

There are two ways to use the sample code.

If you just want to view the code for a specific file in a single example, you can do it easily on GitHub. Choose the example by it’s name using the Branch dropdown on the main GitHub page. You will then see a list of ...

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

PHP & MySQL: Novice to Ninja, 5th Edition

Publisher Resources

ISBN: 9781492065241Errata 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, 6th Edition

by Tom Butler, Kevin Yank

Appendix A: Using The Sample Code Repository

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.