rreload a list box inside a form?

@PeuplarchieNov 15.2007

How can I make a list box reload but not the rest of the form?
The content of the list box is a php generated list of the directory in a variably define variable.

Thanks

to post a comment

JavaScript

@yearbassNov 15.2007 — #you can use folowing method (last time known as remote scripting)

1. hidden frame/iframe

2. AJAX

i think AJAX is a good idea. for ajax framework try prototype.js (http://www.prototypejs.org)

@yearbassNov 15.2007 — #this is some example, that get list data from db

php script [getlist.php]

[code=php]<?php
 mysql_connect("localhost","root","");
 mysql_select_db("mydb");
 $qry = mysql_query("select id_pegawai,nama_pegawai from pegawai");
 
 $sResult = "";
 $sResult .= "[";
 $firstRow = true;
 while ($row = mysql_fetch_assoc($qry)) {
 if ($firstRow) $firstRow = false; else $sResult .= ",";
 $sResult .= "{id:'" .$row["id_pegawai"]. "',name:'" .$row["nama_pegawai"]. "'}";
 }
 $sResult .= "]";
 
 mysql_free_result($qry);
 echo $sResult;
 exit;
 ?>[/code]

and this is your html [test.html]

[code=php]<html>
 <head>
 <script language="javascript" src="includes/prototype.1.5.1.js"></script>
 <script type="text/javascript">
 function reloadEmployee(){
 cleanEmployee();
 new Ajax.Request(
 "getlist.php",
 {
 method:'get',
 onComplete:function(transport){
 var emp = String(transport.responseText).evalJSON();
 var f = document.frm;
 $A(emp).each(
 function(key,index){
 f.employee.options[index] = new Option(key["name"],key["id"]);
 }
 );
 }
 }
 );
 }
 function cleanEmployee(){
 var emp = document.frm.employee.options;
 $A(emp).each(
 function (key,index) {
 key[index]=null;
 }
 )
 }
 </script>
 </head>
 
 <body>
 
 <form name="frm">
 select employee: <select name="employee"></select> <a href="javascript:reloadEmployee()">Reload Employee</a>
 </form>
 
 </body>
 </html>[/code]

don't forget download prototype.js library (i think is cool)

@PeuplarchieauthorNov 16.2007 — #I'm not using a db.

I can't on that server.

@yearbassNov 16.2007 — #no problem you are using db or not, the data in getlist.php not always get from db, it can get from text file instead, or read files from a directory.

but you need to decide the format for the result. in my example the format is in JSON (JavaScript Object Notation), you can use another format such as XML or another one, but JSON and XML are readable in javascript.

rreload a list box inside a form?

4 Comments(s) _↴

Also in #JavaScript _↴

Success!

Social

Version

rreload a list box inside a form?

4 Comments(s) ↴

Also in #JavaScript ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #JavaScript _↴