PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

by Larry Ullman

When static HTML pages no longer cut it, you need to step up to dynamic, database-driven sites that represent the future of the Web. In PHP and MySQL for Dynamic Web Visual QuickPro Guide , the author of best-selling guides to both the database program (MySQL) and the scripting language (PHP) returns to cover the winning pair in tandem the way users work with them today to build dynamic sites using Open Source tools. Using step-by-step instructions, clearly written scripts, and expert tips to ease the way, author Larry Ullman discusses PHP and MySQL separately before going on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. A companion Web site includes source code and demonstrations of techniques used in the volume. If you're already at home with HTML, you'll find this volume the perfect launching pad to creating dynamic sites with PHP and MySQL.

Genres: Reference, Technology, Nonfiction, Programming, Computer Science, Computers, Textbooks

572 pages, Paperback

First published January 1, 2003

About the author

Larry Ullman is a writer, Web and software developer, trainer, instructor, speaker, and consultant. He has written 23 books and numerous articles. His books have sold over 350,000 copies world wide in more than 20 languages. As his readers, students, and co-workers can attest, Larry’s strength is in Translating Geek into English: converting the technical and arcane into something comprehensible and useful.

Reviews

[Katrina · Rating 5 out of 5]

Since I did love the Second Version so much, I decided to go out and get the most current version. The code was a bit outdated (which is quite understandable since my printing came out in 2004).

I was not at all disappointed with the fourth version! In fact I would without a doubt recommend it to anyone who is trying to learn PHP and MySQL. He is so very detailed and explains things excellently :D. The examples are great and I am so ready to get out an crank out a bunch of pages and keep learning from here!

[Leslie]

I haven't got as far in this book as I'd like, because the material is so useful I've accomplished a lot only having read to chapter 3.

That said, I didn't know anything at ALL about MySQL when I bought the book. MySQL is the REASON I bought the book, but the PHP I learned in the early chapters has kept me busy.

I've since taken an introductory MySQL online course, so I feel better prepared to carry on...

[shayath · Rating 2 out of 5]

Good one

[Jodie · Rating 5 out of 5]

This is the perfect book for php/mysql newbies. It is full of excellent code examples with descriptive explanations of what the code is doing. Highly recommended.

[Aan F. Ifatna · Rating 5 out of 5]

Nice book, specially for newbie. Apalagi buat gw kekekeke

[Bill · Rating 5 out of 5]

with so many computer books out there, I found this one to be especially helpful -

[Koushik Das]

Best book for learning PHP and MYSQL for beginners. Glad that I got hands on it.

[Aleksandar Janjic · Rating 5 out of 5]

Ако сте се икад бавили мишљу да направите сопствени веб сајт, а ЦМС-ови као што су Њордпрес и Џумла вас не импресионирају много јер хоћете да имате потпуну контролу над садржајем и изгледом, онда вам нема друге него да засучете рукаве и учите ПХП и МзСЉЛ. ПХП је, као што знамо, језик у коме динамички креирате ХТМЛ странице (умјесто да, као некад у добра стара времена, ручно пишете сваку посебно), користећи базу података коју сте претходно направили у поменутом Ес Ку Елу. Да је све ово једноставно - није, нарочито ако никад до сада нисте имали додир са овим технологијама. Е, зато је ту ова књига да вам помогне у томе.

Не дешава ми се баш често, нарочито кад је техничка литература у питању, да немам апсолутно никаквих замјерки на књигу. Али овде је управо то случај. Осим једне ситне грешкице коју је аутор направио у опису прве нормалне форме у релационим базама података (која је ионако теоретске природе и ни на који начин не утиче на валидност практичних савјета), овде је све изведено буквално савршено. Иако је аутор навео да му није циљ да објашњава ПХП сам по себи, већ првенствено његову интеракцију са Мај Ес Ку Елом, овде имате сасвим довољно уводног материјала да све савладате и испратите без проблема, чак и ако појма благог немате шта је дођавола тај ђавољи Пе Ха Пе. Исто тако лијепо је описано и креирање база података и постављање упита над њима, а онда све то укомбиновано кроз велики број врло лијепих и корисних практичних примјера. Поред тога, ова књига је и врхунски опремљена, изгледа одлично, аутор има симпатичан несувопаран стил писања, ту је брдо скриптова који су врло лијепо објашњени, а на крају сваког поглавља имате и по неколико домаћих задатака и питања за обнову градива.

