【php开源代码栏目提醒】:本文主要为网学会员提供Stockadmin.php,希望对需要Stockadmin.php网友有所帮助,学习一下!
<meta name="generator" content="Namo WebEditor(Trial)">
<?
if($_SESSION[Admin]<="2"){echo("<meta http-equiv=refresh content=\"0;URL=Login.php\"></meta>");}
else
{
$orders=$_GET[order];
$de=$_GET[de];
if(!$orders){$orders=1;}
$sql="select Stock.Stock_id,Movies_name_cht,Stock_number,Agents_Agent,Agents_name from Stock,Movies,Agents where Stock.Stock_id=Movies.Stock_id and Stock.Agents_id=Agents.Agents_id order by $orders $de";
$result=mysql_query($
sql,$link);
$nums=
mysql_num_rows($result);
?>
<TABLE width="100%" border="0">
<TR>
<TD><a href="admin.php?about=Stock&order=1<? if($de){echo("&de=");}else{echo("&de=desc");}?>"></a></TD>
<TD><a href="admin.php?about=Stock&order=2<? if($de){echo("&de=");}else{echo("&de=desc");}?>"></a></TD>
<TD><a href="admin.php?about=Stock&order=3<? if($de){echo("&de=");}else{echo("&de=desc");}?>"></a></TD>
<TD><a href="admin.php?about=Stock&order=4<? if($de){echo("&de=");}else{echo("&de=desc");}?>">ㄑ菜单</a></TD>
<TD></TD>
<TD></TD>
</TR>
<?
for($i=1;$i<=$nums;$i++)
{
$row=mysql_fetch_array($result);
?>
<TR>
<TD bgcolor="<?=color($i,"#FFFFFF","#B0D9FF")?>"><?=$row[Stock_id]?></TD>
<TD bgcolor="<?=color($i,"#FFFFFF","#B0D9FF")?>"><?=$row[Movies_name_cht]?></TD>
<TD bgcolor="<?=color($i,"#FFFFFF","#B0D9FF")?>"><?=number($row[Stock_number])?></TD>
<TD bgcolor="<?=color($i,"#FFFFFF","#B0D9FF")?>"><?=$row[Agents_Agent]?></TD>
<TD bgcolor="<?=color($i,"#FFFFFF","#B0D9FF")?>"><?=$row[Agents_name]?></TD>
<TD bgcolor="<?=color($i,"#FFFFFF","#B0D9FF")?>"><a href="admin.php?about=Stockedit&Stock_id=<?=$row[0]?>">э</a></TD>
</TR>
<?
}
?>
</TABLE>
<?}?>