Просмотр поста

<?php 
define('_IN_JOHNCMS', 1); 
$textl='Поиск'; require_once("../incfiles/core.php"); 
require_once("poi.php"); require_once("../incfiles/head.php"); 

$error = false; 
$search = isset($_GET['text']) ? trim($_GET['text']) : ''; 

if ($search && (mb_strlen($search) < 3 || mb_strlen($search) > 20)){ 
  echo '<div>Разрешено минимум 3 и максимум 20 символов!</div>'; 
  $error = true; 
} 
echo '<form action="" method="get"><input type="text" name="text" value="'.$search.'" /><button>Поиск<button/></form>'; 
if ($search && !$error){ 
  $sql = strtr($search, array('_' => '\\_', '%' => '\\%', '*' => '%')); 
  $query = mysql_query("SELECT * FROM `players` WHERE `name` LIKE '".mysql_real_escape_string($sql)."' "); 
  if (mysql_num_rows($query)){ 
    while ($result = mysql_fetch_assoc($query)){ 
      echo '<div>'.$result['players'].'</div>'; 
    } 
  }else{ 
    echo '<div>Пусто</div>'; 
  } 
} 
require_once("../incfiles/end.php"); ?>