YaWK  24.1
Yet another WebKit
Public Member Functions | Public Attributes | List of all members
YAWK\search Class Reference

Backend search class. More...

Public Member Functions

 searchBlogs ($db, $searchString, $lang)
 search blogs More...
 
 searchMenus ($db, $searchString, $lang)
 search menus More...
 
 searchPages ($db, $searchString, $lang)
 search pages and draw box More...
 
 searchUsers ($db, $searchString, $lang)
 search users More...
 
 searchWidgets ($db, $searchString, $lang)
 search widgets More...
 

Public Attributes

 $searchString
 

Detailed Description

Backend search class.

Backend Search

handles the backend's core search functions.
See Methods Summary for Details!

Author
Daniel Retzl danie.nosp@m.lret.nosp@m.zl@gm.nosp@m.ail..nosp@m.com
Copyright
2017-2021 Daniel Retzl yawk.io @license https://opensource.org/licenses/MIT
Version
1.0.0

Definition at line 15 of file search.php.

Member Function Documentation

◆ searchBlogs()

YAWK\search::searchBlogs (   $db,
  $searchString,
  $lang 
)

search blogs

Parameters
string$searchString
object$dbdatabase object

Definition at line 167 of file search.php.

168  {
169  $i = 0;
170  $blogResults = '';
171  if (isset($searchString) && (!empty($searchString)))
172  {
173  if ($res = $db->query("SELECT blogid, title, subtitle, teasertext FROM {blog_items}
174  WHERE title LIKE '%".$searchString."%' OR
175  subtitle LIKE '%".$searchString."%' OR
176  teasertext LIKE '%".$searchString."%'"))
177  {
178  while ($row = mysqli_fetch_assoc($res))
179  {
180  $i++;
181  $blogResults .= "<a href=\"index.php?plugin=blog&pluginpage=blog-entries&blogid=$row[blogid]\" target=\"_self\"><i class=\"fa fa-edit\"></i> $row[title]</a><br>";
182  }
183  }
184  }
185  if ($i > 0)
186  {
187  echo "
188  <div class=\"box\">
189  <div class=\"box-header with-border\">
190  <h3 class=\"box-title\">$lang[BLOG] <small>$lang[ALL_ELEMENTS]</small></h3>
191  </div>
192  <div class=\"box-body\">
193  <h4>$blogResults</h4><b>$i</b> $lang[BLOG_ENTRIES_WITH_TAG] <i><b>&laquo;$searchString&raquo;</b></i>
194  </div>
195  </div>";
196  }
197  } /* end function searchPages(); */
$i
$i
Definition: widget-edit.php:203

References $db, $i, $res, and YAWK\search\$searchString.

◆ searchMenus()

YAWK\search::searchMenus (   $db,
  $searchString,
  $lang 
)

search menus

Parameters
string$searchString
object$dbdatabase object

Definition at line 61 of file search.php.

62  {
63  $i = 0;
64  $menuResult = '';
65  if (isset($searchString) && (!empty($searchString)))
66  {
67  if ($res = $db->query("SELECT menuID, text FROM {menu} WHERE text LIKE '%".$searchString."%'"))
68  {
69  while ($row = mysqli_fetch_assoc($res))
70  {
71  $i++;
72  $menuResult .= "<a href=\"index.php?page=menu-edit&menu=$row[menuID]\" target=\"_self\"><i class=\"fa fa-edit\"></i> $row[text]</a><br>";
73  }
74  }
75  }
76  if ($i > 0)
77  {
78  echo "
79  <div class=\"box\">
80  <div class=\"box-header with-border\">
81  <h3 class=\"box-title\">$lang[MENUS] <small>$lang[ALL_ELEMENTS]</small></h3>
82  </div>
83  <div class=\"box-body\">
84  <h4>$menuResult</h4><b>$i</b> $lang[MENU_ENTRIES_WITH_TAG] <i><b>&laquo;$searchString&raquo;</b></i>
85  </div>
86  </div>";
87  }
88  } /* end function searchPages(); */

References $db, $i, $res, and YAWK\search\$searchString.

◆ searchPages()

YAWK\search::searchPages (   $db,
  $searchString,
  $lang 
)

search pages and draw box

Parameters
string$searchString
object$dbdatabase object

Definition at line 25 of file search.php.

26  {
27  $i = 0;
28  $pagesResult = '';
29  if (isset($searchString) && (!empty($searchString)))
30  {
31  if ($res = $db->query("SELECT id, alias, title FROM {pages} WHERE alias OR title LIKE '%".$searchString."%'"))
32  {
33  while ($row = mysqli_fetch_assoc($res))
34  {
35  $i++;
36  $pagesResult .= "<a href=\"index.php?page=page-edit&id=$row[id]\" target=\"_self\"><i class=\"fa fa-edit\"></i> $row[alias].html</a><br>";
37  }
38  }
39  }
40 
41  if ($i > 0)
42  {
43  echo "
44  <div class=\"box\">
45  <div class=\"box-header with-border\">
46  <h3 class=\"box-title\">$lang[PAGES] <small>$lang[ALL_ELEMENTS]</small></h3>
47  </div>
48  <div class=\"box-body\">
49  <h4>$pagesResult</h4><b>$i</b> $lang[PAGE_ENTRIES_WITH_TAG] <i><b>&laquo;$searchString&raquo;</b></i>
50  </div>
51  </div>";
52  }
53  } /* end function searchPages(); */

References $db, $i, $res, and YAWK\search\$searchString.

◆ searchUsers()

YAWK\search::searchUsers (   $db,
  $searchString,
  $lang 
)

search users

Parameters
string$searchString
object$dbdatabase object

Definition at line 96 of file search.php.

97  {
98  $i = 0;
99  $userResult = '';
100  if (isset($searchString) && (!empty($searchString)))
101  {
102  if ($res = $db->query("SELECT id, username FROM {users} WHERE username LIKE '%".$searchString."%'"))
103  {
104  while ($row = mysqli_fetch_assoc($res))
105  {
106  $i++;
107  $userResult .= "<a href=\"index.php?page=users&user=$row[id]\" target=\"_self\"><i class=\"fa fa-edit\"></i> $row[username]</a><br>";
108  }
109  }
110  }
111  if ($i > 0)
112  {
113  echo "
114  <div class=\"box\">
115  <div class=\"box-header with-border\">
116  <h3 class=\"box-title\">$lang[USERS] <small>$lang[ALL_ELEMENTS]</small></h3>
117  </div>
118  <div class=\"box-body\">
119  <h4>$userResult</h4><b>$i</b> $lang[USER_ENTRIES_WITH_TAG] <i><b>&laquo;$searchString&raquo;</b></i>
120  </div>
121  </div>";
122  }
123 
124  } /* end function searchPages(); */

References $db, $i, $res, and YAWK\search\$searchString.

◆ searchWidgets()

YAWK\search::searchWidgets (   $db,
  $searchString,
  $lang 
)

search widgets

Parameters
string$searchString
object$dbdatabase object

Definition at line 132 of file search.php.

133  {
134  $i = 0;
135  $widgetResult = '';
136  if (isset($searchString) && (!empty($searchString)))
137  {
138  if ($res = $db->query("SELECT id, widgetTitle FROM {widgets} WHERE widgetTitle LIKE '%".$searchString."%'"))
139  {
140  while ($row = mysqli_fetch_assoc($res))
141  {
142  $i++;
143  $widgetResult .= "<a href=\"index.php?page=widget-edit&widget=$row[id]\" target=\"_self\"><i class=\"fa fa-edit\"></i> $row[widgetTitle]</a><br>";
144  }
145  }
146  }
147  if ($i > 0 )
148  {
149  echo "
150  <div class=\"box\">
151  <div class=\"box-header with-border\">
152  <h3 class=\"box-title\">$lang[WIDGETS] <small>$lang[ALL_ELEMENTS]</small></h3>
153  </div>
154  <div class=\"box-body\">
155  <h4>$widgetResult</h4><b>$i</b> $lang[WIDGETS_ENTRIES_WITH_TAG] <i><b>&laquo;$searchString&raquo;</b></i>
156  </div>
157  </div>";
158  }
159  } /* end function searchPages(); */

References $db, $i, $res, and YAWK\search\$searchString.

Member Data Documentation

◆ $searchString

YAWK\search::$searchString

searchString string contains the search term

Definition at line 18 of file search.php.

Referenced by YAWK\search\searchBlogs(), YAWK\search\searchMenus(), YAWK\search\searchPages(), YAWK\search\searchUsers(), and YAWK\search\searchWidgets().

The documentation for this class was generated from the following file: