1. PHP / Говнокод #7617

    +156

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    13. 13
    14. 14
    15. 15
    16. 16
    17. 17
    18. 18
    19. 19
    20. 20
    21. 21
    22. 22
    23. 23
    24. 24
    25. 25
    26. 26
    27. 27
    28. 28
    29. 29
    30. 30
    31. 31
    32. 32
    33. 33
    34. 34
    35. 35
    36. 36
    37. 37
    38. 38
    39. 39
    40. 40
    41. 41
    42. 42
    43. 43
    44. 44
    45. 45
    46. 46
    47. 47
    48. 48
    49. 49
    50. 50
    51. 51
    52. 52
    53. 53
    54. 54
    55. 55
    56. 56
    57. 57
    58. 58
    59. 59
    60. 60
    61. 61
    62. 62
    63. 63
    64. 64
    65. 65
    66. 66
    67. 67
    68. 68
    69. 69
    70. 70
    71. 71
    72. 72
    <?php
	include_once "database.php";
	
	$db = NewPDO();
	$search = $db->prepare("SELECT w.wine_name as wine_name, w.year as wine_year, gv.variety as wine_variety, wn.winery_name as winery_name,r.region_name as region_name
							FROM wine w
							JOIN wine_variety wv ON w.wine_id = wv.wine_id
							JOIN grape_variety gv ON wv.variety_id = gv.variety_id
							JOIN winery wn ON w.winery_id = wn.winery_id JOIN region r ON wn.region_id = r.region_id
							WHERE w.wine_name LIKE :in_wine_name AND wn.winery_name LIKE :in_winery_name AND r.region_name LIKE :in_region_name
							ORDER BY w.wine_name ASC , w.year ASC , gv.variety ASC");
	$wine_name = '%'.htmlspecialchars($_GET["wine"]).'%';
	$winery_name = '%'.htmlspecialchars($_GET["winery"]).'%';
	$region = '%'.htmlspecialchars($_GET["region"]).'%';
	
	$search->bindValue(':in_wine_name',$wine_name,PDO::PARAM_STR);
	$search->bindValue(':in_winery_name',$winery_name,PDO::PARAM_STR);
	$search->bindValue(':in_region_name',$region,PDO::PARAM_STR);
	
	$search->execute();
	echo "<table>";
	if ($search->columnCount() > 0)
	{
		echo "<tr align=\"center\">
				<th>
					Wine
				</th>
				<th>
					Year
				</th>
				<th>
					Variety
				</th>
				<th>
					Winery
				</th>
				<th>
					Region
				</th>
			  </tr>";
		while($row = $search->fetch())
		{
			echo "<tr align=\"left\">
					<td width=\"80\">
						".$row["wine_name"]."
					</td>
					<td width=\"50\">
						".$row["wine_year"]."
					</td>
					<td width=\"90\">
						".$row["wine_variety"]."
					</td>
					<td width=\"230\">
						".$row["winery_name"]."
					</td>
					<td>
						".$row["region_name"]."
					</td>
				  </tr>";
		}
		echo "<tr>
			  	<td colspan=\"5\">
					".$search->rowCount()." records found matching your criteria.
				</td>
		      </tr>";
	}
	else
	{
		echo "<tr><td>No records match your search criteria</td></tr>";
	}
	echo "</table>";
?>

    Вот такой вот полнотекстовый поиск с выводом результата

    Запостил: denis90, 23 Августа 2011

    Комментарии (16) RSS

    Добавить комментарий