{"id":237,"date":"2025-03-13T09:09:11","date_gmt":"2025-03-13T09:09:11","guid":{"rendered":"https:\/\/documentation.iqonic.design\/graphina\/?p=237"},"modified":"2025-03-13T09:21:01","modified_gmt":"2025-03-13T09:21:01","slug":"dynamic-charts-a-comprehensive-guide","status":"publish","type":"post","link":"https:\/\/documentation.iqonic.design\/graphina\/dynamic-charts-a-comprehensive-guide\/","title":{"rendered":"Dynamic Charts: A Comprehensive Guide"},"content":{"rendered":"
\n
\n\n\n\n

How to Retrieve Dynamic Data Using SQL-Builder<\/strong><\/h2>\n\n\n\n

<\/p>\n\n\n\n

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

This guide will walk you through the fastest way to integrate dynamic WordPress charts from a MySQL database using PHP.<\/p>\n\n\n\n

Previously, we discussed what dynamic data is and the commonly used data sources. Now, it’s time to put that knowledge into action by converting static charts into dynamic ones using SQL Builder<\/strong>.<\/p>\n\n\n\n

Fetching Capital Column Data<\/strong><\/h4>\n\n\n\n

To enable uppercase column names, toggle the option as shown in the image.<\/p>\n\n\n\n

Note:<\/strong><\/p>\n\n\n\n

    \n
  • If the offset and limit are unnecessary, set them to null.<\/li>\n\n\n\n
  • You can extract data from any table within your existing WordPress database.<\/li>\n<\/ul>\n\n\n\n

    Steps to Convert Static Charts into Dynamic Charts Using SQL Builder<\/strong><\/h4>\n\n\n\n

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

      Step 2: Change Data Option from Manual to Dynamic<\/strong><\/h4>\n\n\n\n
        \n
      • Navigate to the chart data option.<\/li>\n\n\n\n
      • Switch from “manual”<\/strong> to “dynamic”<\/strong>.<\/li>\n\n\n\n
      • A message stating “No Data Available” will appear until a data source is selected.<\/li>\n<\/ul>\n\n\n\n

        Step 3: Set Dynamic Data to SQL<\/strong><\/h4>\n\n\n\n
          \n
        • Select the Dynamic Data Option<\/strong>.<\/li>\n\n\n\n
        • Change the type to SQL Builder<\/strong>.<\/li>\n\n\n\n
        • A text area will appear for entering raw SQL queries.<\/li>\n\n\n\n
        • As you input the SQL query, the data executes automatically.<\/li>\n<\/ul>\n\n\n\n

          Step 4: Select the Table<\/strong><\/h4>\n\n\n\n
            \n
          • Click on “Select Mode”<\/strong> and choose “Table”<\/strong>.<\/li>\n\n\n\n
          • A drop-down list of available tables will appear.<\/li>\n\n\n\n
          • Select the relevant table to instantly view the data.<\/li>\n<\/ul>\n\n\n\n

            Step 5: Finalizing the SQL Data Integration<\/strong><\/h4>\n\n\n\n
              \n
            • In SQL Builder, click “External”<\/strong>.<\/li>\n\n\n\n
            • Choose the data table<\/strong> from the dropdown list.<\/li>\n\n\n\n
            • Edit the SQL Raw Query<\/strong> as needed.<\/li>\n\n\n\n
            • Set the Y-axis column<\/strong> to define how data is structured in the chart.<\/li>\n\n\n\n
            • Your SQL Builder Chart<\/strong> is now successfully configured!<\/li>\n<\/ul>\n\n\n\n
              \n