Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying FusionCharts Beginner's Guide: The Official Guide for FusionCharts Suite
  • Table Of Contents Toc
FusionCharts Beginner's Guide: The Official Guide for FusionCharts Suite

FusionCharts Beginner's Guide: The Official Guide for FusionCharts Suite

5 (1)
close
close
FusionCharts Beginner's Guide: The Official Guide for FusionCharts Suite

FusionCharts Beginner's Guide: The Official Guide for FusionCharts Suite

5 (1)

Overview of this book

User experience can make or break any app these days, no matter whether it's a commercial product or an internal solution. While most web applications out there are boring and outdated when it comes to their charting, you can make yours both stunning and powerful using FusionCharts Suite. Once you have mastered it, you can give your users a delightful reporting experience in no time at all. FusionCharts Beginner's Guide is a practical, step-by-step guide to using FusionCharts Suite for creating delightful web reports and dashboards. Getting you started quickly, you will learn advanced reporting capabilities like drill-down and JavaScript integration, and charting best practices to make the most out of it. Filled with examples, real-life tips and challenges, this book is the firstofitstype in the visualization industry. The book teaches you to create delightful reports and dashboards for your web applications assuming no previous knowledge of FusionCharts Suite. It gets your first chart up in 15 minutes after which you can play around with different chart types and customize them. You will also learn how to create a powerful reporting experience using drill-down and advanced JavaScript capabilities. You will also connect your charts to server-side scripts pulling data from databases. Finally you round up the experience learning reporting best practices including right chart type selection and practical usability tips. By the end of the book, you will have a solid foundation in FusionCharts Suite and data visualization itself. You will be able to give your users a delightful reporting experience, from developers to management alike.
Table of Contents (16 chapters)
close
close
FusionCharts
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface

Time for action — creating a chart in PHP using data from MySQL


  1. 1. Create a blank PHP file named chart_from_mysql.php in the root of your web application.

  2. 2. Type the following code in it:

    <?php
    include("/Includes/FusionCharts.php");
    include("/Includes/DBConn.php");
    ?>
    <html>
    <head>
    <title>FusionCharts XT - Plotting data from MySQL</title>
    <script src="Charts/FusionCharts.js"></script>
    </head>
    <body>
    <center>
    <?php
    // Connect to the Database
    $link = connectToDB();
    // Fetch all total revenue of the last 3 years using SQL Query
    $strQuery = "SELECT SUM( order_amount ) AS SUM, YEAR( order_date ) AS YEAR FROM orders GROUP BY YEAR ( order_date )";
    $result = mysql_query($strQuery) or die(mysql_error());
    $strXML = "<chart caption='Annual Revenue - last 3 years' numberPrefix='$'>";
    while($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    $strXML .= "<set label = '".$row['YEAR']."' value = '".$row['SUM']."' />";
    }
    $strXML .=...
Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
FusionCharts Beginner's Guide: The Official Guide for FusionCharts Suite
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon