candlestick with range filter

[nugroho dwi ariansyah]

Hello,

can u guys help me out to figure out how to add range filter to my candlestick chart?

it's really hard for me.

this is the code I used.

<?php

  $servername = "127.0.0.1";

  $username = "root";

  $password = "";

  $database = "stock";

  $mysqli = new mysqli ($servername, $username, $password, $database);

  if ($mysqli ->connect_error){

    die("Connection failed:" .$mysqli->connect_error);

  }

  $query = "SELECT Date, Low, High, Open, Close FROM csv";

  $qresult = $mysqli->query($query);

  $results = array();

    while($res= $qresult->fetch_assoc()){

      $results[] = $res;

      }

  $candlestick_data = array();

    foreach ($results as $result){

  $candlestick_data[] = array($result['Date'], (float)$result['Low'], (float)$result['High'], (float)$result['Open'], (float)$result['Close']);

  }

  $candlestick_data = json_encode($candlestick_data);

      mysqli_free_result($qresult);

      mysqli_close($mysqli);

$HTML=<<<XYZ

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

<script type="text/javascript">

google.charts.load("visualization","1", {'packages':["corechart"]});

google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = new google.visualization.DataTable();

data.addColumn('string', 'Date');

data.addColumn('number', 'High');

data.addColumn('number', 'Low');

data.addColumn('number', 'Open');

data.addColumn('number', 'Close');

data.addRows({$candlestick_data}),true;

var options = {

      width: 1200,

      height: 300,

      animation: {

        duration: 1000,

        easing: 'in'

      },

      hAxis: {viewWindow: {min:0, max:50}}

    };

var chart = new google.visualization.CandlestickChart(document.getElementById('candlestick_div'));

chart.draw(data, options);

}

</script>

<div id="candlestick_div" style="width: 2000px; height: 500px;"></div>

XYZ;

echo $HTML;

?>