本文整理汇总了PHP中dbConnect::getPagesConnection方法的典型用法代码示例。如果您正苦于以下问题:PHP dbConnect::getPagesConnection方法的具体用法?PHP dbConnect::getPagesConnection怎么用?PHP dbConnect::getPagesConnection使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类dbConnect
的用法示例。
在下文中一共展示了dbConnect::getPagesConnection方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: header
if (!isset($_SESSION['myusername'])) {
header("location:../Presentation/main_login.php");
}
if ($_SESSION['editor'] == 0 && $_SESSION['author'] == 0 && $_SESSION['allaccess'] == 0) {
header("location:../Presentation/main_login.php");
}
?>
<html>
<head>
<h1>Site Page Updated:</h1>
</head>
<body>
<?php
include_once "../DataAccess/dbConnect.php";
$db = dbConnect::getPagesConnection();
$siteid = mysqli_real_escape_string($db, $_POST['SitePages_ID']);
$name = mysqli_real_escape_string($db, $_POST['Name']);
$alias = mysqli_real_escape_string($db, $_POST['Alias']);
$description = mysqli_real_escape_string($db, $_POST['Description']);
$modifyby = $_SESSION['myusername'];
$query = "SELECT User_ID FROM Users WHERE user_name = '{$modifyby}'";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_assoc($result);
$modifyid = $row['User_ID'];
$query = "UPDATE SitePages SET Name = '{$name}', Description = '{$description}', ";
$query .= "Alias = '{$alias}' WHERE SitePages_ID = '{$siteid}', ModibyBy = '{$modifyid}', ModifyDate = now()";
$result = mysqli_query($db, $query);
if (!$result) {
die('Unable to Update Site Page record from CMS Database.');
}