set_url('/local/cocoon_form_builder/getformdetail.php?id=' . $id); $PAGE->set_context(context_system::instance()); $id = $_GET['id']; $sql = "SELECT * FROM {cocoon_form_builder_forms} WHERE id = " . $id ; $forms = $DB->get_records_sql($sql); $data = array(); foreach ($forms as $form) { $x = [ "id" => $form->id, "title" => $form->title, "json" => $form->json, "reply" => $form->data, "url" => $form->url, "confirm_message" => $form->confirm_message, "recipients" => $form->recipients, "status" => $form->status, "ajax" => $form->ajax, ]; $data[] = $x; } echo json_encode($data);