(root)/trunk/search_program_edit_sql.php - Редакция 2
Авторство |
Последнее изменение |
Открыть журнал
| RSS
<?PHP
session_start();
if ($_SESSION['$user_privileges'] < 16)
header("Location: index.php");
include "head.php";
$search = $_GET['search'];
$db = mysql_connect("localhost", "linwin");
mysql_select_db("linwin", $db);
mysql_query("SET NAMES 'utf8';", $db);
$sql = "SELECT id, name, description FROM program WHERE name like '%". $search. "%' or description like '%". $search. "%' ORDER BY name";
$query = mysql_query($sql, $db);
$num_program = mysql_num_rows($query);
$mas_program_id = array();
$mas_program_name = array();
for ($i = 0; $i < $num_program; $i++)
{
$mas_program_id[$i] = mysql_result($query, $i, 0);
$mas_program_name[$i] = mysql_result($query, $i, 1);
$mas_program_description[$i] = mysql_result($query, $i, 2);
}
$sql = "SELECT id, name, description FROM section WHERE name like '%". $search. "%' or description like '%". $search. "%' ORDER BY name";
$query = mysql_query($sql, $db);
$num_section = mysql_num_rows($query);
$mas_section_id = array();
$mas_section_name = array();
$mas_section_description = array();
for ($i = 0; $i < $num_section; $i++)
{
$mas_section_id[$i] = mysql_result($query, $i, 0);
$mas_section_name[$i] = mysql_result($query, $i, 1);
$mas_section_description[$i] = mysql_result($query, $i, 2);
}
mysql_close($db);
print "
<p><b>Найденные группы:</b></p>
<hr/>
<table width = \"100%\">
<tr>
<td><b>Название группы</b></td>
<td><b>Описание</b></td>
</tr>
<tr>
<td><br/></td>
<td><br/></td>
</tr>";
for ($i = 0; $i < $num_section; $i++)
{
print "
<tr><td><a href = edit_section.php?section_id=$mas_section_id[$i]>$mas_section_name[$i]</td>
<td>$mas_section_description[$i]</td></tr>";
}
print "</table>";
print "
<p><b>Найденные программы:</b></p>
<hr/>
<table width = \"100%\">
<tr>
<td><b>Название программы</b></td>
<td><b>Описание</b></td>
</tr>
<tr>
<td><br/></td>
<td><br/></td>
</tr>";
for ($i = 0; $i < $num_program; $i++)
{
#echo "<tr><td class = \"border-tb\">$mas_program_name[$i]</td></tr>";
print "
<tr><td><a href = edit_program.php?program_id=$mas_program_id[$i]>$mas_program_name[$i]</td>
<td>$mas_program_description[$i]</td></tr>";
}
print "</table>";
include "foot.php";
?>