Share E-Book
Scan to open this page

Scan with your phone to open this page

Author: Tom Butler, Kevin Yank

Rating No ratings yet

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

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...
View in text
Excerpt 2
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...
View in text
Excerpt 3
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...
View in text
Excerpt 4
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...
View in text
Excerpt 5
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...
View in text
Excerpt 6
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...
View in text
Excerpt 7
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...
View in text
Excerpt 8
= 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...
View in text
Tags
AI categories
PhpProgramming LanguageBackend
ISBN: 0994346980
Publisher: SitePoint
Publish Year: 2017
Language: English
Pages: 690
File Format: EPUB
File Size: 2.9 MB