book

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fifth Edition

by Larry Ullman

November 2017

Intermediate to advanced

705 pages

26h 56m

English

Peachpit Press

Read now

Unlock full access

Basic SyntaxSending Data to the BrowserWriting CommentsWhat Are Variables?Introducing StringsConcatenating StringsIntroducing NumbersIntroducing ConstantsSingle vs. Double Quotation MarksBasic Debugging StepsReview and Pursue
Creating an HTML FormHandling an HTML FormConditionals and OperatorsValidating Form DataIntroducing ArraysFor and While LoopsReview and Pursue
Including Multiple FilesHandling HTML Forms, RevisitedMaking Sticky FormsCreating Your Own FunctionsReview and Pursue
Naming Database ElementsChoosing Your Column TypesChoosing Other Column PropertiesAccessing MySQLReview and Pursue

Creating Databases and TablesInserting RecordsSelecting DataUsing ConditionalsUsing LIKE and NOT LIKESorting Query ResultsLimiting Query ResultsUpdating DataDeleting DataUsing FunctionsReview and Pursue
NormalizationCreating IndexesUsing Different Table TypesLanguages and MySQLTime Zones and MySQLForeign Key ConstraintsReview and Pursue
Performing JoinsGrouping Selected ResultsAdvanced SelectionsPerforming FULLTEXT SearchesOptimizing QueriesPerforming TransactionsDatabase EncryptionReview and Pursue
Error Types and Basic DebuggingDisplaying PHP ErrorsAdjusting Error Reporting in PHPCreating Custom Error HandlersPHP Debugging TechniquesSQL and MySQL Debugging TechniquesReview and Pursue
Modifying the TemplateConnecting to MySQLExecuting Simple QueriesRetrieving Query ResultsEnsuring Secure SQLCounting Returned RecordsUpdating Records with PHPReview and Pursue
Sending Values to a ScriptUsing Hidden Form InputsEditing Existing RecordsPaginating Query ResultsMaking Sortable DisplaysReview and Pursue
Sending EmailHandling File UploadsPHP and JavaScriptUnderstanding HTTP HeadersDate and Time FunctionsPerforming TransactionsReview and Pursue
Making a Login PageMaking the Login FunctionsUsing CookiesUsing SessionsImproving Session SecurityReview and Pursue
Preventing SpamValidating Data by TypeValidating Files by TypePreventing XSS AttacksUsing the Filter ExtensionPreventing SQL Injection AttacksSecuring Passwords with PHPReview and Pursue
Creating a Test ScriptDefining Simple PatternsUsing QuantifiersUsing Character ClassesFinding All MatchesUsing ModifiersMatching and Replacing PatternsReview and Pursue
What Is jQuery?Incorporating jQueryUsing jQuerySelecting Page ElementsEvent HandlingDOM ManipulationUsing AjaxReview and Pursue
Fundamentals and SyntaxWorking with MySQLThe DateTime ClassReview and Pursue
Making the DatabaseWriting the TemplatesCreating the Index PageCreating the Forum PageCreating the Thread PagePosting MessagesReview and Pursue
Creating the TemplatesWriting the Configuration ScriptsCreating the Home PageRegistrationActivating an AccountLogging In and Logging OutPassword ManagementReview and Pursue
Installation on WindowsInstallation on macOSManaging MySQL UsersTesting Your InstallationConfiguring PHPConfiguring Apache

Content preview from PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fifth Edition

Visual QuickPro Guide

PHP and MySQL for Dynamic Web Sites, Fifth Edition

Larry Ullman

Peachpit Presswww.peachpit.com

To report errors, please send a note to: errata@peachpit.comPeachpit Press is a division of Pearson Education.

Editor: Mark TaberCopy Editor: Elizabeth WelchTechnical Reviewer: Timothy BoronczykProduction Coordinator: David Van NessCompositor: Danielle FosterProofreader: Scout FestaIndexer: Valerie Haynes PerryCover Design: RHDG / Riezebos Holzbaur Design Group, Peachpit PressInterior Design: Peachpit PressLogo Design: MINE™ www.minesf.com

Notice of Rights

This publication is protected by copyright, and permission should be obtained from the publisher prior to any prohibited reproduction, storage ...

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.

Start your free trial

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

Publisher Resources

ISBN: 9780134301945

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fifth Edition

by Larry Ullman

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.

You might also like

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fourth Edition

PHP 7 Solutions: Dynamic Web Design Made Easy

Mastering PHP 7

Publisher Resources

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.

You might also like

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fourth Edition

PHP 7 Solutions: Dynamic Web Design Made Easy

Mastering PHP 7

Publisher Resources

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.