jquery - Multiple textbox population with Ajax and PHP -

-

hello have code has multiple textbox populations based on ajax , php.

so each textbox has populate own data mysql.

its working fine except textboxes using same output when input data differend tables. how can separate them each show there table results database ?

$query , $query2 textboxes.

here code:

<?php     $db = new mysqli('localhost', 'root' ,'*', 'records');     if(!$db){         // show error if cannot connect.                 echo 'error: not connect database.';     }          else      {         // there posted query string?         if(isset($_post['querystring']))          {             $querystring = $db->real_escape_string($_post['querystring']);             // string length greater 0?             if(strlen($querystring) >0)              {                 $query = $db->query("select naam_klant overboekingen naam_klant '$querystring%' limit 10");                 $query2 = $db->query("select boekingsnummer overboekingen boekingsnummer '$querystring%' limit 10");                 if($query)                 {                    while ($result = $query ->fetch_object())                     {                       echo '<li onclick="fill(\''.$result->naam_klant.'\');">'.$result->naam_klant.'</li>';                    }                }                    if($query2)                 {                    while ($result = $query2 ->fetch_object())                     {                        echo '<li onclick="fill(\''.$result->boekingsnummer.'\');">'.$result->boekingsnummer.'</li>';                    }                }                else{                    echo 'error: there problem query.';                }           }            else{           } // there querystring.      }       else {          echo 'there should no direct access script!';      }     } ?>

html:

<label>boekingsnummer</label>  <input type="text" name="boekingsnummer" size="20" class="inputstring" onkeyup="lookup(this.value);" onblur="fill();" >     <div id="suggestionsbox" class="suggestions" style="display: none;"> <div id="suggestionlist" class="autosuggestionslist"> </div> </div>  <label>naam klant</label>  <input type="text" name="naam_klant" size="20" class="inputstring" onkeyup="lookup(this.value);" onblur="fill();" >     <div id="suggestionsbox" class="suggestions" style="display: none;"> <div id="suggestionlist" class="autosuggestionslist"> </div> </div>


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more