本文整理汇总了PHP中dbConnect::closeConnection方法的典型用法代码示例。如果您正苦于以下问题:PHP dbConnect::closeConnection方法的具体用法?PHP dbConnect::closeConnection怎么用?PHP dbConnect::closeConnection使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类dbConnect
的用法示例。
在下文中一共展示了dbConnect::closeConnection方法的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getActiveCSS
public static function getActiveCSS()
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM CSSTemplates WHERE ActiveState=1;";
$results = mysqli_query($db, $query);
$row = mysqli_fetch_assoc($results);
$activeCSSTemplate = new self($row);
dbConnect::closeConnection($db);
return $activeCSSTemplate;
}
示例2: execute
public function execute($sql)
{
$exe = mysql_query($sql, $this->_connAccess->getConnection());
if (!$exe) {
exit('Error : ' . mysql_error() . ':' . $sql);
} else {
return $exe;
dbConnect::closeConnection();
}
}
示例3: getContentArea
public static function getContentArea()
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM ContentAreas;";
$results = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($results)) {
$contentAreas[] = new self($row);
}
//end while
dbConnect::closeConnection($db);
return $contentAreas;
}
示例4: _getQuery
protected function _getQuery()
{
if (!$this->_query) {
$this->_conn = dbConnect::getConnection();
$this->_query = mysql_query($this->_sql, $this->_conn);
if (!$this->_query) {
print 'Error : ' . mysql_error() . ' ' . $this->_sql;
}
}
return $this->_query;
dbConnect::closeConnection();
}
示例5: getAllPages
public static function getAllPages($_alias)
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM SitePages;";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($result)) {
$pages[] = new self($row);
}
//end while
dbConnect::closeConnection($db);
return $pages;
}
示例6: getArticle
public static function getArticle($_area, $_page)
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM Articles WHERE (Page='{$_page}' OR AllPages=1) AND ContentArea = '{$_area}';";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($result)) {
$articleArray[] = new self($row);
}
//end while
dbConnect::closeConnection($db);
return $articleArray;
}
示例7: mysqli_real_escape_string
<html>
<head>
<h1>Content Area Created:</h1>
</head>
<body>
<?php
include_once "../DataAccess/dbConnect.php";
$db = dbConnect::getContentAreaConnection();
$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']);
$query = "INSERT INTO ContentAreas (Name, Alias, ContentAreas.Order, Description, CreatedBy) ";
$query .= "VALUES ('{$name}', '{$alias}', '{$order}', '{$description}', 1)";
$result = mysqli_query($db, $query);
if (!$result) {
die('Unable to insert Content Area into CMS Database.');
}
?>
<p>Successfully Inserted <?php
echo mysqli_affected_rows($db);
?>
record.</p>
<?php
dbConnect::closeConnection($db);
?>
<a href="../Presentation/manageContentAreas.php">Back to Manage Content Areas page</a>
</body>
</html>