Подгрузка рекомендаций выполнена при помощи AJAX

Список рекомендаций реализован следующим образом:

<?

session_start();

if (!isset($_SESSION['user_id']))

{

header('Location: /soc/index.php?page='.$_SERVER["PHP_SELF"]);

}

include 'mysql.php';

$id = $_SESSION['user_id'];

$same_user = true;

$no_user = false;

include '../head.php';

include '../menu.php';

?>

<div id="rightCol">

<script type="text/javascript" src="jquery.js"></script>

<script>

<!--

var oldurl = '';

function see_details(url)

{

//alert(url)

if (oldurl == url)

{

$("#d").slideUp("fast");

oldurl = '';

return;

}

else $("#d").hide();

$.get("details.php", {'url': url}, function(data) {

//alert(data)

$("#d").html(data);

oldurl = url;

})

$("#d").animate({

left: 50, opacity: 'show'

}, 500);

}

//-->

</script>

<?

require_once('bm_fns.php');

try

{

$r = recommend_urls($id,1);

echo '<i>Рекомендовано:</i> '

?>

<table border="1" bordercolor="#abcabc" cellspacing="0" cellpadding="5">

<tr><th>URL</th><th>Количество рекомендаций</th></tr>

<?

$i = 0;

while ($m=mysql_fetch_array($r, MYSQL_NUM))

{

echo '<tr>';

echo "<td><a href=\"javascript:void(0)\" onClick=\"see_details('$m[0]')\">$m[0]</a></td><td>$m[1]</td>";

echo '</tr>';

}

}

catch (Exception $e)

{

echo $e->getMessage();

}

?>

</table>

<div id="d" style="border:1px #ccc dashed;display:none;"></div>

</div>

<div id="bottom"></div>

</div>

<?

include '../foot.php';

?>

20. Вывод данных по рекомендациям сделан так:

<?

session_start();

if (!isset($_SESSION['user_id']))

{

header('Location: /soc/index.php?page='.$_SERVER["PHP_SELF"]);

}

include_once('mysql.php');

header('Content-type: text/html; charset=utf-8');

$id = $_SESSION['user_id'];

$url = $_GET['url'];

$q = "SELECT substring_index(url, '/', 10), count(user_id), b.fio, b.id

FROM bookmark INNER JOIN user_details b ON b.id=bookmark.user_id

WHERE user_id!=$id

AND substring_index(url, '/', 3) = substring_index('$url', '/', 3)

AND url NOT IN (select url from bookmark where user_id=$id) group by substring_index(url, '/', 10)";

//echo $q;

$res = mysql_query($q);

echo '<table>';

while ($m = mysql_fetch_array($res))

{

echo '<tr>';

$s = 'рекомендаци';

if ($m[1] == 1) $s.='я';

else if ($m[1] > 1 && $m[1] < 10) $s.='и'; else $s.='й';

echo "<td><a href=\"$m[0]\">$m[0]</a></td><td>$m[1] $s</td><td>";

if (empty($m[2])) $m[2] = 'Пользователь '.$m[3];

if ($m[1] > 1) $s = '&nbsp;'; else $s = '<a href="/soc/profile.php?id='.$m[3].'">'.$m[2].'</a>';

echo $s.'</td>';

echo '</tr>';

}

echo '</table>';

?>