《使用PHP&MySQL构建自己的数据驱动网站(Build Your Own Database Driven Web Site Using PHP&MySQL)_Kevin Yank》pdf电子书免费下载
下载方式一：
百度网盘下载地址：https://pan.baidu.com/s/1um_hQofnrx8E5eUSWRUh8A
百度网盘密码：1111
下载方式二：
http://ziliaoshare.cn/Download/af_124459_pd_SYPHP&MySQLGJZJDSJQDWZ(BuildYourOwnDatabaseDrivenWebSiteUsingPHP&MySQL)_KevinYank.zip
|
|
作者：empty 页数：506 出版社：empty |
《使用PHP&MySQL构建自己的数据驱动网站(Build Your Own Database Driven Web Site Using PHP&MySQL)_Kevin Yank》介绍
PrefacePHP and MySQL have changedBack in 2001， when I wrote the first edition of this book， readers were astonishedto discover that you could create a site full of webpages without having to write aseparate HTML file for each page.PHP stood out from the crowd of programminglanguages， mainly because it was easy enough for almost anyone to learn and freeto download and install.The MySQL database， likewise， provided a simple andfree solution to a problem that， up until that point， had been solvable only by expertprogrammers with corporate budgets，Back then， PHP and MySQL were special—heck， they were downright miraculous!But over the years， they have gained plenty of fast-moving competition.In an agewhen anyone with a free WordPress account can setup a full-featured blog in 30seconds flat， it'sno longer enough for a programming language like PHP to be easyto learn； nor is it enough for a database like MySQL to be free.Indeed， as you sitdown to read this book， you probably have ambitions that extendbeyond what you can throw together using the free point-and-click tools of the Web.You might even be thinking of building an exciting， new point-and-click tool ofyour own， WordPress， after all， is built using PHP and MySQL， so why limit yourvision to anything less?To keep up with the competition， and with the needs of more demanding projects，PHP and MySQL have had to evolve.PHP is now a far more intricate and powerfullanguage than it was back in 2001， and MySQL is a vastly more complex and capabledatabase.Learning PHP and MySQL today opens up alot of doors that would haveremained closed to the PHP and MySQL experts of 2001，Thats the good news.The bad news is tha， in the same way that a butter knife iseasier to figure out than a Swiss Army knife(and less likely to cause self-injury!)all these dazzling new features and improvements have indisputably made PHPand MySQL more dificult for beginners to learn，Worse yet， PHP has completely abandoned several of the beginner-friendly featuresthat gave it a competitive advantage in 2001， because they turned out to be over sim-pl ifications， or could lead inexperienced programmers into building websites withgaping security holes.This is a problem if you're the author of a beginners bookabout PHP and MySQL.
PHP and MySQL have changed， and those changes have made writing this book alot more difficult.But they have also made this book alot more important The moretwisty the path， the more valua blo the map， right?In this book， Tll provide you with a hands-on look at whats involved in buildinga database driven website using PHP and MySQL.If your webhost provides PHPand MySQL support， you're in great shape.lf not， Ill show you howto install themon Windows， MacOSX， and Linux computers， so don't sweat itThis book is your map to the twisty path that every beginner must navigate to learnPHP and MySQL today.Grab your favorite walking stick； let's go hiking!Who Should Read This BookThis book is aimed at intermediate and advanced webdesigners looking to makethe leap into server-side programming.You'll be expected to be comfortable withsimple HTML， as IT l make use of it without much in the way of explanation.Noknowledge of Cascading StyleSheets(CSS J or JavaScript is assumed or required，but if you do know JavaScript.you'll find it will make learning PHP a breeze， sincethese languages are quite similar.By the end of this book.you can expect to have a grasp of what's involved inbuilding a database driven website.If you follow the examples.you'll also learnthe basics of PHP(a server-side scripting language that gives you easy access to adatabase， and alot more J and Structured Query Language(SQL-the standardlanguage for interacting with relational databases) as supported by MySQL.the mostpopular free database engine available today.Most importantly.you'll come awaywith everything you need to start on your very own database driven site!What'sin This BookThis book comprises the following 12 chapters.Read them in order from beginningto end to gain a complete understanding of the subject， or skip around if you onlyneed a refresher on a particular topic.
Before you can start building your database driven website， you must first ensurethat you have the right tools for the job.In this first chapter， Ill tell you whereto obtain the two essential components you'll need：the PHP scripting languageand the MySQL database management system.Ill step you through the setupprocedures on Windows， Linux， and MacOSX， and show you howto test thatPHP is operational on your webserver.Chapter2：IntroducingMySQLAlthoughT'm sure youll be anxious to start building dynamic webpages.Tlbegin with an introduction to databases in general.and the MySQL relationaldatabase management system in particular.If you have never worked with arelational database before， this should definitely bean enlightening chapter thatwill whet your appetite for what's to come!In the process， you'll buildup asimple database to be used in later chapters.Chapter3：IntroducingPHPHere's where the fun really starts.In this chapter， I'll introduce you to the PHPscripting language， which you can use to build dynamic webpages that presentup-to-the-moment information to your visitors.Readers with previous program-ming experience will probably only need a quick skim of this chapter， as I ex-plain the essentials of the language from the ground up.This is a must-readchapter for beginners， however， as the rest of this hook relies heavily on thebasic concepts presented here.Chapter4：PublishingMySQLDataontheWebIn this chapter you'll bring together PHP and MySQL， which you'Tl have seenseparately in the previous chapters， to create some of your first database drivenwebpages.You'll explore the basic techniques of using PHP to retrieve inform-ation from a database and display it on the Web in realtime.Tll also show youhowto use PHP to create web-based forms for adding new entries to.andmodifying existing information in， a MySQL database on the fly.
《使用PHP&MySQL构建自己的数据驱动网站(Build Your Own Database Driven Web Site Using PHP&MySQL)_Kevin Yank》目录
Evaluat on Warning：The document was created with Spire.PDF for.NET.
Summary of Contents
Preface.
1.Installation.
2.Introducing MySQL.
3.Introducing PHP.
4.Publishing MySQL Data on the Web.
5.Relational Database Design.
6.Structured PHP Programming.
7.A Content Management System.
8.Content Formatting with Regular Expressions
9.Cookies， Sessions， and AccessControl.
10.MySQL Administration.
11.Advanced SQL Queries.
12.Binary Data.
A.MySQL Syntax Reference.
B.MySQL Functions.
C.MySQL Column Types.
D.PHP Functions for Working with MySQL.
Index.
DATABASE DRIVEN WEB
SITE USING PHP&MYSQL
sitepoint
An Introduction to Databases.
Logging On to MySQL.
Structured Query Language.
Creating a Database.
Creating a Table， .
Inserting Data into a Table.
Viewing Stored Data.
Modifying Stored Data.
Deleting Stored Data.
Let PHP Do the Typing.
Chapter 3
Introducing PHP.
Basic Syntax and Statements.
Variables， Operators， and Comments.
Arrays.
User Interaction and Forms.
Control Structures.
Hiding the Seams.
Bring On the Database.
Chapter 4
Avoid Advertising Your Technology Choices.
Use PHP Templates.
Many Templates， One Controller.
Giving Credit Where Credit is Due.
Rul c of Thumb：Keep Entities Separate.
SELECT with Multiple Tables.
Simple Relationships.
Many-to-Many Relationships.
One for Many， and Many for One.
Custom Functions and Function Libraries.
Structure in Practice：Template Helpers.
Publishing MySQL Data on the
Web
Relational Database Design.
Structured PHP Programming . 171
A Content Management System . 197
The Big Picture.
Include Files.
Connecting to MySQL with PHP.
Sending SQL Queries with PHP.
Handling SELECT ResultSets.
Inserting Data into the Database.
Deleting Data from the Database.
Mission Accomplished.
Chapter 5
Chapter 6
Managing Authors.
Including HTML Content.
Including PHP Code.
Types of Includes.
Shared Include Files.
Variable Scope and Global Access.
The Best Way.
Chapter 7
The FrontPage.
Deleting Authors.
Adding and Editing Authors.
Searching for Jokes.
Adding and Editing Jokes.
Deleting Jokes.
Summary.
Chapter 8
Content Formatting with Regular
Expressions.
Cookies， Sessions， and Access
Control
Advanced SQL Queries.
String Replacement with Regular Expressions.
Real World Content Submission.
Chapter 9
Cookies.
Chapter 10 MySQL Administration.
Boldface and Italic Text.
Paragraphs.
Hyperlinks.
Matching lags.
Putting It All Together.
A Simple ShoppingCart.
AccessControl.
Managing Passwords and Roles
Sorting SELECT Query Results.
Database Design.
Controller Code.
Function Library.
Setting LIMITs.
Handling File Uploads.
A Challenge：Joke Moderation.
The Sky's the Limit.
phpMyAdmin.
Backing Up MySQL Databases.
MySQL AccessControl.
Checking and Repairing MySQL DataFiles.
Better Safe than Sorry.
Chapter 11
xiii
Database Backups Using mysqldump.
In ere mental Backups Using Binary Logs.
Granting Privileges.
Revoking Privileges.
AccessControl Tips.
Locked Out?.
LOCKing TABLES.
Column and TableName Aliases.
GROUPing SELECT Results.
LEFT JOINs.
Limiting Results with HAVING.
Further Reading.
Chapter 12Binary Data.
Semi-dynamic Pages.
Appendix A MySQL Syntax Reference.
Recording Uploaded Files in the Database.
Putting It All Together.
Large File Considerations.
SQL Statements Implemented in MySQL.
Appendix B MySQL Functions.
Binary Column Types.
Storing Files.
Viewing Stored Files.
MySQL Packet Size.
PHP Script Timeout.
The End.
ALTER TABLE.
ANALYZE TABLE.
CREATE DATABASE.
CREATE INDEX.
CREATE TABLE.
DELETE.
DESCRIBEDESC.
DROP DATABASE.
DROP INDEX.
DROP TABLE.
EXPLAIN.
GRANT.
LOAD DATA IN FILE.
LOCKUNLOCK TABLES.
OPTIMIZE TABLE.
INSERT，
RENAME TABLE.
REPLACE.
REVOKE.
SELECT.
SET.
SHOW.
TRUNCATE.
UNLOCK TABLES.
UPDATE.
USE.
Control Flow Functions.
Mathematical Functions.
String Functions.
DateandTime Functions.
Mis cell an co us Functions.
Numerical Types.
Character Types.
DateTime Types.
mysqli_affected_rows.
mysqli_character_set_name.
mysqli_close.
mysql