Колико ћете добити од ове књиге зависи од труда који уложите. Ако немате намјеру да правите свој веб сајт, опет је препоручљиво да је барем прочитате (без уласка у детаљно објашњење сваке линије кода) јер ћете тако стећи слику о томе како функционишу сајтови које свакодневно посјећујете. Ако се удубите мало више, овде имате довољно материјала да направите сајт какав год желите, потпуно по својој мјери, без ограничења која вам постављају ЦМС-ови. Ако сте тотални штребер, па још будете радили и вјежбе на крају поглавља, постаћете скоро па мастер који комотно може да зарађује од веб програмирања.

Ова књига има и "наставак", који се бави напреднијим темама (као што је нпр. објектно програмирање), то је вјерујем намијењено већ онима који планирају да праве сајтове који ће да буду на нивоу Гугла или Фејсбука.

[Elias Gutierrez · Rating 4 out of 5]

Dynamic Web Sites with PHP and MySQL

If you are new to programming and want to get into the industry of Web Development, then this book might be a little hard for you to grasp since learning on how to program is like learning a new language. On the other hand, if you have some programming experience in your belt, then this would not be too hard, but might be a little weird to learn how PHP works. Either way if you're an experienced programmer or just beginning, this book has important concepts on making a website from static to something dynamically driven.

The book delves into the concepts of PHP while doing some little projects in order to see how everything works. It might be a little weird and hard to grasp, but the more you do it and persevere then the more it makes sense which I like a lot about the book. After a few initial chapters is where the bulk of the book gets into the concepts of SQL and MySQL which, in my opinion, is very important because I would imagine that most programming jobs would require you to know on how to do databases. And beyond that, PHP uses MySQL in order to extracts information from the database about a user or product, or it imports information on what the user submits.

This book also teaches you on how servers work from the Client-Side to the Server-Side which is very important. Near the last few chapters of the book is where the author delves into jQuery and Ajax in order to make a website even more dynamic although if the user turns off JavaScript on their browser is where problems could arise. It also suggests on trying out JSON.

Lastly, in terms of concepts is that the book uses Procedural Programming and NOT on Object-Oriented Programming (although the book has a chapter dedicated on OOP). If one wants to learn and apply OOP for PHP (which I would recommend), then buy the author's other book which deals with Advanced Techniques for PHP.

In the end, this book is a very beautiful and useful book to learn and to apply yourself. I did not give a perfect rating because there are some errors in it such as grammatical and some syntax issues, but overall it is easy and manageable to fix if you know what you are doing.

Buy this book and go out there in the programming world!

[Indie e-books · Rating 4 out of 5]

A really good introduction to PHP with examples to keep interest levels up. There was only the slight problem of too much SQL information early on that wasn't fully explored later on. That's not to say it's any less of a book - in fact those few chapters will probably act as reference material for a while, but it made difficult reading.

All in all, it was a good enough book to have me reaching for the advanced text.....

[Katrina · Rating 4 out of 5]

This book is a fantastic way to learn PHP and MySQL. Only problem is that my copy was released in 2004, which was 8 years ago. Haha! So some of the things are, of course, out of date. I actually just recently ordered the 4th edition online because I loved his teaching style so much and needed something more current.

[Matt Cornelius · Rating 4 out of 5]

I use this book to learn PHP. There are many ways to do things in PHP and this book I think gives a very good introduction to PHP programming for the web and creating dynamic sites. You can use this book to start creating quite complex websites.

[Ramanan Sathananthasarma · Rating 3 out of 5]

Very nice book

[Hassan]

how to create website

[Emily Rapport · Rating 3 out of 5]

PHP is not as impossible as I had thought. Training the mind to do new tasks is good.

[Rob · Rating 3 out of 5]

Great introduction to PHP and MySQL, but it's just that, an introduction.

[Elaine · Rating 3 out of 5]

Very helpful, especially for beginners. However, it is a bit dated. For example, this was released before you could use mySQL transactions. This certainly doesn't impact the book's usability, though.

[Dimitri · Rating 4 out of 5]

A good and easy to read book getting the basic but solid knowledge about PHP & MySQL with many examples. At the end the reader is able to setup and run a website.

[Ali Elouafiq · Rating 3 out of 5]

weak book

[Max Pietsch · Rating 4 out of 5]

Very basic and correspondingly quick to get started. Well-written.

Examples were a little overly verbose, so it did help to know some basic HTML before reading it.

[Araminta Matthews · Rating 3 out of 5]

Not nearly enough on OOP.

[Oscar Sánchez · Rating 3 out of 5]

Not very helpful with realistic web developing, more like a beginners guide.

[Jim Peterson · Rating 4 out of 5]

Learning some stuff for my career.....