PHP and MySQL Web Development

by Luke Welling, Laura Thomson

PHP and MySQL Web Development, Fifth Edition The definitive guide to building database-driven Web applications with PHP and MySQL PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications. PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server. This practical, hands-on book consistently focuses on real-world applications, even in the introductory chapters. The authors cover important aspects of security and authentication as they relate to building a real-world website and show you how to implement these aspects in PHP and MySQL. They also introduce you to the integration of front-end and back-end technologies by using JavaScript in your application development. The final part of this book describes how to approach real-world projects and takes the reader through the design, planning, and building of several projects, User authentication and personalization Web-based email Social media integration Shopping cart The fifth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP through versions 5.6 and 7, as well as features introduced in recent stable releases of MySQL. Free Access to Web Edition Purchase of this book in any format, electronic or print, includes free access to the corresponding Web Edition, which provides several special The complete text of the book online Exercises and interactive quizzes to test your understanding of the material Bonus chapters not included in the print or e-book editions Updates and corrections as they become available The Web Edition can be viewed on all types of computers and mobile devices with any modern web browser that supports HTML5. Contents at a Glance Part Using PHP 1  PHP Crash Course 2  Storing and Retrieving Data 3  Using Arrays 4  String Manipulation and Regular Expressions 5  Reusing Code and Writing Functions 6  Object-Oriented PHP 7  Error and Exception Handling Part Using MySQL 8  Designing Your Web Database 9  Creating Your Web Database 10 Working with Your MySQL Database 11 Accessing Your MySQL Database from the Web with PHP 12 Advanced MySQL Administration 13 Advanced MySQL Programming Part Web Application Security 14 Web Application Security Risks 15 Building a Secure Web Application 16 Implementing Authentication Methods with PHP Part Advanced PHP Techniques 17 Interacting with the File System and the Server 18 Using Network and Protocol Functions 19 Managing the Date and Time 20 Internationalization and Localization 21 Generating Images 22 Using Session Control in PHP 23 Integrating JavaScript and PHP 24 Other Useful Features Part Building Practical PHP and MySQL Projects 25 Using PHP and MySQL for Large Projects 26 Debugging and Logging 27 Building User Authentication and Personalization 28 (Web Edition) Building a Web-Based Email Client with Laravel Part I 29 (Web Edition) Building a Web-Based Email Client with Laravel Part II 30 (Web Edition) Social Media Integration Sharing and Authentication 31 (Web Edition) Building a Shopping Cart Part Appendix A Installing Apache, PHP, and MySQL

Genres: Programming, Reference, Nonfiction, Technical, Computers, Web, Technology

Kindle Edition

First published February 12, 2003

Reviews

[imane · Rating 5 out of 5]

لم اقم باكمال الكتاب قرات فقط جزء
php mysql
جزء الحماية ساتركه لوقت اخر
الكتاب بالنسبة لشخص مبتدئ ممتاز والامثلة بسيطة

[Nawal Al-Qussyer · Rating 4 out of 5]

هذا كتاب ممتار جدا.. أنصح فيه أي أحد حابب يتعلم البي اتش بي.
مليان أمثلة ممتازة ومفيدة جدا. أنصح بهالكتاب للي عنده خلفية كويسة عن البرمجة لكنه حاب يتعلم البي اتش بي بشكل خاص..
فادني بشكل كبير.. وأسلوب الكتاب ممتاز جدا ومرتب وسهل.
قرأته في فبراير الماضي.. لكن فيه يمكن ٢ ابترز ما قرأتهم لعدم حاجتي لهم.. لكن البقية كمصدر تعليمي أقدر أقول انهم ممتازين جدا وراح تنمي معرفتك بشكل كبير في التعامل مع البي اتش بي والماي اس كيو ال

[Kimberly · Rating 3 out of 5]

I used this book for one of my MLIS courses. I'm not sure if it was the book, or the course, but I can say that in combination, it wasn't the PHP introduction that I had been hoping for. To be fair, we only used about 8 of the chapters from this book, so there's a lot I didn't cover. Personally, I had a difficult time applying what was in the book to my course assignments, but again, that could have been the course/instructor's fault, not the book's, (and of course I understand that could have been my fault as well, but I swear, I was working hard and trying to figure it all out, and I did for the most part).

