MySQL eBooks
MySQL for Python
Python is a dynamic programming language, which is completely enterprise ready, owing largely to the variety of support modules that are available to extend its capabilities. In order to build productive and feature-rich Python applications, we need to use MySQL for Python, a module that provides database support to our applications. Although you might be familiar with accessing data in MySQL here you will learn how to access data through MySQL for Python efficiently and effectively. This book demonstrates how to boost the productivity of your Python applications by integrating them with the MySQL database server, the world's most powerful open source database. It will teach you to access the data on your MySQL database server easily with Python's library for MySQL using a practical, hands-on approach. ...
Python is a dynamic programming language, which is completely enterprise ready, owing largely to the variety of support modules that are available to extend its capabilities. In order to build productive and feature-rich Python applications, we need to use MySQL for Python, a module that provides database support to our applications. Although you might be familiar with accessing data in MySQL here you will learn how to access data through MySQL for Python efficiently and effectively. This book demonstrates how to boost the productivity of your Python applications by integrating them with the MySQL database server, the world's most powerful open source database. It will teach you to access the data on your MySQL database server easily with Python's library for MySQL using a practical, hands-on approach. ...
MySQL 5.1 Plugin Development
MySQL has introduced a Plugin API with its latest version – a robust, powerful, and easy way of extending the server functionality with loadable modules on the fly. But until now anyone wishing to develop a plugin would almost certainly need to dig into the MySQL source code and search the Web for missing bits of the information. This is the first book on the MySQL Plugin API. Written together with one of the Plugin API primary architects, it contains all the details you need to build a plugin. It shows what a plugin should contain and how to compile, install, and package it. Every chapter illustrates the material with thoroughly explained source code examples. ...
MySQL has introduced a Plugin API with its latest version – a robust, powerful, and easy way of extending the server functionality with loadable modules on the fly. But until now anyone wishing to develop a plugin would almost certainly need to dig into the MySQL source code and search the Web for missing bits of the information. This is the first book on the MySQL Plugin API. Written together with one of the Plugin API primary architects, it contains all the details you need to build a plugin. It shows what a plugin should contain and how to compile, install, and package it. Every chapter illustrates the material with thoroughly explained source code examples. ...
Beginning PHP and MySQL, 4th Edition
Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more. You'll not only receive extensive introductions to the core features of PHP, MySQL and related tools, but you'll also learn how to effectively integrate them in order to build robust data-driven applications. Gilmore has seven years of experience working with these technologies, and he has packed this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide. ...
Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more. You'll not only receive extensive introductions to the core features of PHP, MySQL and related tools, but you'll also learn how to effectively integrate them in order to build robust data-driven applications. Gilmore has seven years of experience working with these technologies, and he has packed this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide. ...
Learning PHP, MySQL, and JavaScript
If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP, MySQL and JavaScript, regardless of whether you already know how to program. Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add JavaScript to create rich Internet applications and websites. Learning PHP, MySQL and JavaScript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book. ...
If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP, MySQL and JavaScript, regardless of whether you already know how to program. Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add JavaScript to create rich Internet applications and websites. Learning PHP, MySQL and JavaScript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book. ...
Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition
Build Your Own Database Driven Web Site Using PHP & MySQL 4th Edition is a practical, hands-on guide to learning all the tools, principles, and techniques needed to build a fully functional database driven web site using PHP & MySQL. This book covers everything from installing PHP and MySQL on Windows, Linux, and Mac computers, through to building a live, web-based content management system. While this is essentially a beginners book, it also covers more advanced topics such as the storage of binary data in MySQL and cookies and sessions in PHP. ...
Build Your Own Database Driven Web Site Using PHP & MySQL 4th Edition is a practical, hands-on guide to learning all the tools, principles, and techniques needed to build a fully functional database driven web site using PHP & MySQL. This book covers everything from installing PHP and MySQL on Windows, Linux, and Mac computers, through to building a live, web-based content management system. While this is essentially a beginners book, it also covers more advanced topics such as the storage of binary data in MySQL and cookies and sessions in PHP. ...
PHP and MySQL For Dummies, 4th Edition
To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result. PHP scripting language with a MySQL back-end database offers an effective way to design sites that meet these requirements. This full updated 4th Edition of PHP & MySQL For Dummies gets you quickly up to speed, even if your experience is limited. ...
To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result. PHP scripting language with a MySQL back-end database offers an effective way to design sites that meet these requirements. This full updated 4th Edition of PHP & MySQL For Dummies gets you quickly up to speed, even if your experience is limited. ...
Beginning PHP 6, Apache, MySQL 6 Web Development
Apache, MySQL and PHP are each complex in and of themselves, and it's impossible for this book to cover every advanced detail of all three. The purpose of this book is to give you the best possible foundation for understanding how each of the core components work separately and together, which will enable you to take full advantage of all that they have to offer. When you've finished reading this book, you'll have a thorough understanding of the core concepts you need to be an effective developer using Apache, MySQL and PHP, and hopefully a burning desire to continue learning and growing as a developer. ...
Apache, MySQL and PHP are each complex in and of themselves, and it's impossible for this book to cover every advanced detail of all three. The purpose of this book is to give you the best possible foundation for understanding how each of the core components work separately and together, which will enable you to take full advantage of all that they have to offer. When you've finished reading this book, you'll have a thorough understanding of the core concepts you need to be an effective developer using Apache, MySQL and PHP, and hopefully a burning desire to continue learning and growing as a developer. ...
Developing Web Applications with Apache, MySQL, memcached, and Perl
Adding a cache layer to the popular LAMP stack is becoming the common solution to significantly reduce the load on back-end databases, and also allows for better web application performance. This new caching component is represented by another "m" in LAMMP, which stands for memcached - a high-performance, distributed memory object caching system that provides caching for web applications. The author walks you through the process of using Perl to develop web applications both in terms of the front-end display logic as well as the back-end data retrieval from MySQL and memcached. You also see how to configure the Apache web server to run these mod_perl applications. ...
Adding a cache layer to the popular LAMP stack is becoming the common solution to significantly reduce the load on back-end databases, and also allows for better web application performance. This new caching component is represented by another "m" in LAMMP, which stands for memcached - a high-performance, distributed memory object caching system that provides caching for web applications. The author walks you through the process of using Perl to develop web applications both in terms of the front-end display logic as well as the back-end data retrieval from MySQL and memcached. You also see how to configure the Apache web server to run these mod_perl applications. ...
MySQL Administrator's Bible
With special focus on the next major release of MySQL this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management - including MySQL's unique approach to basic database features and functions-as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more. ...
With special focus on the next major release of MySQL this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management - including MySQL's unique approach to basic database features and functions-as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more. ...
PHP 6 and MySQL 6 Bible
MySQL is the leading open source database on the market and PHP continues to dominate the server side of the scripting market - together, they are the most popular and common team for creating dynamic, database-driven web sites. This comprehensive book covers the newest version of PHP and MySQL and is packed with extensive code examples, full working applications, and valuable troubleshooting advice. You'll explore installing, developing, and debugging the latest versions of PHP and MySQL and get insight on advanced topics such as error handling, debugging, PEAR, security, HTTP, cookies, and OOP. ...
MySQL is the leading open source database on the market and PHP continues to dominate the server side of the scripting market - together, they are the most popular and common team for creating dynamic, database-driven web sites. This comprehensive book covers the newest version of PHP and MySQL and is packed with extensive code examples, full working applications, and valuable troubleshooting advice. You'll explore installing, developing, and debugging the latest versions of PHP and MySQL and get insight on advanced topics such as error handling, debugging, PEAR, security, HTTP, cookies, and OOP. ...
Head First PHP & MySQL
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. Use PHP to transform static HTML pages into dynamic web sites; Create and populate your own MySQL database tables, and work with data stored in files; Perform sophisticated MySQL queries with joins, and refine y ...
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. Use PHP to transform static HTML pages into dynamic web sites; Create and populate your own MySQL database tables, and work with data stored in files; Perform sophisticated MySQL queries with joins, and refine y ...