} //get all date from tracking summary but not include current date function getAllDateFromTrackingSummary() { $conn = connectDB(); $re = array(); $sql = "SELECT date FROM pt_tracking_summary GROUP BY MONTH(date), YEAR(date)"; $result = $conn->query($sql); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { if (!checkCurrentMonthAndYear($row['date'])) { $re[] = $row['date']; } } } $conn->close(); return $re; } function checkCurrentMonthAndYear($date) { $today = date('Y-m'); if (date('Y-m', strtotime($date)) === $today) { return true; } else { return false; } } $m = isset($argv[1]) ? $argv[1] : ''; $pid = isset($argv[2]) ? $argv[2] : ''; processingPaymentRequest($m, $pid);
<?php //insert data to payment_request tbl, and payment_request_detail tbl on 1-5 every month. //Mysql define('DB_HOST', '192.168.100.14'); define('DB_USERNAME', 'root'); define('DB_PASSWORD', '123@qazwsX'); define('DB_NAME', 'yomedia'); //run //connectDB(); processingPaymentRequest(); function connectDB() { //Connect Mysql $servername = DB_HOST; $username = DB_USERNAME; $password = DB_PASSWORD; $dbname = DB_NAME; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } else { //die("Connected"); return $conn; } } //excute function processingPaymentRequest() {