[Christian Tjhai · Rating 5 out of 5]

I recommend this book to those of you who just started to learn PHP, but already have a programming background. A Javascript and HTML scripting background should be fine for you to start using this book.

This book helps you a lot to get started real fast with PHP, because this book has much examples.

Updated on 2012:
Now is 2012, and I have been leading many PHP development teams. Unsurprisingly, I made curriculum based on this book to train the PHP development teams. This book is just awesome, I just kept recommending this book to others.

[Nassim Daoud · Rating 5 out of 5]

Excellent book to learn PHP
I've logged here especially to write a review to this book, because I thought I should do it. And because I think honest, neutral and with a minimum understanding of the subject are important and not always found when needed.
I've took more than three months to read it and test the examples and write a summary of it. And since then I've read other books on web programming, and not a time found any mistakes in what I've learned from this book. Its authors or technical reviewers seems to be very knowledgeable in what they are doing, so they'll give you the best practices ready to be consumed without the need to pass long years experimenting.
Cheers!

[Karol · Rating 5 out of 5]

A very good book to start learning PHP, learned a lot and I would recommend it to anyone

[Ivelin Georgiev · Rating 5 out of 5]

I started learing php with this book and I can't say bad thing about this book ;)

[Teriz De Ocampo · Rating 3 out of 5]

I feel like the authors focused more on keeping their word of including everything that is important, rather than assessing whether the material could actually be absorbed by the readers. A lot of information was just dumped/enumerated just so the book could claim that the topic was mentioned or touched on.

[Ankita Jadhav · Rating 5 out of 5]

This was the best book i have read to learn PHP and MySQL this books speaks about each and every concept so deeply that anyone with little tech background can understand it pretty easily.

Web Development Classes in Pune

[Qwerty Fun6 · Rating 5 out of 5]

Finding the right web developers is crucial for any online project. Whether you need a simple website or a complex web application, working with skilled professionals ensures efficiency and quality. Explore top-rated web development companies at https://it-rating.com/web-developers/ and find the perfect team for your needs!

[Darrell Ulm · Rating 4 out of 5]

First book read on the subject of PHP and MySQL, a good start to get into web application development.

[Sai Prashanth · Rating 5 out of 5]

Luke and Laura are very well versed in the subject matter, and it shows. Good set of toy projects to learn PHP with.

[Jure Vidrih · Rating 4 out of 5]

I've read this book and found it to be of a good quality(4/5). I had some experience with PHP and MySQL from before I picked up this book. Just as the book says, it doesn't leave out anything important unexplained, but at the same time it gives plenty of information on where and how to receive more information on certain topics. A large part of this book is also dedicated to building projects with potentially large numbers of users, such as online message boards, e-commerce, etc. This section of the book is good at giving a reader a sense of how to generally write dynamic web apps with PHP and MySQL. The bad part: The version of this book that I've been reading on my e-reader has some formatting errors. For example, lists in this book should have a name of an element and below it a description of it. In reality, the names of all of the list elements are displayed first(grouped together) with list element descriptions displayed after them. This is the only reason why I don't give this book a 5 star rating.

Conclusion: PHP and MySQL: Web Development (4th Edition) by Luke Welling is a good book for anyone who wants to learn how to build modern web apps with PHP and MySQL (+ some Ajax at the very end of the book). Recommended.

[Elizabeth · Rating 4 out of 5]

Esta es la segunda (o quizás tercera vez) tratando de aprender PHP con este libro. Y debo decir que la razón por lo que en esta oportunidad pude pasar de la pag 50 sin que sintiera que la cabeza me iba a explotar es debido a que este libro fue (en esta ocasión) mi material de apoyo en un curso de programación que realizo.

Personalmente, considero que en el libro debería de explicar un poco más sobre el funcionamiento de las bases de datos porque siento que se quedaron un poco cortos. Considero que es importate saber MySQL antes que PHP (cosa que no sabía antes de tratar de leer fallidamente este libro en oportunidades anteriores).

El libro me encantó para leerlo y completar lo que veía en clase. Y disfruté el que fuera bastante extenso porque te explica súper bien las cosas.

He de decir que aún no me he terminado de leer los últimos capítulos que son para realizar un ecommerce y cosas así porque eso ya me lo dieron en el curso mientras me iban dando contenido. Pero cuanto tenga un chance lo chequearé.

