Javascript:Combobox creation taking data from DB On button click

Manashi · 03-30-2006, 06:37 AM

hi...
i am working on PHP with PostgreSQL as DB..OS is LINUX
Both r very New to me...
how to show options in a combobox by takein data from database
+
same combobox along with the data in it should get created every time a button is clicked

Expecting REply....

graemef · 03-30-2006, 11:54 AM

What you need to do is:

Connect to the database
Make you database call, selecting the data that you want
open an HTML select tag
Loop through this data inserting the appropriate HTML: option tags for each database entry
close the select tag

But take it in small steps, checking that at each stage it is working correctly.

graeme.

tangle · 03-30-2006, 12:52 PM

Are you wanting to make a drop down box that lists all data in a column in a certin table? If so, do something like this (it is an example that uses MySQL).

Code:

$database = "db";
$connection = "localhost";
$username = "dbadmin";
$password = "password";

echo "<form action=search_result.php method=POST>";

@ $db = MYSQL_PCONNECT($connection, $username, $password);
mysql_select_db($database);
if (!$db)
  {
    echo "Could not connect to database!";
    exit;
  }

echo "<table width='100%'>";

// Select Data
echo "<tr><td width='25%'>";
echo "<font size=4>Data: </font></td>";
echo "<td>";
$query = "SELECT DataName FROM DataType";
$result = mysql_query($query);
if(mysql_num_rows($result))
  {
    echo "<select name=Dname>";
    while($row = mysql_fetch_row($result))
      {
        print("<option value=\"$row[0]\">$row[0]</option>");
        echo "<br>";
      }
  }
else
  {
    print("<option value=\"\">No data created yet</option>");
  }
echo "</td></tr>";
?>

graemef · 03-30-2006, 04:19 PM

Just a couple of comments to the code tangle provided.

The <br> is not necessary, although a \n would made the generated html easier to read.

The select tag should be closed, after while, giving...

Code:

if(mysql_num_rows($result))
  {
    echo "<select name=Dname>";
    while($row = mysql_fetch_row($result))
      {
        echo "<option value=\"$row[0]\">$row[0]</option>\n";
      }
    echo "</select>";
  }

Manashi · 03-31-2006, 03:02 AM

hi...
thanks 4 the reply...
i am also doing the same thing...
but when i am clicking a button to create another select box its not containing the same data....
already i hav select box with the options from DB in the table...
its like drop down list
i hav used javascript for the button name "MORE"...
The code is as follows :-

Quote:

Inside the form tag the code is as follows :-

Quote:

<form name="criteria_frm" action="file.php?group=criteria_frm.grp_id.value" method="POST">

<tr><td bgcolor="#FFFFFF">
<select name="subject_id[]">
<option value="-1">[All Subjects]</option>
<?php
$s = "select id, title from category order by title";
$conn = getConnection();
$rs = pg_query($s);
if($rs!=null)
{
while($row = pg_fetch_row($rs))
{
echo "<option value=\"$row[0]\">".addslashes(chop($row[1]));
pg_free_result($rs);
}
pg_close($conn);
?>
</select>
</td>
<input type="button" onclick="return addRow(document.criteria_frm)" value="More">

nickwelhar · 03-12-2015, 02:38 AM

Try with.......Javascript Combobox

Nick