當前位置: 首頁>>代碼示例>>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;未經允許,請勿轉載。