public function show($condition = '', $orderby = '', $limit = '') { $sql = 'SELECT * FROM ' . DB_PREFIX . 'notice WHERE 1' . $condition . $orderby . $limit; $q = $this->db->query($sql); while ($r = $this->db->fetch_array($q)) { $r['send_time'] = $r['send_time'] ? date('Y-m-d H:i:s', $r['send_time']) : 0; $r['notice_state'] = get_states($r['from_time'], $r['to_time']); $r['from_time'] = $r['from_time'] ? date('Y-m-d H:i:s', $r['from_time']) : 0; $r['to_time'] = $r['to_time'] ? date('Y-m-d H:i:s', $r['to_time']) : 0; $r['create_time'] = $r['create_time'] ? date('Y-m-d H:i:s', $r['create_time']) : 0; $r['update_time'] = $r['update_time'] ? date('Y-m-d H:i:s', $r['update_time']) : 0; $r['audit_time'] = $r['audit_time'] ? date('Y-m-d H:i:s', $r['audit_time']) : 0; $r['content'] = htmlspecialchars_decode(stripslashes($r['content'])); $r['type_name'] = $this->settings['type'][$r['type']]; if ($r['type'] == 5) { $r['owner_uname'] = '所有人'; } $ret[] = $r; } return $ret; }
public function edit_profile() { if ($this->session->userdata('is_logged_in')) { $email = $this->session->userdata('email'); $user_data = $this->User_model->get_user_data($email); $id = $user_data['id']; $profile_data = $this->User_model->get_user_profile($id); $this->load->helper('common'); $view_data['statelist'] = get_states(); $view_data['countries'] = get_countries(); $view_data['title'] = "Edit My Profile"; $view_data['page_header'] = "User Profile for: <strong>" . $user_data['first'] . " " . $user_data['last'] . "</strong>"; $data = array_merge($view_data, $user_data, $profile_data); $audit = array('primary' => 'PROF', 'secondary' => 'UPDV', 'status' => true, 'controller' => 'Profile', 'value' => $id, 'extra_1' => null, 'extra_2' => null, 'extra_3' => null); $this->Audit_model->log_entry($audit); $this->load->view("header", $data); $this->load->view("navbar", $data); $this->load->view('edit_profile_view', $data); $this->load->view("footer", $data); } else { redirect('User/restricted'); } }
$type = get_all_event_type(); $term = strtolower($_GET['term']); $result = array(); $max_result = isset($_GET["maxRows"]) ? (int) $_GET["maxRows"] : 10; $i = 0; foreach ($type as $t) { if (stripos(strtolower($t), $term) !== false && $i < $max_result) { array_push($result, array("term" => $t, "value" => ucwords($t))); $i++; } } echo json_encode($result); exit; } if (isset($_GET['term']) && $_GET['type'] == "state") { $states = get_states(); $term = strtolower($_GET['term']); $result = array(); $max_result = isset($_GET["maxRows"]) ? (int) $_GET["maxRows"] : 10; $i = 0; foreach ($states as $code => $state) { if (stripos(strtolower($state), $term) !== false && $i < $max_result) { array_push($result, array("term" => $code, "value" => $state)); $i++; } } echo json_encode($result); exit; } if (isset($_GET['term']) && $_GET['type'] == "venues") { global $wpdb;
public function update($id) { if ($this->session->userdata('is_logged_in') && $this->has_permission_to_edit()) { $user_data = $this->User_model->get_user($id); $profile_data = $this->User_model->get_user_profile($id); $data = array_merge($user_data, $profile_data); $this->load->helper('common'); $data['statelist'] = get_states(); $data['countries'] = get_countries(); $lookup['selected_roles'] = $this->User_model->list_user_roles($id); $lookup['active_roles'] = $this->Roles_permissions_model->list_active_roles(); $active_roles = array(); foreach ($lookup['active_roles'] as $role) { $role_id = $role->id; $role = $role->role; $active_roles[$role_id] = $role; } $selected_roles = array(); foreach ($lookup['selected_roles'] as $role) { $selected_roles[] = $role->role_id; } $data['id'] = $id; $data['active'] = $active_roles; $data['selected'] = $selected_roles; $data['title'] = "Edit the user"; $data['page_header'] = "Edit the user"; $audit = array('primary' => 'USRA', 'secondary' => 'UPDV', 'status' => true, 'controller' => 'UserAdmin', 'value' => $id, 'extra_1' => null, 'extra_2' => null, 'extra_3' => null); $this->Audit_model->log_entry($audit); $this->load->view("header", $data); $this->load->view("navbar", $data); $this->load->view('edit_user_view', $data); $this->load->view("footer", $data); } else { redirect('User/restricted'); } }
/** * 用户读取通知 * @param access_token * @param user_id 如果未传入access_token值,则需要传入user_id * @param utype 1-会员(默认) 2-m2o用户 */ public function read() { $uid = $this->user['user_id']; //提交会员id $utype = $this->input['utype'] ? intval($this->input['utype']) : 1; //提交用户为会员还是m20管理员 if (!$uid) { $this->errorOutput(NOT_LOGIN); } $notice_id = intval($this->input['id']); //读取通知的id if (!$notice_id) { $this->errorOutput(NOID); } $sql = 'SELECT id,send_uname,title,content,send_time,to_time FROM ' . DB_PREFIX . 'notice WHERE id =' . $notice_id; $notice = $this->db->query_first($sql); if (!$notice) { $this->errorOutput(NO_NOTICE); } $notice['send_time'] = $notice['send_time'] ? date('Y-m-d H:i:s', $notice['send_time']) : 0; $notice['content'] = htmlspecialchars_decode(stripslashes($notice['content'])); $notice['notice_state'] = get_states($notice['from_time'], $notice['to_time']); //查询通知日志中是否有此通知 $sql = 'SELECT * FROM ' . DB_PREFIX . 'notice_log WHERE notice_id =' . $notice_id . ' AND user_id = ' . $uid . ' AND user_type = ' . $utype; $log = $this->db->query_first($sql); if ($log && $log['statu'] == 0) { $sql = 'UPDATE ' . DB_PREFIX . 'notice_log SET statu = 1 WHERE notice_id =' . $notice_id . ' AND user_id = ' . $uid . ' AND user_type = ' . $utype; $this->db->query($sql); } elseif (!$log) { $sql = 'INSERT INTO ' . DB_PREFIX . 'notice_log' . '(notice_id,user_id,statu,user_type) VALUES (' . $notice_id . ',' . $uid . ',1,' . $utype . ')'; $this->db->query($sql); } $this->addItem($notice); $this->output(); }
<td class="gray-login">City</td> <td> <input name="s_city" type="text" id="s_city" size="30" value="<?php echo $_POST["s_city"]; ?> " /> </td> </tr> <tr> <td class="gray-login">State</td> <td> <select name="s_state"> <option value="">Select state</option> <?php get_states($_POST["s_state"]); ?> </select> </td> </tr> <tr> <td class="gray-login">Subject</td> <td> <select name="s_subject"> <option value="">Select subject</option> <?php get_subject($_POST["s_subject"]); ?> </select> </td> </tr>
include 'functions.php'; include 'ChromePhp.php'; // include 'oo.php'; //Home Flight::route('/', function () { Flight::render('hello.php'); ChromePhp::log('I used ChromePhp for troubleshooting.'); }); // List all states Flight::route('/v1/states/', function () { Flight::render('states.php'); }); // List cities from a certain state Flight::route('GET /v1/states/@state/cities', function ($state) { $state = strtoupper($state); $json_states = get_states('cities.csv', $state); Flight::json($json_states); }); // Lists a single city, can receive radius query data Flight::route('GET /v1/states/@state/cities/@city', function ($state, $city) { $state = strtoupper($state); if (is_numeric($city)) { $current_city = find_city_by_id('cities.csv', $city); } else { $current_city = find_city_by_name('cities.csv', $city, $state); } if (isset($current_city)) { $cityname = $current_city->name; $radius = Flight::request()->query->radius; $nearby = find_distance($state, $cityname, $radius, 'cities.csv'); Flight::json($nearby);
function get_state_by_name($state = '') { $c = get_states(); foreach ($c as $code => $name) { if (strtolower($state) === strtolower($name)) { return $code; break; } } return ""; }
<?php include 'get_connection.php'; try { get_states($conn); } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); return; } $conn = null; function get_states($conn) { $stmt = "SELECT name FROM states"; $sth = $conn->prepare($stmt, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY)); $sth->execute(); $result = $sth->fetchAll(); $length = count($result); for ($i = 0; $i < $length; $i++) { $state = $result[$i][0]; $url = "http://10.171.204.135/state-polls.html?topic=" . $state; //echo $county ."\n". $url . $county . "\n"; $state = str_replace("_", " ", $state); $state = ucwords($state); echo "<a class='list-group-item' href = " . $url . ">" . $state . "</a>"; } }