commentModel.class.php

<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2023/3/16 0016
* Time: 上午 9:51
*/

class commentModel extends model{
   public function insert(){
       $data['poster']=$_POST['poster'];
       $data['mail']=$_POST['mail'];
       $data['comment']=$_POST['comment'];
       $data['reply']='';
       $data['date']=date('Y-m-d H:i:s');
       $data['ip']=$_SERVER['REMOTE_ADDR'];
       $sql="insert into `comment` set ";
       foreach($data as $k=>$v){
           $sql .="`$k`='$v',";
       }
       $sql=rtrim($sql,',');
       return $this->db->query($sql);
   }

   public function getAll(){
       $order='';
       if (isset($_GET['sort']) && $_GET['sort']=='desc'){
           $order='order by id desc';
       }
       $sql="select `poster`,`comment`,`date`,`reply` from `comment` $order";
       $data=$this->db->fetchAll($sql);
       return $data;
   }
   public function getNumber(){
       $data=$this->db->fetchRow("select count(*) from `comment`");
       return $data['count(*)'];
   }
}