OwlCyberSecurity - MANAGER

Edit File: UpdateResultStatus.php

<?php include 'store-procedure.php'; // Update Result Status From 0 to 1 // (Run this with CronJob) function UPDATE_RESULT_STATUS($value,$criteria) { $db_conn = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME) or die('Error connecting to Database Server.'); $sql_string = "UPDATE `" . DB_NAME . "`.`tbl-result` SET `result_status` = " . $value . " WHERE `result_draw_date` = '" . $criteria . "';"; // echo $sql_string; die(); // mysqli_query($db_conn, $sql_string) or die('Error querying database.'); $result = mysqli_query($db_conn, $sql_string); return $result; } $value = 1; $criteria = RETURN_RESULT_DRAW_DATE_CURRENT(0); if(UPDATE_RESULT_STATUS($value,$criteria)) { echo 'Updated'; } else { echo 'Error while updating Result Status'; }