Search the Community
Showing results for tags 'php survey'.
Found 1 result
-
Hi All, i would like to create a web page that allow user to feedback. So, i need a page where allow admin to setup a survey form. The more flexible, the best. What i mean is, admin able to create a form. A form may contain of check box, Main question, Sub Question and also open text feed back. For now, i able to complete only one module, which is allow admin add only Main Question, i have stuck with the Sub Questions. Here is my sample codes. HTML Page: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Test Market</title> <script src="http://jtable.org/Scripts/jquery-1.9.1.min.js" type="text/javascript"></script> <script src="http://jtable.org/Scripts/jquery-ui-1.10.0.min.js" type="text/javascript"></script> </head> <script type="text/javascript"> $(document).ready(function () { var max_fields = 10; //maximum input boxes allowed var wrapper = $(".input_fields_wrap"); //Fields wrapper var add_button = $(".add_field_button"); //Add button ID var x = 1; //initlal text box count $(add_button).click(function (e) { //on add input button click e.preventDefault(); if (x = x) { //max input box allowed x++; //text box increment $(wrapper).append('<div><input type="text" name="question[]"/><a href="#" class="remove_field">Remove</a></div>'); //add input box } }); $(wrapper).on("click", ".remove_field", function (e) { //user click on remove text e.preventDefault(); $(this).parent('div').remove(); x--; }) }); </script> <style> #b-wrapper{ width: 297px; margin: 0 auto; } </style> <body> <div id="b-wrapper"> <form action="save-form.php?mod=add" method="post"> <table> <tr> <td><lable>Form Name</lable></td> <td><input name="form_name"></input></td> </tr> <tr> <td><lable>Form Description</lable></td> <td><input name="form_desc"></input></td> </tr> </table> <div class="input_fields_wrap"> <div>Question</div> <div><input type="text" name="question[]"></input></div> </div> <button class="add_field_button">Add More Fields</button> <input type="submit"></input> </form> </div> </body> </html> SUBMIT FORM PAGE: <?php $serverName = "server_one"; //serverName\instanceName $connectionInfo = array("Database" => "RSA", "UID" => "username", "PWD" => "password"); $conn = sqlsrv_connect($serverName, $connectionInfo); $formName = $_POST['form_name']; $formDesc = $_POST['form_desc']; $formQuestion = $_POST['question']; $id = $_POST["id"]; foreach( $formQuestion as $key => $text_field ) { //print "$formQuetion"; echo '<br>'; //MySqli Insert Query $result = "INSERT INTO form(form_name,form_description,question) VALUES('$formName','$formDesc','$text_field')"; $stmt = sqlsrv_query($conn, $result); } ?> This only able to dynamically add main question, how if there is a sub question? radio button? selection? check box?
