book

PHP and MySQL Web Development: A Beginner’s Guide

Name: PHP and MySQL Web Development: A Beginner’s Guide
Author: Marty Matthews
ISBN: 9780071837316

by Marty Matthews

January 2015

Beginner

624 pages

12h 27m

English

McGraw-Hill

Read now

Unlock full access

Cover
Title Page
Copyright Page
Dedication
Contents at a Glance
Contents
Acknowledgments
Introduction
Part I Getting Ready
1 Setting Up Your Workstation
Picking a Development ToolFull-Featured Development PackagesPowerful AlternativesChoosing a Testing ServerTesting EnvironmentUsing Testing BrowsersConsidering Other Factors

2 Building Web Pages with HTML
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
3 Styling with CSS
Creating CSSAttaching CSSUnderstanding CSS RulesSelecting What to FormatCSS Properties and ValuesApplying CSS ConceptsUsing Text PropertiesImplementing Page PropertiesLaying Out with CSS
4 Adding Dynamic Elements with JavaScript
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
Part II Exercising the Server with PHP
5 Fundamentals of PHP
About PHPTools Needed for PHPPreparing a PHP WorkstationPHP IntroductionIntegrating PHP with HTMLWriting and Testing PHPPHP BasicsParts of PHPTypes of InformationVariables and ConstantsOperatorsStatements and ExpressionsFunctions
6 PHP Control and File Handling
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
7 PHP Arrays and Forms
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
8 Putting PHP to Use
User AuthenticationCreate an Index ScriptAdd Registration ScriptsInsert Sign-In ScriptsAttach a Site Page
Part III Creating and Using Relational Databases with MySQL
9 Introduction to Relational Databases
Databases and Relational DatabasesUnderstanding DatabasesUnderstanding a Relational DatabaseUsing phpMyAdminGet and Install phpMyAdminOpening and Exploring phpMyAdminCreate and Use a Database in phpMyAdmin
10 Fundamentals of MySQL and SQL
About MySQLInstalling and Using MySQL WorkbenchUnderstanding SQLUsing MySQLExploring the MySQL LanguageReviewing MySQL Word UsageUsing MySQL OperatorsExploring MySQL Functions
11 Implementing MySQL Command Statements
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
Part IV Powering Databases with MySQL and PHP
12 Using a MySQL Database with PHP
Bringing PHP and MySQL TogetherDatabase ManipulationDatabase InformationDatabase AdministrationCombining PHP MySQL FunctionsWorking with Forms and DatabasesExpanding PHP Form HandlingFacilitating User InteractionInteracting with a DatabaseImproving Security
13 Registering and Responding to Users
Application DesignDesign Template and CSSDatabase DesignCreating the ScriptsAdministrator AuthenticationDatabase Entry and Maintenance
14 Handling Online Purchases
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
Index

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

Contents at a Glance

1 Setting Up Your Workstation

2 Building Web Pages with HTML

3 Styling with CSS

4 Adding Dynamic Elements with JavaScript

5 Fundamentals of PHP

6 PHP Control and File Handling

7 PHP Arrays and Forms

8 Putting PHP to Use

9 Introduction to Relational Databases

10 Fundamentals of MySQL and SQL

11 Implementing MySQL Command Statements

12 Using a MySQL Database with PHP

13 Registering and Responding to Users

14 Handling Online Purchases

Index

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Learn to Build Web Applications with PHP, MySQL, and JavaScript

Publisher Resources

ISBN: 9780071837309

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

PHP and MySQL Web Development: A Beginner’s Guide

by Marty Matthews

Contents at a Glance

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.