The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>Essentially three books in one, readers not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's 7 years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide.
<h3>What you'll learn</h3> <ul> <li>The PHP language</li> <li>How to back your web site with MySQL</li> <li>Templating so that you can apply a consistent design across all pages on your site</li> <li>How to authenticate your web site users</li> <li>How to use cookies to maintain information (such as items in a shopping cart) while a user is browsing your site</li> </ul> <h3>Who is this book for?</h3>This book is written for developers seeking to take advantage of the PHP language and MySQL database to create powerful web applications.
<h3>About the Apress Beginning Series</h3>The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." You'll start your journey by seeing what you need to know--but without needless theory and filler. You'll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there--it is your trusted guide through unfamiliar territory!
<h3>Related Titles</h3> <ul><li>Beginning PHP 5 and MySQL E-Commerce: From Novice to Professional</li> <li>Beginning Ajax with PHP: From Novice to Professional</li> <li>PHP 5 Recipes: A Problem-Solution Approach</li> <li>Pro PHP Security</li> <li>PHP 5 Objects, Patterns, and Practice</li> </ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.
Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5--specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
<h3>What You Will Learn from This Book</h3><ul><li>Install and configure Apache, PHP, and MySQL on both Windows and Linux.</li> <li>Accept and process information submitted via HTML forms.</li><li>Authenticate users and track user preferences and data using PHP's session-handling capabilities.</li><li>Process web-based file uploads using the HTTP_Upload PEAR package.</li><li>Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.</li><li>Use both command-line and graphical MySQL clients to effectively manage your data.</li><li>Secure the MySQL server, creating roles and restricting access even at very granular levels.</li><li>Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.</li></ul>]]>