<?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);