当前位置: 首页>>代码示例>>PHP>>正文


PHP dbConnect::getReadOnly方法代码示例

本文整理汇总了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;
 }
开发者ID:ColinHill,项目名称:PHP-content-management-system,代码行数:10,代码来源:cssTemplate.php

示例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;
 }
开发者ID:ColinHill,项目名称:PHP-content-management-system,代码行数:12,代码来源:contentArea.php

示例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;
 }
开发者ID:ColinHill,项目名称:PHP-content-management-system,代码行数:12,代码来源:page.php

示例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;
 }
开发者ID:ColinHill,项目名称:PHP-content-management-system,代码行数:12,代码来源:article.php

示例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']);
开发者ID:ColinHill,项目名称:PHP-content-management-system,代码行数:31,代码来源:manageUsers.php


注:本文中的dbConnect::getReadOnly方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。