
PHP and MySQL Web Development: A Beginner s Guide
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Intro
- 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 Tool
- Full-Featured Development Packages
- Powerful Alternatives
- Choosing a Testing Server
- Testing Environment
- Using Testing Browsers
- Considering Other Factors
- 2 Building Web Pages with HTML
- HTML5
- Using HTML5
- Setting Up Aptana
- Reviewing HTML
- Using Basic Tags
- Using Global Attributes
- Setting Paragraph Styles
- Applying Character Styles
- Displaying Special Characters
- Working with Images and Image Maps
- Adding Hyperlinks and Bookmarks
- Defining Forms
- Creating Tables
- Using New HTML5 Tags
- Understanding Deprecated HTML Tags
- HTML Authoring Resources
- 3 Styling with CSS
- Creating CSS
- Attaching CSS
- Understanding CSS Rules
- Selecting What to Format
- CSS Properties and Values
- Applying CSS Concepts
- Using Text Properties
- Implementing Page Properties
- Laying Out with CSS
- 4 Adding Dynamic Elements with JavaScript
- Introducing JavaScript
- Characteristics of JavaScript
- JavaScript Introduction
- Using JavaScript with HTML Pages
- JavaScript Basics
- Writing and Testing JavaScript
- Parts of JavaScript
- Variables and Constants
- Operators
- Statements and Expressions
- Functions
- Objects
- Control Structures
- If/Else Statements
- While and Do-While Statements
- For Statement
- Switch Statements
- Introducing Event Handlers
- Placing Event Handlers in Your Code
- Understanding Event Handler Syntax and Usage
- Working with the Window Event Handlers
- Displaying Messages When a Page Opens/Closes
- Placing and Removing Focus
- Resizing a Window
- Using the Mouse and Keyboard Event Handlers
- Working with onclick, ondblclick, and Arrays
- Moving the Mouse Pointer to Trigger Events
- Using the Keyboard Event Handlers
- Reviewing Forms
- Understanding Forms
- Creating Forms Using HTML
- Using JavaScript in Forms
- Naming Forms on a Web Page
- Form Properties and Methods
- Working with Form Element Properties and Methods
- Validating a Form
- Understanding Validation
- Using Validation with Passwords
- Part II Exercising the Server with PHP
- 5 Fundamentals of PHP
- About PHP
- Tools Needed for PHP
- Preparing a PHP Workstation
- PHP Introduction
- Integrating PHP with HTML
- Writing and Testing PHP
- PHP Basics
- Parts of PHP
- Types of Information
- Variables and Constants
- Operators
- Statements and Expressions
- Functions
- 6 PHP Control and File Handling
- Control Structures
- if/else Statements
- while and do-while Statements
- for and foreach Statements
- switch Statements
- PHP File and Directory Management
- Basic File Functions
- Additional File Functions
- Cookies and Session and Server Variables
- Session Variables
- Cookies
- Server Variables
- 7 PHP Arrays and Forms
- Using Arrays
- Creating Arrays
- Working with Arrays
- Looping Through Arrays
- Sorting Arrays
- Navigating in Arrays
- Converting Arrays To and From Strings
- Joining and Splitting Arrays
- Comparing Arrays
- Handling Multidimensional Arrays
- Building and Handling Forms
- Create a Form in HTML
- Add JavaScript to a Form
- Accepting and Filing Form Data in PHP
- 8 Putting PHP to Use
- User Authentication
- Create an Index Script
- Add Registration Scripts
- Insert Sign-In Scripts
- Attach a Site Page
- Part III Creating and Using Relational Databases with MySQL
- 9 Introduction to Relational Databases
- Databases and Relational Databases
- Understanding Databases
- Understanding a Relational Database
- Using phpMyAdmin
- Get and Install phpMyAdmin
- Opening and Exploring phpMyAdmin
- Create and Use a Database in phpMyAdmin
- 10 Fundamentals of MySQL and SQL
- About MySQL
- Installing and Using MySQL Workbench
- Understanding SQL
- Using MySQL
- Exploring the MySQL Language
- Reviewing MySQL Word Usage
- Using MySQL Operators
- Exploring MySQL Functions
- 11 Implementing MySQL Command Statements
- MySQL Commands
- Understanding the MySQL Command Structure
- Preparing the MySQL Workbench
- Create Databases and Tables
- Creating and Using a Database
- Creating a Table and Its Columns
- Reviewing MySQL Data Types
- Insert Data into Tables
- Inserting Data
- Select, Replace, Update, and Delete Data in Tables
- Selecting Data
- Replacing Data
- Updating Data
- Deleting Data
- Alter, Rename, and Drop Tables and Databases
- Altering Tables and Databases
- Renaming Tables
- Dropping Tables and Databases
- Create and Use Events, Views, and Triggers
- Using Events
- Using Views
- Using Triggers
- Part IV Powering Databases with MySQL and PHP
- 12 Using a MySQL Database with PHP
- Bringing PHP and MySQL Together
- Database Manipulation
- Database Information
- Database Administration
- Combining PHP MySQL Functions
- Working with Forms and Databases
- Expanding PHP Form Handling
- Facilitating User Interaction
- Interacting with a Database
- Improving Security
- 13 Registering and Responding to Users
- Application Design
- Design Template and CSS
- Database Design
- Creating the Scripts
- Administrator Authentication
- Database Entry and Maintenance
- 14 Handling Online Purchases
- Application Design
- Design Template and CSS
- Database Design
- Creating the Book List and Customer Sales Scripts
- Book List and Selection
- Customer Sign-in and Verification
- Sales and Confirmation
- Invoicing
- Building an Invoice
- Deleting Sales
- Writing an Invoice Record
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.