Sams Teach Yourself PHP, MySQL and Apache in 24 Hours - Julie C. Meloni


Sams Teach Yourself PHP, MySQL and Apache in 24 HoursJulie C. Meloni - 2002.

   Sams Teach Yourself PHP, MySQL, and Apache in 24 Hours combines coverage of these three popular open-source Web development tools into one easy-to-understand book
  The book teaches the reader to install, configure and set up the PHP scripting language, the MySQL database system, and the Apache Web server.
  By the end of this book the reader will understand how these technologies work, and -- more importantly -- how they can work together to create a dynamic Web site.
  After creating a simple Web site using these tools, the reader will be able to manage a simple mailing list, and to create an online address book, shopping cart, and storefront.
  The book also teaches the reader how to fine tune Apache and MySQL, and covers simple Web server security.

Sams Teach Yourself PHP






Бесплатно скачать электронную книгу в удобном формате и читать:

Скачать книгу Sams Teach Yourself PHP, MySQL and Apache in 24 Hours - Julie C. Meloni - fileskachat.com, быстрое и бесплатное скачивание.

Скачать



Скачать - fileskachat 2.

Скачать - fileskachat 3.


Скачать книгу  Sams Teach Yourself PHP, MySQL and Apache in 24 Hours -  Julie C. Meloni - depositfiles

Copyright
Lead Author
Contributing Authors
Acknowledgments
We Want to Hear from You!
Reader Services
Introduction
Who Should Read This Book?
How This Book Is Organized
Conventions Used in This Book

Part I:  Getting Up and Running
Hour 1.  Installing and Configuring MySQL
How to Get MySQL
Installing MySQL on Linux/Unix
Installing MySQL on Windows
Troubleshooting Your Installation
Basic Security Guidelines
Introducing the MySQL Privilege System
Working with User Privileges
Summary
Q&A
Workshop

Hour 2.  Installing and Configuring Apache
Choosing the Appropriate Installation Method
Installing Apache on Linux/Unix
Installing Apache on Windows
Apache Configuration File Structure
Apache Log Files
Apache-Related Commands
Starting Apache for the First Time
Troubleshooting
Summary
Q&A
Workshop

Hour 3.  Installing and Configuring PHP
Building PHP on Linux/Unix with Apache
Installing PHP Files on Windows
php.ini Basics
Testing Your Installation
Getting Installation Help
The Basics of PHP Scripts
Summary
Q&A
Workshop


Part II:  Basic Language Elements
Hour 4.  The Building Blocks of PHP
Variables
Data Types
Operators and Expressions
Constants
Summary
Q&A
Workshop

Hour 5.  Flow Control Functions in PHP
Switching Flow
Loops
Code Blocks and Browser Output
Summary
Q&A
Workshop

Hour 6.  Working with Functions
What Is a Function?
Calling Functions
Defining a Function
Returning Values from User-Defined Functions
Dynamic Function Calls
Variable Scope
Saving State Between Function Calls with the static Statement
More About Arguments
Creating Anonymous Functions
Testing for the Existence of a Function
Summary
Q&A
Workshop

Hour 7.  Learning Basic SQL Commands
Learning the MySQL Data Types
Learning the Table Creation Syntax
Using the INSERT Command
Using the SELECT Command
Using WHERE in Your Queries
Selecting from Multiple Tables
Using JOIN
Using the UPDATE Command to Modify Records
Using the REPLACE Command
Using the DELETE Command
Summary
Q&A
Workshop

Hour 8.  Interacting with MySQL Using PHP
Connecting to MySQL with PHP
Working with MySQL Data
Summary
Workshop


Part III:  Getting Involved with the Code
Hour 9.  Working with Forms
Predefined Variables
Creating a Simple Input Form
Accessing Form Input with User-Defined Arrays
Combining HTML and PHP Code on a Single Page
Using Hidden Fields to Save State
Redirecting the User
Sending Mail on Form Submission
Creating the Form
Creating the Script to Send the Mail
Working with File Uploads
Summary
Workshop

Hour 10.  Working with Files
Including Files with include()
include_once()
Testing Files
Creating and Deleting Files
Opening a File for Writing, Reading, or Appending
Reading from Files
Writing or Appending to a File
Working with Directories
Summary
Q&A
Workshop

Hour 11.  Working with Dates and Times
Using Date and Time Functions in PHP
Using Date and Time Functions in MySQL
Summary
Workshop

Hour 12.  Creating a Simple Calendar
Building a Simple Display Calendar
Creating a Calendar Library
Summary
Q&A
Workshop

Hour 13.  Working with Strings
Formatting Strings with PHP
Investigating Strings in PHP
Manipulating Strings with PHP
Frequently Used String Functions in MySQL
Summary
Q&A
Workshop

Hour 14.  Creating a Simple Discussion Forum
Types of Table Relationships
Understanding Normalization
Following the Design Process
Creating a Discussion Forum
Summary
Q&A
Workshop

Hour 15.  Restricting Access to Your Applications
Authentication Overview
Apache Authentication Module Functionality
Using Apache for Access Control
Combining Apache Access Methods
Limiting Access Based on HTTP Methods
Introducing Cookies
Setting a Cookie with PHP
Restricting Access Based on Cookie Values
Summary
Q&A
Workshop

Hour 16.  Working with User Sessions
Session Function Overview
Starting a Session
Working with Session Variables
Passing Session IDs in the Query String
Destroying Sessions and Unsetting Variables
Summary
Q&A
Workshop

Hour 17.  Logging and Monitoring Server Activity
Standard Apache Access Logging
Standard Apache Error Logging
Managing Apache Logs
Logging Custom Information to a Database
Summary
Q&A
Workshop


Part IV:  Simple Projects
Hour 18.  Managing a Simple Mailing List
Developing the Subscription Mechanism
Developing the Mailing Mechanism
Summary
Q&A
Workshop

Hour 19.  Creating an Online Address Book
Planning and Creating the Database Tables
Creating a Menu
Creating the Record Addition Mechanism
Viewing Records
Creating the Record Deletion Mechanism
Adding Subentries to a Record
Summary
Workshop

Hour 20.  Creating an Online Storefront
Planning and Creating the Database Tables
Displaying Categories of Items
Displaying Items
Summary
Workshop

Hour 21.  Creating a Shopping Cart Mechanism
Planning and Creating the Database Tables
Integrating the Cart with Your Storefront
Payment Methods and the Checkout Sequence
Summary
Workshop


Part V:  Administration and Fine-Tuning
Hour 22.  Apache Performance Tuning and Virtual Hosting
Scalability Issues
Load Testing with ApacheBench
Proactive Performance Tuning
Preventing Abuse
Implementing Virtual Hosting
Summary
Q&A
Workshop

Hour 23.  Setting Up a Secure Web Server
The Need for Security
The SSL Protocol
Installing SSL
Managing Certificates
SSL Configuration
Summary
Q&A
Workshop

Hour 24.  Optimizing and Tuning MySQL
Building an Optimized Platform
MySQL Startup Options
Optimizing Your Table Structure
Optimizing Your Queries
Using the FLUSH Command
Using the SHOW Command
Summary
Q&A
Workshop
Index

Скачать книгу  Sams Teach Yourself PHP, MySQL and Apache in 24 Hours -  Julie C. Meloni

Скачать книгу  Sams Teach Yourself PHP, MySQL and Apache in 24 Hours -  Julie C. Meloni - depositfiles
Дата публикации:





Теги: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: :: ::


 


 


Книги, учебники, обучение по разделам




Не нашёл? Найди:





2016-12-05 23:02:34