function initDashboard() { include_once ABSPATH . "/php/CDBConn.php"; include_once ABSPATH . "/php/hostconfig.php"; $conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123"); if (!$conn->connect_no_localhost()) { http_response_code(503); exit; } $cur_login = $_SESSION['g_username']; $get_hostel_id_sql = "SELECT hostel_id FROM users WHERE login = '******'"; $conn->run_query($get_hostel_id_sql); $line = $conn->fetch_array(); // We almost now from which hostel is user $hostel_id = $line['hostel_id']; // in case if hostel id is not set, it's an indicator that hostel definetely has not been configured yet. if ($hostel_id === NULL) { header("Location: /configure/index.php"); exit; } $get_is_configured_sql = "SELECT is_configured FROM hostels WHERE id = {$hostel_id}"; $conn->run_query($get_is_configured_sql); $line = $conn->fetch_array(); $is_configured = $line['is_configured']; // This is the case when user almost configured not if ($is_configured === 'f') { header("Location: /configure/index.php"); // exit(); } $conn->close(); }
<?php require_once '../app-config.php'; include_once ABSPATH . "/php/CDBConn.php"; include_once ABSPATH . "/php/hostconfig.php"; $conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123", FALSE); $conn->connect_no_localhost(); $conn->printinfo(); $conn->close(); /** * Created by PhpStorm. * User: Elisha * Date: 26.12.2015 * Time: 20:01 */
<?php session_start(); include_once "../app-config.php"; include_once ABSPATH . "/php/CDBConn.php"; include_once ABSPATH . "/php/hostconfig.php"; if (!isset($_SESSION['g_username'])) { header("Location: /login/index.php"); exit; } else { // $conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123"); if (!$conn->connect_no_localhost()) { echo "Database error<br>"; exit; } $cur_login = $_SESSION['g_username']; $get_hostel_id_query = "SELECT hostel_id,login FROM users WHERE login='******'"; $res = $conn->run_query($get_hostel_id_query); if ($conn->affected_rows() == 0) { echo "There is no such login in database. <br>"; exit; } $line = $conn->fetch_array(); $hostel_id = $line['hostel_id']; if ($hostel_id != NULL) { header("Location: /dashboard/"); exit; } } // insert is_configured flag checking