[SOLVED] Populating textboxes upon selecting from dropdown control

[dualshock03]

pratically im stilll a newbie to this PHP Dreamweaver coding.. and im still on the basics using notepad..

 

i want to know how to populate the data to  the textbox and labels upon selecting a "record"/ or a "word" list,  from a drop down list control in dreamweaver... the drop down list is database dependent " i mean the lists are from the database and then whenever i choose one list, its corresponding records will appear from the lables, textboxes some list/menus..

 

Hope anyone will give me some good samples.. cheers!!

[p2grace]

You'll either need to use ajax to display it, or generate all of the javascript when the page is accessed and use javascript to do it.  Easiest method would probably be ajax.

[benphp]

onchange="javascript:document.myform.mytextbox.value=document.myform.mylist.value"

 

[947740]

onchange="javascript:document.myform.mytextbox.value=document.myform.mylist.value"

 

You could just make a function and call the function, passing a paramater too.

[dualshock03]

Anyway what about this ajax? i dont know how to use it.. easiest?

[947740]

All I know about AJAX is that it can be used to update webpages without having to reload the webpage.  It is an entirely different language, but there are going to be scripts on the internet that you could use for your own use (at least I would imagine there would be).

[p2grace]

Check into xajax, I use it religiously

 

http://xajaxproject.org

 

 

[dualshock03]

hey guys... im coming back to this thread... what if i want to generate its corresponding column records in the database just like searching records:

 

(DROP DOWN)= list are from the db in column "towname"

 

-town1

-town2

-town3

 

----------------

when i click one of the lists... "for exmple i choose "town1" "

then the result on the textbox, labels, and some imageplaceholders will be...

 

textbox = population data of town1

label =  town name data of town1

image placeholder = image data of town1

etc...

 

how will i code it in javascript or in PHP??

 

 

 

 

 

[dualshock03]

anyone??

 

generating its corresponding column records in the database just like searching records:

 

(DROP DOWN CONTROL)= list are from the db in column "towname"

 

-town1

-town2

-town3

----------------

when i click one of the lists... "for exmple i choose "town1" "

then the result on the textbox, labels, and some imageplaceholders will be...

 

textbox = population data of town1

label =  town name data of town1

image placeholder = image data of town1

etc...

 

how will i code it in javascript or in PHP??

 

 

[attachment deleted by admin]

[DarkWater]

Okay.  We understand what you said.  You need to use Ajax to get the information from the PHP page and the database.  We are NOT coding it for you, but we will help you code it.

[dualshock03]

Ok.. im doing it with dreamweaver.. Using Spry Control

[dualshock03]

ok  i already try this codings.. but the result is... all the controls are empty.. the drop down,textbox and the rest became empty.. conflict on mysql query i think..

 

 

mysql query:

 

if (isset($_GET['towname'])) {
  $coldata_list_town_rec = $_GET['towname'];
}
mysql_select_db($database_mySQL, $mySQL);

$query_list_town_rec = sprintf("SELECT towname, num_brgy, townhistory, townborn, town_pop, general_info FROM tbltowns where towname LIKE %s ", GetSQLValueString("%" . $coldata_list_town_rec . "%", "text"));

$list_town_rec = mysql_query($query_list_town_rec, $mySQL) or die(mysql_error());
$row_list_town_rec = mysql_fetch_assoc($list_town_rec);
$totalRows_list_town_rec = mysql_num_rows($list_town_rec);
?>

 

 

<form action="/lcr8/townspots.php" method="post" name="formdropdown" id="formdropdown">
    <label> </MM:DECORATION>
    </MM_REPEATEDREGION>
    <MM_REPEATEDREGION SOURCE="@@rs@@">
    </label>
    <span id="spryselect1">
    <label>
    <select name="towname" id="towname">
      <option value="value">Select Municipality...</option>
      
<?php
          do {  ?>
      <option value="<?php echo $row_list_town_rec['towname']?>"><?php echo $row_list_town_rec ['towname']?></option>
      <?php
} while ($row_list_town_rec = mysql_fetch_assoc($list_town_rec));
  $rows = mysql_num_rows($list_town_rec);
  if($rows > 0) {
      mysql_data_seek($list_town_rec, 0);
  $row_list_town_rec = mysql_fetch_assoc($list_town_rec);
  }
?>
    </select>
    </label>
    <span class="selectRequiredMsg">Please select an item.</span>    </span>
  </form>

[dualshock03]

what will be?

 

[dualshock03]

MY TOPIC IS SOLVED thanks for the tips!

 

i just found this forum page which has match similar to my problem and it worked for me..

so easy to say than really done..

 

http://www.webmasterworld.com/forum88/6628.htm