livesearch::title_search() - Code Metrics - Inspection of "WIP Experiment" - phpbb/ideas - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#132)

by Matt

created 2020-06-05 22:20 UTC

livesearch::title_search() A

↳ Parent: livesearch

Complexity

Conditions	2
Paths	2

Size

Total Lines	19
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	13
c	1
b	0
f	0
dl	0
loc	19
rs	9.8333
cc	2
nc	2
nop	2

<?php
/**
 *
 * Ideas extension for the phpBB Forum Software package.
 *
 * @copyright (c) phpBB Limited <https://www.phpbb.com>
 * @license GNU General Public License, version 2 (GPL-2.0)
 *
 */

namespace phpbb\ideas\factory;

/**
 * Class for handling multiple ideas
 */
class livesearch extends base
{
	/** @var array */
	protected $sql;

	/**
	 * Do a live search on idea titles. Return any matches based on a given search query.
	 *
	 * @param string $search The string of characters to search using LIKE
	 * @param int    $limit  The number of results to return
	 *
	 * @return array An array of matching idea id/key and title/values
	 */
	public function title_search($search, $limit = 10)
	{
		$results = [];
		$sql = 'SELECT idea_title, idea_id
			FROM ' . $this->table_ideas . '
			WHERE idea_title ' . $this->db->sql_like_expression($this->db->get_any_char() . $search . $this->db->get_any_char());
		$result = $this->db->sql_query_limit($sql, $limit);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$results[] = [
				'idea_id'     => $row['idea_id'],
				'result'      => $row['idea_id'],
				'clean_title' => $row['idea_title'],
				'display'     => "<span>{$row['idea_title']}</span>", // spans are expected in phpBB's live search JS
			];
		}
		$this->db->sql_freeresult($result);

		return $results;
	}
}


1			<?php
2			/**
3			*
4			* Ideas extension for the phpBB Forum Software package.
5			*
6			* @copyright (c) phpBB Limited <https://www.phpbb.com>
7			* @license GNU General Public License, version 2 (GPL-2.0)
8			*
9			*/
10
11			namespace phpbb\ideas\factory;
12
13			/**
14			* Class for handling multiple ideas
15			*/
16			class livesearch extends base
17			{
18			/** @var array */
19			protected $sql;
20
21			/**
22			* Do a live search on idea titles. Return any matches based on a given search query.
23			*
24			* @param string $search The string of characters to search using LIKE
25			* @param int $limit The number of results to return
26			*
27			* @return array An array of matching idea id/key and title/values
28			*/
29			public function title_search($search, $limit = 10)
30			{
31			$results = [];
32			$sql = 'SELECT idea_title, idea_id
33			FROM ' . $this->table_ideas . '
34			WHERE idea_title ' . $this->db->sql_like_expression($this->db->get_any_char() . $search . $this->db->get_any_char());
35			$result = $this->db->sql_query_limit($sql, $limit);
36			while ($row = $this->db->sql_fetchrow($result))
37			{
38			$results[] = [
39			'idea_id' => $row['idea_id'],
40			'result' => $row['idea_id'],
41			'clean_title' => $row['idea_title'],
42			'display' => "<span>{$row['idea_title']}</span>", // spans are expected in phpBB's live search JS
43			];
44			}
45			$this->db->sql_freeresult($result);
46
47			return $results;
48			}
49			}
50

phpbb / ideas

Pull Request — master (#132)

livesearch::title_search() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like