showtextstar.php

LOVESTUdio多校园交易系统 VER 4.0基于3.0开发

<?php 
$sql = "SELECT * FROM ".$tablepre."shop WHERE shopmode='0' ORDER BY shopstar DESC LIMIT 0,5";
$result = $conn->query($sql);
                ?>
				<table width='180' cellpadding='0' cellspacing='0'>
                       <tr>
                       <td width='180'><div id="icetext">
                       <table width='180'  border='0' cellpadding='0' cellspacing='0'>
                      <?php
					 while($arr = $result->fetch_assoc()){  
				$res = $conn->query("SELECT * FROM ".$tablepre."school WHERE schoolid=".$arr[shopschool]);
                $sch = $res->fetch_assoc();
				$ress = $conn->query("SELECT goodsid FROM ".$tablepre."goods WHERE goodsowershop=".$arr[shopid]);
                $num = 0;
				while($aer = $ress->fetch_assoc()){
				$num++;
				}
				
				 echo  "<tr>
                       <td height='100'>
					   <table width='100%' cellpadding='0' cellspacing='0'>
					   <tr>
				<td align='right' width='30%'>名称：</td><td width='70%' align='left'><a href='show_shop.php?shopid=".$arr[shopid]."' target='_blank'><font color='blue'>".substr($arr[shopname],0,10)."</font></a></td>
					   </tr>
					   <tr>
					   <td align='right'>掌柜：</td><td align='left'><font color='red'>".$arr[shopowner]."</font></td>
					   </tr>
					    <tr>
					   <td align='right'>地点：</td><td align='left'><font color='blue'>".$sch[schoolname]."</font></td>
					   </tr>
					    <tr>
					   <td align='right'>商品数：</td><td align='left'><font color='blue'>".$num."</font>个</td>
					   </tr>
					    <tr>
					   <td align='right'>星级：</td><td align='left'><img src='manage/img/star".$arr[shopstar].".gif' /></td>
					   </tr>
					   </table>
					   </td>
                        </tr>";
						}
                                                                                  						?>
				 </table>
		                </div>
		                </td>
		               </tr>
		               </table>
<script language="javascript">
marqueeshigh=100;
stopsroll=false;
with(icetext){
	  style.width=0;
	  style.height=marqueeshigh;
	  style.overflowX='visible';
	  style.overflowY='hidden';
	  noWrap=true;
	  onmouseover=new Function('stopsroll=true');
	  onmouseout=new Function('stopsroll=false');
  }
  preop=0; currentop=marqueeshigh; stoptimes=0;
  icetext.innerHTML+=icetext.innerHTML;
  

function initsrolltext(){
  icetext.scrollTop=0;
  setInterval('scrollUps()',25);
}initsrolltext();

function scrollUps(){
  if(stopsroll==true) return;
  currentop+=1;
  if(currentop==marqueeshigh+1)
  {
  	stoptimes+=1;
  	currentop-=1;
  	if(stoptimes==500) 
  	{
  		currentop=0;
  		stoptimes=0;  		
  	}
  }
  else {  	
	  preop=icetext.scrollTop;
	  icetext.scrollTop+=1;
	  if(preop==icetext.scrollTop){
	    icetext.scrollTop=marqueeshigh;
	    icetext.scrollTop+=1;
	    
	  }
  }

}
initsrolltext();
</script>