برای استفاده از امکانات سیستم، گزینه جاوا اسکریپت در مرورگر شما باید فعال باشد
صفحه
از
0
PHP and MySQL for dummies
Valade, Janet.
اطلاعات کتابشناختی
PHP and MySQL for dummies
Author :
Valade, Janet.
Publisher :
Wiley Pub.,
Pub. Year :
2004
Subjects :
PHP (Computer program language) SQL (Computer program language) Web sites -- Design.
Call Number :
QA 76 .73 .P224 .V35 2004
جستجو در محتوا
ترتيب
شماره صفحه
امتياز صفحه
فهرست مطالب
PHP and MySQL for Dummies, Second Edition
(1)
Cover
(1)
Table of Contents
(14)
Introduction
(22)
About This Book
(22)
Conventions Used in This Book
(23)
What You're Not to Read
(24)
Foolish Assumptions
(24)
How This Book Is Organized
(25)
Part I: Developing a Web Database Application Using PHP and MySQL
(25)
Part II: MySQL Database
(25)
Part III: PHP
(25)
Part IV: Applications
(25)
Part V: The Part of Tens
(26)
Part VI: Appendixes
(26)
Icons Used in This Book
(26)
Where to Go from Here
(26)
Part I: Developing a Web Database Application Using PHP and MySQL
(28)
Chapter 1: Introduction to PHP and MySQL
(30)
What Is a Web Database Application?
(31)
The database
(32)
The application: Moving data in and out of the database
(33)
MySQL, My Database
(33)
Advantages of MySQL
(34)
How MySQL works
(35)
Communicating with the MySQL server
(35)
PHP, a Data Mover
(36)
Advantages of PHP
(37)
How PHP works
(37)
MySQL and PHP, the Perfect Pair
(38)
Advantages of the relationship
(39)
How MySQL and PHP work together
(39)
Keeping Up with PHP and MySQL Changes
(40)
Chapter 2: Setting Up Your Work Environment
(42)
The Required Tools
(42)
Finding a Place to Work
(43)
A company Web site
(43)
A Web hosting company
(45)
Setting up and running your own Web site
(48)
Testing, Testing, 1, 2, 3
(53)
Testing PHP
(53)
Testing MySQL
(55)
Chapter 3: Developing a Web Database Application
(58)
Planning Your Web Database Application
(58)
Identifying what you want from the application
(59)
Taking the user into consideration
(61)
Making the site easy to use
(62)
Leaving room for expansion
(63)
Writing it down
(63)
Presenting the Two Running Examples in This Book
(63)
Stuff for Sale
(64)
Members Only
(64)
Designing the Database
(65)
Choosing the data
(65)
Organizing the data
(67)
Designing the Sample Databases
(72)
Pet Catalog design process
(72)
Members Only design process
(74)
Types of Data
(77)
Character data
(77)
Numerical data
(78)
Date and time data
(78)
Enumeration data
(78)
MySQL data type names
(79)
Writing it down
(80)
Taking a Look at the Sample Database Designs
(80)
Stuff for Sale database tables
(80)
Members Only database tables
(81)
Developing the Application
(82)
Building the database
(83)
Writing the programs
(83)
Part II: MySQL Database
(84)
Chapter 4: Building the Database
(86)
Communicating with MySQL
(86)
Building SQL queries
(87)
Sending SQL queries
(88)
Building a Database
(93)
Creating a new database
(94)
Deleting a database
(94)
Adding tables to a database
(94)
Changing the database structure
(97)
Moving Data In and Out of the Database
(98)
Adding information
(98)
Retrieving information
(102)
Combining information from tables
(107)
Updating information
(111)
Removing information
(112)
Chapter 5: Protecting Your Data
(114)
Controlling Access to Your Data
(114)
Understanding account names and hostnames
(115)
Finding out about passwords
(117)
Taking a look at account permissions
(118)
Setting Up MySQL Accounts
(119)
Identifying what accounts currently exist
(121)
Adding new accounts and changing permissions
(121)
Adding and changing passwords
(123)
Removing permissions
(123)
Removing accounts
(124)
Backing Up Your Data
(125)
Restoring Your Data
(127)
Repairing tables
(128)
Restoring from a backup copy
(129)
Part III: PHP
(135)
Chapter 6: General PHP
(136)
Adding a PHP Section to an HTML Page
(136)
Writing PHP Statements
(139)
Using PHP Variables
(142)
Naming a variable
(142)
Creating and assigning values to variables
(143)
Dealing with notices
(144)
Using PHP Constants
(145)
Working with Numbers
(146)
Working with Character Strings
(148)
Single-quoted strings versus double-quoted strings
(149)
Joining strings
(151)
Working with Dates and Times
(151)
Formatting a date
(152)
Storing a timestamp in a variable
(153)
Using dates with MySQL
(154)
Comparing Values
(155)
Making simple comparisons
(156)
Matching character strings to patterns
(158)
Joining Comparisons with and/or/xor
(162)
Adding Comments to Your Program
(164)
Chapter 7: PHP Building Blocks for Programs
(166)
Useful Simple Statements
(167)
Using echo statements
(168)
Using assignment statements
(171)
Using increment statements
(172)
Using exit
(173)
Using function calls
(174)
Using PHP Arrays
(174)
Creating arrays
(175)
Viewing arrays
(176)
Removing values from arrays
(177)
Sorting arrays
(177)
Getting values from arrays
(179)
Walking through an array
(181)
Multidimensional arrays
(183)
Useful Conditional Statements
(186)
Using if statements
(187)
Using switch statements
(190)
Using Loops
(191)
Using for loops
(192)
Using while loops
(195)
Using do while loops
(197)
Infinite loops
(198)
Breaking out of a loop
(200)
Using Functions
(202)
Using variables in functions
(204)
Passing values between a function and the main program
(205)
Using built-in functions
(209)
Chapter 8: Data In, Data Out
(210)
PHP/MySQL Functions
(210)
Making a Connection
(212)
Connecting to the MySQL server
(212)
Selecting the right database
(215)
Sending SQL queries
(216)
Getting Information from a Database
(218)
Sending a SELECT query
(218)
Getting and using the data
(219)
Using functions to get data
(225)
Getting Information from the User
(229)
Using HTML forms
(230)
Making forms dynamic
(235)
Using the information from the form
(248)
Checking the information
(251)
Giving users a choice with multiple submit buttons
(259)
Putting Information into a Database
(261)
Preparing the data
(262)
Adding new information
(264)
Updating existing information
(269)
Getting Information in Files
(272)
Using a form to upload the file
(272)
Processing the uploaded file
(273)
Putting it all together
(274)
Chapter 9: Moving Information from One Web Page to the Next
(278)
Moving Your User from One Page to Another
(278)
Moving Information from Page to Page
(282)
Adding information to the URL
(283)
Storing information via cookies
(288)
Passing information with HTML forms
(290)
Using PHP Sessions
(291)
How PHP sessions work
(291)
Opening sessions
(292)
Using PHP session variables
(292)
Sessions without cookies
(295)
Making sessions private
(297)
Closing PHP sessions
(298)
Part IV: Applications
(300)
Chapter 10: Putting It All Together
(302)
Organizing the Application
(302)
Organizing at the application level
(303)
Organizing at the program level
(304)
Keeping It Private
(309)
Ensure the security of the computer
(310)
Don't let the Web server display filenames
(310)
Hide things
(311)
Don't trust information from users
(311)
Use a secure Web server
(312)
Completing Your Documentation
(312)
Chapter 11: Building an Online Catalog
(314)
Designing the Application
(314)
Showing pets to the customers
(315)
Adding pets to the catalog
(316)
Building the Database
(316)
Building the Pet table
(317)
Building the PetType table
(320)
Building the Color table
(321)
Adding data to the database
(322)
Designing the Look and Feel
(324)
Showing pets to the customers
(324)
Adding pets to the catalog
(328)
Writing the Programs
(331)
Showing pets to the customers
(331)
Adding pets to the catalog
(337)
Chapter 12: Building a Members Only Web Site
(352)
Designing the Application
(353)
Building the Database
(354)
Building the Member table
(354)
Building the Login table
(357)
Adding data to the database
(358)
Designing the Look and Feel
(358)
Storefront page
(359)
Login page
(359)
New Member Welcome page
(362)
Members Only section
(363)
Writing the Programs
(363)
Writing PetShopFront
(364)
Writing Login
(365)
Writing New_member
(377)
Writing the Members Only section
(379)
Planning for Growth
(379)
Part V: The Part of Tens
(382)
Chapter 13: Ten Things You Might Want to Do Using PHP Functions
(384)
Communicate with MySQL
(384)
Send E-Mail
(385)
Use PHP Sessions
(387)
Stop Your Program
(387)
Handle Arrays
(387)
Check for Variables
(388)
Format Values
(388)
Compare Strings to Patterns
(390)
Find Out about Strings
(390)
Change the Case of Strings
(391)
Chapter 14: Ten PHP Gotchas
(392)
Missing Semicolons
(392)
Not Enough Equal Signs
(393)
Misspelled Variable Names
(393)
Missing Dollar Signs
(393)
Troubling Quotes
(394)
Invisible Output
(394)
Numbered Arrays
(395)
Including PHP Statements
(396)
Missing Mates
(396)
Confusing Parentheses and Brackets
(397)
Part VI: Appendixes
(398)
Appendix A: Installing MySQL
(400)
On Windows
(400)
Downloading and installing MySQL
(401)
Starting the MySQL server
(402)
Setting up the server to start when the computer starts
(404)
On Linux/Unix
(405)
Using RPM (Linux only)
(405)
From binary files
(407)
From source files
(410)
On Mac
(412)
Configuring MySQL
(414)
Appendix B: Installing PHP
(416)
Installing PHP on Unix/Linux/Mac with Apache
(416)
On Unix/Linux
(416)
On Mac OS X
(419)
Installation Options
(422)
Configuring Apache for PHP
(424)
On Windows
(424)
Configuring Your Web Server for PHP
(426)
Configuring Apache
(426)
Configuring IIS
(428)
Configuring PHP
(428)
Appendix C: Installing and Configuring Apache
(430)
Selecting a Version of Apache
(430)
Installing Apache
(431)
On Linux/Unix
(431)
On Windows
(435)
On Mac
(439)
Configuring Apache
(440)
Changing settings
(440)
Changing the location of your Web space
(441)
Changing the port number
(441)
Index
(442)
Team DDU
(1)
