Skip to main content

javascript - Autocomplete/sql to fill input field 2 after onblur on input1 -


okay, here goes. have 2 input fiels. first 1 works charm, autocomplete huge database name, onblur after selecting it, should automatically fill input field 2 via php script, searches selected string in database , populates input field many hits gets. how can that?

so: if first input's autocomplete finds string, it's stored (with multiple id's on same name), should id's. if there no string found in db on first input, have autocomplete written multi selecting id's manually on second box, submitting them. not important now. again, how can populate second input given string found in database first input? far have barebone:

<input type="text" size="20" onblur"" id="firstinput" name="firstinput"> <input type="text" size="40" value="" id="manualorautogroup" name="manualorautogroup">

php json_encodes results:

$lolz = array(); while( $row = mysql_fetch_assoc($resultset) ) { $lolz[] = array( 'value' => $row['gameid'], echo json_encode($lolz); ); }

how client side code call , gets data filled input 2?

database sample:

gameid                         groupname

122                  stringtypedininput1foundyautocomplete

314                  stringtypedininput1foundyautocomplete

513                  stringtypedininput1foundyautocomplete

533                  stringtypedininput1foundyautocomplete

many :)

javascript - autocomplete/sql fill input field 2 after onblur on input1 - stack overflow

learn, share, build

each month, on 50 million developers come stack overflow learn, share knowledge, , build careers.

join world’s largest developer community.

sign up

up vote 0 down vote favorite

okay, here goes. have 2 input fiels. first 1 works charm, autocomplete huge database name, onblur after selecting it, should automatically fill input field 2 via php script, searches selected string in database , populates input field many hits gets. how can that?

so: if first input's autocomplete finds string, it's stored (with multiple id's on same name), should id's. if there no string found in db on first input, have autocomplete written multi selecting id's manually on second box, submitting them. not important now. again, how can populate second input given string found in database first input? far have barebone:

<input type="text" size="20" onblur"" id="firstinput" name="firstinput"> <input type="text" size="40" value="" id="manualorautogroup" name="manualorautogroup">

php json_encodes results:

$lolz = array(); while( $row = mysql_fetch_assoc($resultset) ) { $lolz[] = array( 'value' => $row['gameid'], echo json_encode($lolz); ); }

how client side code call , gets data filled input 2?

database sample:

gameid                         groupname

122                  stringtypedininput1foundyautocomplete

314                  stringtypedininput1foundyautocomplete

513                  stringtypedininput1foundyautocomplete

533                  stringtypedininput1foundyautocomplete

many :)

share|improve question
    
the echo needs outside of while loop. way have won't work. when receive data ajax call, you'll need to use success: function(data){ , inside you'll need set source of autocomplete 2nd input array send server. – ohgodwhy jul 7 '12 @ 0:30
    
the echo inside array. can problem. – chepe263 jul 7 '12 @ 1:45
    
normally echo outside while call yes, mistake pasting wrong position. still, because i'm muh of beginner in js, kind enough drop in few client side lines, can understand first commenter wanted me do? – flatline jul 7 '12 @ 9:56
    
ohgodwhy please, or anyone? :) – flatline jul 8 '12 @ 0:37

your answer

 
discard

posting answer, agree privacy policy , terms of service.

browse other questions tagged or ask own question.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more