empty___.php

PHP源码_环保设计大赛网上投票系统

<?PHP
include ("huanbao.connect.php");


  $query="select * from huanbao_pic order by huanbao_user_id,joindate";
  $result = mysql_query($query,$db);
  $num=mysql_num_rows($result);

  echo "<center>";
  echo "<br><br>";

  $rr=0;
  $id=0;

  for($i=0;$i<$num;$i++)
  {
    $rr_old=$rr;
    $rr = mysql_fetch_array($result);

    $id_old=$id;
    $id=$rr[huanbao_user_id];

    if (($id<>$id_old) and ($rr_old<>0))
    {   //显示作品名/作者/文字说明
       $query="select * from huanbao_user where id='$rr_old[huanbao_user_id]'";
       $result=mysql_query($query,$db);
       $tt=mysql_fetch_array($result);
       echo "<br><br>";
       echo $tt[product]."<br>";
       echo $tt[info]."<br>";
       echo $tt[author]."<br>";
       echo "<br><br>";
    }

    //显示图片
$photo_url=$rr[url];
if ($photo_url<>"")
{
$image_file="http://studentunion.w18.net".$photo_url;

$image_size=getimagesize($image_file);
$width=$image_size[0];
$width1=$image_size[0];
$height=$image_size[1];
$height1=$image_size[1];

//echo $image_file."&nbsp&nbsp&nbsp".$rr[id];

$height1=$height*200/$width;
$width1=200;
$imageurl=$photo_url;

echo "<a href=\"$photo_url\" target=\"_blank\">";

//$imageurl=$photo_url;

echo "<img src=\"$photo_url\"";
echo "width=\"$width1\" height=\"$height1\" border=\"0\"";

echo "></a>&nbsp;&nbsp;&nbsp;";
}

  }

  echo "</center>";

  mysql_close($db);
?>