Autofilling dependant textfields through searching by ID using php And Mysql

[Timkats]

Hi Guys, Iam having a challenge of completing auto filling of dependant input textfields on a form through ID Search. Any Help is Highly Welcome. These are the details for the Form, Php File and Jquery/Ajax File:

HTML FILE:

Search

Stage Name

Stage ID

Entry Date

Stage Location

Stage Chairperson

Stage Chairperson NIN

Stage Chairperson Contact

Village

Parish

District

PHP FILE

0) { while($row = mysqli_fetch_assoc($resultSet)) { $data = $row; } } echo json_encode($data); } ?>

JAVASCRIPT/AJAX FILE

<script> $(document).ready(function(){ $('#searchdata').click(function(e){ e.preventDefault(); var id = $("input[name=id]").val(); $.ajax({ type: "POST", url: 'getStage.php', data: { "search_post_btn": 1, "id": id, }, dataType: "text", success: function(result){ var jsondata = $.parseJSON(result); $("input[name='stagename']").val(jsondata[id].stagename); $("input[name='id']").val(jsondata[id].id); $("input[name='stgcreation_date']").val(jsondata[id].stgcreation_date); $("input[name='stagelocation']").val(jsondata[id].stagelocation); $("input[name='stagechairperson']").val(jsondata[id].stagechairperson); $("input[name='stagechairpersonNIN']").val(jsondata[id].stagechairpersonNIN); $("input[name='stagechairpersoncontact']").val(jsondata[id].stagechairpersoncontact); $("input[name='stagevillage']").val(jsondata[id].stagevillage); $("input[name='stageparish']").val(jsondata[id].stageparish); $("input[name='stagedistrict']").val(jsondata[id].stagedistrict); } }); }); }); </script>