book

Learning PHP, MySQL & JavaScript, 5th Edition

Name: Learning PHP, MySQL & JavaScript, 5th Edition
Author: Robin Nixon
ISBN: 9781491978917

by Robin Nixon

May 2018

Beginner

827 pages

18h 20m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Learning PHP, MySQL & JavaScript
Learning PHP, MySQL & JavaScript
Dedication
Preface
AudienceAssumptions This Book MakesOrganization of This BookSupporting BooksConventions Used in This BookUsing Code ExamplesO’Reilly Online LearningHow to Contact UsAcknowledgments
1. Introduction to Dynamic Web Content
HTTP and HTML: Berners-Lee’s BasicsThe Request/Response ProcedureThe Benefits of PHP, MySQL, JavaScript, CSS, and HTML5MariaDB: The MySQL CloneUsing PHPUsing MySQLUsing JavaScriptUsing CSSAnd Then There’s HTML5The Apache Web ServerHandling Mobile DevicesAbout Open SourceBringing It All TogetherQuestions
2. Setting Up a Development Server
What Is a WAMP, MAMP, or LAMP?Installing AMPPS on WindowsTesting the InstallationAccessing the Document Root (Windows)Alternative WAMPsInstalling AMPPS on macOSAccessing the Document Root (macOS)Installing a LAMP on LinuxWorking RemotelyLogging InUsing FTPUsing a Program EditorUsing an IDEQuestions
3. Introduction to PHP
Incorporating PHP Within HTMLThis Book’s ExamplesThe Structure of PHPUsing CommentsBasic SyntaxVariablesOperatorsVariable AssignmentMultiple-Line CommandsVariable TypingConstantsPredefined ConstantsThe Difference Between the echo and print CommandsFunctionsVariable ScopeQuestions
4. Expressions and Control Flow in PHP
ExpressionsTRUE or FALSE?Literals and VariablesOperatorsOperator PrecedenceAssociativityRelational OperatorsConditionalsThe if StatementThe else StatementThe elseif StatementThe switch StatementThe ? OperatorLoopingwhile Loopsdo...while Loopsfor LoopsBreaking Out of a LoopThe continue StatementImplicit and Explicit CastingPHP Dynamic LinkingDynamic Linking in ActionQuestions
5. PHP Functions and Objects
PHP FunctionsDefining a FunctionReturning a ValueReturning an ArrayPassing Arguments by ReferenceReturning Global VariablesRecap of Variable ScopeIncluding and Requiring FilesThe include StatementUsing include_onceUsing require and require_oncePHP Version CompatibilityPHP ObjectsTerminologyDeclaring a ClassCreating an ObjectAccessing ObjectsCloning ObjectsConstructorsDestructorsWriting MethodsDeclaring PropertiesDeclaring ConstantsProperty and Method ScopeStatic MethodsStatic PropertiesInheritanceQuestions
6. PHP Arrays
Basic AccessNumerically Indexed ArraysAssociative ArraysAssignment Using the array KeywordThe foreach...as LoopMultidimensional ArraysUsing Array Functionsis_arraycountsortshuffleexplodeextractcompactresetendQuestions

