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 III

Creating and Using Relational Databases with MySQL

In Chapters 7 and 8, you saw how with PHP you can read and write a disk file. While that worked, it was limited in that you had to read the entire file into memory and search it there to do what was needed. In Part III, you’ll see how MySQL, a full-fledged relational database management system (RDBMS), greatly enhances the process of reading, writing, maintaining, changing, searching, and rearranging information stored in computer files. It is the third major tool used to make websites dynamic, and while a website requires HTML and PHP in addition to MySQL, MySQL does the heavy lifting when it comes to the handling of data.

Chapter 9 introduces databases and describes what makes them ...