class Wprint{
   //收集打印代碼
   private $data = array();
   //處理打印代碼
   private $handle;
   public function __construct()
  {
    header("Content-type:text/html;charsetutf-8");
    $this->link(); //鏈接數(shù)據(jù)庫
    $this->collect($_POST["username"],$_POST["content"],$_POST["ip"]);
    $this->handle();
   }
   //鏈接數(shù)據(jù)庫
   private function link()
   {
    $link = mysql_connect('localhost', 'root', '123456');
    mysql_select_db('shen', $link);
    mysql_query('SET NAMES utf8');
   }
   //收集打印代碼
   private function collect($username,$content,$ip)
   {
     $code["username"] = $username;
     $code["content"] = $this->check($content);
     $code["ip"] = $ip;
     $code["state"] = 0;
     $code["priority"] = 0;
     array_push($this->data,$code);//數(shù)據(jù)節(jié)點入棧
   }
   //處理打印代碼入庫
   private function handle()
   {
    foreach($this->data as $value)
    {
$sql = "insert into print(username,content,ip,state,priority)
values('{$value["username"]}','{$value["content"]}',
'{$value["ip"]}','{$value["state"]}','{$value["priority"]}')";
     $query = mysql_query($sql);
     if($query)
     {
      $id = mysql_insert_id(); //獲取最近insert操作得到的ID
      echo "數(shù)據(jù)收集成功,正在排隊打印,排隊ID為".$id;
      $this->num($id);
     }
     else
     {
      echo "數(shù)據(jù)收集失敗,請3秒后再一次提交";
     }
    }
   }
    //檢查傳人數(shù)據(jù)是否為空
   private function check($string)
   {
    if(strlen($string) == 0 || $string == " ")
    {
     echo "數(shù)據(jù)收集失敗,打印內(nèi)容為空";
     exit;
    }else
    {
     return $string;
    }
   }
   //獲取打印排隊人數(shù)
   private function num($id)
   {
    $sql = "select id from print where state=0 and id<".$id." order by id asc";
    $query = mysql_query($sql);
    $num = mysql_num_rows($query);
    echo ",您前面還有".$num."個人在排隊";
   }
   //打印數(shù)據(jù)
   public function Yprint()
   {
     $sql = "select id,content from print where state=0 order by id asc limit 1";
     $query = mysql_query($sql);
     $row = mysql_fetch_array($query);
     if(!empty($row["content"]))
     {
      echo "<script tyle=\"text/javascript\">
            window.print();
        </script>";
      $id = $row["id"];
      $sql = "update print set state=1 where id=".$id;
      mysql_query($sql);
      echo "打印處理完成";
     }else
     {
       echo $row["content"];
     }
   }
}