/** *修改指定表记录 */ public static function updateTnameProducts($tName, $set, $where) { self::initDB(); $sql = "UPDATE {$tName} {$set} {$where}"; $query = self::$dbConn->query($sql); if ($query) { $affectRows = self::$dbConn->affected_rows($query); return $affectRows; //成功, 返回列表数据 } else { self::$errCode = "003"; self::$errMsg = "修改失败"; return false; //失败则设置错误码和错误信息, 返回false } }
public static function getPropertyRelationList($id) { self::initDB(); $sql = "SELECT a.propertyId,b.propertyName FROM pc_goods_property_relation AS a \n\t\t\t\t LEFT JOIN pc_goods_property as b on a.propertyId=b.id WHERE a.goodsId='{$id}'"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); return $ret; } else { self::$errCode = "003"; self::$errMsg = "444444444"; return false; } }