<?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);
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Dynamic Form Builder</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<script language="javascript" type="text/javascript" src="js/client.js"></script>
</head>
<body>
<div align="left">
<h1>Create Dynamic Forms with javascript validatation and php script</h1>
<br /><br />
</div>
<?php
if (isset($_REQUEST['ValidateCreateFormFlag']) && $_REQUEST['ValidateCreateFormFlag'] == 'true') {
// Save basic form in db - Start
$TableName = TableName($FormTitle);
$FormGeneratorClass->setTableName($TableName);
$FormGeneratorClass->setFormName($FormTitle);
$SaveInDB = 0;
if (isset($_REQUEST['SaveInDB'])) {
$SaveInDB = 1;
}
$db->query("insert into forms set \r\n\t\tFormName='{$FormTitle}', \r\n\t\tTableName='{$TableName}', \r\n\t\tReturnURL='{$ReturnURL}', \r\n\t\tThankYouMessage='{$ThankYouMessage}', \r\n\t\tEmailToSend='{$EmailToSend}', \r\n\t\tSaveInDB='{$SaveInDB}', \r\n\t\tCreatedDate='" . date("Y-m-d H:i:s") . "'");
$FormID = mysql_insert_id();
$FormGeneratorClass->setFormID($FormID);
$FormGeneratorClass->SaveForm();
// Save basic form in db - End
// Create Form Table - Start
$FormGeneratorClass->CreateTable();
// Create Form Table - End
// Crate form files - Start
$FormGeneratorClass->CreateFormHTMLFile($_REQUEST);
