- Paperback: 840 pages
- Publisher: John Wiley & Sons (16 Jan 2009)
- Language English
- ISBN-10: 0470391146
- ISBN-13: 978-0470391143
- Product Dimensions: 23.1 x 18.8 x 4.8 cm
- Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)
-
Amazon Bestsellers Rank:
493,065 in Books (See Top 100 in Books)
- #22 in Books > Computers & Internet > Computer Science > Databases > Applications > MySQL > Introduction
- #32 in Books > Computers & Internet > Software & Graphics > Applications > Apache
- #45 in Books > Computers & Internet > Computer Science > Databases > Databases & the Web
- See Complete Table of Contents
 Trade In this Item for up to £24.75
Trade in Beginning PHP 6, Apache, MySQL 6 Web Development for an Amazon.co.uk gift card of up to £24.75, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Product details |
Product Description
Product Description
Apache, MySQL and PHP are each complex in and of themselves, and it′s impossible for this book to cover every advanced detail of all three. The purpose of this book is to give you the best possible foundation for understanding how each of the core components work separately and together, which will enable you to take full advantage of all that they have to offer. When you’ve finished reading this book, you’ll have a thorough understanding of the core concepts you need to be an effective developer using Apache, MySQL, and PHP, and hopefully a burning desire to continue learning and growing as a developer.
We assume that anyone reading this book has some experience with web site development concepts and a basic working knowledge of HTML and CSS. Knowledge of other programming languages besides PHP is not a prerequisite for this book, but certainly any programming experience you have will help you understand and apply the concepts we present.
This book is geared toward the “newbie” to Apache, MySQL, and PHP, and we’ve done our best to distill many of the core concepts and code snippets down to their most basic levels. You will find more complex and perhaps more efficient ways of accomplishing the same tasks we present in this book as your knowledge, comfort level, and experience increase. When that happens, you can congratulate yourself and know that you have come over to the “dark side” to join us as Apache, MySQL, and PHP enthusiasts!
A variety of topics are covered in this book:
Installation and configuration of Apache, MySQL, and PHP
Basic introduction to each component and how they interact with one another
Gathering information from and interacting with your web site visitors
How to avoid errors and how to handle them when they inevitably occur
Creating, altering and working with image files
Handling user registration and logins
E–mailing and setting up e–mail lists
Building a content management system
Enhancing your web site by adding e–commerce capabilities
Incorporating a discussion forum into your site
Monitoring the health of your web site through the use of activity logs and error logs
Selecting a third–party web hosting provider
Finding the text editor that’s right for you
Using multiple interfaces to connect to MySQL from PHP
As you read through the chapters in this book and learn about each of these topics, you will be creating two complete web sites. The first is a movie review site that displays information about films and their respective reviews. This project will cover the basics, such as writing PHP code, creating a MySQL database, filling the database with data and showing specific information to your visitors based on what they want to see.
The second project is a comic book fan web site. This site will be developed in the latter part of the book and will incorporate some of the more complex topics of working with Apache, MySQL and PHP. You will create a truly interactive web site where your visitors can interact with you and with other members of the site.
We take you step by step through the development of each of these sites, and you will continually build upon them as new concepts are introduced. Note, however, that each of the chapters in this book has been designed as a standalone chapter, so that if you are not particularly interested in reading a specific topic then you are free to move on to another.
If you thought the days of the “pop quiz” were over, think again! We have provided handy exercises at the end of most of the chapters to test your knowledge of discussed topic and challenge you to think one step further. We’ve provided answers to these exercises in Appendix A.
This book is designed to be multiplatform and we cover topics and issues for both Windows–based and Linux–based machines. You will need Apache, MySQL and PHP to do the exercises in this book. All three are open source programs, so you can download and use them free of charge. We have provided instructions for downloading and installing all three components in Chapter 1 and Appendix I.
You will also need a text editor to enter your code. Many editors are available that you can use, and some of the more popular ones are compared in Appendix F. Finally, you’ll need a web browser, such as Mozilla Firefox, Internet Explorer, Google Chrome, Apple Safari or Opera to view your web pages.
From the Back Cover
Beginning PHP6, Apache, MySQL® Web Development
With this guide, you′ll quickly learn why the combination of PHP, Apache, and MySQL is rapidly becoming the most popular way to develop dynamic web sites. It gives you the best possible foundation for understanding how the core components work separately and together, enabling you to take full advantage of everything they have to offer.
You′ll discover how to utilize the key features of these technologies as you follow two projects to create complete web sites. These projects take you through the basics, such as writing PHP code, building a MySQL database, filling the database with data, and showing specific information to your visitors. You′ll then incorporate some of the more complex topics of working with PHP, Apache, and MySQL as you progress step by step through the development of each site.
When you′ve finished this book, you′ll have a thorough understanding of the core concepts you need to become an effective developer. Plus you′ll be able to create a well–designed, dynamic web site using freely available tools.
What you will learn from this book
Installation and configuration of PHP, Apache, and MySQL
Ways to avoid errors and how to handle them when they occur
Techniques for creating, altering, and working with image files
Steps for building a content management system
How to monitor your web site through activity logs and error logs
Setting up e–mail lists and handling user registrations
Tips for adding e–commerce capabilities
How to connect to MySQL from PHP
Who this book is for
This book is for PHP beginners who have some experience with web site development concepts and a basic working knowledge of HTML and CSS.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
Inside This Book
(Learn More)
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
5 of 5 people found the following review helpful
I read the reviews to the previous volume (Beginning PHP5... etc ) before buying this book. Some of them put me off - but I decided to try it anyway.
I'm an ex-programmer but have never programmed for Linux or web based stuff before.(ie HTML, PHP, Apache, MySQL, Linux were all new to me)
I can only say that this book is brilliant.
It has given me the experience of writing a complete and fully functional web site with email, mailing lists, members login area's, a document management system, administration facilities and even managed/moderated bulletin-boards.
It would have taken me years to learn this on my own - I reckon it took about 80 hours to work through the entire volume - I got all the code/applications working. There were a few stumbling blocks in the text but mostly the code was good and worked first time. Although it is comprehensive and detailed, you do need your thinking hat on with it sometimes. If you want to learn the nuts and bolts of web building - as opposed to the graphic design - then this for me is a great start.
I'm an ex-programmer but have never programmed for Linux or web based stuff before.(ie HTML, PHP, Apache, MySQL, Linux were all new to me)
I can only say that this book is brilliant.
It has given me the experience of writing a complete and fully functional web site with email, mailing lists, members login area's, a document management system, administration facilities and even managed/moderated bulletin-boards.
It would have taken me years to learn this on my own - I reckon it took about 80 hours to work through the entire volume - I got all the code/applications working. There were a few stumbling blocks in the text but mostly the code was good and worked first time. Although it is comprehensive and detailed, you do need your thinking hat on with it sometimes. If you want to learn the nuts and bolts of web building - as opposed to the graphic design - then this for me is a great start.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
6 reviews
3 of 3 people found the following review helpful
Best PHP book I've found
29 Jan 2011
Amazon Verified Purchase
Ok, I've had this book for over a year now and I'm on my second read-through so it's time for a review. This book is the best book I've found for learning how to code real, useful applications that will please clients and make you money. I credit this book for lifting me up from beginner to intermediate PHP programmer. Highly recommended.
Having said that, I am in agreement with some of the other reviews in that the book suffers from some critical, tragic flaws that need to be taken into account so let's start with the cons:
CONS:
1) Many of the MySQL queries in the book & source code cause errors as written and everything comes to a crashing halt. MySQL errors are extremely cryptic and you will be pulling your hair out trying to figure out what to do with the authors' incorrect query syntax. It's very irritating, because obviously the code was not tested and they should know better. Luckily there is a forum where intrepid explorers have blazed the trail to success before you, but that leads to gripe #2.
2) The book has a support site but the authors are nowhere to be found. The only support you will find are scant users helping other users. Most of the issues with buggy code luckily have been answered by past users, but you have to dig for it. As of this writing, the search feature for the board does not work. You have to read through all the topics to find the one you need. FIX THE SEARCH WROX!
3) The book says "PHP 6" but all the MySQL queries are made with the original MySQL extension, not MySQLI or PDO. This is PHP 4 procedural code. You will not learn the intricacies of PHP OOP.
4) The authors are fond of using what they call "transaction" pages to process database interactions (updates, deletes, creating an account, etc.). This is an interesting approach. The authors show you how to check for errors and send the user back to the original page to display the errors, but they don't tell you how to preserve user input in form fields. Major fail.
5) Functions are introduced that are not explained at all. You have to look them up in the PHP manual.
Ok, now on to the positives:
PROS:
1) I own beginning PHP books by David Powers and Larry Ullman, and they are all good, but this book blows them away in terms of teaching you real-world techniques for creating dynamic, interactive web applications in a way that is fun and interesting without bogging you down in complicated minutia. From the very beginning you will be coding stuff that inspires your creativity. You will begin to think like a programmer. The authors have a light, humorous style of writing that made learning fun.
2) The book really showed me how to code sites that are personalized for registered users. It showed me how to effectively register those users, and track them through the applications, offering personalized data for each of them. What I really liked was how this book takes that approach from the very beginning, and never lets up. In my opinion this is a highly marketable skill set to have under your belt. Once you know the basic techniques for creating this type of application, the sky's the limit on what you can offer your clients. Thanks to this book, I have coded several user-community-oriented web applications for clients.
3) From very early in the book you will be using multiple tables within a database. Many beginning PHP books take a one-table approach most of the way through, then introduce multiple tables at the end. Not this book. You WILL become skilled at using multiple tables, joining the tables in intricate queries to compile custom data sets for your users. I found this very empowering. I now have a MUCH better sense of how to design my database tables and how to get the data I need.
4) The approach is "real world". In other words, there are lots of tricks and techniques in the book that enlightened me in a "Oh, so THAT'S how developers do it" kind of way. This is an extremely valuable asset. Most other books concentrate on syntax and methods but this book shows you "the way its really done". I'm sure there are other, perhaps better ways to get things done, but for a beginner, the methods these authors use was very eye opening and immediately helpful.
5) The book has a large appendix that includes a list of PHP functions. It's like having the PHP manual.
6) At the end of each chapter are optional exercises you can try. I didn't do all of them, but the ones I did really reinforced the learning process.
CONCLUSION:
If you have read other beginner PHP books but want to jack up your game with marketable skills, I strongly urge you to get this book! But be prepared - you will have to work through some frustrating errors in the code as well as a sad lack of support by the authors and publisher. It really is a shame - this book could be absolutely perfect if it's creators would just show some pride and fix the flaws.
Having said that, I am in agreement with some of the other reviews in that the book suffers from some critical, tragic flaws that need to be taken into account so let's start with the cons:
CONS:
1) Many of the MySQL queries in the book & source code cause errors as written and everything comes to a crashing halt. MySQL errors are extremely cryptic and you will be pulling your hair out trying to figure out what to do with the authors' incorrect query syntax. It's very irritating, because obviously the code was not tested and they should know better. Luckily there is a forum where intrepid explorers have blazed the trail to success before you, but that leads to gripe #2.
2) The book has a support site but the authors are nowhere to be found. The only support you will find are scant users helping other users. Most of the issues with buggy code luckily have been answered by past users, but you have to dig for it. As of this writing, the search feature for the board does not work. You have to read through all the topics to find the one you need. FIX THE SEARCH WROX!
3) The book says "PHP 6" but all the MySQL queries are made with the original MySQL extension, not MySQLI or PDO. This is PHP 4 procedural code. You will not learn the intricacies of PHP OOP.
4) The authors are fond of using what they call "transaction" pages to process database interactions (updates, deletes, creating an account, etc.). This is an interesting approach. The authors show you how to check for errors and send the user back to the original page to display the errors, but they don't tell you how to preserve user input in form fields. Major fail.
5) Functions are introduced that are not explained at all. You have to look them up in the PHP manual.
Ok, now on to the positives:
PROS:
1) I own beginning PHP books by David Powers and Larry Ullman, and they are all good, but this book blows them away in terms of teaching you real-world techniques for creating dynamic, interactive web applications in a way that is fun and interesting without bogging you down in complicated minutia. From the very beginning you will be coding stuff that inspires your creativity. You will begin to think like a programmer. The authors have a light, humorous style of writing that made learning fun.
2) The book really showed me how to code sites that are personalized for registered users. It showed me how to effectively register those users, and track them through the applications, offering personalized data for each of them. What I really liked was how this book takes that approach from the very beginning, and never lets up. In my opinion this is a highly marketable skill set to have under your belt. Once you know the basic techniques for creating this type of application, the sky's the limit on what you can offer your clients. Thanks to this book, I have coded several user-community-oriented web applications for clients.
3) From very early in the book you will be using multiple tables within a database. Many beginning PHP books take a one-table approach most of the way through, then introduce multiple tables at the end. Not this book. You WILL become skilled at using multiple tables, joining the tables in intricate queries to compile custom data sets for your users. I found this very empowering. I now have a MUCH better sense of how to design my database tables and how to get the data I need.
4) The approach is "real world". In other words, there are lots of tricks and techniques in the book that enlightened me in a "Oh, so THAT'S how developers do it" kind of way. This is an extremely valuable asset. Most other books concentrate on syntax and methods but this book shows you "the way its really done". I'm sure there are other, perhaps better ways to get things done, but for a beginner, the methods these authors use was very eye opening and immediately helpful.
5) The book has a large appendix that includes a list of PHP functions. It's like having the PHP manual.
6) At the end of each chapter are optional exercises you can try. I didn't do all of them, but the ones I did really reinforced the learning process.
CONCLUSION:
If you have read other beginner PHP books but want to jack up your game with marketable skills, I strongly urge you to get this book! But be prepared - you will have to work through some frustrating errors in the code as well as a sad lack of support by the authors and publisher. It really is a shame - this book could be absolutely perfect if it's creators would just show some pride and fix the flaws.
3 of 3 people found the following review helpful
This book could have been so much better
16 Aug 2010
Amazon Verified Purchase
If you are easily frustrated or do not enjoy debugging other peoples code, this book is definitely not for you. There are many, many places in this book where you will complete the tutorials and then attempt to execute the code only to find that you are (a) not getting the results the authors say that you should be getting or (b) you are not getting any results at all (except maybe an error message). I was able to work my way through this book by making frequent visits to the Wrox user forum for this title to see what fixes others have come up with for the bad code and by trolling the internet for solutions to some of the problems not discussed in the forum. I also wasted almost a month trying to get the PHP mail function running on my windows machine before giving up and migrating all my files to a unix server.
I don't know who is to blame for all the errors in this book - the authors or the publishers - but there are lots of them, especially in Chapters 13 - 16. Yet I feel like I learned a lot from this book, because I have a hands-on learning style, and if everything worked right the first time, there would be no challenge to the learning process.
This book has some really good tutorials and covers a lot of ground, but it could be a whole lot better if the authors and the publishers would get their heads together and fix some of the errors.
I don't know who is to blame for all the errors in this book - the authors or the publishers - but there are lots of them, especially in Chapters 13 - 16. Yet I feel like I learned a lot from this book, because I have a hands-on learning style, and if everything worked right the first time, there would be no challenge to the learning process.
This book has some really good tutorials and covers a lot of ground, but it could be a whole lot better if the authors and the publishers would get their heads together and fix some of the errors.
Best book for real applications
1 April 2010
If you are looking for a book that gives you real world applications this is it. However, this book does not go through every little detail and then say make an application. It actually gives you an application then goes into how it works. So if you are a person that likes to learn everything upfront and then tries to make applications from what you have learned then this book might not be for you. But, if you are like me and like to see how these applications are built and learn from "reverse engineering" then this is for you. I have yet to have a problem with the code; however, I do agree with others that it is a must, when learning a new language, to draw from more than one book as a learning tool.
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > MySQL > Introduction
- Books > Computing & Internet > Databases > Databases & the Web
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages > PHP
- Books > Computing & Internet > Web Development > Web Design > Website Design
- Books > Computing & Internet > Web Development > Web-server Software > Apache
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
