本文整理汇总了PHP中dbConnect::getReadOnly方法的典型用法代码示例。如果您正苦于以下问题:PHP dbConnect::getReadOnly方法的具体用法?PHP dbConnect::getReadOnly怎么用?PHP dbConnect::getReadOnly使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类dbConnect
的用法示例。
在下文中一共展示了dbConnect::getReadOnly方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的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: 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;
}
示例3: 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;
}
示例4: 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;
}
示例5:
<head>
<title> </title>
</head>
<body>
<form action="admin.php">
<input type="submit" value="Return To Admin" />
</form>
<p>Manage Users</p>
<table border = "1">
<th>User ID</th><th>First Name</th><th>Last Name</th><th>Username</th>
<th>Created By:</th><th>Creation Date:</th><th>Modified By:</th><th>Modify Date:</th>
<?php
include_once "../DataAccess/dbConnect.php";
$db = dbConnect::getReadOnly();
$result = mysqli_query($db, "SELECT * FROM Users ORDER BY User_ID ASC");
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td><?php
echo strip_tags($row['User_ID']);
?>
</td>
<td><?php
echo strip_tags($row['first_name']);
?>
</td>
<td><?php
echo strip_tags($row['last_name']);