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

18. Example—User Registration

In This Chapter

Creating the Templates

Writing the Configuration Scripts

Creating the Home Page

Registration

Activating an Account

Logging In and Logging Out

Password Management

Review and Pursue

The second example in the book—a user registration system—has already been touched on in several other chapters, because the registration, login, and logout processes make for good examples of many concepts. But this chapter will place all those ideas within the same context using a consistent programming approach.

Users will be able to register, log in, log out, and change their password. This chapter includes three features not shown elsewhere: the ability to reset a password, should it be forgotten; the requirement ...