All pastes #921923 Raw Edit

Anonym

public text v1 · immutable
#921923 ·published 2008-02-28 13:41 UTC
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();
?>