pfuns.php

来自「一个PHP的购物系统源代码」· PHP 代码 · 共 49 行

<?
  function GetMessages($msgStart,$number)
  {
      $connect=mysql_connect("127.0.0.1","root","root");
      mysql_select_db("ebusiness");
      $query="select ProductID,ProductName,Price,Color,size from Product LIMIT";
      $query=$query.$msgStart;
      $query=$query.",";
      $query=$query.$number;
      $result=mysql_query($query);

      if(!result)
      {
          mysql_close($connect);
          $msgs[0]=0;
          return $msgs;
      }
      $count=0;

      while($obj=mysql_fetch_object($result))
      {
          $count++;
          $msgs[$count]=$obj;
          $msgs[0]=$count;
      }
      mysql_close($connect);
      return $msgs;
  }

  //函数getrownumber()，用来统计表中的行数。
  function getrownumber()
  {
      $connect=mysql_connect("127.0.0.1","root","root");
      mysql_select_db('ebusiness');
      $query='select COUNT(*) from Product';
      $result=mysql_query($query);
      $number=mysql_fetch_array[$result];
      mysql_close($connect);
      return($number[0]);
  }

  //函数thelastnumber()，统计最后一页的输出个数。
  function thelastnumber($number)
  {
      $lastnumber=$number%10;
      return($lastnumber);
  }
?>