Synopses & Reviews
Written in the friendly, easy-to-understand … For Dummies style, PHP and MySQL For Dummies, 3rd Edition shows readers how to use the popular Open Source scripting language (PHP) with the popular Open Source database (MySQL) to build dynamic web database applications. This book provides the basic techniques to build any web database application. It explains how to install the Windows, Linux, and Mac OS X versions of PHP and MySQL and includes two complete sample applications. One application is of an online catalog and the other is of a members-only website. Topics covered include setting up a work environment; designing and building a database; planning and developing a web database application; protecting data; writing PHP statements; using PHP constants and variables; working with numbers and character strings; and moving information from one web page to another. The third edition is being updated to reflect the changes in PHP 6 and the latest version of MySQL 5.
Synopsis
Explains how to build Web database applications with the PHP scripting language and the MySQL database.
Synopsis
This friendly, easy-to-understand guide introduces novices to building Web database applications with two of the most popular open-source tools available: PHP scripting language and MySQL databases Covers basic techniques to building Web database applications; installing the Windows, Linux, and Mac OS X versions of PHP and MySQL; protecting data; writing PHP statements; moving information; and more Two complete sample applications (an online catalog and a members-only site) help readers understand setting up a work environment, designing and building a database, planning and developing a Web database application, protecting data, writing PHP statements, using PHP constants and variables, and more Approximately 2.5 million programmers use PHP, and MySQL has 6 million usersSynopsis
Build an online catalog and a members-only siteEverything you need to know to create a dynamic PHP and MySQL Web site!
Been thinking of creating a high-quality interactive Web site? This book is just what you need to get started! Here's the fun and easy way® to develop a Web application in PHP 4, 5, or 6 and MySQL 5, test your software, enable your Web pages to display, change, and move database information, and much more.
Discover how to
- Plan and implement a Web database application
- Design and build a MySQL 5 database
- Build dynamic HTML forms
- Create scripts that store, retrieve, and update database information
- Display database information in a Web page
Synopsis
* Display database information in a Web page
Synopsis
Build an online catalog and a members-only site
Everything you need to know to create a dynamic PHP and MySQL Web site!
Been thinking of creating a high-quality interactive Web site? This book is just what you need to get started! Here's the fun and easy way(r) to develop a Web application in PHP 4, 5, or 6 and MySQL 5, test your software, enable your Web pages to display, change, and move database information, and much more.
Discover how to
* Plan and implement a Web database application
* Design and build a MySQL 5 database
* Build dynamic HTML forms
* Create scripts that store, retrieve, and update database information
* Display database information in a Web page
About the Author
Janet Valade is the author of
PHP 5 For Dummies, PHP & MySQL Everyday Apps For Dummies, and
PHP & MySQL: Your visual blueprint for creating dynamic, database-driven Web sites, as well as the author of first and second editions of this book. In addition, Janet is the author of
Spring into Linux and a coauthor of
Mastering Visually Dreamweaver 8 and Flash 8.Janet has twenty years of experience in the computing field. Most recently, she worked as a Web designer and programmer in an engineering firm for four years. Before that, Janet worked for thirteen years in a university environment, where she was a systems analyst. During her tenure, she supervised the installation and operation of computing resources, designed and developed a data archive, supported faculty and students in their computer usage, wrote numerous technical papers, and developed and presented seminars on a variety of technology topics.
To keep in touch, see janet.valade.com.
Table of Contents
Introduction.Part I: Developing a Web Database Application Using PHP and MySQL.
Chapter 1: Introduction to PHP and MySQL.
Chapter 2: Setting Up Your Work Environment.
Chapter 3: Developing a Web Database Application.
Part II: MySQL Database.
Chapter 4: Building the Database.
Chapter 5: Protecting Your Data.
Part III: PHP.
Chapter 6: General PHP.
Chapter 7: PHP Building Blocks for Programs.
Chapter 8: Data In, Data Out.
Chapter 9: Moving Information from One Web Page to the Next.
Part IV: Applications.
Chapter 10: Putting It All Together.
Chapter 11: Building an Online Catalog.
Chapter 12: Building a Members Only Web Site.
Part V: The Part of Tens.
Chapter 13: Ten Things You Might Want to Do Using PHP Functions.
Chapter 14: Ten PHP Gotchas.
Part VI: Appendixes.
Appendix A: Installing MySQL.
Appendix B: Installing PHP.
Appendix C: Installing and Configuring Apache.
Index.