/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "permissions", "where" => "group_id = groups.id");
$options["select"][] = "groups.*";
$options["select"][] = "permissions.id AS permissions";
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "tickets", "where" => "milestone_id = milestones.id");
$options["select"][] = "milestones.*";
$options["select"][] = "COUNT(tickets.id) AS ticket_count";
$options["group"][] = "id";
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "extensions", "where" => "type_id = types.id");
$options["select"][] = "types.*";
$options["select"][] = "COUNT(extensions.id) AS extension_count";
$options["group"][] = "id";
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "versions", "where" => "extension_id = extensions.id");
$options["select"][] = "extensions.*";
$options["select"][] = "MAX(versions.created_at) AS last_update";
$options["group"][] = "id";
$options["order"] = array("__last_update DESC", "extensions.id DESC");
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "notes", "where" => "version_id = versions.id");
$options["select"][] = "versions.*";
$options["select"][] = "COUNT(notes.id) AS note_count";
$options["select"][] = "MAX(notes.created_at) AS last_note";
$options["group"][] = "id";
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "topics", "where" => "forum_id = forums.id");
$options["select"][] = "forums.*";
$options["select"][] = "COUNT(topics.id) AS topic_count";
$options["group"][] = "id";
fallback($options["order"], array("order ASC", "id ASC"));
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "messages", "where" => "topic_id = topics.id");
$options["select"][] = "topics.*";
$options["select"][] = "COUNT(messages.id) AS message_count";
$options["select"][] = "MAX(messages.created_at) AS last_message";
$options["select"][] = "MAX(messages.updated_at) AS last_update";
fallback($options["order"], array("COALESCE(MAX(messages.created_at), topics.created_at) DESC", "id DESC"));
$options["group"][] = "id";
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["left_join"][] = array("table" => "revisions", "where" => "ticket_id = tickets.id");
$options["select"][] = "tickets.*";
$options["select"][] = "COUNT(revisions.id) AS revision_count";
$options["select"][] = "MAX(revisions.created_at) AS last_revision";
$options["select"][] = "MAX(revisions.updated_at) AS last_update";
if (!isset($options["done"]) or !$options["done"]) {
$options["where"]["state"] = array("new", "open", "on-hold");
}
$options["group"][] = "id";
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array(), $debug = false)
{
if (isset($options["where"]) and !is_array($options["where"])) {
$options["where"] = array($options["where"]);
} elseif (!isset($options["where"])) {
$options["where"] = array();
}
$has_status = false;
foreach ($options["where"] as $key => $val) {
if (is_int($key) and substr_count($val, "status") or $key === "status") {
$has_status = true;
}
}
if (!XML_RPC) {
$options["where"][] = self::feathers();
if (!$has_status) {
$visitor = Visitor::current();
$private = (isset($options["drafts"]) and $options["drafts"] and $visitor->group->can("view_draft")) ? self::statuses(array("draft")) : self::statuses();
if (isset($options["drafts"]) and $options["drafts"] and $visitor->group->can("view_own_draft")) {
$private .= " OR (status = 'draft' AND user_id = :visitor_id)";
$options["params"][":visitor_id"] = $visitor->id;
}
$options["where"][] = $private;
}
}
$options["left_join"][] = array("table" => "post_attributes", "where" => "post_id = posts.id");
$options["select"] = array_merge(array("posts.*", "post_attributes.name AS attribute_names", "post_attributes.value AS attribute_values"), oneof(@$options["select"], array()));
$options["ignore_dupes"] = array("attribute_names", "attribute_values");
fallback($options["order"], "pinned DESC, created_at DESC, id DESC");
return parent::search(get_class(), $options, $options_for_object);
}
static function find($options = array(), $options_for_object = array())
{
return parent::search(get_class(), $options, $options_for_object);
}
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
fallback($options["order"], "id ASC");
return parent::search(get_class(), $options, $options_for_object);
}
<?php
// Make your model available
include 'models/model.php';
include 'connection.php';
// get the connection
$conn = getConnection();
// create model with the connection to db
$model = new Model($conn);
// receive the user's query
$q = $_GET['q'];
// search the database with that query
$matches = $model->search($q);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Movie Database</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" >
<link rel="stylesheet" href="css/main.css" >
</head>
<body>
<div id="wrapper">
<nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0px;">
<div class="navbar-header">
<a class="navbar-brand" href="index.php">Movie Database</a>
</div>
<ul class="nav navbar-top-links navbar-right">
/**
* Function: find
* See Also:
* <Model::search>
*/
static function find($options = array(), $options_for_object = array())
{
$options["order"] = "created_at ASC, id ASC";
return parent::search(get_class(), $options, $options_for_object);
}
