Muutke küpsiste eelistusi

Sams Teach Yourself PHP, MySQL and Apache All in One 4th edition [Multiple-component retail product]

3.53/5 (52 hinnangut Goodreads-ist)
  • Formaat: Multiple-component retail product, 648 pages, kõrgus x laius x paksus: 182x230x37 mm, kaal: 1068 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 26-Jun-2008
  • Kirjastus: Sams Publishing
  • ISBN-10: 067232976X
  • ISBN-13: 9780672329760
Teised raamatud teemal:
  • Multiple-component retail product
  • Hind: 43,08 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Sams Teach Yourself PHP, MySQL and Apache All in One 4th editionSuurem pilt
  • Formaat: Multiple-component retail product, 648 pages, kõrgus x laius x paksus: 182x230x37 mm, kaal: 1068 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 26-Jun-2008
  • Kirjastus: Sams Publishing
  • ISBN-10: 067232976X
  • ISBN-13: 9780672329760
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780672329760.html
Märksõnad:
In just a short time, you can learn how to use PHP, MySQL, and Apache together to create dynamic, interactive websites and applications using the three leading open-source web development technologies.

 

Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of PHP scripting, MySQL databases, and the Apache web server from the ground up.

 

Regardless of whether you run Linux, Windows, or Mac OS X, the enclosed CD includes a complete starter kit that lets you install all the software you need to set up a stable environment for learning, testing, and production.

 

Learn how to





Install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server Get these technologies to work together to create a dynamic, database-backed website Interact with MySQL using PHP Work with forms and files Create a web-based discussion forum or mailing list Add a storefront and shopping cart to your site Optimize your MySQL databases Fine-tune the Apache servers performance Restrict access to your applications Set up a secure web server

 

CD-ROM Includes





A complete PHP, MySQL, and Apache starter kit for Windows®, Linux®, or Mac® OS X.

 

Muu info

Sams Teach Yourself PHP, MySQL® and Apache All in One

 

Fourth Edition

 

Julie C. Meloni

 

Starter Kit

CD-ROM includes a complete starter kit for Windows®, Linux®, and Mac® OS X

 

In just a short time, you can learn how to use PHP, MySQL, and Apache together to create dynamic, interactive websites and applications using the three leading open-source web development technologies.

 

Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of PHP scripting, MySQL databases, and the Apache web server from the ground up.

 

Regardless of whether you run Linux, Windows, or Mac OS X, the enclosed CD includes a complete starter kit that lets you install all the software you need to set up a stable environment for learning, testing, and production.

 

Learn how to





Install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server Get these technologies to work together to create a dynamic, database-backed website Interact with MySQL using PHP Work with forms and files Create a web-based discussion forum or mailing list Add a storefront and shopping cart to your site Optimize your MySQL databases Fine-tune the Apache servers performance Restrict access to your applications Set up a secure web server

 

Julie C. Meloni is the technical director for i2i Interactive, a multimedia company located in Los Altos, California. She has been developing web-based applications since the early days of the web, and is the author of several books and articles on web-based programming languages and database topics, including Sams Teach Yourself MySQL in 24 Hours.

 

CD-ROM Includes





A complete PHP, MySQL, and Apache starter kit for Windows®, Linux®, or Mac® OS X.

 

Category: Web Development

Covers: PHP 5.2, MySQL 5, Apache 2.2

