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
