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

17. Example—Message Board

In This Chapter

Making the Database

Writing the Templates

Creating the Index Page

Creating the Forum Page

Creating the Thread Page

Posting Messages

Review and Pursue

The functionality of a message board (aka a forum) is rather simple: a post can either start a new topic or be in response to an existing one; posts are added to a database and then displayed on a page. That’s about it. Of course, sometimes implementing simple concepts can be quite hard!

To make this example even more exciting and useful, it’s going to be not just a message board but rather a multilingual message board. Each language will have its own forum, and the key elements—navigation, prompts, introductory text, etc.—will be language-specific.