private function loadParams()
{
$this->dbParams = (require __DIR__ . '/../config/db.php');
self::$dsn = $this->dbParams['rds']['dsn'];
self::$user = $this->dbParams['rds']['username'];
self::$pass = $this->dbParams['rds']['password'];
}
public function getURLInfo($shortUrl)
{
$sql = "select * from lu_urlcontainer where shortUrl=?";
$data = [$shortUrl];
$sqlResult = parent::fetch_rows($sql, $data);
if (count($sqlResult) == 1) {
$this->response = new LightResponse();
$this->response->bulkUrl = $sqlResult[0]->bulkUrl;
$this->response->shortUrl = $sqlResult[0]->shortUrl;
$this->response->hashUrl = $sqlResult[0]->hashUrl;
$this->response->insertDate = $sqlResult[0]->insertDate;
return $this->response->LightResponse(true);
}
}
header("location:login.php");
} else {
require_once '../src/core/LightUrl.php';
$sql = "select * from lu_users where username=?";
$username = $_SESSION['username'];
$data = [$username];
$queryUserInfo = LightDB::fetch_rows($sql, $data);
$sqlCountDAY = "SELECT count(id) DAY FROM lu_urlcontainer WHERE insertDate > DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY id DESC";
$sqlCountWEEK = "SELECT count(id) WEEK FROM lu_urlcontainer WHERE insertDate > DATE_SUB(NOW(), INTERVAL 1 WEEK) ORDER BY id DESC";
$sqlCountMONTH = "SELECT count(id) MONTH FROM lu_urlcontainer WHERE insertDate > DATE_SUB(NOW(), INTERVAL 1 MONTH) ORDER BY id DESC";
$sqlCountYEAR = "SELECT count(id) YEAR FROM lu_urlcontainer WHERE insertDate > DATE_SUB(NOW(), INTERVAL 1 YEAR) ORDER BY id DESC";
$data = [];
$queryCountDAY = LightDB::fetch_rows($sqlCountDAY, $data);
$queryCountWEEK = LightDB::fetch_rows($sqlCountWEEK, $data);
$queryCountMONTH = LightDB::fetch_rows($sqlCountMONTH, $data);
$queryCountYEAR = LightDB::fetch_rows($sqlCountYEAR, $data);
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<title>LightURL Dashboard</title>
<!-- BOOTSTRAP STYLES-->
<link href="assets/css/bootstrap.css" rel="stylesheet"/>
<!-- FONTAWESOME STYLES-->
<link href="assets/css/font-awesome.css" rel="stylesheet"/>
<!-- MORRIS CHART STYLES-->
<link href="assets/js/morris/morris-0.4.3.min.css" rel="stylesheet"/>
<!-- CUSTOM STYLES-->
<!-- CUSTOM SCRIPTS -->
<script src="assets/js/custom.js"></script>
<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
require_once '../src/core/LightUrl.php';
$user_id = $queryUserInfo[0]->id;
$password = $queryUserInfo[0]->password;
$username = $_POST['username'];
$password_old = sha1(md5($_POST["old_password"]));
$password_new = sha1(md5($_POST["new_password"]));
$password_newTry = sha1(md5($_POST["new_passwordAgain"]));
if ($password == $password_old) {
if ($password_new == $password_newTry) {
$sql = "UPDATE lu_users set username=?,password=? WHERE id=?";
$data = [$username, $password_new, $user_id];
LightDB::affect_rows($sql, $data);
$_SESSION['username'] = $username;
header("location:settings.php?rMsgCode=1");
} else {
header("location:settings.php?rMsgCode=2");
}
} else {
header("location:settings.php?rMsgCode=3");
}
}
?>
</body>
</html>
<?php
}
<?php
ob_start();
session_start();
if (!$_SESSION['login']) {
header("location:login.php");
} else {
require_once '../src/core/LightUrl.php';
$sql = "select * from lu_users where username=?";
$username = $_SESSION['username'];
$data = [$username];
$queryUserInfo = LightDB::fetch_rows($sql, $data);
$sqlAllUrl = "SELECT * FROM lu_urlcontainer ORDER BY id DESC";
$data = [];
$queryAllUrl = LightDB::fetch_rows($sqlAllUrl, $data);
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<title>LightURL Dashboard</title>
<!-- BOOTSTRAP STYLES-->
<link href="assets/css/bootstrap.css" rel="stylesheet"/>
<!-- FONTAWESOME STYLES-->
<link href="assets/css/font-awesome.css" rel="stylesheet"/>
<!-- MORRIS CHART STYLES-->
<link href="assets/js/morris/morris-0.4.3.min.css" rel="stylesheet"/>
<!-- CUSTOM STYLES-->
<link href="assets/css/custom.css" rel="stylesheet"/>
