/** * 获取数据表中字段与默认值 * * @return array */ public static function getTableAttribute() { $data = array(); foreach (Local::fetchAll('DESC z_accounts') as $k => $v) { $data[$v['Field']] = $v['Default'] == null ? '' : $v['Default']; } return $data; }
/** * 进行数据更新 * * @param array $data 要更新的数据 * @param int $id 要更新的用户 * * @return void */ public static function update($data, $id) { $sql = 'UPDATE z_users SET '; $inputParams = array(); foreach ($data as $k => $v) { $sql .= "{$k}=:{$k},"; $inputParams[':' . $k] = $v; } $sql = substr($sql, 0, strlen($sql) - 1) . ' WHERE user_id=:user_id'; $inputParams[':user_id'] = $id; $statement = Local::query($sql, $inputParams); $statement->closeCursor(); }
/** * 获取easyui格式的数据 * * @return string */ public static function getEasyUITreeData() { $catData = Local::fetchAll('SELECT * FROM z_account_cats WHERE cat_status=1'); return self::getCatTree(0, $catData); }