function dbInsert($data, $table)
{
if ($table == 'keywordgroup') {
$sql = "insert into `keywordgroup`(`id`,`description`,`keywords`) values('" . $data['_attr_id'] . "', '" . mysql_escape_string($data['Description']) . "', '" . mysql_escape_string(json_encode(Web_Common_XMLTools::getXMLTreeArray($data, "Keyword"))) . "')";
} else {
if ($table == 'indexgroup') {
$sql = "insert into `indexgroup`(`id`,`description`,`indexs`) values('" . $data['_attr_id'] . "', '" . mysql_escape_string($data['Description']) . "', '" . mysql_escape_string(json_encode($data['Index'])) . "')";
} else {
if ($table == 'syntactic') {
$syntacticElement = json_encode($data['SyntacticElement']);
$semanticArgument = isset($data['SemanticBind']['SemanticArgumenmt']) ? json_encode($data['SemanticBind']['SemanticArgument']) : "[]";
$semanticArgumentDependency = isset($data['SemanticBind']['SemanticArgumentDependency']) ? json_encode($data['SemanticBind']['SemanticArgumentDependency']) : "[]";
$modifier = isset($data['modifiler']) ? json_encode($data['moidifiler']) : "[]";
$syntacticElement = json_encode($data['SyntacticElement']);
$sql = "insert into `syntactic`(`id`,`semanticId`,`syntacticElement`,`semanticArgument`,`semanticArgumentDependency`,`modifier`,`description`) " . "values('" . $data['id'] . "','" . $data['SemanticBind']['BindTo'] . "','" . mysql_escape_string($syntacticElement) . "','" . mysql_escape_string($semanticArgument) . "','" . mysql_escape_string($semanticArgumentDependency) . "','" . mysql_escape_string($modifier) . "','" . mysql_escape_string($data['Description']) . "')";
//die("$sql\n");
} else {
if ($table == 'semantic') {
$dependencyArgument = "[]";
$independencyArgument = "[]";
$argument = "[]";
$isKeyValue = "";
$internalRepresentation = "[]";
$uiRepresentation = "";
$chineseRepresentation = "";
$argument = json_encode($data['Argument']);
if (isset($data['ArgumenmtDependency'])) {
$ad = $data['ArgumentDependency'];
$dependencyArgument = isset($ad['DependencyArgumenmt']) ? json_encode($ad['DependencyArgument']) : "[]";
$independencyArgument = isset($ad['IndependencyArgumenmt']) ? json_encode($ad['IndependencyArgument']) : "[]";
}
if (isset($data['IsKeyValue'])) {
$isKeyValue = $data['IsKeyValue'];
}
if (isset($data['InternalRepresentation'])) {
$internalRepresentation = json_encode($data['InternalRepresentation']);
}
if (isset($data['UIRepresentation'])) {
$uiRepresentation = $data['UIRepresentation'];
}
if (isset($data['ChineseRepresentation'])) {
$chineseRepresentation = $data['ChineseRepresentation'];
}
$sql = "insert into `semantic`(`id`,`argument`,`argumentDependency`,`argumentIndependency`,`isKeyValue`,`internalRepresentation`, `uiRepresentation`,`chineseRepresentation`,`description`) " . "values('" . $data['id'] . "','" . mysql_escape_string($argument) . "','" . mysql_escape_string($argumentDependency) . "','" . mysql_escape_string($argumentIndependency) . "','" . mysql_escape_string($isKeyValue) . "','" . mysql_escape_string($internalRepresentation) . "','" . mysql_escape_string($uiRepresentation) . "','" . mysql_escape_string($chineseRepresentation) . "','" . mysql_escape_string($data['Description']) . "')";
//die("$sql\n");
} else {
echo "not insert\n";
return false;
}
}
}
}
echo "{$sql}\n";
if (!mysql_query($sql)) {
echo mysql_error();
echo "\n";
}
}
public static function DomToArray($root, $compat = false)
{
$result = array();
if ($root->hasAttributes()) {
$attrs = $root->attributes;
foreach ($attrs as $i => $attr) {
$result["_attr_" . $attr->name] = $attr->value;
}
}
$children = $root->childNodes;
$childtype = array();
for ($i = 0; $i < $children->length; $i++) {
$child = $children->item($i);
if ($child->nodeType == XML_TEXT_NODE) {
if (isset($result['_value'])) {
$result['_value'] .= $child->nodeValue;
} else {
$result['_value'] = $child->nodeValue;
}
} else {
if (!isset($result[$child->nodeName])) {
$childtype[$child->nodeName] = 1;
$result[$child->nodeName] = Web_Common_XMLTools::DomToArray($child, $compat);
} else {
if ($childtype[$child->nodeName] == 1) {
$tmp = $result[$child->nodeName];
$result[$child->nodeName] = array($tmp);
$childtype[$child->nodeName] = 2;
$result['__xml_array__items__'][$child->nodeName] = 1;
}
$result[$child->nodeName][] = Web_Common_XMLTools::DomToArray($child, $compat);
}
}
}
if ($compat === true) {
if (count($result) == 1 && isset($result['_value'])) {
$result = $result['_value'];
}
if (count($result) == 0) {
$result = "";
}
}
return $result;
}