There are many reasons for serving up dynamic content from a web site:to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.
Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look.
But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.
Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.
Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.
This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thorougly described in the text. Topics include: Installation and configuration of Apache, MySQL, and PHP on Unix®, Windows®, and Mac OS® X systems Introductions to PHP, SQL, and MySQL administration Session management, including the use of a custom database for improved efficiency User input validation, security, and authentication The PEAR repository, plus details on the use of PEAR DB and Template classes Production of PDF reports
PHP and MySQL go hand in hand; the former has been carefully adapted, through the efforts of the open-source community, to the latter. For situations that require dynamic content but don't merit the complexity and development time of Java or .NET enterprise applications, the PHP language and the MySQL database server fit the bill perfectly. That's the point Hugh Williams and David Lane make in Web Database Applications with PHP & MySQL, which combines language tutorials with application design advice to yield a comprehensive picture of its subjects at a reasonable price. Williams and Lane--both Australian academics who use an online wine store in many of their examples--deserve tremendous kudos for their way of presenting recommended coding strategies. Though the code listings themselves aren't remarkably well commented, the authors do a commendable job of explaining in prose what the code is up to.
Case in point: The ever-essential task of using PHP to open a connection to a MySQL database, submit a query to that database, receive a response, and format the returned rows, if any. The book addresses this problem with a straight code listing, followed by text that explains what's happening in five numbered steps. Similar care goes to the other popular applications of the PHP/MySQL duo: session management, shopping carts, and authentication of users. --David Wall
Topics covered: How to use the PHP server-side scripting language and the MySQL database engine to underlie dynamic Web sites (those that rely on database queries) and full-on Web applications, such as those that require session management and maintenance of user rosters. Tutorials in both subjects begin with the basics and proceed through moderately complicated stuff, though there's no absolutely comprehensive reference here.
Publisher:
O'Reilly Media, Inc.
Author:
Hugh E. Williams
Release Date: 2004-05-16
ISBN/EAN: 0596005431 / 9780596005436
First, there was HTML. Then along came JavaScript. Close on the heels of JavaScript came CSS and before you mastered that, along came XML. Behind every successful web page is an overworked and underappreciated webmaster with a big pile of books about various web technologies spilling out across their desk.
That collection of books is a valuable resource for delving into the topics at depth (and at leisure). But when you need an answer fast, the dog-eared book you'll turn to again and again is the new third edition of "Webmaster in a Nutshell,"
This concise and portable quick reference distills an immense amount of information on several languages and technologies into one compact reference book. This is one book that will pay for itself a thousand times over in time saved and increased productivity.
"Webmaster in a Nutshell" puts a fast-paced introduction, detailed reference section, and quick reference guide to each technology all within easy reach. It's packed full of the genuinely useful information a webmaster needs daily, whatever the technology, including:
HTML
CSS
XML
CGI
JavaScript
HTTP
PHP
Apache
This thorough, clear, and accessible reference makes it easy to find the information you want about the technologies you use. You'll keep your other books on the shelf; you'll keep "Webmaster in a Nutshell" next to your keyboard.
This terrific reference book condenses the material of at least five huge volumes on Web site construction into a single small one. It doesn't teach how to develop and maintain a Web site, but it puts all the commands, syntax information, and related knowledge where you can find them quickly. Sections cover HTML, CGI, HTTI, JavaScript, and server configurations. Each section begins with a brief overview of the topic then follows with a series of well-organized lists, charts, and other reminders to help you rapidly find a little-used command or forgotten bit of information.
Publisher:
O'Reilly Media, Inc.
Author:
Stephen Spainhour
Release Date: 2002-12-01
ISBN/EAN: 0596003579 / 9780596003579
Over the last few years, Linux has grown both as an operating system and a tool for personal and business use. Simultaneously becoming more user friendly and more powerful as a back-end system, Linux has achieved new plateaus: the newer filesystems have solidified, new commands and tools have appeared and become standard, and the desktop--including new desktop environments--have proved to be viable, stable, and readily accessible to even those who don't consider themselves computer gurus.
Whether you're using Linux for personal software projects, for a small office or home office (often termed the SOHO environment), to provide services to a small group of colleagues, or to administer a site responsible for millions of email and web connections each day, you need quick access to information on a wide range of tools. This book covers all aspects of administering and making effective use of Linux systems. Among its topics are booting, package management, and revision control. But foremost in "Linux in a Nutshell" are the utilities and commands that make Linux one of the most powerful and flexible systems available.
Now in its fifth edition, "Linux in a Nutshell" brings users up-to-date with the current state of Linux. Considered by many to be the most complete and authoritative command reference for Linux available, the book covers all substantial user, programming, administration, and networking commands for the most common Linux distributions.
Comprehensive but concise, the fifth edition has been updated to cover new features of major Linux distributions. Configuration information for the rapidly growing commercial network services and community update services isone of the subjects covered for the first time.
But that's just the beginning. The book covers editors, shells, and LILO and GRUB boot options. There's also coverage of Apache, Samba, Postfix, sendmail, CVS, Subversion, Emacs, vi, sed, gawk, and much more. Everything that system administrators, developers, and power users need to know about Linux is referenced here, and they will turn to this book again and again.
Publisher:
O'Reilly Media, Inc.
Authors:
Ellen Siever, Aaron Weber, Stephen Figgins, Robert Love, Arnold Robbins
Release Date: 2005-07-27
ISBN/EAN: 0596009305 / 9780596009304
PHP is a simple yet powerful open source scripting language that has become a big player in web development. Over a million web sites, from large corporate sites to small personal sites, are using PHP to serve dynamic web content. PHP's broad feature set, approachable syntax, and support for different operating systems and web servers make it an ideal language for rapid web development. The PHP Cookbook is a collection of problems, solutions, and practical examples for PHP programmers. The book contains a unique and extensive collection of best practices for everyday PHP programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe" -- short, focused pieces of code that you can insert directly into your applications. But this book offers more than cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the problem-solving techniques to similar situations. The recipes in the PHP Cookbook range from simple tasks, such as sending a database query and fetching URLs, to entire programs that demonstrate complex tasks, such as printing HTML tables and generating bar charts. This book contains over 250 recipes on the following topics:
Working with basic data types, including strings, numbers, dates and times, and arrays
PHP building blocks, such as variables, functions, classes, and objects
Web programming, including forms, database access, and XML
Useful features like regular expressions, encryption and security, graphics, internationalization and localization, and Internet services
Working with files and directories
Command-line PHP and PHP-GTK
PEAR, the PHP Extension and Application Repository
This book contains an impressive collection of useful code for PHP programmers, from novices to advanced practitioners. Instead of poking around mailing lists, online documentation, and other sources, you can rely on the PHP Cookbook to provide quick solutions to common problems, so you can spend your time on those out-of-the-ordinary problems specific to your application.
Publisher:
O'Reilly Media, Inc.
Authors:
David Sklar, Adam Trachtenberg
Release Date: 2002-11-20
ISBN/EAN: 1565926811 / 9781565926813
Consisting of a number of well-known open source products, JBoss is more a family of interrelated services than a single monolithic application. But, as with any tool that's as feature-rich as JBoss, there are number of pitfalls and complexities, too.
Most developers struggle with the same issues when deploying J2EE applications on JBoss: they have trouble getting the many J2EE and JBoss deployment descriptors to work together; they have difficulty finding out how to get started; their projects don't have a packaging and deployment strategy that grows with the application; or, they find the Class Loaders confusing and don't know how to use them, which can cause problems.
"JBoss at Work: A Practical Guide" helps developers overcome these challenges. As you work through the book, you'll build a project using extensive code examples. You'll delve into all the major facets of J2EE application deployment on JBoss, including JSPs, Servlets, EJBs, JMS, JNDI, web services, JavaMail, JDBC, and Hibernate. With the help of this book, you'll:
Implement a full J2EE application and deploy it on JBoss
Discover how to use the latest features of JBoss 4 and J2EE 1.4, including J2EE-compliant web services
Master J2EE application deployment on JBoss with EARs, WARs, and EJB JARs
Understand the core J2EE deployment descriptors and how they integrate with JBoss-specific descriptors
Base your security strategy on JAAS
Written for Java developers who want to use JBoss on their projects, the book covers the gamut of deploying J2EE technologies on JBoss, providing a brief survey of each subject aimed at the working professional with limited time.
If you're one of thelegions of developers who have decided to give JBoss a try, then "JBoss at Work: A Practical Guide" is your next logical purchase. It'll show you in plain language how to use the fastest growing open source tool in the industry today. If you've worked with JBoss before, this book will get you up to speed on JBoss 4, JBoss WS (web services), and Hibernate 3.
Publisher:
O'Reilly Media, Inc.
Authors:
Tom Marrs, Scott Davis
Release Date: 2005-10-13
ISBN/EAN: 0596007345 / 9780596007348
Setting up and maintaining a Linux server requires understanding not only the hardware, but the ins and outs of the Linux operating system along with its supporting cast of utilities as well as layers of applications software. There's basic documentation online but there's a lot beyond the basics you have to know, and this only comes from people with hands-on, real-world experience. This kind of "know how" is what we sought to capture in Linux Server Hacks. Linux Server Hacks is a collection of 100 industrial-strength hacks, providing tips and tools that solve practical problems for Linux system administrators. Every hack can be read in just a few minutes but will save hours of searching for the right answer. Some of the hacks are subtle, many of them are non-obvious, and all of them demonstrate the power and flexibility of a Linux system. You'll find hacks devoted to tuning the Linux kernel to make your system run more efficiently, as well as using CVS or RCS to track the revision to system files. You'll learn alternative ways to do backups, how to use system monitoring tools to track system performance and a variety of secure networking solutions. Linux Server Hacks also helps you manage large-scale Web installations running Apache, MySQL, and other open source tools that are typically part of a Linux system. O'Reilly's new Hacks Series proudly reclaims the term "hacking" for the good guys. Hackers use their ingenuity to solve interesting problems.
Publisher:
O'Reilly Media, Inc.
Author:
Rob Flickenger
Release Date: 2003-01
ISBN/EAN: 0596004613 / 9780596004613
While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut. MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations. The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to:
Import data from external sources
Export data for use by external programs
Access MySQL from your web server
Use scripts with MySQL to read queries from a file
Access MySQL from within client programs that use Perl, PHP, Java, Python and other languages
Construct queries that solve commonly-occurring questions
Interact with the server
This learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch.
Good programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel. If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process.
DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You'll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they're working with, or that they're able to transliterate the one DuBois has provided. It's usually not a big problem. --David Wall
Topics covered: How to make MySQL databases do your bidding--in terms of queries, table manipulation, data formatting, transactions, and Web interfaces--through the database server's command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques.
Publisher:
O'Reilly Media, Inc.
Author:
Paul DuBois
Release Date: 2002-11
ISBN/EAN: 0596001452 / 9780596001452
Professional Apache is the book for anybody who needs to get the most out of the Apache Web Server. If you're thinking of setting up Apache for the first time, or of moving an existing web site to a dedicated server, then this book will help you build the server you want. It's also full of information on how to add new capabilities to existing servers, like e-commerce, PHP, or server-side Java support.This book provides you with the author's real-world knowledge of Apache's intricacies and annoyances, including undocumented information gleaned from source-code and experience.
Peter Wainwright's book provides web server administrators and ISPs with the information they need to apply Apache to real world problems, using real examples, without bogging them down in excessive detail about every configuration directive.The key theme is 'Apache the way you want it' - through extensive examples, this book gives you the information you need to build, configure and extend Apache to suit your requirements.
With comprehensive coverage of the many issues a Web server administrator faces, Professional Apache is a terrific resource for those looking to implement the popular open-source Web server. This title covers installation, configuration, and customization of the Apache Web server.
Apache devotee Peter Wainwright dishes up plenty of tips for making the most of Apache. He begins with a couple of introductory chapters that cover some of the basic networking concepts of the Internet and an overview of the Apache server. Readers who have experience with other Web servers should be able to get up to speed with Apache here without a problem.
The text covers the various configuration files that determine Apache's personality, illustrating how to achieve particular goals with small snippets of code. The author goes far beyond this, however, using examples of how to configure Apache to manage multiple sites, monitor the server's performance, apply security, and extend the product with several third-party add-on modules.
There aren't any fluffy elements to this book's format. It is entirely composed of detailed information that is most often presented in short, easily digestible chunks with meaningful headings, and it finishes off with a series of appendices that include a number of critical lists such as available modules and directives. Professional Apache is a very useful administration tool, indeed. --Stephen W. Plain
Topics covered: TCP/IP and HTTP overview, installation and build procedures, server configuration, aliases, redirection, CGI implementation, virtual hosting, performance optimization, security, mod_perl, PHP, and Jserv.
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics. Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book. In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.
Publisher:
O'Reilly Media, Inc.
Authors:
Jeremy D. Zawodny, Derek J. Balling
Release Date: 2004-04-08
ISBN/EAN: 0596003064 / 9780596003067
Apache is the most popular web server on the Internet because it is free, reliable, and extensible. The availability of the source code and the modular design of Apache makes it possible to extend web server functionality through the Apache API. For the most part, however, the Apache API has only been available to C programmers, and requires rebuilding the Apache server from source. mod_perl, the popular Apache module used primarily for enhanced CGI performance, changed all that by making the Apache API available to Perl programmers. With mod_perl, it becomes simple to develop Apache modules with Perl and install them without having to rebuild the web server. Writing Apache Modules with Perl and C shows how to extend web server capabilities regardless of whether the programming language is Perl or C. The book explains the design of Apache, mod_perl, and the Apache API. It then demonstrates how to use them to perform for tasks like the following:
Rewriting CGI scripts as Apache modules to vastly improve performance
Server-side filtering of HTML documents, to embed special markup or code (much like SSI)
Enhancing server log functionality
Converting file formats on the fly
Implementing dynamic navigation bars
Incorporating database access into CGI scripts
Customizing access control and authorization to block robots or to use an external database for passwords
The authors are Lincoln Stein and Doug MacEachern. Lincoln is the successful author of How to Set Up and Maintain a World Wide web Site and the developer of the widely used Perl CGI.pm module. Doug is a consultant and the creator of the innovative mod_perl Apache module.
Writing Apache Modules with Perl and C will allow you to enhance your Apache HTTP server in just about any way you'd like. Overall, it is an excellent book, and it has a lot of good information and terrific examples on everything from "Content Handlers" to customizing the Apache server configuration process.
It's quickly apparent that Lincoln Stein and Doug MacEachern spent valuable time writing this book considering the breadth of their subject and the depth they devote to it. The only downside to the book is that it's kind of hard to explain all of the API functionality without assuming a minimum level of competence from the audience. For that reason, this book might be a bit intimidating to novice programmers, but it really rewards you if you put time into it and tinker with things.
The book also works well as a source of ideas and inspiration for when you have to write your own server modules, and I'd recommend it if you want to customize your Apache server or speed up your Perl CGI programs. --Doug Beaver
Publisher:
Authors:
Lincoln Stein, Doug MacEachern, Linda Mui
Release Date: 1999-03
ISBN/EAN:
