book

PHP and MySQL® Web Development, Fifth Edition

Name: PHP and MySQL® Web Development, Fifth Edition
ISBN: 9780133038644

by Luke Welling, Laura Thomson

September 2016

Intermediate to advanced

688 pages

19h 38m

English

Addison-Wesley Professional

Read now

Unlock full access

About This E-Book
Title Page
Copyright Page
Contents at a Glance
Table of Contents
Lead Authors
Contributing Authors
We Want to Hear from You!
Reader Services
Accessing the Free Web Edition

Introduction
Why You Should Read This BookWhat You Will Learn from This BookWhat Is PHP?What Is MySQL?Why Use PHP and MySQL?Some of PHP’s StrengthsPerformanceScalabilityDatabase IntegrationBuilt-in LibrariesCostEase of Learning PHPObject-Oriented SupportPortabilityFlexibility of Development ApproachSource CodeAvailability of Support and DocumentationKey Features of PHP 7Some of MySQL’s StrengthsPerformanceLow CostEase of UsePortabilitySource CodeAvailability of SupportWhat Is New in MySQL (5.x)?How Is This Book Organized?Accessing the Free Web EditionFinally
I: Using PHP
1. PHP Crash Course
Before You Begin: Accessing PHPCreating a Sample Application: Bob’s Auto PartsCreating the Order FormProcessing the FormEmbedding PHP in HTMLPHP TagsPHP StatementsWhitespaceCommentsAdding Dynamic ContentCalling FunctionsUsing the date() FunctionAccessing Form VariablesForm VariablesString ConcatenationVariables and LiteralsUnderstanding IdentifiersExamining Variable TypesPHP’s Data TypesType StrengthType CastingVariable VariablesDeclaring and Using ConstantsUnderstanding Variable ScopeUsing OperatorsArithmetic OperatorsString OperatorsAssignment OperatorsComparison OperatorsLogical OperatorsBitwise OperatorsOther OperatorsWorking Out the Form TotalsUnderstanding Precedence and AssociativityUsing Variable Handling FunctionsTesting and Setting Variable TypesTesting Variable StatusReinterpreting VariablesMaking Decisions with Conditionalsif StatementsCode Blockselse Statementselseif Statementsswitch StatementsComparing the Different ConditionalsRepeating Actions Through Iterationwhile Loopsfor and foreach Loopsdo...while LoopsBreaking Out of a Control Structure or ScriptEmploying Alternative Control Structure SyntaxUsing declareNext
2. Storing and Retrieving Data
Saving Data for LaterStoring and Retrieving Bob’s OrdersProcessing FilesOpening a FileChoosing File ModesUsing fopen() to Open a FileOpening Files Through FTP or HTTPAddressing Problems Opening FilesWriting to a FileParameters for fwrite()File FormatsClosing a FileReading from a FileOpening a File for Reading: fopen()Knowing When to Stop: feof()Reading a Line at a Time: fgets(), fgetss(), and fgetcsv()Reading the Whole File: readfile(), fpassthru(), file(), and file_get_contents()Reading a Character: fgetc()Reading an Arbitrary Length: fread()Using Other File FunctionsChecking Whether a File Is There: file_exists()Determining How Big a File Is: filesize()Deleting a File: unlink()Navigating Inside a File: rewind(), fseek(), and ftell()Locking FilesA Better Way: DatabasesProblems with Using Flat FilesHow RDBMSs Solve These ProblemsFurther ReadingNext
3. Using Arrays
What Is an Array?Numerically Indexed ArraysInitializing Numerically Indexed ArraysAccessing Array ContentsUsing Loops to Access the ArrayArrays with Different IndicesInitializing an ArrayAccessing the Array ElementsUsing LoopsArray OperatorsMultidimensional ArraysSorting ArraysUsing sort()Using asort() and ksort() to Sort ArraysSorting in ReverseSorting Multidimensional ArraysUsing the array_multisort() functionUser-Defined SortsReverse User SortsReordering ArraysUsing shuffle()Reversing an ArrayLoading Arrays from FilesPerforming Other Array ManipulationsNavigating Within an Array: each(), current(), reset(), end(), next(), pos(), and prev()Applying Any Function to Each Element in an Array: array_walk()Counting Elements in an Array: count(), sizeof(), and array_count_values()Converting Arrays to Scalar Variables: extract()Further ReadingNext
4. String Manipulation and Regular Expressions
Creating a Sample Application: Smart Form MailFormatting StringsTrimming Strings: chop(), ltrim(), and trim()Formatting Strings for OutputJoining and Splitting Strings with String FunctionsUsing explode(), implode(), and join()Using strtok()Using substr()Comparing StringsPerforming String Ordering: strcmp(), strcasecmp(), and strnatcmp()Testing String Length with strlen()Matching and Replacing Substrings with String FunctionsFinding Strings in Strings: strstr(), strchr(), strrchr(), and stristr()Finding the Position of a Substring: strpos() and strrpos()Replacing Substrings: str_replace() and substr_replace()Introducing Regular ExpressionsThe BasicsDelimitersCharacter Classes and TypesRepetitionSubexpressionsCounted SubexpressionsAnchoring to the Beginning or End of a StringBranchingMatching Literal Special CharactersReviewing Meta CharactersEscape SequencesBackreferencesAssertionsPutting It All Together for the Smart FormFinding Substrings with Regular ExpressionsReplacing Substrings with Regular ExpressionsSplitting Strings with Regular ExpressionsFurther ReadingNext
5. Reusing Code and Writing Functions
The Advantages of Reusing CodeCostReliabilityConsistencyUsing require() and include()Using require() to Include CodeUsing require() for Website TemplatesUsing auto_prepend_file and auto_append_fileUsing Functions in PHPCalling FunctionsCalling an Undefined FunctionUnderstanding Case and Function NamesDefining Your Own FunctionsExamining Basic Function StructureNaming Your FunctionUsing ParametersUnderstanding ScopePassing by Reference Versus Passing by ValueUsing the return KeywordReturning Values from FunctionsImplementing RecursionImplementing Anonymous Functions (or Closures)Further ReadingNext
6. Object-Oriented PHP
Understanding Object-Oriented ConceptsClasses and ObjectsPolymorphismInheritanceCreating Classes, Attributes, and Operations in PHPStructure of a ClassConstructorsDestructorsInstantiating ClassesUsing Class AttributesCalling Class OperationsControlling Access with private and publicWriting Accessor FunctionsImplementing Inheritance in PHPControlling Visibility Through Inheritance with private and protectedOverridingPreventing Inheritance and Overriding with finalUnderstanding Multiple InheritanceImplementing InterfacesUsing TraitsDesigning ClassesWriting the Code for Your ClassUnderstanding Advanced Object-Oriented Functionality in PHPUsing Per-Class ConstantsImplementing Static MethodsChecking Class Type and Type HintingLate Static BindingsCloning ObjectsUsing Abstract ClassesOverloading Methods with __call()Using __autoload()Implementing Iterators and IterationGeneratorsConverting Your Classes to StringsUsing the Reflection APINamespacesUsing SubnamespacesUnderstanding the Global NamespaceImporting and Aliasing NamespacesNext
7. Error and Exception Handling
Exception Handling ConceptsThe Exception ClassUser-Defined ExceptionsExceptions in Bob’s Auto PartsExceptions and PHP’s Other Error Handling MechanismsFurther ReadingNext
II: Using MySQL
8. Designing Your Web Database
Relational Database ConceptsTablesColumnsRowsValuesKeysSchemasRelationshipsDesigning Your Web DatabaseThink About the Real-World Objects You Are ModelingAvoid Storing Redundant DataUse Atomic Column ValuesChoose Sensible KeysThink About What You Want to Ask the DatabaseAvoid Designs with Many Empty AttributesSummary of Table TypesWeb Database ArchitectureFurther ReadingNext
9. Creating Your Web Database
Using the MySQL MonitorLogging In to MySQLCreating Databases and UsersSetting Up Users and PrivilegesIntroducing MySQL’s Privilege SystemPrinciple of Least PrivilegeUser Setup: The CREATE USER and GRANT CommandsTypes and Levels of PrivilegesThe REVOKE CommandExamples Using GRANT and REVOKESetting Up a User for the WebUsing the Right DatabaseCreating Database TablesUnderstanding What the Other Keywords MeanUnderstanding the Column TypesLooking at the Database with SHOW and DESCRIBECreating IndexesUnderstanding MySQL IdentifiersChoosing Column Data TypesNumeric TypesDate and Time TypesString TypesFurther ReadingNext
10. Working with Your MySQL Database
What Is SQL?Inserting Data into the DatabaseRetrieving Data from the DatabaseRetrieving Data with Specific CriteriaRetrieving Data from Multiple TablesRetrieving Data in a Particular OrderGrouping and Aggregating DataChoosing Which Rows to ReturnUsing SubqueriesUpdating Records in the DatabaseAltering Tables After CreationDeleting Records from the DatabaseDropping TablesDropping a Whole DatabaseFurther ReadingNext
11. Accessing Your MySQL Database from the Web with PHP
How Web Database Architectures WorkQuerying a Database from the WebChecking and Filtering Input DataSetting Up a ConnectionChoosing a Database to UseQuerying the DatabaseUsing Prepared StatementsRetrieving the Query ResultsDisconnecting from the DatabasePutting New Information in the DatabaseUsing Other PHP-Database InterfacesUsing a Generic Database Interface: PDOFurther ReadingNext
12. Advanced MySQL Administration
Understanding the Privilege System in DetailThe user TableThe db TableThe tables_priv, columns_priv, and procs priv TablesAccess Control: How MySQL Uses the Grant TablesUpdating Privileges: When Do Changes Take Effect?Making Your MySQL Database SecureMySQL from the Operating System’s Point of ViewPasswordsUser PrivilegesWeb IssuesGetting More Information About DatabasesGetting Information with SHOWGetting Information About Columns with DESCRIBEUnderstanding How Queries Work with EXPLAINOptimizing Your DatabaseDesign OptimizationPermissionsTable OptimizationUsing IndexesUsing Default ValuesOther TipsBacking Up Your MySQL DatabaseRestoring Your MySQL DatabaseImplementing ReplicationSetting Up the MasterPerforming the Initial Data TransferSetting Up the Slave or SlavesFurther ReadingNext
13. Advanced MySQL Programming
The LOAD DATA INFILE StatementStorage EnginesTransactionsUnderstanding Transaction DefinitionsUsing Transactions with InnoDBForeign KeysStored ProceduresBasic ExampleLocal VariablesCursors and Control StructuresTriggersFurther ReadingNext
III: Web Application Security
14. Web Application Security Risks
Identifying the Threats We FaceAccess to Sensitive DataModification of DataLoss or Destruction of DataDenial of ServiceMalicious Code InjectionCompromised ServerRepudiationUnderstanding Who We’re Dealing WithAttackers and CrackersUnwitting Users of Infected MachinesDisgruntled EmployeesHardware ThievesOurselvesNext
15. Building a Secure Web Application
Strategies for Dealing with SecurityStart with the Right MindsetBalancing Security and UsabilityMonitoring SecurityOur Basic ApproachSecuring Your CodeFiltering User InputEscaping OutputCode OrganizationWhat Goes in Your CodeFile System ConsiderationsCode Stability and BugsExecuting CommandsSecuring Your Web Server and PHPKeep Software Up-to-DateBrowse the php.ini fileWeb Server ConfigurationShared Hosting of Web ApplicationsDatabase Server SecurityUsers and the Permissions SystemSending Data to the ServerConnecting to the ServerRunning the ServerProtecting the NetworkFirewallsUse a DMZPrepare for DoS and DDoS AttacksComputer and Operating System SecurityKeep the Operating System Up to DateRun Only What Is NecessaryPhysically Secure the ServerDisaster PlanningNext
16. Implementing Authentication Methods with PHP
Identifying VisitorsImplementing Access ControlStoring PasswordsSecuring PasswordsProtecting Multiple PagesUsing Basic AuthenticationUsing Basic Authentication in PHPUsing Basic Authentication with Apache’s .htaccess FilesCreating Your Own Custom AuthenticationFurther ReadingNext
IV: Advanced PHP Techniques
17. Interacting with the File System and the Server
Uploading FilesHTML for File UploadWriting the PHP to Deal with the FileSession Upload ProgressAvoiding Common Upload ProblemsUsing Directory FunctionsReading from DirectoriesGetting Information About the Current DirectoryCreating and Deleting DirectoriesInteracting with the File SystemGetting File InformationChanging File PropertiesCreating, Deleting, and Moving FilesUsing Program Execution FunctionsInteracting with the Environment: getenv() and putenv()Further ReadingNext
18. Using Network and Protocol Functions
Examining Available ProtocolsSending and Reading EmailUsing Data from Other WebsitesUsing Network Lookup FunctionsBacking Up or Mirroring a FileUsing FTP to Back Up or Mirror a FileUploading FilesAvoiding TimeoutsUsing Other FTP FunctionsFurther ReadingNext
19. Managing the Date and Time
Getting the Date and Time from PHPUnderstanding TimezonesUsing the date() FunctionDealing with Unix TimestampsUsing the getdate() FunctionValidating Dates with checkdate()Formatting TimestampsConverting Between PHP and MySQL Date FormatsCalculating Dates in PHPCalculating Dates in MySQLUsing MicrosecondsUsing the Calendar FunctionsFurther ReadingNext
20. Internationalization and Localization
Localization Is More than TranslationUnderstanding Character SetsSecurity Implications of Character SetsUsing Multibyte String Functions in PHPCreating a Basic Localizable Page StructureUsing gettext() in an Internationalized ApplicationConfiguring Your System to Use gettext()Creating Translation FilesImplementing Localized Content in PHP Using gettext()Further ReadingNext
21. Generating Images
Setting Up Image Support in PHPUnderstanding Image FormatsJPEGPNGGIFCreating ImagesCreating a Canvas ImageDrawing or Printing Text on the ImageOutputting the Final GraphicCleaning UpUsing Automatically Generated Images in Other PagesUsing Text and Fonts to Create ImagesSetting Up the Base CanvasFitting the Text onto the ButtonPositioning the TextWriting the Text onto the ButtonFinishing UpDrawing Figures and Graphing DataUsing Other Image FunctionsNext
22. Using Session Control in PHP
What Is Session Control?Understanding Basic Session FunctionalityWhat Is a Cookie?Setting Cookies from PHPUsing Cookies with SessionsStoring the Session IDImplementing Simple SessionsStarting a SessionRegistering Session VariablesUsing Session VariablesUnsetting Variables and Destroying the SessionCreating a Simple Session ExampleConfiguring Session ControlImplementing Authentication with Session ControlNext
23. Integrating JavaScript and PHP
Understanding AJAXA Brief Introduction to jQueryUsing jQuery in Web ApplicationsBasic jQuery Techniques and ConceptsUsing jQuery SelectorsIntroduction to jQuery EventsUsing jQuery and AJAX with PHPThe AJAX-Enabled Chat Script/ServerThe jQuery AJAX MethodsThe Chat Client/jQuery ApplicationFurther ReadingNext
24. Other Useful Features
Evaluating Strings: eval()Terminating Execution: die() and exit()Serializing Variables and ObjectsGetting Information About the PHP EnvironmentFinding Out What Extensions Are LoadedIdentifying the Script OwnerFinding Out When the Script Was ModifiedTemporarily Altering the Runtime EnvironmentHighlighting Source CodeUsing PHP on the Command LineNext
V: Building Practical PHP and MySQL Projects
25. Using PHP and MySQL for Large Projects
Applying Software Engineering to Web DevelopmentPlanning and Running a Web Application ProjectReusing CodeWriting Maintainable CodeCoding StandardsBreaking Up CodeUsing a Standard Directory StructureDocumenting and Sharing In-House FunctionsImplementing Version ControlChoosing a Development EnvironmentDocumenting Your ProjectsPrototypingSeparating Logic and ContentOptimizing CodeUsing Simple OptimizationsTestingFurther ReadingNext
26. Debugging and Logging
Programming ErrorsSyntax ErrorsRuntime ErrorsLogic ErrorsVariable Debugging AidError Reporting LevelsAltering the Error Reporting SettingsTriggering Your Own ErrorsLogging Errors GracefullyLogging Errors to a Log FileNext
27. Building User Authentication and Personalization
Solution ComponentsUser Identification and PersonalizationStoring BookmarksRecommending BookmarksSolution OverviewImplementing the DatabaseImplementing the Basic SiteImplementing User AuthenticationRegistering UsersLogging InLogging OutChanging PasswordsResetting Forgotten PasswordsImplementing Bookmark Storage and RetrievalAdding BookmarksDisplaying BookmarksDeleting BookmarksImplementing RecommendationsConsidering Possible Extensions
VI: Appendix
A. Installing Apache, PHP, and MySQL
Installing Apache, PHP, and MySQL Under UNIXBinary InstallationSource InstallationBasic Apache Configuration ModificationsIs PHP Support Working?Is SSL Working?Installing Apache, PHP, and MySQL for Windows and Mac OS X Using All-in-One Installation PackagesTesting Your WorkInstalling PEARInstalling PHP with Other Web Servers
Index

Content preview from PHP and MySQL® Web Development, Fifth Edition

Lead Authors

Laura Thomson is Director of Engineering at Mozilla Corporation. She was formerly a principal at both OmniTI and Tangled Web Design, and she has worked for RMIT University and the Boston Consulting Group. She holds a Bachelor of Applied Science (Computer Science) degree and a Bachelor of Engineering (Computer Systems Engineering) degree with honors. In her spare time she enjoys riding horses, arguing about free and open source software, and sleeping.

Luke Welling is a software engineer and regularly speaks on open source and web development topics at conferences such as OSCON, ZendCon, MySQLUC, PHPCon, OSDC, and LinuxTag. He has worked for OmniTI, for the web analytics company Hitwise.com, at the database vendor MySQL AB, and as ...

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 for the Web: Visual QuickStart Guide, Fifth Edition

Publisher Resources

ISBN: 9780133038644Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

PHP and MySQL® Web Development, Fifth Edition

by Luke Welling, Laura Thomson

Lead Authors

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.