Joe Wu is a full-time Senior PHP Web

Joe Wu is a full-time Senior PHP Web Developer, and has been in the industry since 2005. He has worked on various projects of all sizes and is familiar with most of the open source technologies surrounding PHP web development. Joe is always enthusiastic about new and upcoming technologies and is keen to learn and pick up new skill-sets wherever possible and utilize them in his current or future projects. He is also keen to learn about new opportunities and innovative ideas out there, and believes that the market is always wide open for new and upcoming innovations to improve our way of living. Aside from all the technological computer work, Joe is a professional badminton player and manages to somehow fit a near full-time training schedule together with his full-time job. Joe’s best ranking of 59th in the world in singles and the attendance of the Commonwealth Games Delhi 2010 means that he has equally as much experience in badminton and web developing. Aside from all the endeavors, Joe also works for his own company (with his business partner) to put his skills and experience to good use and to help anyone who needs assistance with web development. Wackyinnovation ( promotes the concept of always moving forward and coming up with and utilizing new technologies and ideas. Their always enthusiastic and can-do attitude ensures jobs are done to perfection with an innovative edge on their competitors. Shameemah Kurzawa has been programming since she was at high school. Being motivated to be a Systems Analyst, she pursued both undergraduate and postgraduate studies in Business Information System and Software Engineering, respectively. She has been working as a Web Developer/Analyst for the past five years, for a renowned company SBS (Special Broadcasting Service) in Australia. Besides work, she enjoys spending her time with her family (she is the mum of a little two year old baby boy) and enjoys travelling as well as investigating new technologies. I would like to thank my husband, my son, and the Packt Publishing team for their support and understanding in reviewing this book.

About the Reviewers Md. Mahmud Ahsan graduated in

About the Reviewers Md. Mahmud Ahsan graduated in Computer Science & Engineering from the International Islamic University Chittagong (IIUC) in Bangladesh. He is a Zend Certified Engineer and expert in developing web applications, Facebook applications, Mashup applications, and iPhone-native applications. Besides his full time job, he blogs at and writes articles on different technologies, especially Facebook applications development. He lives in Bangladesh with his wife Jinat. Currently, Mahmud works as a Software Engineer (remote developer) in i2we inc. (867 Avalon, Lafayette, CA) where he develops social web applications using PHP, MySQL, JavaScript, Zend Framework, CodeIgniter, jQuery, and Mashup APIs. He also leads various small to medium level projects. Mahmud is also an Indie iPhone application developer and publishes his own applications at He was a technical reviewer of the Zend Framework 1.8 Web Application Development book by Packt Publishing. I m very grateful to my father who bought a computer for me in 2001. Since then, I have loved programming and working with various technologies.

About the Author Vijay Joshi is a programmer

About the Author Vijay Joshi is a programmer with over six years of experience on various platforms. He discovered his passion for open source four years ago when he started playing with PHP on a hobby project after completing his Masters in Computer Applications. Vijay is a professional web developer now and prefers writing code ONLY in open source (but that does not always happen, unfortunately!). He switches hats as needed he is full-time lead programmer at Philogy, independent consultant for a few selected companies where he advises them on a variety of Internet-based initiatives, and still remains an active blogger at Besides his work, he enjoys reading, trekking, and sometimes getting obsessed with fitness. Writing a book is a long and complicated task which requires the support and coordination of many people. I am thankful to the entire team at Packt, especially Michelle, Chaitanya, and Neha for being so cooperative and patient with me. This book is dedicated to all open source developers, contributors, and enthusiasts around the world who have made PHP and jQuery the leading programming tools in their niche. A big thank you to you guys. I am feeling both proud and excited to be able to contribute to the community that gave me so much to learn. On a personal note, I would like to thank my parents, my brother Ajay, and Sheethal for their support and encouragement. A special thanks to Ravindra Vikram Singh for helping me get started on this project.

Credits Author Vijay Joshi Reviewers Anis Ahmad Md.

Credits Author Vijay Joshi Reviewers Anis Ahmad Md. Mahmud Ahsan Joe Wu Shameemah Kurzawa Acquisition Editor Chaitanya Apte Development Editor Neha Mallik Technical Editors Mohd. Sahil Hithesh Uchil Editorial Team Leader Aanchal Kumar Project Team Leader Ashwin Shetty Project Coordinator Michelle Quadros Proofreader Mario Cecere Indexer Hemangini Bari Production Coordinator Aparna Bhagat Cover Work Aparna Bhagat

PHP jQuery Cookbook Copyright 2010 Packt Publishing

PHP jQuery Cookbook Copyright 2010 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information. First published: December 2010 Production Reference: 1081210 Published by Packt Publishing Ltd. 32 Lincoln Road Olton Birmingham, B27 6PA, UK. ISBN 978-1-849512-74-9 Cover Image by Vinayak Chittar (

sources in Reporting Services. This connector supports images,

sources in Reporting Services. This connector supports images, attachments, rich text, unread marks, parent/response relationships, full-text search, formulas, and much more. (2) Notes Mail Delivery Extension: Allows any scheduled reports in Reporting Services to be routed to subscribers via native Notes mail. (3) Notes Database Delivery Extension: Allows any scheduled reports in Reporting Services to be deposited into Notes/Domino databases (great for building report archiving/workflow/distribution applications). OfficeWriter SoftArtisans OfficeWriter enables the design, publishing, and delivery of reports directly from Microsoft Excel and Word using SQL Server Reporting Services or ASP.NET. End users design and publish their Reporting Services reports without ever leaving Microsoft Office avoiding design tools, like VS.NET, that are unfamiliar to most business users. OfficeWriter creates Reporting Services reports (RDL files), but unlike Reporting Services Excel output, all Excel features such as pivot tables, VBA, macros, advanced formulas, and charts are preserved by OfficeWriter. Without OfficeWriter, Reporting Services cannot deliver reports in Microsoft Word format. OfficeWriter-rendered documents preserve all the Word features contained in the user s existing Word template. All this is accomplished without the need for Microsoft Office on the server.

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost JSP Web Hosting services

Fenestrae Fenestrae extends Microsoft SQL Server Reporting

Panorama Software Panorama Software offers a powerful and intuitive front end to SQL Server Analysis Services. Panorama extends the Microsoft Platform through integrated business intelligence and corporate performance management solutions. With Panorama, decision makers at all levels and functions can easily analyze data, quickly create and distribute reports, and proactively measure performance. Companies gain a greater understanding of their business and make better decisions. These informed decisions improve profitability, increase revenues, reduce costs and time to market, and mitigate competitive risks. Panorama is a leading innovator of business intelligence solutions and supports customers worldwide in industries such as financial services, manufacturing, healthcare, retail, telecommunications, and life sciences. ProClarity Microsoft SQL Server Reporting Services integrates seamlessly with the ProClarity product family, providing customers with a comprehensive and cost-effective reporting and analysis solution that s very easy to implement. The ProClarity Analytics Server allows organizations to publish collections of views onto a middle-tier server for centralized access to analytical information. With Reporting Services, customers can launch relational reports from the ProClarity environment, making both relational and OLAP (online analytical processing) reports within a common context available to the broadest range of decision makers throughout the enterprise. Proposion Proposion Report Adapter connects Microsoft Reporting Services to Lotus Notes/Domino environments. This product extends Reporting Services in three ways: (1) Notes/Domino Data Extension: A fast, robust, and feature-rich data driver that turns your Notes and Domino databases into first-class data 386 Part VII: The Part of Tens

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Adult Web Hosting services

Fenestrae Fenestrae extends Microsoft SQL Server Reporting

Fenestrae Fenestrae extends Microsoft SQL Server Reporting Services beyond the desktop to make business information more widely available within the company and business partner networks. Fenestrae Communication Server makes Business Intelligence available anywhere, anytime, and on any device. With Fenestrae and SQL Reporting Services, you can ensure real-time, automatic delivery of business information to remote locations, including reports as faxed documents or KPIs as mobile SMS and MMS messages when on the move. GFI GFI FAXmaker for Exchange/SMTP is a leading network fax server. It integrates with Exchange Server and popular SMTP servers, enabling you to send and receive faxes and SMS/text messages directly from your e-mail client. By using the e-mail server and Active Directory, GFI FAXmaker provides reliable fax administration through your existing infrastructure. GFI FAXmaker fully supports the use of Microsoft SQL Server Reporting Services. It can log all incoming and outgoing faxes to Microsoft SQL Server and enables users to easily create custom reports such as billing/fax usage, fax notifications, and more. OutlookSoft OutlookSoft CPM is a fully integrated Microsoft-based Corporate Performance Management application. Microsoft Reporting Services extends the reach of OutlookSoft s CPM to a whole new level of detail. Customers can access data from relational tables as well as Analysis Services through the application interface. Reporting Services will be integrated into OutlookSoft solutions to provide greater reporting flexibility to meet business challenges in areas such as Sarbanes Oxley, Line item detail analysis, and Security and audit reporting. OutlookSoft CPM provides access to Reporting Services through a secured browser interface and through a patented Web-based Microsoft Excel interface. Chapter 24: Ten Third Party Tools to Use with Reporting Services 385

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Adult Web Hosting services

Chapter 24 Ten Third Party Tools to Use

such as CICS, IMS, VSAM, COBOL, RPG, DB2, Enscribe, RMS, Oracle, and many others. Founded in 1987 and a Microsoft Partner, Attunity and its worldwide operations support more than 1,000 direct end users. Attunity s support of the Microsoft SQL Server Reporting Services offers customers real-time access to corporate and enterprise data. With Attunity Connect, you have the flexibility to analyze and generate reports with the right data at the right time. Cizer Software Cizer.Net Reporting for Reporting Services is the Web-based Business Intelligence suite from Cizer Software. It provides full report authoring in the browser, and does not require Visual Studio or any .Net client or download of any kind, including ActiveX controls or Java applets. The built-in Portal features configurable links to Cizer Quick Query ad hoc reports for Business Users, mid-level Cizer Report Builder reports with global libraries, charts, and parameters for intermediate authors, as well as the ability to run advanced Visual Studio reports from the Cizer Portal. Originally launched with Reporting Services in 2004, Cizer.Net Reporting has become a standard component of SQL Server BI implementations, and in December 2004 became the first Reporting Services application to pass the Microsoft Gold-level ISV BI Test. Dundas Software Dundas Software, founded in 1992, specializes in data visualization solutions for the Microsoft .NET Framework. Data visualization is the graphical presentation of information, with the goal of providing the viewer with a qualitative understanding of the information contents. Portions of Dundas Chart for .NET technology are currently being utilized within Microsoft SQL Server 2000 Reporting Services to display a variety of advanced charts. With the next release of Reporting Services, users will have the ability to create charts using Dundas Chart for Reporting Services, a charting add-on, which will take advantage of the extensive features found in the Enterprise Edition of Dundas Chart for .NET. This additional charting functionality will offer developers more sophisticated charts, new chart types, and many advanced customization options beyond what is standard. 384 Part VII: The Part of Tens

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Clan Web Hosting services