function queryDeleteTable($param, $mysqli = '') { if ($mysqli === '') { $mysqli = connect_DB(); } recursive_trim($param); extract($param); $stmt = $mysqli->stmt_init(); if ($stmt->prepare("DELETE FROM `table` WHERE Table_ID=?")) { $stmt->bind_param("s", $Table_ID); $stmt->execute(); $stmt->close(); } else { die($stmt->error); } $stmt = $mysqli->stmt_init(); if ($stmt->prepare("DELETE FROM table_pages WHERE Table_ID=?")) { $stmt->bind_param("s", $Table_ID); $stmt->execute(); $stmt->close(); } else { die($stmt->error); } $mysqli->real_query("SELECT Field_ID\n FROM `table_fields`\n WHERE Table_ID='{$Table_ID}'"); if ($result = $mysqli->use_result()) { $mysqli2 = connect_DB(); while ($data = $result->fetch_assoc()) { queryDeleteTableField($data, $mysqli2); } } else { die($mysqli->error); } $result->close(); }
} $mysqli->close(); $mysqli_validation_routines = connect_DB(); $mysqli_validation_routines->real_query("SELECT Validation_Routine \n FROM `table_fields_secondary_validation` \n WHERE Field_ID='{$Field_ID}'"); $mysqli_select_parameters = connect_DB(); $mysqli_select_parameters->real_query("SELECT b.Field_Name, a.Display \n FROM `table_fields_list_source_select` a, \n `table_fields` b \n WHERE a.Field_ID='{$Field_ID}' AND a.Select_Field_ID = b.Field_ID"); $mysqli_where_parameters = connect_DB(); $mysqli_where_parameters->real_query("SELECT b.Field_Name, a.Where_Field_Operand, a.Where_Field_Value, a.Where_Field_Connector \n FROM `table_fields_list_source_where` a, \n `table_fields` b \n WHERE a.Field_ID='{$Field_ID}' AND a.Where_Field_ID = b.Field_ID"); } elseif (xsrf_guard()) { init_var($_POST['btnCancel']); init_var($_POST['btnSubmit']); if ($_POST['btnCancel']) { header('location: ListView_TableFields.php'); exit; } elseif ($_POST['btnSubmit']) { queryDeleteTableField($_POST); header("location: ../success.php?success_tag=DeleteTableFields"); exit; } } drawHeader(); drawPageTitle('Delete Table Field', 'Are you sure you wish to delete this table field?'); echo '<input type="hidden" name="Field_ID" value="' . $Field_ID . '">'; ?> <div class="container_mid"> <fieldset class="top"> Delete Table Field </fieldset> <fieldset class="middle"> <table class="input_form">