{"id":315,"date":"2025-03-13T10:45:30","date_gmt":"2025-03-13T10:45:30","guid":{"rendered":"https:\/\/documentation.iqonic.design\/graphina\/?p=315"},"modified":"2025-03-13T10:45:31","modified_gmt":"2025-03-13T10:45:31","slug":"using-sql-builder-to-fetch-dynamic-data-for-wordpress-charts","status":"publish","type":"post","link":"https:\/\/documentation.iqonic.design\/graphina\/using-sql-builder-to-fetch-dynamic-data-for-wordpress-charts\/","title":{"rendered":"Using SQL Builder to Fetch Dynamic Data for WordPress Charts"},"content":{"rendered":"
\n

Introduction<\/strong><\/h4>\n\n\n\n

In this guide, we’ll explore the fastest way to integrate dynamic charts<\/strong> in WordPress using SQL Builder<\/strong> with MySQL and PHP. Instead of manually updating data, you can leverage SQL queries<\/strong> to pull real-time information directly from your WordPress database.<\/p>\n\n\n\n

We\u2019ve previously discussed dynamic data<\/strong> and its sources\u2014now, it’s time to put that knowledge into action. This tutorial will transform a static chart<\/strong> into a fully dynamic<\/strong> one using SQL Builder.<\/p>\n\n\n\n

\n\n\n\n

How to Use SQL Builder for Dynamic Charts<\/strong><\/h3>\n\n\n\n

Step 1 \u2013 Select Your Chart<\/strong><\/h4>\n\n\n\n
    \n
  • Open Graphina \u2013 WordPress Chart Plugin<\/strong>.<\/li>\n\n\n\n
  • Choose the chart type where you want to display data (e.g., Line Chart<\/strong>).<\/li>\n<\/ul>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 2 \u2013 Switch from Manual to Dynamic Data<\/strong><\/h4>\n\n\n\n
      \n
    • Navigate to the chart data settings<\/strong>.<\/li>\n\n\n\n
    • Change the data source from \u201cManual\u201d<\/strong> to \u201cDynamic\u201d<\/strong>.<\/li>\n\n\n\n
    • At this stage, the chart might display \u201cNo Data Available\u201d<\/strong>\u2014this is expected because the data source hasn\u2019t been selected yet.<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 3 \u2013 Enable SQL Builder<\/strong><\/h4>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
        \n
      • In the Dynamic Data Options<\/strong>, select \u201cSQL Builder\u201d<\/strong> as the data source.<\/li>\n\n\n\n
      • You will now see a text area<\/strong> where you can enter an SQL query.<\/li>\n<\/ul>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Step 4 \u2013 Selecting a Table<\/strong><\/h4>\n\n\n\n
          \n
        • Click on \u201cSelect Mode\u201d<\/strong>, which allows you to choose a table.<\/li>\n\n\n\n
        • A drop-down list of available WordPress database tables<\/strong> will appear.<\/li>\n\n\n\n
        • Select a table from the list\u2014the chart will instantly reflect the selected table’s data.<\/li>\n<\/ul>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          Step 5 \u2013 Writing and Executing SQL Queries<\/strong><\/h4>\n\n\n\n
            \n
          • Write your SQL Query<\/strong> inside the text area. The query will execute automatically, updating the chart in real time.<\/li>\n\n\n\n
          • The column list<\/strong> from your SQL query result will be available for X-Axis and Y-Axis<\/strong> selection.<\/li>\n<\/ul>\n\n\n\n

            Step 6 \u2013 Finalizing the Chart<\/strong><\/h4>\n\n\n\n
              \n
            • Click on \u201cExternal\u201d<\/strong> under the SQL Builder options.<\/li>\n\n\n\n
            • Choose a dataset from the dropdown (e.g., WordPress 2<\/strong>).<\/li>\n\n\n\n
            • Edit your SQL Raw Query<\/strong> and select the desired column<\/strong> for the Y-axis.<\/li>\n\n\n\n
            • The chart will now display live database-driven<\/strong> data.<\/li>\n<\/ul>\n\n\n\n
              \n\n\n\n

              Key Features & Notes<\/strong><\/h3>\n\n\n\n

              \u2705 Supports Any WordPress Database Table<\/strong> \u2013 Fetch data from any table in your WordPress database.
              \u2705 Uppercase Column Names<\/strong> \u2013 Enable the setting for capitalized column names if needed.
              \u2705 Offset & Limit Control<\/strong> \u2013 Set to NULL<\/code> if not required.
              \u2705 Instant Data Execution<\/strong> \u2013 SQL queries automatically update the chart upon execution.<\/p>\n\n\n\n

              By following these steps, you can seamlessly integrate dynamic charts<\/strong> in WordPress using SQL Builder<\/strong>, eliminating the need for manual data updates! \ud83d\ude80<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

              Introduction In this guide, we’ll explore the fastest way to integrate dynamic charts in WordPress using SQL Builder with MySQL and PHP. Instead of manually updating data, you can leverage SQL queries to pull real-time information directly from your WordPress database. We\u2019ve previously discussed dynamic data and its sources\u2014now, it’s time to put that knowledge […]<\/p>\n","protected":false},"author":12,"featured_media":0,"parent":235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-315","post","type-post","status-publish","format-standard","hentry","category-graphina"],"featured_image_src":null,"author_info":{"display_name":"wordpressadminiq","author_link":"https:\/\/documentation.iqonic.design\/graphina\/author\/wordpressadminiq\/"},"children":[],"_links":{"self":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/comments?post=315"}],"version-history":[{"count":1,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/315\/revisions"}],"predecessor-version":[{"id":323,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/315\/revisions\/323"}],"up":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/235"}],"wp:attachment":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/media?parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/categories?post=315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/tags?post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}