getAll('SELECT * FROM `' . $db_mymps . 'coupon_category`'); include mymps_tpl('group_category'); } else { if (is_array($cate_name)) { foreach ($cate_name as $key => $val) { $catename = trim($val); $cateorder = intval($cate_order[$key]); $cateview = intval($cate_view[$key]); if ($catename) { $db->query('UPDATE `' . $db_mymps . 'coupon_category` SET cate_view=\'' . $cateview . '\', cate_order=\'' . $cateorder . '\',cate_name=\'' . $catename . '\' WHERE cate_id=\'' . $key . '\''); unset($catename); unset($cateview); unset($cateorder); } } } if (is_array($newcate_order) && is_array($newcate_view) && is_array($newcate_name)) { foreach ($newcate_name as $key => $cate_name) { $cate_name = trim($cate_name); $cate_order = intval($newcate_order[$key]); $cate_view = intval($newcate_view[$key]); if ($cate_name) { $db->query('INSERT INTO' . "\t" . '`' . $db_mymps . 'coupon_category` (cate_view,cate_order,cate_name) VALUES (\'' . $cate_view . '\', \'' . $cate_order . '\',\'' . $cate_name . '\')'); unset($cate_order); unset($cate_name); unset($cate_view); } } } if (is_array($delete)) { $db->query('DELETE FROM `' . $db_mymps . 'coupon_category` WHERE ' . create_in($delete, 'cate_id')); } write_msg('优惠券分类设置更新成功', '?', 'write_record'); }