PHP Data processing public class

/*==================================================================*/ /* File name: BaseLogic.class.php */ /* Summary: Data processing public class. */ Class Baselogic extends MyDB { protected $tabName; Name of the table protected $fieldList; Field Collection protected $messList; //========================================== Function: Add ($postList) Features: Adding Parameters: List of variables submitted $postList Return: The self-increment ID just inserted //========================================== function Add ($postList) { $fieldList = "; $value = "; foreach ($postList as $k = = $v) { if (In_array ($k, $this->fieldlist)) { $fieldList. = $k. ","; if (!GET_MAGIC_QUOTES_GPC ()) $value. = "'". Addslashes ($v). "',"; Else $value. = "'". $v. "',"; } } $fieldList =rtrim ($fieldList, ","); $value =rtrim ($value, ","); $sql = "INSERT into {$this->tabname} (". $fieldList. ") VALUES (". $value.") "; Echo $sql; $result = $this->mysqli->query ($sql); if ($result && $this->mysqli->affected_rows >0) return $this->mysqli->insert_id; Else return false; } //========================================== Function: MoD ($postList) Function: Modify table Data Parameters: List of variables submitted $postList //========================================== function mod ($postList) { $id = $postList ["id"]; unset ($postList ["id"]); $value = "; foreach ($postList as $k = = $v) { if (In_array ($k, $this->fieldlist)) { if (!GET_MAGIC_QUOTES_GPC ()) $value. = $k. "=". Addslashes ($v). "',"; Else $value. = $k. "=". $v. "',"; } } $value =rtrim ($value, ","); $sql = "UPDATE {$this->tabname} SET {$value} WHERE id={$id}"; return $this->mysqli->query ($sql); } //========================================== function: Del ($id) Function: Delete Parameters: $id number or ID list array Returns: 0 number of records failed successfully for deletion //========================================== Function del ($id) { if (Is_array ($id)) $tmp = "In (". Join (",", $id). ")"; Else $tmp = "= $id"; $sql = "DELETE from {$this->tabname} WHERE ID". $tmp; return $this->mysqli->query ($sql); } function Get ($id) { $sql = "Select * from {$this->tabname} WHERE ID ={$id}"; $result = $this->mysqli->query ($sql); if ($result && $result->num_rows ==1) { return $result->fetch_assoc (); }else{ return false; } } function Getmesslist () { $message = ""; if (!empty ($this->messlist)) { foreach ($this->messlist as $value) { $message. = $value. " "; } } return $message; } } ?> Copy Code

Php

