You are not registered.
Registration allows you to subscribe to projects, open projects, and more. Click here to register.Website Source Code
<< Back
search.php
search.php
<?php
function get_search()
{
$vars['SEARCH'] = '';
$vars['CHECKED'] = '';
$vars['RESULTS'] = '';
if (isset($_POST['sent']))
{
$vars['SEARCH'] = escape_html($_POST['keywords']);
if ($_POST['hiring'])
{
$vars['CHECKED'] = ' checked="checked"';
$where = ' OR `hiring` LIKE \'%' . db_escape($_POST['keywords']) . '%\'';
}
else
{
$where = '';
}
$result = mysql_query('SELECT `id`, `name`, `category`, `description` FROM `projects` WHERE `name` LIKE \'%' . db_escape($_POST['keywords']) . '%\'' . $where . ' ORDER BY `last` DESC, `subscribers` DESC;');
$vars['RESULTS'] = get_show_results($result);
}
return get_template('search', $vars);
}
function get_browse()
{
global $categories;
$browse = '<div style="font-size: 20px">Projects:</div><hr style="border: 1px solid #555555;" />';
if (isset($_GET['cat']))
$where = ' WHERE `category` = ' . intval($_GET['cat']);
else
$where = '';
$result = mysql_query('SELECT `id`, `name`, `category`, `description` FROM `projects`' . $where . ' ORDER BY `last` DESC, `subscribers` DESC;');
$browse .= get_show_results($result);
return $browse;
}
function get_show_results($result)
{
global $categories;
$ret = '';
if (mysql_num_rows($result) == 0)
{
$ret .= '<div style="font-size: 12px; font-style: italic">Sorry, no projects found.</div>';
}
else
{
$vars = null;
$first = true;
while ($row = mysql_fetch_assoc($result))
{
$vars['UP'] = $first ? '' : '<hr style="border: 1px solid #eeeeee; width: 100%" />';
$vars['PRJ-ID'] = $row['id'];
$vars['TITLE'] = escape_html($row['name']);
$vars['CAT'] = $row['category'];
$vars['CAT_NAME'] = $categories[$row['category']];
$vars['TEXT'] = make_shorter(xss_safe($row['description']) , 1000);
$vars['LINK'] = create_link($row['category'], $row['id'], $row['name']);
$icon_size = getimagesize('projects_images/' . $row['id'] . '.png');
$size = get_image_size($icon_size[0], $icon_size[1], 88);
$vars['WIDTH'] = $size[0];
$vars['HEIGHT'] = $size[1];
$ret .= get_template('project_result', $vars);
$first = false;
}
}
return $ret;
}
?>
