PHP Database::Disconnect Examples

Example #1

File: User.php Project: JSiedlecky/LAI_v2.0

 public function getsetDisplayLm($optional = [])
 {
     $db = new Database();
     if (isset($optional['display_lm'])) {
         $result = $db->Update('users', ['display_lm' => $optional['display_lm']], ['idu' => $this->idu], ['debug' => true]);
         $db->Disconnect();
         return $result;
     } else {
         $result = $db->Select('users', ['display_lm'], ['idu' => $this->idu]);
         $db->Disconnect();
         return $result[0]['display_lm'];
     }
 }

Example #2

File: user.php Project: jake-cryptic/ultrapowa-user-overviews

						<?php 
if (!$Database->Run($sql)) {
    die($Database->Error());
} else {
    $response = $Database->Run($sql);
    while ($row = mysqli_fetch_array($response)) {
        $avatar = json_encode(json_decode($row["Avatar"]), JSON_PRETTY_PRINT);
        echo "<h3>Avatar</h3>\n\t\t\t\t\t\t<textarea id=\"avatar\" name=\"avatar\" class=\"fullwidth\">" . $avatar . "</textarea>";
        ?>
					</div>
					<div class="col-md-4">
						<?php 
        echo "<h3>Meta</h3>\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\tLast Update Time: " . $row["LastUpdateTime"] . "<br /><br />Account Privilege Level<br />\n\t\t\t\t\t\t\t<input type=\"text\" name=\"AccountPrivileges\" value=\"" . $row["AccountPrivileges"] . "\">\n\t\t\t\t\t\t</p>\n";
        ?>
					</div>
					<div class="col-md-4">
						<?php 
        $gameobjects = json_encode(json_decode($row["GameObjects"]), JSON_PRETTY_PRINT);
        echo "<h3>GameObjects</h3><textarea id=\"GameObjects\" name=\"GameObjects\" class=\"fullwidth\">" . $gameobjects . "</textarea>\n";
    }
}
?>
					</div>
				</form>
			</div>
		</div>
	</body>
</html>
<?php 
$Database->Disconnect();

Example #3

File: index.php Project: viion/XIVModels

        include "home.php";
        break;
    case 'Home':
        include "home.php";
        break;
    case 'Translation':
        include "translation.php";
        break;
    case 'Patches':
        include "import/patch.php";
        break;
    case 'IMP_models':
        include "import/imp_models.php";
        break;
    case 'IMP_models_all':
        include "import/imp_models_all.php";
        break;
    case 'IMP_humans':
        include "import/imp_models_human.php";
        break;
}
?>
		</div>
	
	</body>
	
</html>

<?php 
$DB->Disconnect();

Example #4

File: index.php Project: iensenfirippu/securipe

<?php

// load all necessary config and class files, etc.
include_once "Bootstrap.php";
$currentpage = Site::GetArgumentSafely("action");
// create the requested page
$RTK = new RTK("Securipe");
if (Login::FetchBanStatus()) {
    include_once "Pages/Banned.php";
} else {
    if ($currentpage == "Logout") {
        Login::LogOut();
    } elseif ($currentpage == "Home") {
        include_once "Pages/Home.php";
    } elseif ($currentpage == "Login") {
        include_once "Pages/Login.php";
    } elseif ($currentpage == "ViewRecipe") {
        include_once "Pages/ViewRecipe.php";
    } elseif ($currentpage == "EditRecipe") {
        include_once "Pages/EditRecipe.php";
    } elseif ($currentpage == "CreateUser") {
        include_once "Pages/CreateUser.php";
    } elseif ($currentpage == "MyPage") {
        include_once "Pages/PersonalStartPage.php";
    } else {
        Site::BackToHome();
    }
}
echo $RTK;
Database::Disconnect();
//echo "\n".(microtime(true) - STARTTIME);

Example #5

File: body.left.php Project: JSiedlecky/LAI_v2.0

<?php

$menu_arr = "";
$db = new Database();
$menu_arr = $db->Select('left_menu', ['display_string', 'page_scheme']);
$menu_show = $db->Select('users', ['display_lm']);
$db->Disconnect();
?>

<div id="left-sidebar" data-show="<?php 
echo $menu_show[0]['display_lm'];
?>
">
    <ul>
        <?php 
foreach ($menu_arr as $item) {
    $active = "";
    if (isset($_GET['page']) && $_GET['page'] == $item['page_scheme']) {
        $active = 'class="active"';
    }
    if ($user->getPermissions()['isGm'] || $user->getPermissions()[$item['page_scheme']]) {
        echo '<li ' . $active . '><a href="index.php?page=' . $item['page_scheme'] . '">' . $item['display_string'] . '</a></li>';
    }
}
?>
    </ul>
</div>

Example #6

File: Response.php Project: ChiperSoft/phPit

 /**
  * Sends a location header and terminates the controller, redirecting the browser to a new location.
  *
  * @param string URL to redirect to. Defaults to the current url if omitted.
  * @return void
  **/
 public static function Redirect($url = ".")
 {
     if ($url == '.') {
         $url = WebPath::Me();
     }
     header("Location: {$url}");
     Database::Disconnect();
     exit;
 }