book

PHP and MySQL Web Development: A Beginner’s Guide

by Marty Matthews

January 2015

Beginner

624 pages

12h 27m

English

McGraw-Hill

Read now

Unlock full access

Picking a Development ToolFull-Featured Development PackagesPowerful AlternativesChoosing a Testing ServerTesting EnvironmentUsing Testing BrowsersConsidering Other Factors

HTML5Using HTML5Setting Up AptanaReviewing HTMLUsing Basic TagsUsing Global AttributesSetting Paragraph StylesApplying Character StylesDisplaying Special CharactersWorking with Images and Image MapsAdding Hyperlinks and BookmarksDefining FormsCreating TablesUsing New HTML5 TagsUnderstanding Deprecated HTML TagsHTML Authoring Resources
Creating CSSAttaching CSSUnderstanding CSS RulesSelecting What to FormatCSS Properties and ValuesApplying CSS ConceptsUsing Text PropertiesImplementing Page PropertiesLaying Out with CSS
Introducing JavaScriptCharacteristics of JavaScriptJavaScript IntroductionUsing JavaScript with HTML PagesJavaScript BasicsWriting and Testing JavaScriptParts of JavaScriptVariables and ConstantsOperatorsStatements and ExpressionsFunctionsObjectsControl StructuresIf/Else StatementsWhile and Do-While StatementsFor StatementSwitch StatementsIntroducing Event HandlersPlacing Event Handlers in Your CodeUnderstanding Event Handler Syntax and UsageWorking with the Window Event HandlersDisplaying Messages When a Page Opens/ClosesPlacing and Removing FocusResizing a WindowUsing the Mouse and Keyboard Event HandlersWorking with onclick, ondblclick, and ArraysMoving the Mouse Pointer to Trigger EventsUsing the Keyboard Event HandlersReviewing FormsUnderstanding FormsCreating Forms Using HTMLUsing JavaScript in FormsNaming Forms on a Web PageForm Properties and MethodsWorking with Form Element Properties and MethodsValidating a FormUnderstanding ValidationUsing Validation with Passwords
About PHPTools Needed for PHPPreparing a PHP WorkstationPHP IntroductionIntegrating PHP with HTMLWriting and Testing PHPPHP BasicsParts of PHPTypes of InformationVariables and ConstantsOperatorsStatements and ExpressionsFunctions
Control Structuresif/else Statementswhile and do-while Statementsfor and foreach Statementsswitch StatementsPHP File and Directory ManagementBasic File FunctionsAdditional File FunctionsCookies and Session and Server VariablesSession VariablesCookiesServer Variables
Using ArraysCreating ArraysWorking with ArraysLooping Through ArraysSorting ArraysNavigating in ArraysConverting Arrays To and From StringsJoining and Splitting ArraysComparing ArraysHandling Multidimensional ArraysBuilding and Handling FormsCreate a Form in HTMLAdd JavaScript to a FormAccepting and Filing Form Data in PHP
User AuthenticationCreate an Index ScriptAdd Registration ScriptsInsert Sign-In ScriptsAttach a Site Page
Databases and Relational DatabasesUnderstanding DatabasesUnderstanding a Relational DatabaseUsing phpMyAdminGet and Install phpMyAdminOpening and Exploring phpMyAdminCreate and Use a Database in phpMyAdmin
About MySQLInstalling and Using MySQL WorkbenchUnderstanding SQLUsing MySQLExploring the MySQL LanguageReviewing MySQL Word UsageUsing MySQL OperatorsExploring MySQL Functions
MySQL CommandsUnderstanding the MySQL Command StructurePreparing the MySQL WorkbenchCreate Databases and TablesCreating and Using a DatabaseCreating a Table and Its ColumnsReviewing MySQL Data TypesInsert Data into TablesInserting DataSelect, Replace, Update, and Delete Data in TablesSelecting DataReplacing DataUpdating DataDeleting DataAlter, Rename, and Drop Tables and DatabasesAltering Tables and DatabasesRenaming TablesDropping Tables and DatabasesCreate and Use Events, Views, and TriggersUsing EventsUsing ViewsUsing Triggers
Bringing PHP and MySQL TogetherDatabase ManipulationDatabase InformationDatabase AdministrationCombining PHP MySQL FunctionsWorking with Forms and DatabasesExpanding PHP Form HandlingFacilitating User InteractionInteracting with a DatabaseImproving Security
Application DesignDesign Template and CSSDatabase DesignCreating the ScriptsAdministrator AuthenticationDatabase Entry and Maintenance
Application DesignDesign Template and CSSDatabase DesignCreating the Book List and Customer Sales ScriptsBook List and SelectionCustomer Sign-in and VerificationSales and ConfirmationInvoicingBuilding an InvoiceDeleting SalesWriting an Invoice Record

Content preview from PHP and MySQL Web Development: A Beginner’s Guide

Acknowledgments

This book, as with most, is a team effort of many truly talented people. Among them are the following:

Christie Sorenson, technical editor extraordinaire, who corrected many errors, added many tips and notes, and greatly improved the book. Throughout the process, Christie has been a joy to work with. Thanks, Christie!

Amanda Russell, editorial coordinator, queen of the McGraw-Hill Education labyrinth and Apple permissions, and a true Wonder Woman, who makes it all happen! She tries hard to keep us on schedule; accounts for all the chapters, pages, and illustrations; and gets everything to the right people. And she does all this with a light touch and a smile in her email voice. Thanks, Amanda!

Lisa McCoy, copy editor, who added ...