Popular Posts
-
.jpg)
This is the story of 1970s African-American action legend Black Dynamite. The Man killed his brother, pumped heroin into local orphana... -
Joe Casad, "Sams Teach Yourself TCP/IP in 24 Hours" Sams | 2008 | ISBN: 0672329964 | 456 pages | PDF | In just 24 lessons of on... -
Type your message, and then just a few mouse clicks can fax it, print it, email it, prepare an envelope and print a label. Best of all, le... -
Top Forum Software Sites 01. Invision Power Board 02. PunBB 03. Vanilla 04. K4BB 05. XMB extreme message board 06. Simple Machines Forum 07....
-
Like its name, DreamLight Photo Editor can easily add many special dream effects onto your photo. By just several ... -
PLOT Dave Lizewski is an unnoticed high school student and comic book fan with a few friends and who lives alone with his father. His life ... -
Ferrari Virtual Race 2 [iSO/FiNAL] Synetic | Publisher: System 3 | Genre: Racing | Platform: PC | ISO 343 mb | 2009 | English Game includ... -
.jpg)
Officers: World War II (PC) PC | English | 3A Games | 2009 | 1.14 GB Genre: Real-Time Strategy Officers - Six years of bloodshed and genoc... -
AoA Audio Extractor provides you a handy tool to extract audio/sound or background music from video files. Comparing to the free version, ... -
Top Webmaster Forums Sites 01. Now you can View your Site Stats in Real-Time 3D! 02. SitePoint Forums 03. WebDigity Webmaster Forums 04. glo...
Marc starts off by explaining how to install and configure phpMyAdmin on Windows and Linux. Given a working LAMP or WAMP platform, any reader with basic PHP skills should be able to get phpMyAdmin up and running really quickly.
After a first overview over the user interface, the author explains how to create databases and tables, and how to enter data. A quick overview over phpMyAdmin's querying capabilities concludes the "First steps" chapter. Next, the author dives into changing data. I was surprised to learn that phpMyAdmin has a multi-row editing feature.
The "Changing Table Structures" chapter deals with how to edit table definitions and the various column types like TEXT, BLOB ENUM, and DATE. This chapter also deals with index management, and explaining queries.
Chapter 7, "Exporting Structure and Data", deals with exporting databases. Though I personally have never seen the value of exporting a database to anything else than SQL, I was rather surprised to learn that phpMyAdmin supports exporting to PDF, Word, Excep, Open Office, Latex, XML, or YAML format.
Consequently, the next chapter deals with importing structure and data. Due to various server limits like timeout, or limitations of the file upload size, this is not always as easy as it might seem. The author explains the problems and shows ways to circumvent restrictions, which I think is very important, as I see quite a few users in the field struggling with importing large database dump files.
Chapter 9 deals with searching the database, without having to write SQL statements. I was not aware, for example, of the possiblity to search all database tables for strings or even regular expressions. The next chapter covers table and database operations, including table maintenance, renaming tables, moving and copying tables, appending data to a table, and even copying a whole database, which can be an interesting alternative to creating a backup before upgrading it. The database backup feature is complemented by the possibility to rename a database, thus allowing you to create a backup and potentially restore it without having do download and upload SQL dumps.
Chapter 11 introduces the relational system. Since MyISAM tables do not support key relationships, phpMyAdmin can optionally administer information about table relations. The author explains how to set up phpMyAdmin to do this, and continues by introducing the Designer, which is an ajaxy tool to work with table relationships, foreign keys, and check the referential integrity of a database.
Of course, a chapter on how to write SQL statements with phpMyAdmin can not be left out from a book like this. The author explains how phpMyAdmin helps the user to write SQL statements, and shows how an external SQL validator can be used, to make sure that the statements conform to the SQL standard. He then dives into creating multi-table queries, which is where more complex criteria and joins come into play.
Next, the author explains bookmarks, a way of storing statements for later reuse, just like browser bookmarks. In that chapter, I was surprised to learn that phpMyAdmin even allows changing the default initial query that is executed when the table is browsed.
Following a short chapter on how to create database documentation in tabular or PDF format, mime-based transformations are explained. Mime-based transformations allow you, for example, to configure phpMyAdmin to display thumbnails of images stored in the database, format dates, create links, or display strings in hex format, which can be useful to debug issues with different or wrong character encodings. These transformations were, admittedly, completely new for me, and I think they may in fact be one of the most powerful features phpMyAdmin has.
Towards the end of the book, the author covers an important topic, namely character sets and collations. He explains the differences between MySQL versions before and after 4.1, and then continues with a short introduction of new features in MySQL 5, like views, stored procedures, triggers, information_schema as the standards-compatible way to access meta data, and profiling.
This chapter is followed by "MySQL Server Administration", which comprises of user and privilege management, retrieving database information, and checking the server status. The book is concluded with a Troubleshooting chapter that gives hints on how to solve common errors.
After a first overview over the user interface, the author explains how to create databases and tables, and how to enter data. A quick overview over phpMyAdmin's querying capabilities concludes the "First steps" chapter. Next, the author dives into changing data. I was surprised to learn that phpMyAdmin has a multi-row editing feature.
The "Changing Table Structures" chapter deals with how to edit table definitions and the various column types like TEXT, BLOB ENUM, and DATE. This chapter also deals with index management, and explaining queries.
Chapter 7, "Exporting Structure and Data", deals with exporting databases. Though I personally have never seen the value of exporting a database to anything else than SQL, I was rather surprised to learn that phpMyAdmin supports exporting to PDF, Word, Excep, Open Office, Latex, XML, or YAML format.
Consequently, the next chapter deals with importing structure and data. Due to various server limits like timeout, or limitations of the file upload size, this is not always as easy as it might seem. The author explains the problems and shows ways to circumvent restrictions, which I think is very important, as I see quite a few users in the field struggling with importing large database dump files.
Chapter 9 deals with searching the database, without having to write SQL statements. I was not aware, for example, of the possiblity to search all database tables for strings or even regular expressions. The next chapter covers table and database operations, including table maintenance, renaming tables, moving and copying tables, appending data to a table, and even copying a whole database, which can be an interesting alternative to creating a backup before upgrading it. The database backup feature is complemented by the possibility to rename a database, thus allowing you to create a backup and potentially restore it without having do download and upload SQL dumps.
Chapter 11 introduces the relational system. Since MyISAM tables do not support key relationships, phpMyAdmin can optionally administer information about table relations. The author explains how to set up phpMyAdmin to do this, and continues by introducing the Designer, which is an ajaxy tool to work with table relationships, foreign keys, and check the referential integrity of a database.
Of course, a chapter on how to write SQL statements with phpMyAdmin can not be left out from a book like this. The author explains how phpMyAdmin helps the user to write SQL statements, and shows how an external SQL validator can be used, to make sure that the statements conform to the SQL standard. He then dives into creating multi-table queries, which is where more complex criteria and joins come into play.
Next, the author explains bookmarks, a way of storing statements for later reuse, just like browser bookmarks. In that chapter, I was surprised to learn that phpMyAdmin even allows changing the default initial query that is executed when the table is browsed.
Following a short chapter on how to create database documentation in tabular or PDF format, mime-based transformations are explained. Mime-based transformations allow you, for example, to configure phpMyAdmin to display thumbnails of images stored in the database, format dates, create links, or display strings in hex format, which can be useful to debug issues with different or wrong character encodings. These transformations were, admittedly, completely new for me, and I think they may in fact be one of the most powerful features phpMyAdmin has.
Towards the end of the book, the author covers an important topic, namely character sets and collations. He explains the differences between MySQL versions before and after 4.1, and then continues with a short introduction of new features in MySQL 5, like views, stored procedures, triggers, information_schema as the standards-compatible way to access meta data, and profiling.
This chapter is followed by "MySQL Server Administration", which comprises of user and privilege management, retrieving database information, and checking the server status. The book is concluded with a Troubleshooting chapter that gives hints on how to solve common errors.
.Product Description
It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination.Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create.
With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications.
This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic.
In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now).
The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject.
From the Back Cover
When static HTML pages no longer cut it, you need to step up to dynamic, database-driven sites that represent the future of the Web.
In PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, the author of best-selling guides to both the database program (MySQL) and the scripting language (PHP) returns to cover the winning pair in tandem-the way users work with them today to build dynamic sites using Open Source tools.
Using step-by-step instructions, clearly written scripts, and expert tips to ease the way, author Larry Ullman discusses PHP and MySQL separately before going on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications.
A companion Web site includes source code and demonstrations of techniques used in the volume.
If you're already at home with HTML, you'll find this volume the perfect launching pad to creating dynamic sites with PHP and MySQL.
December 2008 | English | ISBN-13: 978-0-596-00630-3 | 814 Pages | PDF | 38.7 MB
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 your results with LIMIT and ORDER BY
* Use cookies and sessions to track visitors' login information and personalize the site for users
* Protect your data from SQL injection attacks
* Use regular expressions to validate information on forms
* Dynamically display text based on session info and create images on the fly
* Pull syndicated data from other sites using PHP and XML
Throughout the book, you'll build sophisticated examples -- including a mailing list, a job board, and an online dating site -- to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.
ISBN: 0131867164 Publisher: Prentice Hall PTR Author: Marc Wandschneider
PHP and MySQL have become a serious and commercially viable system with which to develop web applications. With the relase of PHP 5, J2EE developers, in particular, are starting to take a second look at PHP. And while there are many books on the makret that describe PHP language syntax, there are very few that fully describe web application development with PHP and related technologies. This book describes the complete web application development lifecycle, from planning the application to designing the user interface to building in robust security. And since web applications serve the entire world, often neglected globalization issues are treated in detail. Though MySQL is used throughout the examples, Part IV also contains examples of building applications on top of both Oracle and PostgresSQL, two popular alternatives to MySQL for use in mission-critical systems.
or
Step-by-step instructions for using PHP, a popular Web scripting language. Coverage progresses from first principles to a working knowledge of the PHP programming language, with chapters covering basic features of the language, functions and techniques, and library code. Chapter quizes and exercises are included. An understanding of the Web and of HTML is assumed, and some of the examples are written to work with SQL databases. Although no prior knowledge of programming is required, some experience with a language such as C or Perl is helpful.
Subscribe Now: Feed Icon