7. Practical PHP
Using printfPrecision SettingString PaddingUsing sprintfDate and Time FunctionsDate ConstantsUsing checkdateFile HandlingChecking Whether a File ExistsCreating a FileReading from FilesCopying FilesMoving a FileDeleting a FileUpdating FilesLocking Files for Multiple AccessesReading an Entire FileUploading FilesSystem CallsXHTML or HTML5?Questions
8. Introduction to MySQL
MySQL BasicsSummary of Database TermsAccessing MySQL via the Command LineStarting the Command-Line InterfaceUsing the Command-Line InterfaceMySQL CommandsData TypesIndexesCreating an IndexQuerying a MySQL DatabaseJoining Tables TogetherUsing Logical OperatorsMySQL FunctionsAccessing MySQL via phpMyAdminQuestions
9. Mastering MySQL
Database DesignPrimary Keys: The Keys to Relational DatabasesNormalizationFirst Normal FormSecond Normal FormThird Normal FormWhen Not to Use NormalizationRelationshipsOne-to-OneOne-to-ManyMany-to-ManyDatabases and AnonymityTransactionsTransaction Storage EnginesUsing BEGINUsing COMMITUsing ROLLBACKUsing EXPLAINBacking Up and RestoringUsing mysqldumpCreating a Backup FileRestoring from a Backup FileDumping Data in CSV FormatPlanning Your BackupsQuestions
10. Accessing MySQL Using PHP
Querying a MySQL Database with PHPThe ProcessCreating a Login FileConnecting to a MySQL DatabaseA Practical ExampleThe $_POST ArrayDeleting a RecordDisplaying the FormQuerying the DatabaseRunning the ProgramPractical MySQLCreating a TableDescribing a TableDropping a TableAdding DataRetrieving DataUpdating DataDeleting DataUsing AUTO_INCREMENTPerforming Additional QueriesPreventing Hacking AttemptsSteps You Can TakeUsing PlaceholdersPreventing HTML InjectionUsing mysqli ProcedurallyQuestions
11. Form Handling
Building FormsRetrieving Submitted DataDefault ValuesInput TypesSanitizing InputAn Example ProgramHTML5 EnhancementsThe autocomplete AttributeThe autofocus AttributeThe placeholder AttributeThe required AttributeOverride AttributesThe width and height AttributesThe min and max AttributesThe step AttributeThe form AttributeThe list AttributeThe color Input TypeThe number and range Input TypesDate and Time PickersQuestions
12. Cookies, Sessions, and Authentication
Using Cookies in PHPSetting a CookieAccessing a CookieDestroying a CookieHTTP AuthenticationStoring Usernames and PasswordsAn Example ProgramUsing SessionsStarting a SessionEnding a SessionSetting a TimeoutSession SecurityQuestions
13. Exploring JavaScript
JavaScript and HTML TextUsing Scripts Within a Document HeadOlder and Nonstandard BrowsersIncluding JavaScript FilesDebugging JavaScript ErrorsUsing CommentsSemicolonsVariablesString VariablesNumeric VariablesArraysOperatorsArithmetic OperatorsAssignment OperatorsComparison OperatorsLogical OperatorsIncrementing, Decrementing, and Shorthand AssignmentString ConcatenationEscape CharactersVariable TypingFunctionsGlobal VariablesLocal VariablesThe Document Object ModelAnother Use for the $ SymbolUsing the DOMAbout document.writeUsing console.logUsing alertWriting into ElementsUsing document.writeQuestions
14. Expressions and Control Flow in JavaScript
ExpressionsLiterals and VariablesOperatorsOperator PrecedenceAssociativityRelational OperatorsThe with StatementUsing onerrorUsing try...catchConditionalsThe if StatementThe else StatementThe switch StatementThe ? OperatorLoopingwhile Loopsdo...while Loopsfor LoopsBreaking Out of a LoopThe continue StatementExplicit CastingQuestions
15. JavaScript Functions, Objects, and Arrays
JavaScript FunctionsDefining a FunctionReturning a ValueReturning an ArrayJavaScript ObjectsDeclaring a ClassCreating an ObjectAccessing ObjectsThe prototype KeywordJavaScript ArraysNumeric ArraysAssociative ArraysMultidimensional ArraysUsing Array MethodsQuestions
16. JavaScript and PHP Validation and Error Handling
Validating User Input with JavaScriptThe validate.html Document (Part 1)The validate.html Document (Part 2)Regular ExpressionsMatching Through MetacharactersFuzzy Character MatchingGrouping Through ParenthesesCharacter ClassesIndicating a RangeNegationSome More Complicated ExamplesSummary of MetacharactersGeneral ModifiersUsing Regular Expressions in JavaScriptUsing Regular Expressions in PHPRedisplaying a Form After PHP ValidationQuestions
17. Using Asynchronous Communication
What Is Asynchronous Communication?Using XMLHttpRequestYour First Asynchronous ProgramUsing GET Instead of POSTSending XML RequestsUsing Frameworks for Asynchronous CommunicationQuestions
18. Introduction to CSS
Importing a StylesheetImporting CSS from Within HTMLEmbedded Style SettingsUsing IDsUsing ClassesUsing SemicolonsCSS RulesMultiple AssignmentsUsing CommentsStyle TypesDefault StylesUser StylesExternal StylesheetsInternal StylesInline StylesCSS SelectorsThe Type SelectorThe Descendant SelectorThe Child SelectorThe ID SelectorThe Class SelectorThe Attribute SelectorThe Universal SelectorSelecting by GroupThe CSS CascadeStylesheet CreatorsStylesheet MethodsStylesheet SelectorsThe Difference Between div and span ElementsMeasurementsFonts and Typographyfont-familyfont-stylefont-sizefont-weightManaging Text StylesDecorationSpacingAlignmentTransformationIndentingCSS ColorsShort Color StringsGradientsPositioning ElementsAbsolute PositioningRelative PositioningFixed PositioningPseudoclassesShorthand RulesThe Box Model and LayoutSetting MarginsApplying BordersAdjusting PaddingObject ContentsQuestions
19. Advanced CSS with CSS3
Attribute SelectorsMatching Parts of StringsThe box-sizing PropertyCSS3 BackgroundsThe background-clip PropertyThe background-origin PropertyThe background-size PropertyUsing the auto ValueMultiple BackgroundsCSS3 BordersThe border-color PropertyThe border-radius PropertyBox ShadowsElement OverflowMulticolumn LayoutColors and OpacityHSL ColorsHSLA ColorsRGB ColorsRGBA ColorsThe opacity PropertyText EffectsThe text-shadow PropertyThe text-overflow PropertyThe word-wrap PropertyWeb FontsGoogle Web FontsTransformations3D TransformationsTransitionsProperties to TransitionTransition DurationTransition DelayTransition TimingShorthand SyntaxQuestions
20. Accessing CSS from JavaScript
Revisiting the getElementById FunctionThe O functionThe S FunctionThe C FunctionIncluding the FunctionsAccessing CSS Properties from JavaScriptSome Common PropertiesOther PropertiesInline JavaScriptThe this KeywordAttaching Events to Objects in a ScriptAttaching to Other EventsAdding New ElementsRemoving ElementsAlternatives to Adding and Removing ElementsUsing InterruptsUsing setTimeoutCanceling a TimeoutUsing setIntervalUsing Interrupts for AnimationQuestions
21. Introduction to jQuery
Why jQuery?Including jQueryChoosing the Right VersionDownloadingUsing a Content Delivery NetworkCustomizing jQueryjQuery SyntaxA Simple ExampleAvoiding Library ConflictsSelectorsThe css MethodThe Element SelectorThe ID SelectorThe Class SelectorCombining SelectorsHandling EventsWaiting Until the Document Is ReadyEvent Functions and PropertiesThe blur and focus EventsThe this KeywordThe click and dblclick EventsThe keypress EventConsiderate ProgrammingThe mousemove EventOther Mouse EventsAlternative Mouse MethodsThe submit EventSpecial EffectsHiding and ShowingThe toggle MethodFading In and OutSliding Elements Up and DownAnimationsStopping AnimationsManipulating the DOMThe Difference Between the text and html MethodsThe val and attr MethodsAdding and Removing ElementsDynamically Applying ClassesModifying DimensionsThe width and height MethodsThe innerWidth and innerHeight MethodsThe outerWidth and OuterHeight MethodsDOM TraversalParent ElementsChild ElementsSibling ElementsSelecting the Next and Previous ElementsTraversing jQuery SelectionsThe is MethodUsing jQuery Without SelectorsThe $.each MethodThe $.map MethodUsing Asynchronous CommunicationUsing the POST MethodUsing the GET MethodPlug-insjQuery User InterfaceOther Plug-insQuestions
22. Introduction to jQuery Mobile
Including jQuery MobileGetting StartedLinking PagesLinking SynchronouslyLinking Within a Multipage DocumentPage TransitionsStyling ButtonsList HandlingFilterable ListsList DividersWhat Next?Questions
23. Introduction to HTML5
The CanvasGeolocationAudio and VideoFormsLocal StorageWeb WorkersMicrodataQuestions
24. The HTML5 Canvas
Creating and Accessing a CanvasThe toDataURL FunctionSpecifying an Image TypeThe fillRect MethodThe clearRect MethodThe strokeRect MethodCombining These CommandsThe createLinearGradient MethodThe addColorStop Method in DetailThe createRadialGradient MethodUsing Patterns for FillsWriting Text to the CanvasThe strokeText MethodThe textBaseline PropertyThe font PropertyThe textAlign PropertyThe fillText MethodThe measureText MethodDrawing LinesThe lineWidth PropertyThe lineCap and lineJoin PropertiesThe miterLimit PropertyUsing PathsThe moveTo and lineTo MethodsThe stroke MethodThe rect MethodFilling AreasThe clip MethodThe isPointInPath MethodWorking with CurvesThe arc MethodThe arcTo MethodThe quadraticCurveTo MethodThe bezierCurveTo MethodManipulating ImagesThe drawImage MethodResizing an ImageSelecting an Image AreaCopying from a CanvasAdding ShadowsEditing at the Pixel LevelThe getImageData MethodThe putImageData MethodThe createImageData MethodAdvanced Graphical EffectsThe globalCompositeOperation PropertyThe globalAlpha PropertyTransformationsThe scale MethodThe save and restore MethodsThe rotate MethodThe translate MethodThe transform MethodThe setTransform MethodQuestions
25. HTML5 Audio and Video
About CodecsThe <audio> ElementSupporting Non-HTML5 BrowsersThe <video> ElementThe Video CodecsSupporting Older BrowsersQuestions
26. Other HTML5 Features
Geolocation and the GPS ServiceOther Location MethodsGeolocation and HTML5Local StorageUsing Local StorageThe localStorage ObjectWeb WorkersDrag and DropCross-Document MessagingOther HTML5 TagsQuestions
27. Bringing It All Together
Designing a Social Networking AppOn the Websitefunctions.phpThe Functionsheader.phpsetup.phpindex.phpsignup.phpChecking for Username AvailabilityLogging Incheckuser.phplogin.phpprofile.phpAdding the “About Me” TextAdding a Profile ImageProcessing the ImageDisplaying the Current Profilemembers.phpViewing a User’s ProfileAdding and Dropping FriendsListing All Membersfriends.phpmessages.phplogout.phpstyles.cssjavascript.js
A. Solutions to the Chapter Questions
Chapter 1 AnswersChapter 2 AnswersChapter 3 AnswersChapter 4 AnswersChapter 5 AnswersChapter 6 AnswersChapter 7 AnswersChapter 8 AnswersChapter 9 AnswersChapter 10 AnswersChapter 11 AnswersChapter 12 AnswersChapter 13 AnswersChapter 14 AnswersChapter 15 AnswersChapter 16 AnswersChapter 17 AnswersChapter 18 AnswersChapter 19 AnswersChapter 20 AnswersChapter 21 AnswersChapter 22 AnswersChapter 23 AnswersChapter 24 AnswersChapter 25 AnswersChapter 26 Answers
B. Online Resources
PHP Resource Sites MySQL Resource SitesJavaScript Resource Sites CSS Resource Sites HTML5 Resource Sites Asynchronous Communication Resource Sites Miscellaneous Resource Sites
C. MySQL’s FULLTEXT Stopwords
D. MySQL Functions
String FunctionsDate FunctionsTime Functions
E. jQuery Selectors, Objects, and Methods
jQuery SelectorsjQuery ObjectsjQuery Methods
Index
About the Author
Colophon

Content preview from Learning PHP, MySQL & JavaScript, 5th Edition

About the Author

Robin Nixon has 40 years of experience with writing software and developing websites and apps. He also has an extensive history of writing about computers and technology, with a portfolio of over 500 published magazine articles and over 30 books, many of which have been translated into other languages. In addition, he is a prolific internet video course instructor.

As well as IT, his interests include psychology and motivation (which he also writes about), artificial intelligence research, many types of music (both playing and listening to), playing and creating board games, studying philosophy and culture, and enjoying good food and drink.

Robin lives on the southeast coast of England with his five children and wife, Julie (a trained nurse and university lecturer). Between them they also foster three disabled children. Robin maintains a Facebook page where he keeps up to date with the latest web technologies.

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

Learning PHP, MySQL & JavaScript, 6th Edition

Publisher Resources

ISBN: 9781491979075Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Learning PHP, MySQL & JavaScript, 5th Edition

by Robin Nixon

About the Author

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.