public function execSQL($query, $multi = false)
{
$res = DBHelper::exec($query, $multi);
if ($res != null) {
$this->error++;
$this->printStepMsg($res, true);
}
return true;
}
$sql = "UPDATE tabDataToNode SET ";
for ($i = 1; $i <= 10; $i++) {
$paramName = "data" . $i;
if (isset($_POST[$paramName])) {
if ($isFirstParam) {
//如果是第一个参数，无需加逗号分割，且要把标志设为false了
$isFirstParam = false;
} else {
//如果不是第一个参数，则需要加逗号来分割
$sql = $sql . ",";
}
$sql = $sql . "fldData" . $i . "=" . $_POST[$paramName];
}
}
if ($isFirstParam) {
//如果isFirstParam还为真，那么说明data1, data2, ..., data10 一个都没有POST过来
echo "Error! At least one paramater (data1-10) must be posted.";
} else {
$sql = $sql . ", fldUpdatedBy='webAPI', fldUpdatedOn=datetime('now', 'localtime') WHERE fldNodeID=" . $nodeID;
//$sql = $sql . ", fldUpdatedBy='robot', fldUpdatedOn=datetime('now', 'localtime') WHERE fldNodeID1=".$nodeID1." AND fldNodeID2=".$nodeID2;
echo $sql;
$db = new DBHelper();
$db->exec($sql);
// or die("Error: " .sqlite_error_string(sqlite_last_error($conn)));
$db->close();
echo "OK";
}
}
} else {
echo "Error, [nodeID] must be set";
}
echo '<i style="padding-left:30px;" >|_ Update reports in (' . implode(', ', $issue['reports']) . ') with issue id ' . $issueId . ' ... </i>';
if (DBHelper::updateReportsIssue($issue['reports'], $issueId)) {
echo '<i>OK</i><br/>';
} else {
echo '<i style="color:red" >FAILED</i><br/>';
}
} else {
echo '<i style="color:red" >FAILED</i><br/>';
echo '<i style="padding-left:30px; color:red; font-weight:bold;" >' . DBHelper::getLastError() . '</i><br/>';
}
}
} catch (Exception $e) {
echo '<b style="padding-left:30px; color:red;" >' . $e->getMessage() . '</b><br/>';
exit;
}
echo '<b>Step 5.</b> ... OK<br/>';
echo '<b>Step 6.</b> Create database triggers ... ';
$res = DBHelper::exec($sql[1], true);
if ($res != null) {
echo '<br/><b style="padding-left:30px; color:red;" >' . $res . '</b>';
exit;
}
DBHelper::clearStoredResults();
// count triggers
$res = DBHelper::countRows('information_schema.triggers', null, true);
if ($res != 4) {
echo '<b style="color:red" >FAILED</b><br/><b style="padding-left:30px; color:red;" >All triggers not created properly !</b>';
} else {
echo 'OK<br/>';
}
echo '<p><b style="color:green" >UPDATE IS COMPLETE !</b></p>';
