本文整理汇总了PHP中dbConnect::getUserConnection方法的典型用法代码示例。如果您正苦于以下问题:PHP dbConnect::getUserConnection方法的具体用法?PHP dbConnect::getUserConnection怎么用?PHP dbConnect::getUserConnection使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类dbConnect
的用法示例。
在下文中一共展示了dbConnect::getUserConnection方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: session_start
<?php
session_start();
include_once "../DataAccess/dbConnect.php";
$db = dbConnect::getUserConnection();
if (!isset($_SESSION['myusername'])) {
header("location:main_login.php");
}
if ($_SESSION['admin'] == 0 && $_SESSION['allaccess'] == 0) {
header("location:main_login.php");
}
$userid = mysqli_real_escape_string($db, $_POST['update']);
$query = "SELECT * FROM Users WHERE User_ID = '{$userid}'";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($result)) {
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$user_name = $row['user_name'];
$password = $row['password'];
$salt = $row['salt'];
}
$query = "SELECT * FROM Privileges WHERE Users_User_ID = '{$userid}'";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($result)) {
$administrator = $row['Administrator'];
$editor = $row['Editor'];
$author = $row['Author'];
}
?>
<html>
<head>