Hello,
I ve created a php form for user registration in which have also used the drop down boxes.
I want that data in the drop down box should be taken from mysql database.
The data in qualification drop down should be taken from database and depending on what the user selected in qualification it should take the corresponding data for specialization drop down again from database itself. How can this be done. Im stuck up with it.
Plz help me for this.
26  4572 
Show any code you have developed (within the appropriate code tags PLEASE) and we will look at it.
Ronald
hi,
thanks. Ive uploaded the txt file of the html code i developed. I want this to be in php. The Qualification, Specialization, Role, etc. are drop down boxes for which i need to take data from database. In this code i ve manually specified the values.
In this there are only certain values inserted. I ll b adding more if i get it done thru database.
Plz check this out.
hi,
thanks. Ive uploaded the txt file of the html code i developed. I want this to be in php. The Qualification, Specialization, Role, etc. are drop down boxes for which i need to take data from database. In this code i ve manually specified the values.
In this there are only certain values inserted. I ll b adding more if i get it done thru database.
Plz check this out.
I assume the options will be static once populated from the database? If so, you should be able to use php (make sure your server/host is configured to allow php--most are now days) to query the database and populate the list. Check out www.php.net for more.
Here's an example: -
$query = "SELECT options FROM qualifications";
-
$result = mysql_query($query,$link);
-
if(!$result) {
-
die(mysql_error());
-
}
-
-
while($row = mysql_fetch_row($result)) {
-
$list[] = $row[0];
-
}
-
Where $link is a valid mysql database connection and $list is the array of your options.
The next code can (when adapted) also be used for the other 3 select lists:[php]<?php
// Make connection to server and database
$conn = mysql_connect($dbhost, $dbuser, $dbpass)
or die('Error connecting to mysql');
mysql_select_db('DB_name');
// select the data from db
$result = mysql_query( "SELECT * FROM table_name" )
or die("SELECT Error: ".mysql_error());
// start the select list
echo '<select name="AreaName" id="AreaName">';
echo '<OPTION value="" selected>-Select-</OPTION>';
// read each row field and build option list
while ($row = mysql_fetch_assoc($result)) {
$field_name=$row['field_name'];
print "<option value='$field_name'>$field_name</option>";
}
// close the select list
print "</select>";[/php]Ronald
hi,
I saw ur code. Bt im not able to egt the data from database. Im not geting where to place it exactly in the php code. The table name from which ive to take info is admin. The fields in it are QualificationId and QualificationName in which the data to be viewed by the user is there. Ive attached my php file plz help me in teling how exactly it wil be placed.
Thanks a lot
When you say "I am not able to get the data from the database"when what is the point of this exercise?
If you don't have the data from the db, then you cannot fill the drop down list.
So what is then the problem? Please describe it in understandable english, so I do not have toi guess what you mean.
Ronald
I have filled the data in database. I tried the code u gave me. Using that i was not able to get the data in drop down box. I wanted to know exactly where in my code it ll b placed so that it should retrieve the data.
Thanks.
It is not that difficult, just replace the build select list with name 'Areaname' in your code with the PHP code I showed in my previous post.
So replace this code - <select name="AreaName" id="AreaName">
-
<OPTION value="" selected>-Select-</OPTION>
-
<OPTION>Corporate Planning/Consulting</OPTION>
-
<OPTION>Engineering Design/R and D</OPTION>
-
<OPTION>HR/Administration/IR</OPTION>
-
<OPTION>IT Software-Client Server</OPTION>
-
<OPTION>IT Software-Mainframe</OPTION>
-
<OPTION>IT Software-Middleware</OPTION>
-
<OPTION>IT Software-Mobile</OPTION>
-
<OPTION>IT Software-Other</OPTION>
-
<OPTION>IT Software-System Programming</OPTION>
-
<OPTION>IT Software-Telecom Software</OPTION>
-
<OPTION>IT Software-Application Programming/Maintenance</OPTION>
-
<OPTION>IT Software-DBA/Datawarehousing</OPTION>
-
<OPTION>IT Software-E-Commerce/Internet Technologies</OPTION>
-
<OPTION>IT Software-Embedded/EDA/VLSI/ASIC/Chip Des.</OPTION>
-
<OPTION>IT Software- ERP/CRM</OPTION>
-
<OPTION>IT Software-Network Administration/Security</OPTION>
-
<OPTION>IT Software-QA and Testing</OPTION>
-
<OPTION>IT Software-Systems/EDP/MIS</OPTION>
-
<OPTION>IT-Hardware/Telecom/Technical Staff/Support</OPTION>
-
<OPTION>ITES/BPO/KPO/Customer Service/Operations</OPTION>
-
<OPTION>Site Engineering/Project Management</OPTION>
-
<OPTION>Web/Graphic Design/Visualiser</OPTION>
-
<OPTION>Other</OPTION>
-
</select>
with this code[php]<?php
// Make connection to server and database
$conn = mysql_connect($dbhost, $dbuser, $dbpass)
or die('Error connecting to mysql');
mysql_select_db('DB_name');
// select the data from db
$result = mysql_query( "SELECT * FROM table_name" )
or die("SELECT Error: ".mysql_error());
// start the select list
echo '<select name="AreaName" id="AreaName">';
echo '<OPTION value="" selected>-Select-</OPTION>';
// read each row field and build option list
while ($row = mysql_fetch_assoc($result)) {
$field_name=$row['field_name'];
print "<option value='$field_name'>$field_name</option>";
}
// close the select list
print "</select>";[/php]When you have done that and understand the php code, you then know how to dynamically build a drop down list in PHP, and you can do the other drop down lists populates yourself.
Ronald
Hi,
I ve placed that code as you told in my php file and tried to execute it. The drop down box is seen but the values are not displayed in it. Only select is displayed and when i click on it it shows everything blank. I ve the data in database. Ive pasted the code which i used according to the table names. Plz check this. -
<?php
-
-
// Make connection to server and database
-
$dbi=mysql_connect($hostname, $db_user, $db_password)
-
or die('Error connecting to mysql');
-
mysql_select_db($db_name,$dbi);
-
-
// select the data from db
-
$result = mysql_query( "SELECT * FROM admin" )
-
or die("SELECT Error: ".mysql_error());
-
-
// start the select list
-
echo '<select name="QualificationName">';
-
echo '<OPTION value="" selected>-Select-</OPTION>';
-
-
// read each row field and build option list
-
while ($row = mysql_fetch_assoc($result)) {
-
$field_name = $row['field_name'];
-
print "<option value='$field_name'>$field_name</option>";
-
}
-
-
// close the select list
-
print "</select>";
-
?>
-
I can cook it but I will not eat it!!
You have to do something yourself on the code. How can you copy this field field_name literally? It is an example of course. How would I knmow what the name of your db field is?
So YOU have to change those statement with $field_name = $row['field_name']; into the name that is in your database!!
Ronald
Hi,
That problem has got solved and it is working now.
Now i wanted dt when a user selects a qualification name then the coresponding specializations should be displayed in the drop down menu. So do i ve to use a query where in it compares the qualification id coz in specialization table i ve a field called qualificationid.
How can this be done. Thanks a lot.
This goes exactly in the same way as the one you just implemented. You only must change your select statement, the rowid and the name of the select list.
Ditto for the other ones. Just take the code I showed you and adapt it to the other drop down select lists.
Ronald
Ive used the same code for others and it is working but in case of specialization my need is different. How can i get the qualificationId for the qualification name that the user selected. Each qualification has diferent specialization list. Depending on the qualification selected specializaton list should be displayed. The qualification Id is stored in the same table where the drop down list of names is stored. There is a id for each name. Im not able to retrieve the qualification id of the qualification selected to modify my select statement. Plz let me know.
I have no idea what you are talking about. And it does not correspond with any code you showed.
Anyway, the problem for which you opened this thread is answered and solved.
Now you are asking for us to write more code for you without showing what you have done yourself to solve it. And we are not here to write your code.
So explain in a little more detail in plain and concise english, what the problem now is.
What specializationID, nowhere to be seen!
Ronald
The code which i sent you in that the specialization drop down box is defined for particular set of values. In my project specialization selection differs based on qualification selected. For eg. if the user selects B.E. as qualification then a particular set of specialization drop box should be displayed whereas if the user selects B.Sc as qualification then another set of specialization values should be displayed. Can it be done using php or have i to use javascript for it.
Thanks.
If you want to dynamically populate a new drop down box without having a submit been issued, you must use JavaScript (Ajax) to do that.
Ronald
Thanks alot. You were a great help.
You are welcome. See you next time in this forum.
Ronald
hi,
I had a problem with htose drop downs. Im not able 2 retrieve the selected values. For eg. if the user has selected a particular area name then i want its coresponding id to b stored in the database. Bt im not able 2 store it neither in database nor in a variable.
There is no area ID in your option list, just the description and that is what is passed to you.
If you want to associate an options description with an ID and have that passed, you must add the value attribute to the option statement, such as [php]<option value='1'>area of interest</option>[/php]Ronald
In the functional area drop down i passed the id also using the following code shown below. -
<?php
-
-
// Make connection to server and database
-
$dbi=mysql_connect($hostname, $db_user, $db_password)
-
or die('Error connecting to mysql');
-
mysql_select_db($db_name,$dbi);
-
-
// select the data from db
-
$query = mysql_query("SELECT AreaName,FunctionalAreaId FROM functionalarea")
-
or die("SELECT Error: ".mysql_error());
-
-
// start the select list
-
echo '<select name="AreaName" value="FunctionalAreaId">';
-
echo '<OPTION value="" selected>-Select-</OPTION>';
-
-
// read each row field and build option list
-
while($row = mysql_fetch_array($query)) {
-
echo("<option value=$row[FunctionalAreaId]>$row[AreaName]</option>");
-
}
-
-
// close the select list
-
echo "</select>";
-
?>
-
Bt im not able to retrieve FunctionalAreaId value of selected AreaName in my insert statement.
There is no FunctionalAreaId variable in sight in the code that you showed us.
Ronald
Its there in select statement on line 9 and on line 13
In the file i attached below i want to insert it in the database using the query on line 253. but its not geting inserted.
My previous problem has yet not solved. Ive tried a code for which you told to use javascript. I first tested it on a small database all work fined but its not working with my project database. Again its not displaying any values on the form. The code that i ve used is pasted below. Plz check it n let me know if theres an error somewhere around. -
-
<?php
-
-
// Make connection to server and database
-
$dbi=mysql_connect($hostname, $db_user, $db_password)
-
or die('Error connecting to mysql');
-
mysql_select_db($db_name,$dbi);
-
-
// select the data from db
-
$query = mysql_query("SELECT * FROM qualification")
-
or die("SELECT Error: ".mysql_error());
-
-
// start the select list
-
echo '<select name="QualificationName">';
-
echo '<OPTION value="" selected>-Select-</OPTION>';
-
-
// read each row field and build option list
-
while($row = mysql_fetch_array($query)) {
-
echo "addOption(document.drop_list.Qualification, '$row[QualificationId]', '$row[QualificationName]');";
-
//echo("<option>$row[QualificationName]</option>");
-
}
-
// close the select list
-
echo "</select>";
-
?>
-
-
function addOption(selectbox, value, text )
-
{
-
var optn = document.createElement("OPTION");
-
optn.text = text;
-
optn.value = value;
-
-
selectbox.options.add(optn);
-
}
-
-
Hi,
All my problem is solved. Now only i am not able to insert the value of selected name in drop down into database. Plz help me out with this. Just tell me what i should do to store that data.
Thanks a lot.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: julian |
last post by:
hi
I was wondering if anyone can help me out on this....
I have dynamcally populated a drop down menu with data from an access
database using ASP. The values seem fine, however when i pass...
|
by: Greg Scharlemann |
last post by:
I am attempting to populate a drop down menu based on the selection of
a different drop down menu. However, it is not working correctly, I
cannot figure out for the life of me what exactly happens...
|
by: Greg Scharlemann |
last post by:
I would like to automatically populate a drop down menu when the page
loads based on the selection of an item in a different drop down menu.
I made a test page that when drop down #1 changes, drop...
|
by: SirPoonga |
last post by:
Lets say I have a couple of tables in a database containg car make,
type, and model. I want to create a drop down box that is populated by
the makes. Based on that selection run a query to get...
|
by: Miguel Dias Moura |
last post by:
Hello,
i have an ASP.NET / VB page where i have a few 4 groups of Drop Down Lists.
Each group of Drop Down Lists include 3 Drop Down Lists for date such as:
DAY, MONTH, and YEAR.
I don't want...
|
by: Yi Chen |
last post by:
We have a drop down list on a PHP page, with several product names, and
when people click one item, we will refresh the same page with the
product name as parameter, and in turn we want to include...
|
by: rubinamunir |
last post by:
I need three drop down states,country,cities. States will populate from db then on the selection of state ..the list of coutries will populate and when select a country .its cities list will...
|
by: bips2005 |
last post by:
i need to populate drop down box with database values. i have a field customername from table customer and i want a function that populates drop down in html with the values of this field. we have to...
|
by: jagdeep gupta |
last post by:
How to add data from database in drop down list manually?
I have added it as:
In the database table name tbldate there is field day and I have to add all these dates manually as:
dropdownlist1...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
