Reply to thread

Message

<blockquote data-quote="විල්සන් මාමා" data-source="post: 16594312" data-attributes="member: 397789">ඇයි ajax වලින් එන response එක දෙවෙනි dropdown එකට එකතු වෙන්නෙ &amp;aමෙතන dropdowns ඩෙකක් තියෙනවා (ඩෙකක් නෙමයි දෙකක් <img src="/styles/default/xenforo/smilies/default/lol.gif"&nbsp; class="smilie" loading="lazy" alt=":lol:" title="LOL&nbsp; &nbsp; :lol:" data-shortname=":lol:" />). පලවෙනි එකේ values db table එකකින් ගන්නෙ. දෙවෙනි එකෙ values&nbsp; වෙනස් වෙනවා first dropdown එකෙ තොරන දෙය අනුව . පලවෙනි dropdown එක [HTML]&lt;div class=&quot;formBlock&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label for=&quot;branch_id&quot;&gt;Branch Name&lt;span class=&quot;required&quot;&gt;*&lt;/span&gt;&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;select id=&quot;branch_id&quot; name=&quot;branch_id&quot; class=&quot;textInput&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $branches = $branch-&gt;find_by_sql(&quot;SELECT * FROM branch&quot;);//this is an arry&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; foreach ($branches as $branch) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; echo &quot;&lt;option value='$branch-&gt;id'&gt;$branch-&gt;branch_name&lt;/option&gt; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/select&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/div&gt;&nbsp; [/HTML]දෙවෙනි එක.&nbsp;[HTML]&nbsp;&lt;div class=&quot;formBlock&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;label for=&quot;cust_id&quot;&gt;Customer Name &lt;span class=&quot;required&quot;&gt;*&lt;/span&gt;&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;select id=&quot;cust_id&quot;&nbsp; &gt;&lt;/select&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;[/HTML]JS[CODE]&nbsp;$(function(){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $(&quot;#branch_id&quot;).bind(&quot;change&quot;,function(){&nbsp; &nbsp;&nbsp; $.ajax({&nbsp; &nbsp; &nbsp; &nbsp; type:&quot;GET&quot;,&nbsp; &nbsp; &nbsp; &nbsp; url:&quot;create_loan_request.php&quot;, //same file&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; data:&quot;branch_id=&quot;+$(&quot;#branch_id&quot;).val(),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; dataType:&quot;text&quot;, //changed this to html also&nbsp; &nbsp; &nbsp; &nbsp; success:function(html){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $(&quot;#cust_id&quot;).html(html); // I have tried append also&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(html);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //inserting options to second dropdown&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; error: function(jqXHR, textStatus, errorThrown) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; console.log(textStatus, errorThrown);&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; &nbsp; });&nbsp;&nbsp; });[/CODE]PHP code[PHP]if(isset($_GET[&quot;branch_id&quot;])){&nbsp; &nbsp;&nbsp; $id=(int)$_GET[&quot;branch_id&quot;];&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $customers=&nbsp; Customer::find_by_sql(&quot;SELECT id,firstname,lastname FROM customer WHERE branch_id=&quot;.$id);&nbsp; &nbsp;&nbsp; foreach ($customers as $customer) {&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; echo &quot;&lt;option value='$customer-&gt;id'&gt;&quot;.$customer-&gt;firstname.&quot;&lt;/option&gt;&quot;;&nbsp; &nbsp;&nbsp; } }[/PHP]Console එකේ print වෙනවා මචන්ලා හරියට.එත් දෙවෙනි dropdown එකට එන්නෙ නැහැනේ. ajax success එකේ alert කලාම &lt;option&gt; tags වලට අම්තරව මුලු html file එකම එනවා. </blockquote>

[QUOTE="විල්සන් මාමා, post: 16594312, member: 397789"] [b]ඇයි ajax වලින් එන response එක දෙවෙනි dropdown එකට එකතු වෙන්නෙ &a[/b] [SIZE=4]මෙතන dropdowns ඩෙකක් තියෙනවා (ඩෙකක් නෙමයි දෙකක් :lol:). පලවෙනි එකේ values db table එකකින් ගන්නෙ. දෙවෙනි එකෙ values වෙනස් වෙනවා first dropdown එකෙ තොරන දෙය අනුව . [/SIZE] [U][B]පලවෙනි dropdown එක [/B][/U] [HTML]<div class="formBlock"> <label for="branch_id">Branch Name*</label> <select id="branch_id" name="branch_id" class="textInput"> <?php $branches = $branch->find_by_sql("SELECT * FROM branch");//this is an arry foreach ($branches as $branch) { echo "<option value='$branch->id'>$branch->branch_name</option> "; } ?> </select> </div> [/HTML][U][B]දෙවෙනි එක.[/B][/U] [HTML] <div class="formBlock"> <label for="cust_id">Customer Name *</label> <select id="cust_id" ></select> </div> [/HTML]JS [CODE] $(function(){ $("#branch_id").bind("change",function(){ $.ajax({ type:"GET", url:"create_loan_request.php", //same file data:"branch_id="+$("#branch_id").val(), dataType:"text", //changed this to html also success:function(html){ $("#cust_id").html(html); // I have tried append also console.log(html); //inserting options to second dropdown }, error: function(jqXHR, textStatus, errorThrown) { console.log(textStatus, errorThrown); } }); }); [/CODE] PHP code [PHP] if(isset($_GET["branch_id"])){ $id=(int)$_GET["branch_id"]; $customers= Customer::find_by_sql("SELECT id,firstname,lastname FROM customer WHERE branch_id=".$id); foreach ($customers as $customer) { echo "<option value='$customer->id'>".$customer->firstname."</option>"; } } [/PHP][SIZE=4]Console එකේ print වෙනවා මචන්ලා හරියට.එත් දෙවෙනි dropdown එකට එන්නෙ නැහැනේ. ajax success එකේ alert කලාම <option> tags වලට අම්තරව මුලු html file එකම එනවා. [/SIZE] [/QUOTE]

Verification

Payakata winadi keeyak tibeda?

Search

Latest ads

Reply to thread