Похожие публикации

function sqlwildcardesc($x) {

        global $mysqli;

return str_replace(array("%","_"), array("\\%","\\_"), $mysqli->real_escape_string($x));

}

 

preg_match_all('/([а-яА-Я]+)/siu', $row['name'], $rus);

preg_match_all('/([a-zA-Z]+)/si', $row['name'], $eng);

 

$rus = sqlwildcardesc(trim(implode(" ", $rus[0])));

$eng = sqlwildcardesc(trim(implode(" ", $eng[0])));

 

if (!empty($rus) && !empty($eng))

        $query = "(l.name LIKE '%$rus%' OR l.name LIKE '%$eng%')";

elseif (!empty($rus) && empty($eng))

        $query = "l.name LIKE '%$rus%'";

else

        $query = "l.name LIKE '%$eng%'";

 

$similar = $mysqli->query("SELECT l.id, l.textid, l.name, l.categoryid, c.cat_name FROM lists as l LEFT JOIN categories AS c ON l.categoryid = c.id WHERE $query AND l.id <> " . $id . " LIMIT 10") or sqlerr(__FILE__, __LINE__, $mysqli->error);

        if ($similar->num_rows > 0) {

        ?>

       

<h2>Читайте также</h2>

 

                while ($row = $similar->fetch_array())

        {

                $text_my_view = $mysqli->query("SELECT text FROM texts WHERE id = " . $row['textid']) or sqlerr(__FILE__, __LINE__, $mysqli->error);

                $row_twoxxx = $text_my_view->fetch_array();

                echo "<li>- <a target=\"_blank\" href=\"/" . mb_strtolower($row['cat_name']) . "/view/" . $row['textid'] . "_" . title_name($row['name']) . "\">" . $row['name'] . "</a> <p>" . short(strip_tags($row_twoxxx['text']), 500) . " <a target=\"_blank\" href=\"/" . mb_strtolower($row['cat_name']) . "/view/" . $row['textid'] . "_" . title_name($row['name']) . "\">[читать подробенее]</a></p></li> <br />";

        }

       }