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

Part IV

Powering Databases with MySQL and PHP

In previous chapters you saw how PHP provides a strong programming language, and then how MySQL provides a full-featured relational database. In Part IV you’ll see how PHP and MySQL work together with HTML, CSS, and JavaScript to allow you to build extremely capable and powerful web applications to handle a wide range of needs.

Chapter 12 describes how PHP is used with MySQL to create, access, and query a database. It reviews the types of queries; how information entered into website forms is used to create new records in database tables; and then how information in a database is read, formatted, and displayed on a web page. Finally, the chapter looks at how to detect and handle errors and security ...