Форумы портала PHP.SU :: Версия для печати

1. DarkRevenger - 21 Июня, 2011 - 15:28:14 - перейти к сообщению

Почему при выводе результата запроса колличество строк на 1 меньше чем должно быть? Куда пропадает первая строка?Index.php

Спойлер (Отобразить)

PHP:
скопировать код в буфер обмена

<?PHP  session_start();
require_once $_SERVER['DOCUMENT_ROOT']."/db/config.php";
require_once $_SERVER['DOCUMENT_ROOT']."/constants.php";
require_once $_SERVER['DOCUMENT_ROOT']."/functions.php";
session_start();
if (!session_is_registered("id")) header("location:index.php");?>
<?PHP 
include_once $_SERVER['DOCUMENT_ROOT']."/db/config.php" ;
        dbConnect();?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>My Calls</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="/js/jquery.min.js" type="text/javascript"></script>
        <link rel="stylesheet" type="text/css" href="/jquery.Checkbox/jquery.Checkbox.css" />
                <script type="text/javascript" src="/js/jquery.min.js"></script> <!---->
        <script type="text/javascript" src="/js/jquery-ui.min.js"></script> <!---->
                <script src="/jquery.Checkbox/jquery.Checkbox.js"></script> <!---->
                <script src="/js/script.js"></script>
<script type="text/javascript">
function f_show(recipient, elem) {
var div = $("#div" + recipient);
var link = $(elem);
if (div.is(":hidden")) {
if (div.text() == "") {
div.load("ajax.php", { "recipient": recipient }, 
function(responseText, textStatus) {
if (textStatus == 'error') {
div.html("Ошибка при загрузке");
}
div.slideDown(300);
link.html("Скрыть");
});
}
else {
div.slideDown(300);
link.html("Скрыть");
}
}
else {
div.slideUp(300);
link.html("Показать");
}
}
</script>
 
</head>
 
<body>
<?PHP 
if(isset($_SESSION['id']))
{
    $id =$_SESSION['id'];
}
else { echo "<p class='block' style='color:red'>You have come to a page without an argument!<a href='index.php'>Home</a></p>";}
if (!preg_match("|^[\d]+$|", $id)) {echo "<p class='block' style='color:red'>Invalid request format! Check URL <a href='index.php'>Home</a></p>";}
$phone_number = $_SESSION['phone_number'];
$limit=$_SESSION['position_balance'];
if (empty($_SESSION['login'])) { echo "<p class='block' style='color:red'>User does not exist! Perhaps it was deleted.<a href='index.php'>Home</a></p>";} //если такого не существует
echo "<h3>Personal user page: ".$_SESSION['lastname']."&nbsp;".$_SESSION['firstname']."</h3>";
 $query="SELECT distinct recipient FROM Calls WHERE phone_number=$phone_number  AND Calls.date_of_call 
BETWEEN DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 1 MONTH), INTERVAL DAY(CURDATE())-1 DAY) 
AND DATE_SUB(CURDATE(), INTERVAL DAY(CURDATE()) DAY) and Calls.Cost<>0 order by recipient";
 $result=mysql_query($query);
 $myrow=mysql_fetch_array($result);
 echo "<center>";
 if($result) {
while ($myrow = mysql_fetch_array($result)) {
echo "<a href='#' onclick='f_show(".$myrow[0].", this); return false;'>Показать ".$myrow[0]."</a><br>";
echo '<div id="div'.$myrow[0].'" style="display:none;">';
echo "</div>\n";
}
}
?></center>
</body>
</html>

ajax.php

Спойлер (Отобразить)

PHP:
скопировать код в буфер обмена

<?PHP  session_start();
require_once $_SERVER['DOCUMENT_ROOT']."/db/config.php";
require_once $_SERVER['DOCUMENT_ROOT']."/constants.php";
require_once $_SERVER['DOCUMENT_ROOT']."/functions.php";
session_start();
if (!session_is_registered("id")) header("location:index.php");?>
<?PHP 
include_once $_SERVER['DOCUMENT_ROOT']."/db/config.php" ;
        dbConnect();?>
<?PHP 
header('Content-Type: text/html; charset=utf-8');
if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) {
exit('Данные отправлены не через AJAX');
}
if (isset($_POST['recipient'])) $recipient =$_POST['recipient'];
else $recipient = 0;
if ($recipient === 0) exit('Параметр содержит ошибку');
$db = mysql_connect('localhost', 'root', '') 
or die('Не удалось установить подключение');
mysql_select_db('Calls') or die('Такой базы данных нет');
$phone_number=$_SESSION['phone_number'];
$query = "SELECT * FROM Calls WHERE phone_number=$phone_number  AND Calls.date_of_call 
BETWEEN DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 1 MONTH), INTERVAL DAY(CURDATE())-1 DAY) 
AND DATE_SUB(CURDATE(), INTERVAL DAY(CURDATE()) DAY) and Calls.Cost<>0 and recipient=".$recipient;
$result=mysql_query($query);
$myrow=mysql_fetch_array($result);
if($result)
 {$o=array($tcalls);
while($myrow = mysql_fetch_array($result)){
                         if($myrow['personal']==1)
{$o[]="<td class='check'><input type=checkbox name=\"call_select[]\" checked data-on=\"Personal\" data-off=\"Business\" value=\"$value\" ></td>";}
             else
{$o[]="<td class='check'><input type=checkbox name=\"call_select[]\" data-on=\"Personal\" data-off=\"Business\"  value=\"$value\" ></td>";}
             $o[]="<td>{$myrow['cost']}</td>";
             $o[]="<td>{$myrow['recipient']}</td>";
             $o[]="<td>{$myrow['date_of_call']}</td>";
             $o[]="<td>{$myrow['time_of_call']}</td>";
             $o[]="<td>{$myrow['duration']}</td>";
             $o[]="<td>{$myrow['connection_type']}</td>";
             $o[]="<td>{$myrow['volume']}</td>";
             $o[]="<td>{$myrow['rouming']}</td>";
             $o[]="</thead></tr>";
}$o[]="</tbody></table>";
       $o[]="</form><br>";
           echo implode('',$o);
}
?>
        <html>
        <head>
        <link rel="stylesheet" type="text/css" href="/jquery.Checkbox/jquery.Checkbox.css" />
                <script type="text/javascript" src="/js/jquery.min.js"></script> <!---->
        <script type="text/javascript" src="/js/jquery-ui.min.js"></script> <!---->
                <script src="/jquery.Checkbox/jquery.Checkbox.js"></script> <!---->
                <script src="/js/script.js"></script></head>
        <body>
<body>
</html>