Have a read of AJAX in Plugins, then see if you can adapt this code to what Highcharts is wanting:
add_action('wp_ajax_wpse_77392_get_json', 'wpse_77392_get_json');
add_action('wp_ajax_nopriv_wpse_77392_get_json', 'wpse_77392_get_json');
function wpse_77392_get_json() {
global $wpdb;
$sql = "
SELECT `date`,`value`
FROM {$wpdb->prefix}table_name
WHERE `date` BETWEEN '2011' AND '2012'
ORDER BY `date` ASC;
";
$results = $wpdb->get_results($sql);
$json = json_encode($results);
header('Content-type: application/json');
echo $json;
exit;
}
Related Posts:
- AJAX in plugin wp_send_json() sending html
- Create WordPress posts from JSON array using plugin in admin
- Call Ajax URL in Plugin
- In a plugin, How to update a json file using ajax
- How to use Datatable with Ajax when creating plugin on WordPress?
- Ajax specific template not loading in replacement of index.php
- Plugin Admin Page Ajax-Admin call returning 0, URL set correctly. Implemented localized scripts but did not fix it
- Using AJAX to generate front end / viewer end pages
- Using color picker in plugin, does input attribute order matter?
- How to handle cookies from a WordPress plugin on a cached page?
- Ajax : Call undefined function plugin_function() … can’t call any plugin function
- wordpress file upload with ajax when site is ajaxyfi
- Post Comments with Ajax in WordPress
- AJAX search as you type? [duplicate]
- WordPress api call using wp-ajax returns error 400
- AJAX call – failling to call do_action
- how to insert data in wordpress table usnig jquery ajax
- Using wpdb without loading all plug-ins via wp-load.php
- What are the Best Practises When Using AJAX in Plugin Development?
- Admin AJAX doesn’t work in plugin admin page – Even though code is copied verbatim from WordPress Codex
- AJAX fileupload – TypeError: not a function ajaxSubmit()
- Call plugin with php function
- Render Modula Plugin Shortcode On Ajax Request
- Prevent plugin from intruding on wp-json posts api
- AJAX on Front-End Button Click not working – Custom Plugin
- How to handle WordPress Plugin Front-end AJAX Call [duplicate]
- Does having more than 30 Admin Ajax affects site performance (plugin)?
- Submit Form data to another page via Ajax (WordPress Way)
- AJAX Load more start with x posts
- Is it safe to use admin-ajax.php in the frontend?
- plugin shortcode not working on ajax request call
- wordpress add_action() issue in ajax call
- How to display checked posts on another page over AJAX? (like comparasion style)
- PHP script from functions php is loaded via admin-ajax to div…and the result is 0, not the desired content
- Ajax Plugin Not Echoing Response
- where do I send my ajax calls
- Ajax save data to database on document ready, no data being saved
- WordPress front end AJAX. Return 0 :?
- WordPress Ajax code is not Working
- Using WordPress to build membership Page
- don’t call ajax if not plugin page
- How to get specific string/value from an array? php [closed]
- coding a WordPress AJAX Form using PHP to check if User is Logged Out and Show error
- How to do the simplest possible frontend ajax call from a plugin?
- Proper way to handle admin-ajax calls
- woocommerce search by sku and title ajax
- URL rewrite with external JSON query
- Using custom php file for ajax url inside plugin
- Where Should i write the code for wordpress ajax voting?
- Asynchronous request in wordpress
- Remove value from array within post meta ajax admin
- How do I localize admin-ajax.php that is used in Ajax Load More – Infinite Scroll?
- Convert to shortcode?
- Is there a better way of handling AJAX requests in WordPress?
- Ajax object not defined – JS file is in plugin folder
- How to get CPT category checkbox list and show post of selected(multiply) checkboxes via ajax?
- WP Rest API and json_decode()
- WordPress subfolder installation AJAX Problem
- How to request admin-ajax.php correctly when wordpress URL and site URL are different?
- WordPress API functions not working at AJAX functions.php call
- Plugin not working locally, but works on server
- Passing PHP Variables to AJAX Loaded Pages
- How to include my Ajax calls in one function instead of calling different ones every time?
- wp_ajax action responds with 0
- Calling a class method instantiated by ajax call in wordpress [closed]
- Why AJAX response 0!
- Using conditional staements to load plugins
- Ajax Call in page theme not working?
- Loading by Ajax a plugin that also uses Ajax
- Call ajax on the frontend
- How to implement a plugin featuring foursquare like check-in
- Using AJAX to run SQL statement and populate dropdown
- Ajax request sends url rather than data
- Problem with ajax plugin for refreshing posts
- grab or load text on demand
- best way to run a php script away from the template?
- How to call php file in theme directory from plugin
- Need help creating asynchronous data scraper in WordPress
- admin-ajax.php 500 error when new users try to register
- Ajax call not working in wordpress through a plugin
- Send Array from JS to php file then insert it in wp database through a plugin
- can’t unzip file
- Ajax 400 error when used inside a plugin
- AJAX call inside plugin class is not getting to it’s response function
- Strange admin-ajax / CSS / $_SESSION issue
- wp_query ‘s’ parameter does not work with WC_AJAX
- wc_get_template_part doesnt display the content [duplicate]
- Jquery POST Ajax Return null data in wordpress
- How do I reinit WordPress plugins dynamically using jS?
- Upload Javascript and json webpage to wordpress
- How can I adjust my function so the page editor still loads in the backend?
- I’m receiving the following error using the below code: Uncaught Error: Cannot use object of type WP_REST_Response as array
- How to add a PW Gift Card to a Woocommerce Order request API?
- Error datatable whit ajax
- Facing Problem with admin-ajax.php URL – Getting 404 with AJAX call
- Trouble with AJAX using GET
- WP Ajax DB issues
- Calling PHP function with AJAX
- Adding LOAD MORE on a page
- Cannot pass value variable to WP AJAX functions