If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics...
If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.
Head First PHP & MySQL offers the same visually rich format that's turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.
作者简介
· · · · · ·
Lynn Beighley is a fiction writer stuck in a technical book writer's body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it. After going back to school to get a Masters in Computer Science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller. A victim of bad timing, she move...
Lynn Beighley is a fiction writer stuck in a technical book writer's body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it. After going back to school to get a Masters in Computer Science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller. A victim of bad timing, she moved to Silicon Valley just before the great crash. She spent several years working for Yahoo! and writing other books and training courses. Finally giving in to her creative writing bent, she moved to the New York area to get an MFA in Creative Writing. Her Head First-style thesis was delivered to a packed room of professors and fellow students. It was extremely well received, and she finished her degree, finished Head First SQL, and can't wait to begin her next book.
Lynn loves traveling, cooking, and making up elaborate background stories about complete strangers. She's a little scared of clowns.
Michael Morrison is a writer, developer, toy inventor, and author of books on Java, Web scripting, game development, and mobile devices. An instructor of Web-based courses, Michael is also the founder of Stalefish Labs (www.stalefishlabs.com), a company specializing in games, toys, and interactive media.
It's possible to skip the php substr() function and limit the job description data in the SQL query itself.You use a very similar MySQL function called SUBSTRING() that accepts the same arguments as substr(). The only difference is that the starting index starts at 1 instead of 0.So grabbing the first 100 characters of the job description looks like this:
SELECT SUBSTRING(job_description, 1, 100) FROM riskyjobs; (查看原文)
Remember that our goal is to simplify the messy Mismatch queries with INNER JOIN.When an inner join involves matching columns with the same name, we can further simplify the query with the help of USING statement.The USING statement takes the place of ON in an INNER JOIN query, and requires the name of the column to be used in the match.Just make sure the column is named exactly the same in both tables.As an example, here's the Mismatch query again:
SELECT mismatch_topic.topic_id, mismatch_category.name FROM mismatch_topic INNER JOIN mismatch_category USING (category_id) WHERE mismatch_topic.name = 'Horror movies' (查看原文)
0 有用 curer 2012-07-28 22:58:02
过多的插画,让人分心,步骤很细,非常非常入门的书
0 有用 孤单的大熊猫 2014-01-20 22:39:17
从基础到高级的全面掌握,拿来巩固一下非常不错
1 有用 trivial 2011-11-30 01:46:41
其实是本web开发入门书
0 有用 猪小乐 2012-02-29 13:38:16
不喜欢,就是不喜欢。不是coding的料。
0 有用 Q小帝 2011-03-15 20:34:44
HF的书都比较生动,但内容也有点浅,要实用还需要其它材料补充。