function checkNotes($notes, $dataManager) { // Look if there's a subtable to be displayed $check = preg_match("/¬(.*?)¬/", $notes, $matches); //print_r($check); //print_r($matches); for ($i = 1; $i <= $check; $i++) { $found = $matches[round($i / 2) - 1]; $id = explode(":", $matches[round($i / 2)]); //echo '<br />Subtable '. $id[1] .' needed!!!!<br />'; $sql = "SELECT * FROM " . $dataManager->dbName . ".dbdocssubtables WHERE subTableId = " . chkVars($id[1]); $row = $dataManager->executeQuery($sql); if ($row) { //echo $row["subTableContent"] .'<br />'; $notes = str_replace($found, $row["subTableContent"], $notes); } else { //echo '<p>Warning! Infommation not avaiable. Add into database</p>'; $notes = str_replace($found, "<b>**" . $found . " not found**</b>", $notes); } //$notes = str_replace($found, "TABELLA!",$notes); } return $notes; }
<input type="submit" value="Modify" /> </td> </tr> </table> <?php } else { echo "Unable to identify the object to edit"; } } else { //do the modify $sql = "UPDATE " . $dataManager->dbName . ".dbdocsfields \r\n\t\t\t\t\t\tSET fieldComment = " . chkVars($_GET["txtFieldComment"]) . ", fieldNotes = " . chkVars($_GET["txtFieldNotes"]) . " \r\n\t\t\t\t\t\tWHERE fieldId = " . chkVars($editRowId); $editRes = $dataManager->executeQuery($sql); if ($editRes) { echo "Modify applied with success! This is the query to copy-paste into SQL updates files: <br/> \r\n\t\t\t\t\t\t<b>UPDATE dbdocsfields \r\n\t\t\t\t\t\tSET fieldComment = " . htmlentities(chkVars($_GET["txtFieldComment"])) . ", fieldNotes = " . htmlentities(chkVars($_GET["txtFieldNotes"])) . " \r\n\t\t\t\t\t\tWHERE fieldId = " . chkVars($editRowId) . "</b>"; } else { echo "There was errors on update. Operation aborted."; } } break; default: echo "Subject to modify is missing."; break; } ?> </form> <?php } else { echo "Row identifier missing."; }