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