PHP gcms::oneLine Examples

Example #1

File: admin_category_action.php Project: phannack/GCMS

            // new row
            $row = '<dd id="config_category_' . $id . '">';
            $row .= '<span class="no">[' . $save['category_id'] . ']</span>';
            $row .= '<span class="icon-delete" id="config_category_delete_' . $id . '" title="' . $lng['LNG_DELETE'] . ' ' . $text . '">&nbsp;</span>';
            $row .= $text . ' <span id="config_category_name_' . $id . '" title="' . $lng['LNG_CLICK_TO'] . ' ' . $lng['LNG_EDIT'] . '">' . $topic[LANGUAGE] . '</span>';
            $row .= '</dd>';
            $ret['data'] = rawurlencode($row);
            $ret['newId'] = "config_category_" . $id;
        } elseif (preg_match('/^config_(category)_delete_([0-9]+)$/', $action, $match)) {
            // ลบหมวดหมู่
            $db->query("DELETE FROM `" . DB_CATEGORY . "` WHERE `module_id`='{$module_id}' AND `id`='{$match['2']}' LIMIT 1");
            // รายการที่ลบ
            $ret['del'] = "config_{$match['1']}_" . $match[2];
        } elseif (preg_match('/^config_(category)_name_([0-9]+)$/', $action, $match)) {
            // แก้ไขชื่อหมวดหมู่
            $topic[LANGUAGE] = $db->sql_trim_str(gcms::oneLine($_POST['value']));
            $sql = "SELECT `id` FROM `" . DB_CATEGORY . "` WHERE `module_id`='{$module_id}' AND `id`='{$match['2']}' LIMIT 1";
            $category = $db->customQuery($sql);
            if (sizeof($category) == 1) {
                $db->edit(DB_CATEGORY, $category[0]['id'], array('topic' => gcms::array2Ser($topic)));
                // ส่งข้อมูลใหม่ไปแสดงผล
                $ret['edit'] = rawurlencode($topic[LANGUAGE]);
                $ret['editId'] = $action;
            }
        }
    }
} else {
    $ret['error'] = 'ACTION_ERROR';
}
// คืนค่าเป็น JSON
echo gcms::array2json($ret);

Example #2

File: admin_categorywrite_save.php Project: phannack/GCMS

// referer, member
if (gcms::isReferer() && gcms::isMember()) {
    if (isset($_SESSION['login']['account']) && $_SESSION['login']['account'] == 'demo') {
        $ret['error'] = 'EX_MODE_ERROR';
    } else {
        $save = array();
        $error = false;
        $input = false;
        $topic = array();
        $detail = array();
        foreach ($_POST['category_topic'] as $k => $v) {
            $v = $db->sql_trim_str(gcms::oneLine($v));
            if ($v != '') {
                $topic[$k] = $v;
            }
            $v = $db->sql_trim_str(gcms::oneLine($_POST['category_detail'][$k]));
            if ($v != '') {
                $detail[$k] = $v;
            }
        }
        // ค่าที่ส่งมา
        $id = gcms::getVars($_POST, 'write_id', 0);
        $category_id = gcms::getVars($_POST, 'category_id', 0);
        $module_id = gcms::getVars($_POST, 'module_id', 0);
        if ($id > 0) {
            // แก้ไข, ตรวจสอบหมวดที่เลือก
            $sql = "SELECT C.`id`,C.`module_id`,C.`icon`,CONCAT(M.`config` ,'\n' ,C.`config`) AS `config`";
            $sql .= ",(SELECT `id` FROM `" . DB_CATEGORY . "` WHERE `category_id`={$category_id} AND `module_id`={$module_id}) AS `cid`";
            $sql .= " FROM `" . DB_CATEGORY . "` AS C";
            $sql .= " INNER JOIN `" . DB_MODULES . "` AS M ON M.`id`={$module_id} AND M.`owner`='board'";
            $sql .= " WHERE C.`id`={$id} AND C.`module_id`={$module_id} LIMIT 1";