<?php
session_start();
extract($_REQUEST);
include_once "classes/commonfunctions.php";
include_once "form_generator.class.php";
$FormGeneratorClass = new FormGenerator();
if (isset($_REQUEST['TableID']) && $_REQUEST['TableID'] != '') {
$db->query("select * from form_elements where TableID='" . $_REQUEST['TableID'] . "'");
if ($db->num_rows() > 0) {
$db->next_Record();
$FieldName = $db->f('HTML_Name');
$FormID = $db->f('FormID');
$FormDetails = FetchRecordByID($FormID, "TableID", "forms");
$DirectoryName = $FormDetails['TableName'];
//delete_directory("forms/$DirectoryName");
$db->query("delete from form_elements where TableID='" . $_REQUEST['TableID'] . "'");
$db->query("ALTER TABLE {$DirectoryName} DROP COLUMN {$FieldName}");
$FormGeneratorClass->setTableName($DirectoryName);
$FormGeneratorClass->setFormID($FormID);
$FormInfo = $FormGeneratorClass->SetValuesSession();
$FormInfo["SaveInDB"] = 1;
$FormGeneratorClass->UpdateForm($FormInfo);
}
showmessage("Form all related items deleted successfully");
}
redirect("index.php", 0);
