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

4. Introduction to MySQL

In This Chapter

Naming Database Elements

Choosing Your Column Types

Choosing Other Column Properties

Accessing MySQL

Review and Pursue

Because this book discusses how to integrate several technologies—primarily PHP, SQL, and MySQL—a solid understanding of each is important before you begin writing PHP scripts that use SQL to interact with MySQL. This chapter is a departure from its predecessors in that it temporarily leaves PHP behind to delve into MySQL.

MySQL is the world’s most popular open source database application (according to MySQL’s web site, www.mysql.com) and is commonly used with PHP. The MySQL software comes with the database server that stores the actual data, different client applications for interacting ...