date_default_timezone_set('America/New_York');
$servername = "localhost";
$username = "dgdfgfdg";
$password ="dfgdfg";
$databasename ="dfgdfg";

$con = mysqli_connect("$servername","$username","$password","$databasename");

if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}


//lets get orders
$sql = mysqli_query($con, "SELECT * FROM sales_order_grid where created_at BETWEEN date('2018-06-22') AND  date('2018-06-25') AND order by increment_id asc");
$numorders = mysqli_num_rows($sql);

echo "$numorders";