php - Set value from database to textbox based on search by id -

-

please me solve case. have code below :

<script>     function getxmlhttp() {         var xmlhttp = false;             try{             xmlhttp=new xmlhttprequest();         }         catch(e)         {             try{                 xmlhttp= new activexobject("microsoft.xmlhttp");             catch(e){                 try{                     xmlhttp = new activexobject("msxml2.xmlhttp");                 catch(e1){                     xmlhttp=false;                 }             }         }         return xmlhttp;     }      function getcity(url, id1) {         var req = getxmlhttp(url);         if (req) {             req.onreadystatechange = function() {                 if (req.readystate == 4) {                     // if "ok"                     if (req.status == 200) {                         document.getelementbyid(id1).value=req.responsetext;                             // document.getelementbyid(id2).value=req.responsetext;                     } else {                         alert("there problem while using xmlhttp:\n" + req.statustext);                     }                 }             }             req.open("get", url, true);             req.send(null);         }     } </script>  <?php            echo "         <tbody>             <tr>                 <td class='td'><input type='text' size='6' name='kode_barang" ."' maxlength='6' onchange='javascript:this.value=this.value.touppercase();' onkeyup='getcity(\"search.php?kode_barang=\"+this.value, \"nama_barang"  . "\",\"harga_barang"  . "\");' id='kode_barang'></td>                 <td class='td'><input type='text' size='22' name='nama_barang"  . "' id='nama_barang" . "' readonly tabindex='1'></td>                 <td class='td'><input type='text' size='22' name='harga_barang"  . "' id='harga_barang" . "' tabindex='1'></td>         </tbody>     "; ?>

search.php file :

include_once('config.php');  if (isset($_get['kode_barang'])) {     $qry = "select nama_barang, harga_barang t_barang kode_barang = '" . $_get['kode_barang'] . "'";     $sql = mysql_query($qry);      $ary = mysql_fetch_array($sql);      echo $ary['nama_barang'];     echo $ary['harga_barang']; }

this how find nama_barang , harga_barang based on kode_barang input. example if input kode_barang in textbox kode_barang in text_box nama_barang , harga_barang set information database automatically.

i've tried in code, set 2 information(nama_barang & harga_barang) in 1 textbox nama_barang. should set in each textbox.

so, question : how set information nama_barang , harga_barang database each textbox ?

appreciate helps. thank you.

replace getcity() function following one

  function getcity(url, id1, id2) {             var req = getxmlhttp(url);             if (req) {                 req.onreadystatechange = function() {                     if (req.readystate == 4) {                         // if "ok"                         if (req.status == 200) {             var res = json.parse(req.responsetext);                             document.getelementbyid(id1).value=res.nama_barang;                               document.getelementbyid(id2).value=res.harga_barang;                         } else {                             alert("there problem while using xmlhttp:\n" + req.statustext);                         }                     }                 }              req.open("get", url, true);                 req.send(null);             }      }

and replace part of code in search.php

from 

$ary = mysql_fetch_array($sql);  echo $ary['nama_barang']; echo $ary['harga_barang'];

to

$ary = mysql_fetch_array($sql);  echo json_encode($ary);

the problem was, missing id of second text box in getcity() function.

update sending default value

replace following part

if (isset($_get['kode_barang'])) {     $qry = "select nama_barang, harga_barang t_barang kode_barang = '" . $_get['kode_barang'] . "'";     $sql = mysql_query($qry);      $ary = mysql_fetch_array($sql);      echo $ary['nama_barang'];     echo $ary['harga_barang']; }

with

if (isset($_get['kode_barang'])) {     $qry = "select nama_barang, harga_barang t_barang kode_barang = '" . $_get['kode_barang'] . "'";     $sql = mysql_query($qry);      if (mysql_num_rows($sql) > 0)     {       $ary = mysql_fetch_array($sql);        echo json_encode($ary);     }     else     {        echo json_encode(array("nama_barang" => "", "harga_barang" => ""));     }  }

* way not best practice make data base request each of keyup event. can solve.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more