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

8. Error Handling and Debugging

In This Chapter

Error Types and Basic Debugging

Displaying PHP Errors

Adjusting Error Reporting in PHP

Creating Custom Error Handlers

PHP Debugging Techniques

SQL and MySQL Debugging Techniques

Review and Pursue

If you’re working through this book sequentially (which would be for the best), the next subject to learn is how to use PHP and MySQL together. However, that process will undoubtedly generate errors, errors that can be tricky to debug. So before moving on to new concepts, these next few pages address the bane of the programmer: errors. As you gain experience, you’ll make fewer errors and learn your own debugging methods, but there are plenty of tools and techniques the beginner can use to help ease the ...