rendered paste body<?php
include 'connect_db.php';
$search_raw = strtolower(ltrim(rtrim($_POST["search"])));
$search = explode(" ", $search_raw);
include 'head.php';
$all_tags = 'tag_00, tag_01, tag_02, tag_03, tag_04, tag_05, tag_06, tag_07, tag_08, tag_09';
$result = mysql_query("SELECT filename, name, ".$all_tags." FROM images;");
while ($data = mysql_fetch_array($result) )
{
if (in_array (strtolower($data['name']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_00']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_01']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_02']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_03']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_04']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_05']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_06']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_07']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_08']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
else if (in_array (strtolower($data['tag_09']), $search)) {
?> <a href="upload/<?php echo $data['filename'];?>"><?php echo $data['name'];?></a> <br /><?php }
}
include 'foot.php';
mysql_close();
?>