PHP & MySQL: Novice to Ninja, 6th Edition is a hands-on guide to learning all the tools, principles, and techniques needed to build a fully functional application using PHP & MySQL. Comprehensively updated to cover PHP 7 and modern best practice, this practical and fun book covers everything from installing PHP and MySQL through to creating a complete online content management system.
You'll learn how to:
Install PHP & MySQL on Windows, Mac OS X, or Linux
Gain a thorough understanding of PHP syntax
Use object oriented programming techniques
Master database design principles and SQL
Develop robust websites that can handle high levels of traffic
Build a working content management system (CMS)
And much more!
AI Reading Assistant
Whole-book reading guide from stratified index samples; jump to passages in the text
Tip the Site
Support this siteYour recognition and a small knowledge-service contribution help keep this technical work open source.Scan the WeChat Pay or Alipay code below. Logged-in and guest visitors can both tip.
WeChat Pay
Alipay
Open WeChat or Alipay and scan. No login required.
AI guide
【One-Line Pitch】
A hands-on, project-driven introduction to building dynamic websites with PHP and MySQL, written for web designers who already know HTML and want to cross the bridge into server-side programming. If you learn best by typing code and breaking things rather than reading theory first, this is your on-ramp.
【Book Arc】
- **Opening (~0%–10%)**: Sets expectations and mindset before any code appears — who the book is for, why you should dive in and write code early, and how to avoid the "Concorde fallacy" of stubbornly defending a broken approach.
- **Early (~10%–35%)**: Establishes the learning philosophy and conventions: programming concepts build on each other, so resist skipping ahead; the goal is learning to *code*, not just learning PHP syntax; typographic conventions and supplementary materials are introduced.
- **Middle (~35%–55%)**: Gets the environment running — why you need your own local web server, the trade-offs of manually installing Apache/PHP/MySQL versus prepackaged stacks, and the development pitfalls (error display, case-sensitivity, always-on background services) that trip up beginners.
- **Late (~55%–85%)**: (Excerpts do not cover this range in detail.) Based on the book's stated scope, this is where PHP syntax, object-oriented techniques, database design, and SQL are developed through building the CMS.
- **Ending (~85%–100%)**: (Excerpts do not cover this range.) Presumably culminates in the completed content management system and appendices, including code-archive instructions referenced in Appendix A.
【Key Takeaways】
- **Learn to code, not just to write PHP** (Early): The author explicitly frames PHP as the vehicle for teaching general programming thinking — like learning to drive rather than learning to drive a Ford. This reframing matters because it changes how you absorb every later chapter.
- **Dive in and write code first; plan later** (Early): The book deliberately rejects the "design everything before typing" advice common in programming texts, arguing you can't design well without knowing your tools. Beginners should run code, break it, and experiment before formalizing designs.
- **Concepts are cumulative — don't skip ahead** (Early): Programming ideas build on each other, so getting stuck usually means an earlier concept wasn't fully absorbed. Going back for a refresher is faster than pressing forward.
- **Know when to abandon a failing approach** (Early): The "Concorde fallacy" — throwing more effort at something because you've already invested — is called out as a trap. Scrapping and restarting often reaches the same point faster with cleaner code.
- **You need a local development server** (Middle): Browsers can't execute PHP; a PHP-savvy server must process scripts into HTML. Running one locally lets you edit-and-refresh instead of the tedious upload-check-repeat cycle of remote hosting.
- **Setup method is a real trade-off** (Middle): Manual Apache/PHP/MySQL installation offers control but requires configuring error display and server-PHP integration; prepackaged stacks are easier but can be outdated and mask platform differences.
- **Development environments hide production problems** (Middle): Windows' case-insensitive filenames, default PHP settings that suppress errors, and always-running background services are all flagged as sources of "works locally, breaks live" bugs.
【Reading Tips】
- **Deep-read the early mindset chapters (~0%–35%)** even though they contain little code — the author's guidance on restarting, not skipping, and learning-to-code is the book's spine and pays off later.
- **Skim the installation chapter (~35%–55%)** if you already have a working local stack; focus instead on the error-display and case-sensitivity warnings, which are the genuinely useful bits.
- **Type every example yourself** rather than copying from the archive — the book's whole pedagogy assumes hands-on experimentation, and the author says you learn more solving problems before seeing solutions.
- **Treat the CMS build as the integration test**: if the later chapters feel hard, revisit the earlier concept they depend on rather than pushing through.
- **Keep your scrapped code as reference**, not deleted — the author recommends this explicitly when you restart an approach.
【Coverage Limits】
The excerpts provided cover only the front matter, introductory mindset chapters, and installation setup (roughly the first half of the book). PHP syntax, OOP, SQL, database design, and the CMS build itself are described in the blurb but not present in the excerpt material, so this guide cannot detail their specific content.
Excerpt 1
k, or by the software or hardware products described herein. Trademark Notice Rather than indicating every occurrence of a trademarked name as such, this boo...
ng run. This is often referred to as the “Concorde fallacy”. There are times when it’s better to cut your losses than keep working on a failed project! There...
ning was wasted because of something they didn’t see coming. Programmers don’t encounter hippos, but there are lots of obstacles you won’t be able to anticip...
uses up precious time that you could be using to write code. By running a server on your own PC, you’ll be able to save a file in your editor and view the ch...
rver up and running. It’s a lot easier than you might think! Your Own Virtual Server Before writing any PHP code and developing your website, you’ll need to...
t appears in the browser window than HTML alone can provide. The key difference between JavaScript and PHP is the stage of loading the web page at which thes...
L code a lot, which tends to contain a lot of double quotes. For example: echo '<a href="http://www.sitepoint.com">Click here</a>'; If double quotes were use...
= is used for assignment and cannot be used for comparison. The if statement uses braces { and } to surround the code you want to run when the condition is m...
Support this siteYour recognition and a small knowledge-service contribution help keep this technical work open source.
Scan the WeChat Pay or Alipay code below. Logged-in and guest visitors can both tip.
WeChat PayAlipay
Open WeChat or Alipay and scan. No login required.
Add Tag
Enter tag name (max 50 characters)
Share E-Book
PHP MySQL Novice to Ninja (Tom Butler, Kevin Yank)(Z-Library)
Scan QR code with your phone to access
Copy the link or scan the QR code to access this e-book on your phone
Share E-Book via Email
Please enter email address
Donation Statistics
¥.00
Total Donations
0
Donation Count
PHP MySQL Novice to Ninja (Tom Butler, Kevin Yank)(Z-Library)
Find Your Favorite Books
Only registered users can comment after logging in. Comments need to be reviewed by administrators before being displayed
Loading comments...
Reply to Comment
Edit Comment