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"/>