Research Catalog

Title

MySQL and PHP from scratch / Wade Maxfield.

Author

Maxfield, Wade

Publication

Indianapolis, Ind. : Que, c2001.

Items in the Library & Off-site

Details

Description

xi, 372 p. : ill.; 23 cm.

Series Statement

Jesse Liberty's from scratch programming series

Uniform Title

Jesse Liberty's programming from scratch series

Alternative Title

MySQL & PHP from scratch

Subject

• SQL (Computer program language)
• PHP (Computer program language)
• Relational databases

Note

• "Integrate Linux, MySQL, Apache, PHP, and IMP into a Web-based email application"--Cover.
• Includes index.

Processing Action (note)

• committed to retain

Contents

Chapter 1 Prerequisite Operational System and Software 5 -- Red Hat Linux 6.0 or Greater Recommended 5 -- How to Check for the Presence of an Installed Package 7 -- How to Install a Needed Package from a CD 10 -- Standalone Usage: How to Verify Required Services Are Installed and Working 12 -- Network Functionality 13 -- General Network Connectivity Guidelines 14 -- Testing Your Network Connection 16 -- System Security 17 -- Initial Security Steps 18 -- Application Upgrades 21 -- Apache Web Server 22 -- Verifying Apache Installation 22 -- Testing the Web Server Locally 24 -- Testing the Web Server from Another Computer 24 -- sendmail 25 -- Verifying sendmail Installation 25 -- sendmail Configuration 26 -- Testing sendmail 29 -- GNU C/C++ Compiler 29 -- Verifying GNU C/C++ Installation 30 -- Testing the Compiler 30 -- Optional Local Network Usage 31 -- How to Connect to an Existing Local Area Network 31 -- Network Usage: Windows-Based Clients 31 -- Chapter 2 Obtaining the Software 33 -- How to Obtain Red Hat 6.2 33 -- Where to Purchase or Download 33 -- How to Obtain MySQL, PHP3, and IMP 34 -- Required File List 34 -- Chapter 3 MySQL 37 -- A Brief History 37 -- What Is MySQL? 38 -- MySQL Description 39 -- How It Works 43 -- What It Does for You 44 -- Getting Online Help for MySQL 44 -- Installation 45 -- Installing the RPM 45 -- A Quick Test of the Install 46 -- Troubleshooting the Install 50 -- Configuration for Use with IMP 50 -- Database System Concepts 54 -- Database Design Tips 55 -- System Design Overview 55 -- General Database Design Issues 55 -- Relational Databases 56 -- Data Identification Techniques 56 -- Database Design Helpers 57 -- Keys 57 -- Correct Utilization of Data 58 -- Modifications to the IMP Database 61 -- Graphical Database Representations 61 -- The IMP Database Structure 62 -- SQL Overview 63 -- MySQL Implements a Subset of SQL 63 -- SQL Keywords 64 -- Typical SQL Statements 66 -- MySQL's License 74 -- Free Use Within Limitations 75 -- Chapter 4 Apache Web Server 77 -- Apache License 77 -- PHP Configuration Overview 78 -- IMP Configuration Overview 79 -- CGI and PHP Server Pages Overview 79 -- How CGI Works 80 -- How PHP Works in the ESL Mode 81 -- Testing the PHP and IMP Configuration 81 -- Security Issues 82 -- Running PHP with Minimal Risk 84 -- Apache Configuration Issues 84 -- Chapter 5 PHP 87 -- A Brief History 87 -- PHP Worldwide Use 88 -- The GNU Public License 88 -- What It Means 88 -- Use of PHP Under the GNU License 89 -- What Is PHP? 90 -- How It Works 90 -- What It Does for You 91 -- Getting Online Help for PHP 92 -- The Software Packages to Obtain 92 -- Apache Development RPM 92 -- PHP3 Source Code 92 -- IMP Source Code 93 -- IMAP Development RPM 93 -- Freetype Development RPM 93 -- Installation 93 -- Troubleshooting the Installation 95 -- PHP in a Nutshell 96 -- General Format 98 -- Strings and Parsing 101 -- Web Page Use 101 -- Apache Web Server 102 -- PHP Use 103 -- Database Interfacing 103 -- Graphics 107 -- Using PHP in HTML Documents 107 -- Chapter 6 IMP 111 -- GPL and GNU Library General Public License 112 -- Use of IMP Under the GNU Public License 112 -- What Is IMP? 112 -- IMP Description 113 -- IMP Installation 113 -- Obtaining the Software 113 -- Configuring the Program 114 -- Installing IMP 115 -- Testing IMP 129 -- Setting Up User Accounts 130 -- Connecting to IMP 131 -- Using IMP 133 -- How IMP Works 137 -- What IMP Does for You 139 -- Getting Online Help for IMP 139 -- Troubleshooting the Install 139 -- Everyday Use of IMP 142 -- Customizing IMP 142 -- Email Inside an Office 143 -- Email on the Internet 144 -- Appendix A PHP Language Reference In this Appendix 147 -- Basic Syntax 149 -- Variables and Types 150 -- Arrays 150 -- Integers 151 -- Floating Point 151 -- Objects 151 -- Resource 152 -- Strings 152 -- Type Casting and Conversion 154 -- Predefined Variables 154 -- Variable Scoping 154 -- Variable Variables 155 -- External Variables 156 -- Constants and Expressions 157 -- Operators 157 -- Arithmetic Operators 158 -- Comparison Operators 158 -- Execution Operators 159 -- Assignment Operators 159 -- Logic Operators 160 -- Reference Operators 161 -- String Operator 162 -- Program Flow Control Statements 162 -- The if Statement 163 -- The else Statement 163 -- The elseif Statement 163 -- The while Statement 163 -- The do/while Statement 163 -- The for Statement 164 -- The switch Statement 164 -- The break Statement 165 -- The continue Statement 165 -- The require and include Statements 165 -- User-Defined Functions 166 -- Classes 168 -- Built-In Functions 170 -- Arrays 170 -- I/O 189 -- Apache Server-Specific 225 -- Calendar and Date / Time 227 -- Databases 236 -- Data Manipulation 258 -- Imaging 259 -- New Image Functions in PHP 4 273 -- IMAP 274 -- Math 293 -- PHP Information and Options 311 -- String Functions 316 -- URL Functions 337 -- Variable Functions 338.

ISBN

0789724405

LCCN

^^^00108842^

OCLC

• 44735940
• SCSB-9983576

Owning Institutions

Harvard Library