function getSearchResults($function_name, $description = TRUE) { $this->db - like('Name', $function_name); $this->db - orderby('Name'); $query = $this->db->get('Items'); if ($query->num_rows() > 0) { $output = '<ul>'; foreach ($query->result() as $function_info) { if ($description) { $output .= '<li><strong>' . $function_info->name . '</strong></>'; $output .= $function_info->function_description . '</li>'; } else { $output .= '<li>' . $function_info->function_name . '</li>'; } } $output = '</ul>'; return $output; } else { return '<p> Sorry No Search Results </p>'; } }
/** * Model definition. */ function define() { // Fields. $this->fields = array('id', 'slug', 'name', 'fields', 'inputs', 'subscribers', 'date_created', 'date_updated', 'fields' => function ($channel) { return orderby($channel['fields'], 'sort'); }, 'fields_by_id' => function ($channel) { return Channels::get_fields_by_id($channel); }, 'entries' => function ($channel) { return get("/entries", array('channel_id' => $channel['id'])); }, 'entry_count' => function ($channel) { return get("/entries/:count", array('channel_id' => $channel['id'])); }); $this->search_fields = array('name'); // Indexes. $this->indexes = array('id' => 'unique', 'slug' => 'unique'); // Query defaults. $this->query = array('order' => 'name ASC'); // Validate. $this->validate = array('required' => array('name', 'slug'), 'unique' => array('slug'), ':fields' => array('required' => array('id', 'name', 'type'), 'unique' => array('id'))); // Event binds. $this->binds = array('POST' => function ($event) { $data =& $event['data']; // Auto slug? if ($data['name'] && !$data['slug']) { $data['slug'] = hyphenate($data['name']); } }, 'POST.fields' => function ($event) { $data =& $event['data']; // Default field ID to underscored field name. if (isset($data['name']) && !$data['id']) { $data['id'] = underscore($data['name']); } }); }
} editThread($threadid); break; case "submit_link": $link = ""; if (isset($_REQUEST['link'])) { $link = $_REQUEST['link']; } submitLink($link); break; case "orderby": $orderby = ""; if (isset($_REQUEST['orderby'])) { $orderby = $_REQUEST['orderby']; } orderby($orderby); break; case "interests_option": $orinterests_optionderby = ""; if (isset($_REQUEST['interests_option'])) { $interests_option = $_REQUEST['interests_option']; } interests_option($interests_option); break; case "load_recent_category_topics": $categoryid = ""; if (isset($_REQUEST['categoryid'])) { $categoryid = $_REQUEST['categoryid']; } loadRecentCategoryTopics($categoryid); break;
/** * Model definition. */ function define() { // Fields. $this->fields = array('id', 'order_id', 'name', 'phone', 'address', 'city', 'state', 'zip', 'country', 'method', 'tracking', 'items', 'date_created', 'date_updated', 'items' => function ($shipment) { return get("/products", array(':with' => $shipment['items'])); }, 'order' => function ($shipment) { return get("/orders/{$shipment['order_id']}"); }, 'carrier' => function ($shipment) { return Shipments::get_carrier($shipment); }); $this->search_fields = array('name', 'address'); // Validate. $this->validate = array('required' => array('order_id', 'name', 'address', 'city', 'state', 'method', 'tracking'), ':items' => array('required' => array('id', 'quantity'))); // Event binds. $this->binds = array('GET' => function ($event, $model) { $params =& $event['data']; // Get shipping methods? if ($event['id'] == "methods") { $methods = array(); // Trigger special context event. $methods = trigger('shipments', 'methods', $methods, $params, $model); // Process default shipping methods? if (empty($methods)) { $methods = Shipments::process_default_methods($methods, $params); } // No methods exist? if (!empty($methods)) { // Order methods by price. if ($params) { $methods = orderby($methods, 'price'); } // Direct result. return array('result' => $methods); } return false; } }, 'POST' => function ($event) { $data =& $event['data']; if ($data['order_id'] && ($order = get("/orders/{$data['order_id']}"))) { // Default data from order. $data = array_merge((array) $order['shipping'], $data); $data['name'] = $data['name'] ?: $order['name']; $data['phone'] = $data['phone'] ?: $order['phone']; // Filter shipment items. $shipment_items = array(); foreach ($order['items'] as $order_item_id => $item) { // Specific items? Otherwise defaults to all order items. if (is_array($data['items'])) { $add_this_item = false; foreach ($data['items'] as $data_item) { if (is_array($data_item) && $data_item['order_item_id'] == $order_item_id) { $add_this_item = true; } } if ($add_this_item === false) { continue; } } // Bundle? if ($item['items']) { foreach ($item['items'] as $i) { $shipment_items[++$ship_item_id] = array('id' => $i['id'], 'quantity' => $i['quantity'] * $item['quantity'], 'order_item_id' => $order_item_id); } } else { $shipment_items[++$ship_item_id] = array('id' => $item['id'], 'quantity' => $item['quantity'], 'order_item_id' => $order_item_id); } } // Filtered. $data['items'] = $shipment_items; } }, 'PUT, POST' => function ($event, $model) { $data =& $event['data']; if ($data['items']) { // Clean items data if ID missing. foreach ((array) $data['items'] as $id => $item) { if (!$item['id'] || !$item['quantity']) { unset($data['items'][$id]); } } // Shipment requires at least 1 item. if (count($data['items']) == 0) { $model->error('Must contain at least one item', 'items'); } } }, 'after:POST, after:PUT' => function ($result, $event) { $data =& $event['data']; if ($result) { // Send shipment e-mail? if ($data[':email']) { $settings = get("/settings/emails/shipment"); if ($settings !== false) { $settings['shipment'] = $result; $settings['to'] = $result['order']['account']['email']; // Default subject? if ($settings['subject']) { $settings['subject'] .= ' #' . $result['order']['id']; } // Override default email? if (is_array($data[':email'])) { $settings = array_merge($settings, $data[':email']); } post("/emails/shipment", $settings); } } if ($result['order_id']) { // Set date_shipped on order? if (!$result['order']['date_shipped']) { put("/orders/{$result['order_id']}", array('date_shipped' => $result['date_created'])); } else { if ($result['is_cancelled']) { if (count($result['order']['shipments']) == 1) { put("/orders/{$result['order_id']}", array('date_shipped' => null)); } } } } } }, 'after:DELETE' => function ($result, $event) { if ($result) { // Last shipment of an order? Unset date shipped. if ($result['order']['shipments']['count'] == 0) { put("/orders/{$result['order_id']}", array('date_shipped' => null)); } } }); }
/** * Model definition. */ function define() { // Fields. $this->fields = array('id', 'slug', 'name', 'price', 'cost', 'sku', 'weight', 'description', 'category_ids', 'variants', 'items', 'stock', 'images', 'is_bundle', 'is_active', 'date_created', 'date_updated', 'items' => function ($product) { return get("/products", array(':with' => orderby($product['items'], 'sort'))); }, 'weight' => function ($product) { return Products::get_weight($product); }, 'categories' => function ($product) { return get("/categories", array('id' => array('$in' => (array) $product['category_ids']))); }); // Search fields. $this->search_fields = array('name', 'sku', 'description'); // Indexes. $this->indexes = array('id' => 'unique', 'slug' => 'unique', 'sku'); // Validate. $this->validate = array('required' => array('slug', 'name', 'price'), 'unique' => array('slug', 'sku'), ':items' => array('required' => array('id', 'quantity'))); // Event binds. $this->binds = array('GET' => function ($event) { $data =& $event['data']; // Get by category ID or slug. if ($data['category']) { if ($category = get("/categories/{$data['category']}")) { $data['category_ids'] = $category['id']; unset($data['category']); } else { // Category not found. return false; } } // Default category sort? if (!$data['order'] && is_numeric($data['category_ids'])) { $data['order'] = "category_sort.{$data['category_ids']}"; } if ($data['pricing']) { // Avoid conflicts with actual pricing field. $data[':pricing'] = $data['pricing']; unset($data['pricing']); } }, 'POST' => function ($event) { $data =& $event['data']; // Auto slug? if ($data['name'] && !$data['slug']) { $data['slug'] = hyphenate($data['name']); } }, 'POST, PUT' => function ($event, $model) { $data =& $event['data']; // Set product categories? if (isset($data['categories'])) { foreach ((array) $data['categories'] as $category_id) { if (!is_numeric($category_id)) { $category = get("/categories/{$category_id}"); $category_id = $category['id']; } if ($category_id) { $data['category_ids'][] = $category_id; } } unset($data['categories']); } // Updating category ids? if (is_array($data['category_ids'])) { sort($data['category_ids']); } }, 'POST.variants' => function ($event) { $data =& $event['data']; // Unset default override keys if (!$data['sku']) { unset($data['sku']); } if (!$data['price']) { unset($data['price']); } }, 'after:GET' => function ($result, $event) { $data =& $event['data']; if ($result && $data[':pricing']) { // Handle special pricing. $result = Products::get_pricing($result, $data[':pricing']); } }); }
<h1 class="center">Sortera filmer</h1> <p class="center">Alla filmer i databasen:</p> <?php /** * Function to create links for sorting */ function orderby($column) { return "<span class='orderby'>" . "<a href='?p=moviesort&orderby={$column}&order=asc' class='sortButton'>↓</a>" . "<a href='?p=moviesort&orderby={$column}&order=desc' class='sortButton'>↑</a>" . "</span>"; } $tr = "<tr><th>Rad</th><th>Id " . orderby('id') . "</th><th>Bild</th><th>Titel " . orderby('title') . "</th><th>År " . orderby('year') . "</th><th>Genre</th></tr>"; // Get parameters for sorting $orderby = isset($_GET['orderby']) ? strtolower($_GET['orderby']) : 'id'; $order = isset($_GET['order']) ? strtolower($_GET['order']) : 'asc'; // Check that incoming is valid in_array($orderby, array('id', 'title', 'year')) or die('Check: Not valid column.'); in_array($order, array('asc', 'desc')) or die('Check: Not valid sort order.'); //connect to database $db = new CDatabase($urbax['database']); //build query-string $sql = "SELECT * FROM VMovie ORDER BY {$orderby} {$order};"; //run query $res = $db->ExecuteSelectQueryAndFetchAll($sql); //build table echo "<table class='table'>"; echo $tr; foreach ($res as $i => $row) { echo "<tr><td>{$i}</td><td>{$row->id}</td><td><img src='{$row->image}' alt='bild på film' width='100' height='50'></td><td>{$row->title}</td><td>{$row->year}</td><td>{$row->genre}</td></tr>"; }