<?php
//error_reporting(E_ALL);
//ini_set('display_errors', 1);

//set timezone to HK (sames as server time)
date_default_timezone_set('Asia/Hong_Kong');

//DB connection setting
$servername = "rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com";
$username = "breadsecret.com";
$password = "3#!Xj7f&5";
$dbname = "breadsecret.com";

// Create connection
$mysqli = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($mysqli ->connect_error) {
  die("Connection failed: " . $mysqli ->connect_error);
}

//get today in correct format
$stock_date = date('Y-m-d', strtotime("+30 day"));

//12:00 update stock of japanese soft loaf to 0
//13:00 update stock of anchovy and salted roll to 0
$sql = "INSERT INTO `sku_stock` (`id`, `GB-CCN-211`, `GB-CAN-357`, `BD-ABR-180`, `BD-BAG-300`, `BD-JPL-425`, `BD-SBR-180`, `CF-CAN-260`, `CF-CCC-163`, `stock_date`) VALUES (NULL, '10', '10', '10', '6', '10', '10', '5', '10', '".$stock_date."')";
$mysqli->query($sql);
$mysqli -> close();


?>