[PET · Rating 4 out of 5]

This is the book that taught me the basics of PHP and MySQL.
For years all I did was the first 2 chapters which taught me the basics of PHP and the basics of MySQL. This allowed me to actually do some work for money.

I remember making my first money right after finishing high school because I knew those things.

My point is, that this book actually knows how to begin. It teaches you the basics so you can actually start to practice. Years later I bought another book that... for the first 400 pages had everything about PHP and for the last 400 pages everything about MySQL. That book had no flow... it had nothing. Just pages and pages about functions and stuff. Because of that lame book I actually learned to appreciate this book more.

[Benjamin Davidson · Rating 5 out of 5]

As a beginning programmer with only a handful of QBasic experience, this was the book that showed me everything I needed to know to start exploring my creative potential efficiently when programming. It gives excellent examples that clearly unify the model, view, controller framework at a low enough level that I never felt any unwarranted assumptions about my knowledge and understanding were made. This was back in the PHP 4 days, so things might have changed, but I owe a lot to this book all the same.

[Rick · Rating 4 out of 5]

This is a good introduction to web programming using PHP and MySQL. The material is clear and comprehensive, and the examples illustrate the principles well. You should have a working understanding of HTML and CSS before getting into PHP and MySQL, just for practical purposes since PHP is often used to generate HTML from data stored in a database (e.g., MySQL). The material provides a good, broad foundation for working with PHP and MySQL, but don't expect to be an expert when completing the book.

[Rolcom Ld · Rating 5 out of 5]

In common this book has answered almost al my questions.But...
According to PHP tutorial, using the substitutions for the bold terms, plus substituting DBPASSWORD with your own mysql password:

* Replace DBSERVER with the correct database servername for your site.
* Replace DBUSERNAME with your own mysql username.
* Replace DBNAME with your own mysql databasename.
So I coud not find these examples

[Marian · Rating 5 out of 5]

I borrowed this book from the campus library, hoping it would give me some guidance on a database project. Turns out it has some excellent tutorials, e.g. the middle part of the book is easily readable even if you only know basic MySQL/PHP. The concise examples and explanations definitely helped me make rapid progress and learn more PHP than I could have otherwise. I would consider purchasing a newer edition for future reference.

[Derek Bridge · Rating 3 out of 5]

A good PHP book for someone who can already program (whether in PHP or some other language). The strength lies in 2 or 3 of the case studies, which, while falling short of production-quality code, can help you transition from the noddy examples you see in most books and web tutorials to reasonably well-styled larger programs.

[Jesse Jones · Rating 4 out of 5]

By far one of the best books for getting started with PHP and MySQL. The book starts off slow and is perfect for a beginner to get started in database/dynamic web page creation. Over the course you create a shopping cart and learn how to integrate web services into your website. For PHP and MySQL, this is one of the best introductions.

[Sheffielder · Rating 4 out of 5]

This is a great guide to PHP and MySQL, but it's worth noting that it contains various typographical errors. Confident programmers shouldn't find this a problem, as the mistakes are minor and easily fixed.

[James napoli · Rating 2 out of 5]

working my way through building a dynamic php/mySql website, and this book is full of flaws and code that simply doesnt work. nearly 1k book, spends about 2 1/2 pages on actual php and mysql output/integration...weakSauce.

[Stacia · Rating 4 out of 5]

I needed to learn how to code specific things rather quickly, and I was able to get code implemented and working in a short amount of time after I got this book. I can also use this as a reference for certain php methods. For that reason, I give this 4 stars.

[Graeme Breathnach · Rating 5 out of 5]

This book is very instructive. The examples in the book are excellent. Within a day or two of getting my hands on the book I was able to set up a database-driven website. Worked a treat and met all of my needs.

[Sathya Prakash Moparthi · Rating 4 out of 5]

Before this book i used PHP for general programming purpose, but now i have a slight change in my perspective a i knew that i could be applied to large scale applications by the help of MySQL as back-end.

[Fany Ariasari · Rating 4 out of 5]

helping for beginner so much

[Matt · Rating 5 out of 5]

Read this book in one night...

[Basilakis]

My first php Book!

[RJ]

PHP and MySQL Web Development (4th Edition) (Developer's Library) by Luke Welling (2008)