PHP/MySQL | Ошибка в коде
Где-то ошибка[q]<?
include("../inc/connect.php");
$title = "Почта";
include("../inc/head.php");
if (empty($login) and empty($password)) {
header("Location:/index.php");
} else {
/*Функции*/
function hsc($text)
{
return htmlspecialchars($text);
}
function err_game($msg)
{
echo '<div id="cnt"><div id="hdr_m"><div align="center" >' . $msg . '</div></div></div>';
}
function cut_msg($text)
{
$text = substr($text, 0, 16);
return $text;
}
/*Функции*/
if(isset($_GET['read_all']))
{
$sql->query("UPDATE `user_mail` SET `read` = '1' WHERE `id_user` = '$arr[id]' AND `type` = 'to' AND `read` = '0'");
header("Location: /mail");
}
elseif(isset($_GET['del_all']))
{
if(isset($_GET['ok']))
{
$q=$sql->query("SELECT * FROM `user_mail` WHERE `id_user` = '$arr[id]'") or die(mysqli_error());
while($post=$sql->obj_assoc($q))
{
if($post['type']=='to' && $post['read']==1)$sql->query("DELETE FROM `user_mail` WHERE `id` = '$post[id]'");
elseif($post['type']=='at')$sql->query("DELETE FROM `user_mail` WHERE `id` = '$post[id]'");
}
header("Location: /mail");
}
echo "<div class='event'><h1>Подтверждение</h1></div><div class='content'><div class='block'><ul class='block'><li><span class='title'>Вы уверены?</span></li><li class='pt'><img alt='' width='16' height='16' src='images/icons/tick.png'> <a href='?mail&del_all&ok'><span> Да, подтверждаю</span></a></li><li><img alt='' width='16' height='16' src='images/icons/cross.png'> <a href='?mail&del_all'><span> Нет, отказываюсь</span></a></li></ul></div>";
}
elseif(isset($_GET['del']) && intval($_GET['del'])!=NULL && $sql->num("SELECT * FROM `user_mail` WHERE `id` = '".intval($_GET['del'])."' AND `id_user` = '$arr[id]' LIMIT 1")!=0)
{
$sql->query("DELETE FROM `user_mail` WHERE `id` = '".intval($_GET['del'])."'");
header("Location: /mail");
}
elseif(isset($_GET['msg']) && intval($_GET['msg'])!=NULL && $sql->num("SELECT * FROM `user_mail` WHERE `id` = '".intval($_GET['msg'])."' AND `id_user` = '$arr[id]' LIMIT 1")!=0)
{
$msg=$sql->ass("SELECT * FROM `user_mail` WHERE `id` = '".intval($_GET['msg'])."' AND `id_user` = '$arr[id]' LIMIT 1") or die(mysqli_error());
if($msg['type']=='to' && $msg['read']==0)
{
$sql->query("UPDATE `user_mail` SET `read` = '1' WHERE `id` = '$msg[id]'");
$sql->query("UPDATE `user_mail` SET `read` = '1' WHERE `id` = '".($msg['id']+1)."'");
header("Location:?&msg=$msg[id]");
}
$ank=$sql->ass("SELECT * FROM `users` WHERE `id` = '$msg[id_kont]'" or die(mysqli_error()));
$anku=$sql->ass("SELECT * FROM `users` WHERE `id` = '$ank[id]'") or die(mysqli_error());
echo "<div class='event'><h1>Просмотр сообщения</h1></div>";
echo '<div class="content"><div class="block">';
echo "<ul><li><span class='minor'>".($msg['type']=='to'?"От":"Кому").":</span> <span>";
if($msg['id_kont']!=0)echo $ank['id'];
echo " ".($msg['id_kont']==0?"Почтовый Сервис":"<a class='' href='?user=$ank[id]'>".$ank['id']."</a>")."</span></li><li><div class='title'><p>".$msg['msg']."</p></div></li><li class='small minor'><span>".usertime($msg['time'])."</span></li>".($msg['id_kont']==0?"":"<li class='pt'><img width='16' height='16' src='../style/images/icons/reply.png' alt='o'> <a href='?&new_msg=$ank[id]'>Ответить</a>")."<img width='16' height='16' src='../style/images/icons/delete.png' alt='o'> <a href='?&del=$msg[id]'>Удалить</a> <img width='16' height='16' src='../style/images/icons/delete.png' alt='o'> <a href='?&del_all'> Удалить все</a> <img width='16' height='16' src='../style/images/icons/mail_filter_all.png' alt='o'> <a href='?&history=$ank[id]'>Переписка</a></li></ul></div>";
}
elseif(isset($_GET['new_msg']))
{
if(isset($_GET['ok']) && isset($_POST['login']) && isset($_POST['msg']))
{
if($sql->num("SELECT * FROM `users` WHERE `login` = '".hsc($_POST['login'])."' " )!=0)
{
$anku=$sql->ass("SELECT * FROM `users` WHERE `login` = '".hsc($_POST['login'])."'") or die(mysqli_error());
$ank=$sql->ass("SELECT * FROM `users` WHERE `id_user` = '$anku[id]'") or die(mysqli_error());
}
if(!isset($ank))
{
$err=1;
echo "Фермер ненайден";
}
if($_POST['msg']==NULL)
{
$err=1;
echo "Сообщение слишком короткое";
}
if(!isset($err))
{
________
посл. ред. 27.05.2017 в 22:39; всего 1 раз(а); by wladua2016
include("../inc/connect.php");
$title = "Почта";
include("../inc/head.php");
if (empty($login) and empty($password)) {
header("Location:/index.php");
} else {
/*Функции*/
function hsc($text)
{
return htmlspecialchars($text);
}
function err_game($msg)
{
echo '<div id="cnt"><div id="hdr_m"><div align="center" >' . $msg . '</div></div></div>';
}
function cut_msg($text)
{
$text = substr($text, 0, 16);
return $text;
}
/*Функции*/
if(isset($_GET['read_all']))
{
$sql->query("UPDATE `user_mail` SET `read` = '1' WHERE `id_user` = '$arr[id]' AND `type` = 'to' AND `read` = '0'");
header("Location: /mail");
}
elseif(isset($_GET['del_all']))
{
if(isset($_GET['ok']))
{
$q=$sql->query("SELECT * FROM `user_mail` WHERE `id_user` = '$arr[id]'") or die(mysqli_error());
while($post=$sql->obj_assoc($q))
{
if($post['type']=='to' && $post['read']==1)$sql->query("DELETE FROM `user_mail` WHERE `id` = '$post[id]'");
elseif($post['type']=='at')$sql->query("DELETE FROM `user_mail` WHERE `id` = '$post[id]'");
}
header("Location: /mail");
}
echo "<div class='event'><h1>Подтверждение</h1></div><div class='content'><div class='block'><ul class='block'><li><span class='title'>Вы уверены?</span></li><li class='pt'><img alt='' width='16' height='16' src='images/icons/tick.png'> <a href='?mail&del_all&ok'><span> Да, подтверждаю</span></a></li><li><img alt='' width='16' height='16' src='images/icons/cross.png'> <a href='?mail&del_all'><span> Нет, отказываюсь</span></a></li></ul></div>";
}
elseif(isset($_GET['del']) && intval($_GET['del'])!=NULL && $sql->num("SELECT * FROM `user_mail` WHERE `id` = '".intval($_GET['del'])."' AND `id_user` = '$arr[id]' LIMIT 1")!=0)
{
$sql->query("DELETE FROM `user_mail` WHERE `id` = '".intval($_GET['del'])."'");
header("Location: /mail");
}
elseif(isset($_GET['msg']) && intval($_GET['msg'])!=NULL && $sql->num("SELECT * FROM `user_mail` WHERE `id` = '".intval($_GET['msg'])."' AND `id_user` = '$arr[id]' LIMIT 1")!=0)
{
$msg=$sql->ass("SELECT * FROM `user_mail` WHERE `id` = '".intval($_GET['msg'])."' AND `id_user` = '$arr[id]' LIMIT 1") or die(mysqli_error());
if($msg['type']=='to' && $msg['read']==0)
{
$sql->query("UPDATE `user_mail` SET `read` = '1' WHERE `id` = '$msg[id]'");
$sql->query("UPDATE `user_mail` SET `read` = '1' WHERE `id` = '".($msg['id']+1)."'");
header("Location:?&msg=$msg[id]");
}
$ank=$sql->ass("SELECT * FROM `users` WHERE `id` = '$msg[id_kont]'" or die(mysqli_error()));
$anku=$sql->ass("SELECT * FROM `users` WHERE `id` = '$ank[id]'") or die(mysqli_error());
echo "<div class='event'><h1>Просмотр сообщения</h1></div>";
echo '<div class="content"><div class="block">';
echo "<ul><li><span class='minor'>".($msg['type']=='to'?"От":"Кому").":</span> <span>";
if($msg['id_kont']!=0)echo $ank['id'];
echo " ".($msg['id_kont']==0?"Почтовый Сервис":"<a class='' href='?user=$ank[id]'>".$ank['id']."</a>")."</span></li><li><div class='title'><p>".$msg['msg']."</p></div></li><li class='small minor'><span>".usertime($msg['time'])."</span></li>".($msg['id_kont']==0?"":"<li class='pt'><img width='16' height='16' src='../style/images/icons/reply.png' alt='o'> <a href='?&new_msg=$ank[id]'>Ответить</a>")."<img width='16' height='16' src='../style/images/icons/delete.png' alt='o'> <a href='?&del=$msg[id]'>Удалить</a> <img width='16' height='16' src='../style/images/icons/delete.png' alt='o'> <a href='?&del_all'> Удалить все</a> <img width='16' height='16' src='../style/images/icons/mail_filter_all.png' alt='o'> <a href='?&history=$ank[id]'>Переписка</a></li></ul></div>";
}
elseif(isset($_GET['new_msg']))
{
if(isset($_GET['ok']) && isset($_POST['login']) && isset($_POST['msg']))
{
if($sql->num("SELECT * FROM `users` WHERE `login` = '".hsc($_POST['login'])."' " )!=0)
{
$anku=$sql->ass("SELECT * FROM `users` WHERE `login` = '".hsc($_POST['login'])."'") or die(mysqli_error());
$ank=$sql->ass("SELECT * FROM `users` WHERE `id_user` = '$anku[id]'") or die(mysqli_error());
}
if(!isset($ank))
{
$err=1;
echo "Фермер ненайден";
}
if($_POST['msg']==NULL)
{
$err=1;
echo "Сообщение слишком короткое";
}
if(!isset($err))
{
________
посл. ред. 27.05.2017 в 22:39; всего 1 раз(а); by wladua2016
При отправки пишет Fatal error: Call to a member function fetch_assoc() on null in D:\OpenServer\domains\402m\inc\class.php on line 63
wladua2016 (27.05.2017 в 22:40)
При отправки пишет Fatal error: Call to a member function fetch_assoc() on null in D:OpenServerdomains402mincclass.php on line 63
При отправки пишет Fatal error: Call to a member function fetch_assoc() on null in D:OpenServerdomains402mincclass.php on line 63
что не ясно?? если туго с Англ. то переводчик есть!!
IndiS, проблема только при отправке в данном коде
IndiS, я не пойму где в коде ошибка
IndiS, там в классе все нормально. Проблема где ю-то в этом коде
Стр.: 1, 2