owenoneill

Any luck on this? Would love some feedback or just an email to see if you are up for paid work?

Hey guys,

Any chance I could get an update on this?

Owen

Greg, Final Question…

<?php

ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(-1);

function endsWith($haystack, $needle) {
    // search forward starting from end minus needle length characters
    return $needle === "" || (($temp = strlen($haystack) - strlen($needle)) >= 0 && strpos($haystack, $needle, $temp) !== FALSE);
}

$lastDate = date('Y-m-d', strtotime('today - 30 days'));
$todayDate = date('Y-m-d');

$results = $wpdb->get_results( "SELECT * FROM <code>wp_statistics_pages</code> WHERE id=37 AND <code>date</code> BETWEEN '$lastDate' AND '$todayDate' ", ARRAY_A );

for($i=0;$i<count($results);$i++)
if (endsWith(get_site_url().''.$results[$i]['uri'], 'http://universitycompare.com/universities/anglia-ruskin-uni/'))
 {
   $newstring = $results[$i]['count'];
    echo $newstring.',';
    } ?>

How would showcase the results inside shortcode? As using the above with only displays the latest value, not all of them?

<?php echo do_shortcode('[wp_charts title="linechart" canvaswidth="976px" canvasheight="244px" relativewidth="4" width="976px" height="244px" type="line" align="alignright" datasets="' . $newstring . '" labels="1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30"]'); ?>

Hi Greg Ross, Finally worked out the answer, it requires you to use the endsWith Function, see inline:

<?php
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(-1);

function startsWith($haystack, $needle) {
    // search backwards starting from haystack length characters from the end
    return $needle === "" || strrpos($haystack, $needle, -strlen($haystack)) !== FALSE;
}

function endsWith($haystack, $needle) {
    // search forward starting from end minus needle length characters
    return $needle === "" || (($temp = strlen($haystack) - strlen($needle)) >= 0 && strpos($haystack, $needle, $temp) !== FALSE);
}

echo "<strong>Stack Overflow Results</strong>";
echo "<br><div style='float:left; width:100%; padding:1em; background:#FFF; margin:2em 0;'>";
$lastDate = date('Y-m-d', strtotime('today - 30 days'));
$todayDate = date('Y-m-d');

$results = $wpdb->get_results( "SELECT * FROM <code>wp_statistics_pages</code> WHERE id=37 AND <code>date</code> BETWEEN '$lastDate' AND '$todayDate' ", ARRAY_A );
for($i=0;$i<count($results);$i++)
if (endsWith(get_site_url().''.$results[$i]['uri'], 'http://universitycompare.com/universities/anglia-ruskin-uni/'))

{
    echo "<span id='data-point'style='float:left;clear:left;' value='";
    echo $results[$i]['count'];
    echo "'>";
    echo get_site_url().''.$results[$i]['uri'].' (';
    echo $results[$i]['count'].')</span>';
}

?>

I am thinking of maybe turning this into an add-on child plugin where we can showcase chosen front end stats to display in graphs, May send it to you If I do.

Almost there, so close…

http://universitycompare.com/analytics/

I’m now trying to pinpoint each value to each date/day while not including any of the slugs that aren’t clean (i.e. only http://universitycompare.com/universities/anglia-ruskin-uni/)

So it’s like:

17/09/2015 = 108
18/09/2015 = 90
19/09/2015 = will be there tomorrow

Any ideas? You have it perfected re. data as part of the plugin: http://imgur.com/LQSTYwL

<?php
echo "<strong>Last 30 days (individual stats/points) for specific page</strong>";
echo "<br><div style='float:left; width:100%; padding:1em; background:#FFF; margin:2em 0;'>";
$lastDate = date('Y-m-d', strtotime('today - 30 days'));
$todayDate = date('Y-m-d');

$results = $wpdb->get_results( "SELECT * FROM 'ucsite_statistics_pages' WHERE id=37 AND date 'BETWEEN' '$lastDate' AND '$todayDate' ", ARRAY_A );
for($i=0;$i<count($results);$i++)
{
	echo get_site_url().''.$results[$i]['uri'] .'<strong> =</strong> '. $results[$i]['count'].'<br>';
}
?>

Definitely owe a beer, or two? 😉

Owen

Hi Greg,

I don’t have the above tables, the prefix has changed but I cannot find the above that you are on about, with ‘my_prefix_’

I’ve tried re-running the install of DB twice via optimisation as noted in another thread and still no luck? Any ideas?

Do I need to give permission to write to my db?

Owen

Hi Greg,

is there a way to single out each day? As then I could build my own interactive chart.

I.e. singular data points such as:
data point 1 – day 1 of past 30 days.
data point 2 – day 2 of past 30 days.

and so on…

Yeah it’s done re an added plugin and loaded via ajax.

Is there a way to record the results that are are inputted in one search box? If I can understand how your plugin works a little better I may be able to tweak it.

I know you’ve got a lot on your to-do list, happy to pay if you are able to sort this.

Owen