當前位置: 首頁>>代碼示例>>PHP>>正文


PHP Contest::getSingle方法代碼示例

本文整理匯總了PHP中Contest::getSingle方法的典型用法代碼示例。如果您正苦於以下問題:PHP Contest::getSingle方法的具體用法?PHP Contest::getSingle怎麽用?PHP Contest::getSingle使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在Contest的用法示例。


在下文中一共展示了Contest::getSingle方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。

示例1: header

    header('Content-type: application/json');
    echo json_encode($json);
} else {
    if (filter_input(INPUT_GET, "fetchEntrants") != NULL) {
        $requestData = $_REQUEST;
        $columns = array(0 => 'id', 1 => 'id', 2 => 'id', 3 => 'contest', 4 => 'email', 5 => 'friends', 6 => 'names', 7 => 'time_entered', 8 => 'point');
        // getting total number records without any search
        $query = $dbObj->query("SELECT * FROM " . $entrantObj::$tableName);
        $totalData = mysqli_num_rows($query);
        $totalFiltered = $totalData;
        // when there is no search parameter then total number rows = total number filtered rows.
        $sql = "SELECT * FROM " . $entrantObj::$tableName . " WHERE 1=1 ";
        if (!empty($requestData['search']['value'])) {
            // if there is a search parameter, $requestData['search']['value'] contains search parameter
            $sql .= " AND ( email LIKE '%" . $requestData['search']['value'] . "%' ";
            $sql .= " OR contest = '" . Contest::getSingle($dbObj, 'id', $requestData['search']['value']) . "' ) ";
        }
        $query = $dbObj->query($sql);
        $totalFiltered = mysqli_num_rows($query);
        // when there is a search parameter then we have to modify total number filtered rows as per search result.
        $sql .= " ORDER BY " . $columns[$requestData['order'][0]['column']] . "   " . $requestData['order'][0]['dir'] . "  LIMIT " . $requestData['start'] . " ," . $requestData['length'] . "   ";
        echo $entrantObj->fetchForJQDT($requestData['draw'], $totalData, $totalFiltered, $sql);
    }
    if (filter_input(INPUT_GET, "sendEmail") != NULL) {
        $postVars = array('email');
        // Form fields names
        //Validate the POST variables and add up to error message if empty
        foreach ($postVars as $postVar) {
            switch ($postVar) {
                default:
                    $entrantObj->{$postVar} = filter_input(INPUT_GET, $postVar, FILTER_VALIDATE_EMAIL) ? mysqli_real_escape_string($dbObj->connection, filter_input(INPUT_GET, $postVar, FILTER_VALIDATE_EMAIL)) : '';
開發者ID:Mojolagbe2014,項目名稱:mojokalokalo,代碼行數:31,代碼來源:manage-entrants.php


注:本文中的Contest::getSingle方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。