fareedquraishi

----------------------


Product Description

In Detail



PhpMyAdmin is a well known and popular open-source tool written in PHP intended to handle the administration of MySQL over the Internet. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, and manage keys on fields. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool.



MySQL is the most popular open-source database, used by millions of developers and supporting numerous large dynamic websites and applications. MySQL acquired this wide popularity by virtue of its open-source nature, performance, reliability, robustness, and support for various platforms. This popularity has also been helped by the existence of phpMyAdmin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice.



The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application. Whether you are an experienced developer, system administrator, web designer, or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your databases.

What you will learn from this book?



Common reasons for installing PhpMyAdmin
Managing multiple servers on single copy of PhpMyAdmin
Securing your PhpMyAdmin installation
Upgrading your PhpMyAdmin installation
Managing databases, data table structures, and indexes to create efficient databases
Administering MySQL users and privileges
Getting server and database statistics
Generating better documentation of evolving table structures

Along the way you will build a more detailed understanding of SQL and how it works in MySQL.
Approach. This book is a tutorial that systematically explains and demonstrates the potential of this tool. It then goes on to show the less well known and generally under-used features and capabilities of phpMyAdmin in depth.

Who this book is written for?

Whether you are an experienced developer, system administrator, web designer or new to MySQL, phpMyAdmin is a must-have tool for anyone who needs to manage MySQL databases and tables. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.



About the Author

Marc Delisle
Marc Delisle is a member of the MySQL Developers Guild - which regroups community developers - because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with the phpMyAdmin project since May 2001 as a developer and project administrator.
He has worked since 1980 at Collège de Sherbrooke, Québec, Canada, as an application programmer and network manager. He has also been teaching networking, security, Linux servers, and PHP/MySQL application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina.

------



Editorial Reviews
Product Description
PHP 5 Recipes: A Problem-Solution Approach</i> supplies you with complete code for all of the common coding problems you are likely to face when using PHP in your day-to-day work. The book begins with an in-depth discussion of PHP 5 object-oriented techniques and methodology, and gets you up to speed on OOP with PHP: where and where not to use it, and how to use it.</p>
<p>This invaluable guide includes over 200 recipes and covers numerous topics: math, arrays, automation, security, graphics, regular expressions, web basics, HTML forms, database access, date and time, variables and functions, and internationalization and localization. Help yourself achieve a winning edge with this one-of-a-kind cookbook.</p>

About the Author
Lee Babin

Lee Babin is a programmer based in Calgary, Alberta, Canada, where he serves as the Chief Programmer for an innovative development firm duly named The Code Shoppe. He has been developing complex web driven applications since his graduation from DeVry University in early 2002 and has since worked on over 50 custom websites and online applications. Lee is married to a beautiful woman by the name of Dianne, who supports him in his rather full yet rewarding work schedule. He enjoys video games, working out, martial arts, and traveling, and can usually be found working online on one of his many fun web projects at any given time.While Lee has experience in a multitude of web programming languages, his preference has always been PHP. With the release of PHP 5, many of his wishes have been fulfilled.

Nathan A. Good

Nathan A. Good lives in the Twin Cities area in Minnesota. He is a contractor with Alliance of Computer Professionals in Bloomington. When he isn't writing software, Nathan enjoys building PCs and servers, reading about and working with new technologies, and trying to get all his friends to make the move to open source software. When he's not at a computer (which he admits is not often), he spends time with his family, at his church, and at the movies.

Frank M. Kromann

Frank M. Kromann is the Senior Software Engineer at intelleFLEET, where he is responsible for software design and development as well as hardware integration. Most of his work involves developing database driven web applications, and involves a combination of centralized Linux servers and decentralized Linux and Windows XP systems (touch screen computers) for data acquisition.

Frank has been involved with PHP development since 1997, has developed several extensions to the project, and has contributed to development of the Windows version of PHP-GTK. When he is not writing code, he is on a golf course in Southern California or having fun with his family.

Jon Stephens

Jon Stephens is a programmer and database analyst based out of Australia. He has written about MySQL, PHP, and other topics, and he has co-authored Beginning MySQL Database Design and Optimization: From Novice to Professional and PHP 5 Recipes: A Problem-Solution Approach. Stephens recently joined MySQL AB as a member of the Documentation Team.


---------------------------------



Product Description
* An ideal introduction to the entire process of setting up a Web site using PHP (a scripting language), MySQL (a database management system), and Apache (a Web server)
* Programmers will be up and running in no time, whether they're using Linux or Windows servers
* Shows readers step by step how to create several Web sites that share common themes, enabling readers to use these examples in real-world projects
* Invaluable reading for even the experienced programmer whose current site has outgrown the traditional static structure and who is looking for a way to upgrade to a more efficient, user-friendly site
* The companion Web site features sample PHP scripts, as well as two fully functional working applications from the book

From the Back Cover
PHP, Apache, and MySQL are the three key open source technologies that form the basis for most active Web servers. This book takes you step by step through understanding each -- using it and combining it with the other two on both Linux and Windows servers.
This book will guide you through creating your own sites using the open source AMP model. You’ll learn to install PHP, Apache, and MySQL. Then you’ll create PHP Web pages, including database management and security. Finally, you’ll discover how to integrate your work with e-commerce and other technologies. By building different types of Web sites, you will progress from setting up simple database tables to tapping the full potential of PHP, Apache, and MySQL.

When you’re finished, you will be able to create well-designed, dynamic Web sites using open source tools.

What you will learn from this book

How PHP server-side scripting language works for connecting HTML-based Web pages to a backend database
Syntax, functions, and commands for PHP, Apache, and MySQL
Methods and techniques for building user-friendly forms
How to easily store, update, and access information using MySQL
Ways to allow the user to edit a database
E-commerce applications using these three technologies
How to set up user logins, profiles, and personalizations
Proper protocols for error handling
Who this book is for

This book is for beginners who are new to PHP and who need to learn quickly how to create Web sites using open source tools. Some basic HTML knowledge is helpful but not essential.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.




----------------------------------