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-->
<?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); ?> <!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"/> <!-- GOOGLE FONTS--> <link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'/> </head>
<?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"/>