Add/Remove Rows Dynamically with drop down list in html table using php
Here Is My Code.
I want to give and get the id of drop down list.
Can Anyone Help?
Dropdowndesign.php
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="ddljs1.js">
</script>
</head>
<body>
<form>
<table border="1" id="tblSample">
<tr>
<th>Name</th>
<th>Add Field</th>
</tr>
<tr>
<td>
<div id="emp">
<select id="namesel">
<option>Select Name</option>
<?php
include("db.php");
$result=mysql_query("select * from test");
while($row=mysql_fetch_assoc($result))
{
echo "<option>".$row['Name']."</option>";
}
?>
</select>
</div>
</td>
<td><input type="button" value="Add" id="nameselbtn" onclick="javascript:addrow();" /></td>
</tr>
</table>
</form>
</body>
</html>
dropdownjavascript.js
var xmlHttp
xmlHttp=GetXmlHttpObject()
var divid="";
function addrow()
{
var tbl = document.getElementById('tblSample');
var lastRow = tbl.rows.length-1;
var iteration = tbl.tBodies[0].rows.length;
var row =tbl.tBodies[0].insertRow(-1);
var cellRightSel = row.insertCell(0);
var di1=document.createElement('div');
di1.id= 'emp' + iteration;
var newCell1 = row.insertCell(1);
var el1 = document.createElement('input');
el1.type = 'button';
el1.value= 'Add';
el1.id = 'nameselbtn' + iteration;
el1.onclick = addrow;
newCell1.appendChild(el1);
cellRightSel.appendChild(di1);
cellRightSel.appendChild(showEmp(di1.id));
}
function showEmp(str)
{
if (typeof XMLHttpRequest != "undefined")
xmlHttp= new XMLHttpRequest();
else if (window.ActiveXObject)
xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
if (xmlHttp==null)
{
alert("Browser does not support XMLHTTP Request")
return;
}
xmlHttp.onreadystatechange = function()
{
if(xmlHttp.readyState==4)
document.getElementById(str).innerHTML=xmlHttp.responseText
}
xmlHttp.open("GET", "ddl_code.php?q="+str, true);
xmlHttp.send(null);
}
dropdowncode.php
<?php
$buffer="";
echo '<select name="emp"><option>Select</option>';
include('db.php');
$result=mysql_query("select * from test");
while($row=mysql_fetch_array($result))
{
echo "<option>".$row['Name']."</option>";
}
echo "</select>";
?>
View Answers
January 7, 2012 at 3:58 PM
January 17, 2012 at 5:16 PM
so simple..
first display all record in drop down menu.. using php. its easy..
then in second page u just show all the record from the db which is u showing in dropdown menu. in this list display two options Update and Delete. when u click Update it will display record below in text box and update button. and when u click Delete record will be delete.
when u c the dropdonw menu u can c the dynamically changed..
its easy..
January 18, 2012 at 11:06 AM
got it. waiting your reply.....
Ads
Related Tutorials/Questions & Answers:
Advertisements
drop down php mysql - PHP
drop down php mysql
PHP Script required to show the similar
drop down item in each menu without refreshing the page. Is it possible if yes how
view data from database using drop down list
view data from database
using drop down list hi i want to view the data from database by selecting a value in a
drop down list. for an example
drop down list have picture element.when click it select pictures from the database
How to create a dependent drop down list using [Apache POI]
How to create a dependent
drop down list using [Apache POI] Here I.... In that two
drop down list are there. Want to create a
drop down list that depends..., and "rice, curd, milk" items will appear in the dependent
drop down list in cell
How to create a dependent drop down list using [Apache POI]
How to create a dependent
drop down list using [Apache POI] Here I.... In that two
drop down list are there. Want to create a
drop down list that depends..., and "rice, curd, milk" items will appear in the dependent
drop down list in cell
Dependent drop down list
dependent
drop down list is used my code is successful but when i select class from first
drop down list all the data get lossed means the value entered in fields before
drop down list get blank.what can i do for this?
This is the code
dynamic drop down list
dynamic
drop down list I want to create 2
drop down list, where it takes value from database and the two
list are dependent..means if I select a particular value from one the other
list is developed accordingly..depending
Adding checkbox in table using that delete table rows
Adding checkbox in
table using that delete
table rows I need coding for how to
add checkbox in
table,the
table data from database.Using that checkbox select more than than one
rows,and
using delete button i want to delete
Get values in drop down list
Get values in
drop down list Pls provide me jsp code to get values in
drop down list from another
table's field.
my project has customer... in
drop down box in front end..... pls provide me code.. thanx
Drop Table
;
Drop Table in SQL get rid of an object or
table from the database.
Using a
drop Query get rid of all the
rows deleted from the
table and the structure...));
Insert Data into Stu_
Table
The insert into
add the records or
rows
html menu button drop down
html menu button
drop down How to create a menu button in
HTML?
<select id="category">
<option value="1">One</option>
<option value="2">Two</option>
</select>
<select id
Login With Drop Down, Having Departments in different table
the
HTML page in such a way the I have a
drop down list consisting of Customs... have a
drop down list box with Customs and Accounts..A Username and a Password... to login when I select department from the
drop down list. Since I cannot populate
Dependant & dynamic drop down list
Dependant & dynamic
drop down list I don't know this should be in this or AJAX forum.
I have one dynamic
drop down list from data base (working... on the values selected by user in first
drop down list.
How to achieve this ?
 
Drop down list from database
Drop down list from database Hi, Can I know how do we get the
drop down list from database? Eg: select country--select state--select district--so..., we have created two database tables:
CREATE
TABLE `country
Excel Cell Drop Down List
Excel Cell
Drop Down List
In this section, you will learn how to validate data entered in a cell and
provide a
drop down list of possible values to the user... in a excel sheet's
cell and also can provide
drop list of possible value
Drop-down text selection in jsp/html
Drop-
down text selection in jsp/html Hi,
I am trying to create JSP page where I have two
drop-downs. There are two-sets of data - First set....
Now the first dropdown will have all the values. The second
drop-
down depends upon
store values of drop down list box in database
store values of
drop down list box in database how to store values of
drop down list box in oracle database in jsp?I have information inserting form where i have date of birth as
drop down list box
Dependant & dynamic drop down list - Follow up
Dependant & dynamic
drop down list - Follow up Thanks for your answer. As per your answer
This will select only ONE row (country) from first
drop down. In my case user can choose more than one row , which is then sent to next