User Level: Beginning

 
Introduction 1(1)
Who Should Read This Book?
1(1)
How This Book Is Organized
2(1)
About the Book's Source Code
3(1)
Conventions Used in This Book
3(4)
Part I: Getting Up and Running
Installation QuickStart Guide
7(14)
Linux/UNIX Installation
7(3)
Windows Installation
10(6)
Mac OS X Installation
16(4)
Troubleshooting
20(1)
Installing and Configuring MySQL
21(22)
Current and Future Versions of MySQL
21(1)
How to Get MySQL
22(1)
Installing MySQL on Linux/UNIX
22(2)
Installing MySQL on Mac OS X
24(2)
Installing MySQL on Windows
26(6)
Troubleshooting Your Installation
32(1)
Basic Security Guidelines
33(2)
Introducing the MySQL Privilege System
35(2)
Working with User Privileges
37(2)
Summary
39(1)
Q&A
40(1)
Workshop
40(3)
Installing and Configuring Apache
43(22)
Current and Future Versions of Apache
43(1)
Choosing the Appropriate Installation Method
44(1)
Installing Apache on Linux/UNIX
45(2)
Installing Apache on Mac OS X
47(1)
Installing Apache on Windows
48(2)
Apache Configuration File Structure
50(6)
Apache Log Files
56(1)
Apache-Related Commands
57(1)
Starting Apache for the First Time
58(2)
Troubleshooting
60(2)
Summary
62(1)
Q&A
62(1)
Workshop
63(2)
Installing and Configuring PHP
65(22)
Current and Future Versions of PHP
65(1)
Building PHP on Linux/UNIX with Apache
66(3)
Installing PHP on Mac OS X
69(2)
Installing PHP on Windows
71(2)
php. ini Basics
73(1)
Testing Your Installation
74(1)
Getting Installation Help
74(2)
The Basics of PHP Scripts
76(5)
Summary
81(1)
Q&A
81(1)
Workshop
82(5)
Part II: PHP Language Structure
The Building Blocks of PHP
87(24)
Variables
87(3)
Data Types
90(6)
Operators and Expressions
96(9)
Constants
105(2)
Summary
107(1)
Q&A
107(1)
Workshop
108(3)
Flow Control Functions in PHP
111(20)
Switching Flow
111(6)
Loops
117(8)
Code Blocks and Browser Output
125(2)
Summary
127(1)
Q&A
128(1)
Workshop
128(3)
Working with Functions
131(18)
What Is a Function?
131(1)
Calling Functions
132(1)
Defining a Function
133(3)
Returning Values from User-Defined Functions
136(1)
Variable Scope
137(3)
Saving State Between Function Calls with the Static Statement
140(2)
More About Arguments
142(3)
Testing for the Existence of a Function
145(1)
Summary
146(1)
Q&A
147(1)
Workshop
147(2)
Working with Arrays
149(10)
What Are Arrays?
149(1)
Creating Arrays
150(4)
Some Array-Related Functions
154(2)
Summary
156(1)
Q&A
156(1)
Workshop
156(3)
Working with Objects
159(12)
Creating an Object
159(5)
Object Inheritance
164(2)
Summary
166(1)
Q&A
166(1)
Workshop
167(4)
Part III: Getting Involved with the Code
Working with Strings, Dates, and Time
171(30)
Formatting Strings with PHP
172(8)
Investigating Strings in PHP
180(4)
Manipulating Strings with PHP
184(7)
Using Date and Time Functions in PHP
191(6)
Other String, Date, and Time Functions
197(1)
Summary
197(1)
Workshop
198(3)
Working with Forms
201(22)
Creating a Simple Input Form
201(2)
Accessing Form Input with User-Defined Arrays
203(3)
Combining HTML and PHP Code on a Single Page
206(2)
Using Hidden Fields to Save State
208(1)
Redirecting the User
209(2)
Sending Mail on Form Submission
211(6)
Working with File Uploads
217(4)
Summary
221(1)
Workshop
221(2)
Working with Cookies and User Sessions
223(16)
Introducing Cookies
223(2)
Setting a Cookie with PHP
225(2)
Deleting a Cookie with PHP
227(1)
Session Function Overview
227(1)
Starting a Session
228(1)
Working with Session Variables
229(4)
Passing Session IDs in the Query String
233(1)
Destroying Sessions and Unsetting Variables
234(1)
Using Sessions in an Environment with Registered Users
234(1)
Summary
235(1)
Q&A
236(1)
Workshop
236(3)
Working with Files and Directories
239(30)
Including Files with include()
239(5)
Validating Files
244(4)
Creating and Deleting Files
248(1)
Opening a File for Writing, Reading, or Appending
249(1)
Reading from Files
250(5)
Writing or Appending to a File
255(2)
Working with Directories
257(3)
Opening Pipes to and from Processes Using popen()
260(2)
Running Commands with exec()
262(1)
Running Commands with system() or passthru()
263(2)
Summary
265(1)
Q&A
266(1)
Workshop
266(3)
Working with Images
269(24)
Understanding the Image-Creation Process
269(1)
Necessary Modifications to PHP
270(1)
Drawing a New Image
271(4)
Getting Fancy with Pie Charts
275(4)
Modifying Existing Images
279(3)
Image Creation from User Input
282(4)
Using Images Created by Scripts
286(2)
Summary
288(1)
Q&A
289(1)
Workshop
289(4)
Part IV: PHP and MySQL Integration
Understanding the Database Design Process
293(12)
The Importance of Good Database Design
293(1)
Types of Table Relationships
294(4)
Understanding Normalization
298(3)
Following the Design Process
301(2)
Summary
303(1)
Q&A
303(1)
Workshop
303(2)
Learning Basic SQL Commands
305(48)
Learning the MySQL Data Types
306(3)
Learning the Table Creation Syntax
309(1)
Using the INSERT Command
310(2)
Using the SELECT Command
312(3)
Using WHERE in Your Queries
315(2)
Selecting from Multiple Tables
317(6)
Using the UPDATE Command to Modify Records
323(2)
Using the REPLACE Command
325(1)
Using the DELETE Command
326(2)
Frequently Used String Functions in MySQL
328(8)
Using Date and Time Functions in MySQL
336(12)
Summary
348(1)
Q&A
349(1)
Workshop
350(3)
Using Transactions and Stored Procedures in MySQL
353(8)
What Are Transactions?
353(4)
What Are Stored Procedures?
357(2)
Summary
359(1)
Q&A
359(1)
Workshop
359(2)
Interacting with MySQL Using PHP
361(14)
MySQL Versus MySQLi Functions
361(1)
Connecting to MySQL with PHP
361(4)
Working with MySQL Data
365(6)
Summary
371(1)
Q&A
372(1)
Workshop
372(3)
Part V: Basic Projects
Managing a Simple Mailing List
375(14)
Developing the Subscription Mechanism
375(8)
Developing the Mailing Mechanism
383(3)
Summary
386(1)
Q&A
387(1)
Workshop
387(2)
Creating an Online Address Book
389(26)
Planning and Creating the Database Tables
389(3)
Creating an Include File for Common Functions
392(1)
Creating a Menu
393(1)
Creating the Record Addition Mechanism
394(4)
Viewing Records
398(7)
Creating the Record Deletion Mechanism
405(2)
Adding Subentries to a Record
407(5)
Summary
412(1)
Q&A
413(1)
Workshop
413(2)
Creating a Simple Discussion Forum
415(18)
Designing the Database Tables
415(1)
Creating an Include File for Common Functions
416(1)
Creating the Input Forms and Scripts
417(4)
Displaying the Topic List
421(3)
Displaying the Posts in a Topic
424(4)
Adding Posts to a Topic
428(3)
Summary
431(1)
Q&A
431(1)
Workshop
432(1)
Creating an Online Storefront
433(12)
Planning and Creating the Database Tables
433(4)
Displaying Categories of Items
437(4)
Displaying Items
441(3)
Summary
444(1)
Workshop
444(1)
Creating a Shopping Cart Mechanism
445(14)
Planning and Creating the Database Tables
445(2)
Integrating the Cart with Your Storefront
447(8)
Payment Methods and the Checkout Sequence
455(2)
Summary
457(1)
Workshop
458(1)
Creating a Simple Calendar
459(22)
Building a Simple Display Calendar
459(14)
Creating a Calendar Library
473(6)
Summary
479(1)
Q&A
479(1)
Workshop
480(1)
Restricting Access to Your Applications
481(20)
Authentication Overview
481(2)
Apache Authentication Module Functionality
483(5)
Using Apache for Access Control
488(2)
Combining Apache Access Methods
490(1)
Limiting Access Based on HTTP Methods
491(1)
Restricting Access Based on Cookie Values
492(5)
Summary
497(1)
Q&A
498(1)
Workshop
498(3)
Logging and Monitoring Web Server Activity
501(16)
Standard Apache Access Logging
501(6)
Standard Apache Error Logging
507(2)
Managing Apache Logs
509(2)
Logging Custom Information to a Database
511(4)
Summary
515(1)
Q&A
516(1)
Workshop
516(1)
Application Localization
517(12)
About Internationalization and Localization
517(1)
About Character Sets
518(1)
Environment Modifications
519(2)
Creating a Localized Page Structure
521(5)
Summary
526(1)
Q&A
526(1)
Workshop
527(2)
Working with XML
529(14)
What Is XML?
529(3)
Accessing XML in PHP Using DOM Functions
532(3)
Accessing XML in PHP Using SimpleXML Functions
535(3)
Summary
538(1)
Q&A
538(1)
Workshop
539(4)
Part VI: Administration and Fine-Tuning
Apache Performance Tuning and Virtual Hosting
543(18)
Scalability Issues
543(4)
Load Testing with ApacheBench
547(2)
Proactive Performance Tuning
549(2)
Preventing Abuse
551(1)
Implementing Virtual Hosting
552(5)
Summary
557(1)
Q&A
557(1)
Workshop
558(3)
Setting Up a Secure Web Server
561(14)
The Need for Security
561(1)
The SSL Protocol
562(5)
Obtaining and Installing SSL Tools
567(3)
Managing Certificates
570(2)
SSL Configuration
572(1)
Summary
573(1)
Q&A
574(1)
Workshop
574(1)
Optimizing and Tuning MySQL
575(16)
Building an Optimized Platform
575(2)
MySQL Startup Options
577(2)
Optimizing Your Table Structure
579(1)
Optimizing Your Queries
580(1)
Using the FLUSH Command
581(1)
Using the SHOW Command
582(6)
Summary
588(1)
Q&A
589(1)
Workshop
589(2)
Software Upgrades
591(6)
Staying in the Loop
591(2)
Upgrading MySQL
593(1)
Upgrading Apache
593(2)
Upgrading PHP
595(1)
Summary
595(1)
Workshop
596(1)
Index 597
Julie C. Meloni

is the technical director for i2i Interactive (http://www.i2ii.com), a multimedia company located in Los Altos, California. She has been developing web-based applications since the Web first saw the light of day and remembers the excitement surrounding the first GUI web browser. She has authored numerous books and articles on web-based programming

languages and database topics, and you can find translations of her work in 15 different languages. She is also a fervent blogger and is the author of Sams Teach Yourself Blogging in a Snap. Most days, Julie can be found wandering the halls of Avery Hall on the campus of Washington State University, where she is a Ph.D. student in English who is quite interested in digital/social scholarship in the humanities.