static function getNextTrialTime() { $config = Config::getConfig("db"); $mysqli = new \mysqli($config["server"], $config["username"], $config["password"], $config["name"], $config["port"]); if ($mysqli->connect_errno) { $this->throwDBExceptionOnError($mysqli->connect_error, $mysqli->connect_errno); } //Find if there is a username/password matching the input $next_trial_start_q = "SELECT TIME_TO_SEC(TIMEDIFF(start,now())),TIME_TO_SEC(TIMEDIFF(end,now())) FROM `gametrials` WHERE end > NOW() ORDER BY start LIMIT 1"; if (!($stmt = $mysqli->prepare($next_trial_start_q))) { $this->throwDBExceptionOnError($mysqli->error, $mysqli->errno); } if (!$stmt->execute()) { $this->throwDBExceptionOnError($mysqli->error, $mysqli->errno); } $diff = new \stdClass(); $diff->start = -1; $diff->end = -1; if (!$stmt->bind_result($diff->start, $diff->end)) { $this->throwDBExceptionOnError($mysqli->error, $mysqli->errno); } if (!$stmt->fetch()) { $diff->start = -1; $diff->end = -1; } $stmt->free_result(); $stmt->close(); $mysqli->close(); /* * The return value contains to elements, start and end in seconds */ return $diff; }
public function __construct() { parent::__construct(); $config = Config::getConfig("db"); $this->mysqli = new \mysqli($config["server"], $config["username"], $config["password"], $config["name"], $config["port"]); if ($this->mysqli->connect_errno) { $this->throwDBExceptionOnError($this->mysqli->connect_error, $this->mysqli->connect_errno); } }
function __construct(\mysqli $mysqli_con = null) { parent::__construct(); $config = Config::getConfig("db"); if (!$mysqli_con) { @($this->mysqli_con = new \mysqli($config["server"], $config["username"], $config["password"], $config["name"], $config["port"])); if ($this->mysqli_con->connect_errno) { $this->throwDBExceptionOnError($this->mysqli_con->error, $this->mysqli_con->errno); } } else { $this->mysqli_con = $mysqli_con; } }