Untitled

<!DOCTYPE html>
<html>
    <head>
        <title>DARK</title>
                <link rel="icon" href="http://myac.dx.am/icon.png">
        <style>
            .chart-container {
                width: 1000px;
                height: auto;
            }
        </style>
    </head>
    <body style="background-color:#1a1a1a;">
        <div class="chart-container">
            <canvas id="mycanvas"></canvas>
        </div>

        <!-- javascript -->
        <script type="text/javascript">var limitSQLvar = 150;</script>
        <script type="text/javascript">alert(limitSQLvar);</script>
        <script type="text/javascript">alert("leaving html");</script>
        <script type="text/javascript" src="http://myac.dx.am/js//jquery.min.js"></script>
        <script type="text/javascript" src="http://myac.dx.am/js//Chart.min.js"></script>
        <script type="text/javascript" src="http://myac.dx.am/js//linegraph.js"></script>
    </body>
</html>

$(document).ready(function(){
    alert(limitSQLvar);
    $.ajax({
        alert("inside ajax");
        url : "http://myac.dx.am/followersdata.php", data: {limitSQLvar: limitSQLvar}, dataType: 'json', type: 'POST', type : 'GET',
        success : function(data){
            console.log(data);

            var userid = [];
            var facebook_follower = [];
            var twitter_follower = [];
            var googleplus_follower = [];

            for(var i in data) {
                //recordID, temp, highCutOff, lowCutOff
                userid.push("recordID " + data[i].recordID);
                facebook_follower.push(data[i].temp);
                twitter_follower.push(data[i].highCutOff);
                googleplus_follower.push(data[i].lowCutOff);
            }

            var chartdata = {
                labels: userid,
                datasets: [
                    {
                        label: "temp",
                        fill: false,
                        lineTension: 0.1,
                        backgroundColor: "rgba(59, 89, 152, 0.75)",
                        borderColor: "rgba(59, 89, 152, 1)",
                        pointHoverBackgroundColor: "rgba(59, 89, 152, 1)",
                        pointHoverBorderColor: "rgba(59, 89, 152, 1)",
                        data: facebook_follower
                    },
                    {
                        label: "highCutOff",
                        fill: false,
                        lineTension: 0.1,
                        backgroundColor: "rgba(29, 202, 255, 0.75)",
                        borderColor: "rgba(29, 202, 255, 1)",
                        pointHoverBackgroundColor: "rgba(29, 202, 255, 1)",
                        pointHoverBorderColor: "rgba(29, 202, 255, 1)",
                        data: twitter_follower
                    },
                    {
                        label: "lowCutOff",
                        fill: false,
                        lineTension: 0.1,
                        backgroundColor: "rgba(211, 72, 54, 0.75)",
                        borderColor: "rgba(211, 72, 54, 1)",
                        pointHoverBackgroundColor: "rgba(211, 72, 54, 1)",
                        pointHoverBorderColor: "rgba(211, 72, 54, 1)",
                        data: googleplus_follower
                    }
                ]
            };

            var ctx = $("#mycanvas");

            var LineGraph = new Chart(ctx, {
                type: 'line',
                data: chartdata
            });
        },
        error : function(data) {
            alert(data);
        }
    });
});

<?php
//setting header to json
header('Content-Type: application/json');

//database
define('DB_HOST', 'host');
define('DB_USERNAME', 'un');
define('DB_PASSWORD', 'pw');
define('DB_NAME', 'db name');

//get connection
$mysqli = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

if(!$mysqli){
    die("Connection failed: " . $mysqli->error);
}

//query to get data from the table
//$query = sprintf("SELECT userid, facebook, twitter, googleplus FROM followers");
$query = sprintf("SELECT recordID, temp, highCutOff, lowCutOff FROM (SELECT recordID, temp, highCutOff, lowCutOff FROM v1 order by recordID DESC LIMIT '".$_POST["limitSQLvar"]."') tmp ORDER BY tmp.recordID");

//execute query
$result = $mysqli->query($query);

//loop through the returned data
$data = array();
foreach ($result as $row) {
    $data[] = $row;
}

//free memory associated with result
$result->close();

//close connection
$mysqli->close();

//now print the data
print json_encode($data);