function rule_data_insert($post, $db) { $new_rule_data = new Rule(); $new_rule_data->setDataFileID($post['rdf_filter']); $new_rule_data->setRuleData($post['rd_name']); $new_rule_data->setRuleDataActive($post['validity']); $new_rule_data->setFilled(true); $db->addRuleDatas($new_rule_data); }
public function getAllRuleDatas($where = '', $wlimit = '') { $count_str = "SELECT RD.RuleDataID,RD.DataFileID,RDF.DataFileName,\n RD.RuleData,RD.Deleted\n FROM rule_data RD\n LEFT JOIN rule_data_files RDF ON (RDF.DataFileID=RD.DataFileID)\n WHERE 1 {$where} ORDER BY RD.RuleDataID DESC {$wlimit}"; $result = $this->dbh->query($count_str); if (PEAR::isError($result)) { echo $result->getMessage() . ' - ' . $result->getUserinfo(); exit; } $array = $result->fetchAll(); $result->free(); $rules_da = array(); foreach ($array as $rd) { $rule_data = new Rule(); $rule_data->setRuleDataID($rd[0]); $rule_data->setDataFileID($rd[1]); $rule_data->setDataFileName($rd[2]); $rule_data->setRuleData($rd[3]); $rule_data->setRuleDataActive($rd[4]); $rules_da[] = $rule_data; } return $rules_da; }