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

Overview

Essential Skills—Made Easy!

PHP and MySQL Web Development: A Beginner's Guide takes you from building static web pages to creating comprehensive database-driven web applications. The book reviews HTML, CSS, and JavaScript and then explores PHP--its structure, control statements, arrays, functions, use with forms, and file handling capabilities. Next, the book examines MySQL, including SQL, the MySQL command set, and how to use it with PHP to create a relational database and build secure, databasedriven web applications. This practical resource features complete, step-by-step examples with code that you can use as templates for your own projects.

Designed for Easy Learning

Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter
Try This--Hands-on exercises that show you how to apply your skills
Notes--Extra information related to the topic being covered
Tips--Helpful reminders or alternate ways of doing things
Cautions--Errors and pitfalls to avoid
Self Tests--End-of-chapter quizzes to reinforce your skills
Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

Ready-to-use code at www.mhprofessional.com