10/10/2018, 10:42
Các bác vào sửa giúp em lỗi này với.
Em dính lỗi này mong các bác sửa giúp em, em gà không biết gì về code cả mong các bác thông cảm.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vol3/webhostprovn.0lx.net/0lx_6211186/htdocs/cumchucnang/xuat_sanpham/xuat_sanpham.php on line 252
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vol3/webhostprovn.0lx.net/0lx_6211186/htdocs/cumchucnang/xuat_sanpham/xuat_sanpham.php on line 322
Code trang có lỗi đây ạ:
<?php
class class__xuat_sanpham
{
function title()
{
$sql="select * from menu where id in ('$_GET[id_menu]')";
$q_sql=mysql_query($sql);
$r_sql=mysql_fetch_array($q_sql);
return $r_sql['ten'];
}
function titlemoi()
{
$sql="select * from menumoi where id in ('$_GET[id_menumoi]')";
$q_sql=mysql_query($sql);
$r_sql=mysql_fetch_array($q_sql);
return $r_sql['ten'];
}
}
$class__xuat_sanpham=new class__xuat_sanpham;
class phantrang_xuatlink
{
function trang_truoc()
{
if($_GET['trang']=="" or $_GET['trang']==1){$a=1;}else{$a=($_GET['trang']-1);}
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=$a">";
echo "Previous page ";
echo "</a>";
}
function trang_sau($st)
{
if($_GET['trang']==$st){$a=$st;}else{$a=($_GET['trang']+1);}
if($_GET['trang']=="" or $_GET['trang']==1){$a=2;}
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=$a">";
echo " Next page ";
echo "</a>";
}
function cham_cham_duoi($gioi_han_tren,$st)
{
if($gioi_han_tren<$st)
{
$a=$st-1;
if($a!=$gioi_han_tren)
{
echo " ... ";
}
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=$st">";
echo "$st ";
echo "</a>";
}
}
function cham_cham_duoimoi($gioi_han_tren,$st)
{
if($gioi_han_tren<$st)
{
$a=$st-1;
if($a!=$gioi_han_tren)
{
echo " ... ";
}
echo "<a href="?thamso=xuat_sanpham&id_menumoi=$_GET[id_menumoi]&trang=$st">";
echo "$st ";
echo "</a>";
}
}
function cham_cham_tren($gioi_han_duoi)
{
if($gioi_han_duoi>2)
{
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=1">";
echo "1 ";
echo "</a>";
echo " ... ";
}
if($gioi_han_duoi==2)
{
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=1">";
echo "1 ";
echo "</a>";
}
}
function cham_cham_trenmoi($gioi_han_duoi)
{
if($gioi_han_duoi>2)
{
echo "<a href="?thamso=xuat_sanpham&id_menumoi=$_GET[id_menumoi]&trang=1">";
echo "1 ";
echo "</a>";
echo " ... ";
}
if($gioi_han_duoi==2)
{
echo "<a href="?thamso=xuat_sanpham&id_menumoi=$_GET[id_menumoi]&trang=1">";
echo "1 ";
echo "</a>";
}
}
function gioi_han_tren($trang_hien_tai)
{
$gioi_han_tren=$trang_hien_tai+4;
if($gioi_han_tren>=5 and $gioi_han_tren<9)
{
$gioi_han_tren=9;
}
return $gioi_han_tren;
}
function gioi_han_duoi($trang_hien_tai,$st)
{
$cao_nhat=$st-8;
$gioi_han_duoi=$trang_hien_tai-4;
if($gioi_han_duoi>$cao_nhat)
{
$gioi_han_duoi=$cao_nhat;
}
return $gioi_han_duoi;
}
function xuat_link($st)
{
if($_GET['trang']==""){$trang_hien_tai=1;}else{$trang_hien_tai=$_GE T['trang'];}
$gioi_han_tren=$this->gioi_han_tren($trang_hien_tai);
$gioi_han_duoi=$this->gioi_han_duoi($trang_hien_tai,$st);
$this->trang_truoc();
$this->cham_cham_tren($gioi_han_duoi);
for($i=$gioi_han_duoi;$i<=$gioi_han_tren;$i++)
{
$link_phan_trang="?thamso=xuat_sanpham&id_menu=$_G ET[id_menu]&trang=$i";
if($i>0 and $i<=$st)
{
if($i!=$trang_hien_tai)
{
echo "<a href="$link_phan_trang">";
echo "$i ";
echo "</a>";
}
else
{
echo "<span style="color:red">| $i | </span>";
}
}
}
$this->cham_cham_duoi($gioi_han_tren,$st);
$this->trang_sau($st);
}
function xuat_linkmoi($st)
{
if($_GET['trang']==""){$trang_hien_tai=1;}else{$trang_hien_tai=$_GE T['trang'];}
$gioi_han_tren=$this->gioi_han_tren($trang_hien_tai);
$gioi_han_duoi=$this->gioi_han_duoi($trang_hien_tai,$st);
$this->trang_truoc();
$this->cham_cham_tren($gioi_han_duoi);
for($i=$gioi_han_duoi;$i<=$gioi_han_tren;$i++)
{
$link_phan_trang="?thamso=xuat_sanpham&id_menumoi= $_GET[id_menumoi]&trang=$i";
if($i>0 and $i<=$st)
{
if($i!=$trang_hien_tai)
{
echo "<a href="$link_phan_trang">";
echo "$i ";
echo "</a>";
}
else
{
echo "<span style="color:red">| $i | </span>";
}
}
}
$this->cham_cham_duoi($gioi_han_tren,$st);
$this->trang_sau($st);
}
}
?>
<?php
$sd=5;
$so_du_lieu_tren_1_dong=3;
$so_gioi_han=$sd*$so_du_lieu_tren_1_dong;
if($_GET['trang']=="")
{
$vtbd=0;
}
else
{
$vtbd=($_GET['trang']-1)*$so_gioi_han;
}
$sql="select * from dulieu where thuoc_menu in ('$_GET[id_menu]') order by id desc limit $vtbd,$so_gioi_han";
$q_sql=mysql_query($sql);
?>
<?php
$sd=5;
$so_du_lieu_tren_1_dong=3;
$so_gioi_han=$sd*$so_du_lieu_tren_1_dong;
if($_GET['trang']=="")
{
$vtbd=0;
}
else
{
$vtbd=($_GET['trang']-1)*$so_gioi_han;
}
$sql="select * from dulieumoi where thuoc_menumoi in ('$_GET[id_menumoi]') order by id desc limit $vtbd,$so_gioi_han";
$q_sql=mysql_query($sql);
?>
<?php
$title=$class__xuat_sanpham->title();
?>
<?php
$title=$class__xuat_sanpham->titlemoi();
?>
<?php
$tv_ppp="select * from menu_ngang order by id";
$tv_ppp_1=mysql_query($tv_ppp);
while($tv_ppp_2=mysql_fetch_array($tv_ppp_1))
{
$loai_menu_ppp=$tv_ppp_2['loai'];
if($loai_menu_ppp=="toanbo_sanpham")
{
$id_ppp=$tv_ppp_2['id'];
break;
}
}
?>
<div style="padding-left:8px; padding-right:8px; padding-bottom:8px;">
<div class="menu_tab_detail" style="margin-left:6px;">
<div class="one_tab_detail">
<div class="one_tab_detail_left"></div>
<div class="one_tab_detail_text">
<a href="?thamso=toanbo_sanpham&id=<?php echo $id_ppp; ?>">Vietnam</a> »
<a href="?thamso=xuat_sanpham&id_menu=<?php echo $_GET['id_menu']; ?>"><?php echo $title; ?></a>
<a href="?thamso=xuat_sanpham&id_menumoi=<?php echo $_GET['id_menumoi']; ?>"><?php echo $title; ?></a>
</div>
<div class="one_tab_detail_right"></div>
</div>
</div>
<div style="clear:both"></div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="hinhanh_flash/dungchung/k_t_l.jpg" /></td>
<td height="6" background="hinhanh_flash/dungchung/k_bg_t.jpg"></td>
<td><img src="hinhanh_flash/dungchung/k_t_r.jpg" /></td>
</tr>
<tr>
<td width="6" background="hinhanh_flash/dungchung/k_bg_l.jpg"></td>
<td bgcolor="#FFFFFF">
<?php
while($r_sql=mysql_fetch_array($q_sql))
{
for($i=1;$i<=$so_du_lieu_tren_1_dong;$i++)
{
if($i!=1)
{
$r_sql=mysql_fetch_array($q_sql);
}
$id_sp=$r_sql['id'];
$link_chi_tiet="?thamso=chitiet_sanpham&id_chitiet =$r_sql[id]";
if($r_sql['tieu_de']!="")
{
//echo $r_sql['loai_gia'];
if($r_sql['loai_gia']!="lien_he")
{
$gia=$r_sql['gia'];
$gia_1=number_format($gia,0,",",".");
$don_vi_tien="VNĐ";
}
else
{
$gia="Please contact";
$gia_1=$gia;
$don_vi_tien="";
}
if($r_sql[hinh_anh]!="")
{
$link_hinh="hinhanh_flash/sanpham/$r_sql[hinh_anh]";
}
else
{
$link_hinh="hinhanh_flash/dungchung/kep_toc.gif";
}
?>
<div id="sp">
<div class="sp_boder">
<a href="<?php echo $link_chi_tiet ?>">
<img src="<?php echo $link_hinh?>" width="100px" height="100px"/>
</a>
</div>
<?php echo $r_sql['tieu_de']?><br />
<span class="gia_sp">
<?php echo "$gia_1 $don_vi_tien "; ?></span>
<div style="float:left; padding:3px;">
<a href="<?php echo $link_chi_tiet ?>">
<img src="hinhanh_flash/dungchung/chi-tiet.jpg" />
</a>
</div>
<div style="float:right; padding:3px;">
<a href="?thamso=giohang_xuly_session&id=<?php echo $id_sp?>">
<img src="hinhanh_flash/dungchung/mua-hang.jpg" />
</a>
</div>
</div>
<?php
}
}
}
?>
<?php
$c_sql="select count(*) from dulieu where thuoc_menu in ('$_GET[id_menu]')";
$q_c_sql=mysql_query($c_sql);
$r_c_sql=mysql_fetch_row($q_c_sql);
$st=ceil($r_c_sql[0]/$so_gioi_han);
?>
<?php
$c_sql="select count(*) from dulieumoi where thuoc_menumoi in ('$_GET[id_menu]')";
$q_c_sql=mysql_query($c_sql);
$r_c_sql=mysql_fetch_row($q_c_sql);
$st=ceil($r_c_sql[0]/$so_gioi_han);
?>
<div class="pages">
<div class="pages_text">
<?php
if($r_c_sql[0]!=0)
{
?>
<b> Total </b> <?php echo $r_c_sql[0] ?>.
<?php
$xuat_link=new phantrang_xuatlink();
$xuat_link->xuat_link($st);
?>
<?php
}
else
{
echo "<div style="width:100%;text-align:left">";
echo "Updating";
echo "</div>";
}
?>
<!--Next page--></a>
</td>
<td width="6" background="hinhanh_flash/dungchung/k_bg_r.jpg"></td>
</tr>
<tr>
<td><img src="hinhanh_flash/dungchung/k_b_l.jpg" /></td>
<td height="6" background="hinhanh_flash/dungchung/k_bg_b.jpg"></td>
<td><img src="hinhanh_flash/dungchung/k_b_r.jpg" /></td>
</tr>
</table>
</div> </td>
</td>
cám ơn các bác nhiều
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vol3/webhostprovn.0lx.net/0lx_6211186/htdocs/cumchucnang/xuat_sanpham/xuat_sanpham.php on line 252
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vol3/webhostprovn.0lx.net/0lx_6211186/htdocs/cumchucnang/xuat_sanpham/xuat_sanpham.php on line 322
Code trang có lỗi đây ạ:
<?php
class class__xuat_sanpham
{
function title()
{
$sql="select * from menu where id in ('$_GET[id_menu]')";
$q_sql=mysql_query($sql);
$r_sql=mysql_fetch_array($q_sql);
return $r_sql['ten'];
}
function titlemoi()
{
$sql="select * from menumoi where id in ('$_GET[id_menumoi]')";
$q_sql=mysql_query($sql);
$r_sql=mysql_fetch_array($q_sql);
return $r_sql['ten'];
}
}
$class__xuat_sanpham=new class__xuat_sanpham;
class phantrang_xuatlink
{
function trang_truoc()
{
if($_GET['trang']=="" or $_GET['trang']==1){$a=1;}else{$a=($_GET['trang']-1);}
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=$a">";
echo "Previous page ";
echo "</a>";
}
function trang_sau($st)
{
if($_GET['trang']==$st){$a=$st;}else{$a=($_GET['trang']+1);}
if($_GET['trang']=="" or $_GET['trang']==1){$a=2;}
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=$a">";
echo " Next page ";
echo "</a>";
}
function cham_cham_duoi($gioi_han_tren,$st)
{
if($gioi_han_tren<$st)
{
$a=$st-1;
if($a!=$gioi_han_tren)
{
echo " ... ";
}
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=$st">";
echo "$st ";
echo "</a>";
}
}
function cham_cham_duoimoi($gioi_han_tren,$st)
{
if($gioi_han_tren<$st)
{
$a=$st-1;
if($a!=$gioi_han_tren)
{
echo " ... ";
}
echo "<a href="?thamso=xuat_sanpham&id_menumoi=$_GET[id_menumoi]&trang=$st">";
echo "$st ";
echo "</a>";
}
}
function cham_cham_tren($gioi_han_duoi)
{
if($gioi_han_duoi>2)
{
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=1">";
echo "1 ";
echo "</a>";
echo " ... ";
}
if($gioi_han_duoi==2)
{
echo "<a href="?thamso=xuat_sanpham&id_menu=$_GET[id_menu]&trang=1">";
echo "1 ";
echo "</a>";
}
}
function cham_cham_trenmoi($gioi_han_duoi)
{
if($gioi_han_duoi>2)
{
echo "<a href="?thamso=xuat_sanpham&id_menumoi=$_GET[id_menumoi]&trang=1">";
echo "1 ";
echo "</a>";
echo " ... ";
}
if($gioi_han_duoi==2)
{
echo "<a href="?thamso=xuat_sanpham&id_menumoi=$_GET[id_menumoi]&trang=1">";
echo "1 ";
echo "</a>";
}
}
function gioi_han_tren($trang_hien_tai)
{
$gioi_han_tren=$trang_hien_tai+4;
if($gioi_han_tren>=5 and $gioi_han_tren<9)
{
$gioi_han_tren=9;
}
return $gioi_han_tren;
}
function gioi_han_duoi($trang_hien_tai,$st)
{
$cao_nhat=$st-8;
$gioi_han_duoi=$trang_hien_tai-4;
if($gioi_han_duoi>$cao_nhat)
{
$gioi_han_duoi=$cao_nhat;
}
return $gioi_han_duoi;
}
function xuat_link($st)
{
if($_GET['trang']==""){$trang_hien_tai=1;}else{$trang_hien_tai=$_GE T['trang'];}
$gioi_han_tren=$this->gioi_han_tren($trang_hien_tai);
$gioi_han_duoi=$this->gioi_han_duoi($trang_hien_tai,$st);
$this->trang_truoc();
$this->cham_cham_tren($gioi_han_duoi);
for($i=$gioi_han_duoi;$i<=$gioi_han_tren;$i++)
{
$link_phan_trang="?thamso=xuat_sanpham&id_menu=$_G ET[id_menu]&trang=$i";
if($i>0 and $i<=$st)
{
if($i!=$trang_hien_tai)
{
echo "<a href="$link_phan_trang">";
echo "$i ";
echo "</a>";
}
else
{
echo "<span style="color:red">| $i | </span>";
}
}
}
$this->cham_cham_duoi($gioi_han_tren,$st);
$this->trang_sau($st);
}
function xuat_linkmoi($st)
{
if($_GET['trang']==""){$trang_hien_tai=1;}else{$trang_hien_tai=$_GE T['trang'];}
$gioi_han_tren=$this->gioi_han_tren($trang_hien_tai);
$gioi_han_duoi=$this->gioi_han_duoi($trang_hien_tai,$st);
$this->trang_truoc();
$this->cham_cham_tren($gioi_han_duoi);
for($i=$gioi_han_duoi;$i<=$gioi_han_tren;$i++)
{
$link_phan_trang="?thamso=xuat_sanpham&id_menumoi= $_GET[id_menumoi]&trang=$i";
if($i>0 and $i<=$st)
{
if($i!=$trang_hien_tai)
{
echo "<a href="$link_phan_trang">";
echo "$i ";
echo "</a>";
}
else
{
echo "<span style="color:red">| $i | </span>";
}
}
}
$this->cham_cham_duoi($gioi_han_tren,$st);
$this->trang_sau($st);
}
}
?>
<?php
$sd=5;
$so_du_lieu_tren_1_dong=3;
$so_gioi_han=$sd*$so_du_lieu_tren_1_dong;
if($_GET['trang']=="")
{
$vtbd=0;
}
else
{
$vtbd=($_GET['trang']-1)*$so_gioi_han;
}
$sql="select * from dulieu where thuoc_menu in ('$_GET[id_menu]') order by id desc limit $vtbd,$so_gioi_han";
$q_sql=mysql_query($sql);
?>
<?php
$sd=5;
$so_du_lieu_tren_1_dong=3;
$so_gioi_han=$sd*$so_du_lieu_tren_1_dong;
if($_GET['trang']=="")
{
$vtbd=0;
}
else
{
$vtbd=($_GET['trang']-1)*$so_gioi_han;
}
$sql="select * from dulieumoi where thuoc_menumoi in ('$_GET[id_menumoi]') order by id desc limit $vtbd,$so_gioi_han";
$q_sql=mysql_query($sql);
?>
<?php
$title=$class__xuat_sanpham->title();
?>
<?php
$title=$class__xuat_sanpham->titlemoi();
?>
<?php
$tv_ppp="select * from menu_ngang order by id";
$tv_ppp_1=mysql_query($tv_ppp);
while($tv_ppp_2=mysql_fetch_array($tv_ppp_1))
{
$loai_menu_ppp=$tv_ppp_2['loai'];
if($loai_menu_ppp=="toanbo_sanpham")
{
$id_ppp=$tv_ppp_2['id'];
break;
}
}
?>
<div style="padding-left:8px; padding-right:8px; padding-bottom:8px;">
<div class="menu_tab_detail" style="margin-left:6px;">
<div class="one_tab_detail">
<div class="one_tab_detail_left"></div>
<div class="one_tab_detail_text">
<a href="?thamso=toanbo_sanpham&id=<?php echo $id_ppp; ?>">Vietnam</a> »
<a href="?thamso=xuat_sanpham&id_menu=<?php echo $_GET['id_menu']; ?>"><?php echo $title; ?></a>
<a href="?thamso=xuat_sanpham&id_menumoi=<?php echo $_GET['id_menumoi']; ?>"><?php echo $title; ?></a>
</div>
<div class="one_tab_detail_right"></div>
</div>
</div>
<div style="clear:both"></div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="hinhanh_flash/dungchung/k_t_l.jpg" /></td>
<td height="6" background="hinhanh_flash/dungchung/k_bg_t.jpg"></td>
<td><img src="hinhanh_flash/dungchung/k_t_r.jpg" /></td>
</tr>
<tr>
<td width="6" background="hinhanh_flash/dungchung/k_bg_l.jpg"></td>
<td bgcolor="#FFFFFF">
<?php
while($r_sql=mysql_fetch_array($q_sql))
{
for($i=1;$i<=$so_du_lieu_tren_1_dong;$i++)
{
if($i!=1)
{
$r_sql=mysql_fetch_array($q_sql);
}
$id_sp=$r_sql['id'];
$link_chi_tiet="?thamso=chitiet_sanpham&id_chitiet =$r_sql[id]";
if($r_sql['tieu_de']!="")
{
//echo $r_sql['loai_gia'];
if($r_sql['loai_gia']!="lien_he")
{
$gia=$r_sql['gia'];
$gia_1=number_format($gia,0,",",".");
$don_vi_tien="VNĐ";
}
else
{
$gia="Please contact";
$gia_1=$gia;
$don_vi_tien="";
}
if($r_sql[hinh_anh]!="")
{
$link_hinh="hinhanh_flash/sanpham/$r_sql[hinh_anh]";
}
else
{
$link_hinh="hinhanh_flash/dungchung/kep_toc.gif";
}
?>
<div id="sp">
<div class="sp_boder">
<a href="<?php echo $link_chi_tiet ?>">
<img src="<?php echo $link_hinh?>" width="100px" height="100px"/>
</a>
</div>
<?php echo $r_sql['tieu_de']?><br />
<span class="gia_sp">
<?php echo "$gia_1 $don_vi_tien "; ?></span>
<div style="float:left; padding:3px;">
<a href="<?php echo $link_chi_tiet ?>">
<img src="hinhanh_flash/dungchung/chi-tiet.jpg" />
</a>
</div>
<div style="float:right; padding:3px;">
<a href="?thamso=giohang_xuly_session&id=<?php echo $id_sp?>">
<img src="hinhanh_flash/dungchung/mua-hang.jpg" />
</a>
</div>
</div>
<?php
}
}
}
?>
<?php
$c_sql="select count(*) from dulieu where thuoc_menu in ('$_GET[id_menu]')";
$q_c_sql=mysql_query($c_sql);
$r_c_sql=mysql_fetch_row($q_c_sql);
$st=ceil($r_c_sql[0]/$so_gioi_han);
?>
<?php
$c_sql="select count(*) from dulieumoi where thuoc_menumoi in ('$_GET[id_menu]')";
$q_c_sql=mysql_query($c_sql);
$r_c_sql=mysql_fetch_row($q_c_sql);
$st=ceil($r_c_sql[0]/$so_gioi_han);
?>
<div class="pages">
<div class="pages_text">
<?php
if($r_c_sql[0]!=0)
{
?>
<b> Total </b> <?php echo $r_c_sql[0] ?>.
<?php
$xuat_link=new phantrang_xuatlink();
$xuat_link->xuat_link($st);
?>
<?php
}
else
{
echo "<div style="width:100%;text-align:left">";
echo "Updating";
echo "</div>";
}
?>
<!--Next page--></a>
</td>
<td width="6" background="hinhanh_flash/dungchung/k_bg_r.jpg"></td>
</tr>
<tr>
<td><img src="hinhanh_flash/dungchung/k_b_l.jpg" /></td>
<td height="6" background="hinhanh_flash/dungchung/k_bg_b.jpg"></td>
<td><img src="hinhanh_flash/dungchung/k_b_r.jpg" /></td>
</tr>
</table>
</div> </td>
</td>
cám ơn các bác nhiều
Bài liên quan
var_dump biến trả về của câu query ($q_sql) trước câu lệnh bị lỗi để xem kiểu dữ liệu trả về là gì? từ đó mới sửa đc.