Title: Retrieve Live Data from wpdb Last modified: August 21, 2016 --- # Retrieve Live Data from wpdb * Resolved [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/) * I am trying to run some live data feeds into my page. I am using the global $ wpdb variable to access the custom tables and data which works great. * However I have a timer running which re-runs the $wpdb->get_results() and rewrites the results into a div. But after the inital run through the data is not updated as if the $wpdb is not updated. * The function I have is: * ``` get_results( "SELECT NET_AMOUNT FROM wp_dailysales"); foreach($sales as $sale) { $total += $sale->NET_AMOUNT; } $total = $total; ?> ``` * If I refresh the page it pulls in the correct data, just not on the timer. Is there a function that I am missing? * Thanks * Simon Viewing 12 replies - 1 through 12 (of 12 total) * [graphicgeek](https://wordpress.org/support/users/graphicgeek/) * (@graphicgeek) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204241) * I don’t think get_results can update the database. You would need to use $wpdb- >update() inside your foreach loop (or maybe at the end of it?). * [http://codex.wordpress.org/Class_Reference/wpdb#UPDATE_rows](http://codex.wordpress.org/Class_Reference/wpdb#UPDATE_rows) * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204247) * graphicgeek, my take on this is the DB is being updated correctly by other means, the OP’s problem is `get_results()` isn’t finding this new data. * adviceit, it may be `get_results()` is getting cached, out of date results. Try running `$wpdb->flush()` to force getting data from the actual DB. * Thread Starter [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204266) * Hi Guys, * bcworkz you are correct that is the problem i am having I have tried the `$wpdb- >flush();` as well but got same result returned. * I change the script to show what $sale->NET_AMOUNT was and it was still showing the old values after a manual change to the database. But if I refresh the page it shows the new value. * Wierd… * Thread Starter [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204274) * I have also tried * ``` $wpdb = new wpdb( DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); $sales = array(); $total = 0; ``` * To try and clear everything but still getting the old results. * Simon * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204304) * How does your timer trigger your `$wpdb->get_results()` code to run? * [graphicgeek](https://wordpress.org/support/users/graphicgeek/) * (@graphicgeek) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204306) * I wonder if you could somehow “redeclare” $wpdb. Maybe if you wrapped it inside a function or something: * ``` ``` * Not sure if that will work or not, but it seems like the $wpdb variable in the function would get the latest. * Thread Starter [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204310) * ``` function getSales() { $(".updatingSales", this.DOM_obj).removeClass("hideMe"); get_var($wpdb->prepare("SELECT SUM(NET_AMOUNT) FROM wp_dailysales")); ?> $panel = document.getElementsByClassName("panel-6")[0]; $content = $panel.getElementsByTagName("span")[0]; $content.innerHTML = ""; $content.innerHTML = "

Total for is:

£

Next Update: 1:00
"; updatemins = 0; updatesecs = 59; setTimeout(function(){$(".updatingSales", this.DOM_obj).addClass("hideMe")}, 500); setTimeout(function(){getSales()}, 1*60*1000); clearTimeout(salesticker); salesticker = setTimeout(function(){updatesalesticker()}, 1000); } ``` * This is the complete function. it is self calling on the setTimeout after 1 minute. * Thanks * Simon * Thread Starter [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204311) * tried the resetdb() and this had the same result. * Thanks * Simon * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204317) * All PHP is executed on your server before sending the jQuery code to the browser. Once at the browser, the PHP portions are static, the PHP is no longer executed on each iteration. You are just getting the original, now static values each time. * To get update information jQuery needs to send an AJAX request to the browser. It can then receive the updated information and place it in the appropriate HTML element. * Of course then you also need a PHP AJAX handler to accept the request and return the requested information. * Thread Starter [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204331) * Hi * Ok, think i understand what you are saying. The page and the code is static, so the variables will be also. * So if i perform a GET from a new php page which returns the result that will work… * Ok cool, I have now added this to a new PHP page but keep getting Error 500 from the new PHP page, when i try and reference the $wpdb variable or its functions I get this error. * ``` get_var($wpdb->prepare("SELECT SUM(NET_AMOUNT) FROM wp_dailysales")); echo $results; ?> ``` * I think it is because it doesn’t know what the object $wpdb is. So I tried all the includes I could think of without any joy. * Any ideas? * Thread Starter [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204332) * ok sorted the 500 error was wrong reference to the wp-load.php not referencing he right location. * some : “../” needed. * Incase anyone else finds this post here are my scripts: * AJAX call in javascript: * ``` $.ajax({ cache: false, url: "/scripts/sales.php", success:function(data) { $("#sales-figure").html("

Total for is:

£"+data+"

Next Update: 1:00
"); } }); ``` * PHP file: * ``` get_var("SELECT SUM(NET_AMOUNT) FROM wp_dailysales"); if($results == "") { $results = 0; } echo $results ?> ``` * Thank you for your assistance guys. * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204345) * You’re welcome! Glad you got it all sorted. * For the record, that is not really the suggested way to handle AJAX in WordPress. The script should be enqueued and the request should go through wp-admin/admin- ajax.php. The PHP handler then hooks into the appropriate action initiated by admin-ajax.php. * [@adviceit](https://wordpress.org/support/users/adviceit/) – while your use of AJAX is not the preferred method, it’s such a small thing, I would not bother changing it as long as it’s working for you. I only mention the suggested method for anyone else that comes along. Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Retrieve Live Data from wpdb’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [wpdb](https://wordpress.org/support/topic-tag/wpdb/) * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/) * 12 replies * 3 participants * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/) * Last activity: [12 years, 7 months ago](https://wordpress.org/support/topic/retrieve-live-data-from-wpdb/#post-4204345) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics