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.....
Related Tutorials/Questions & Answers:
Advertisements
drop down php mysql - PHPdrop 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 listview 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
validation for drop down listvalidation for
drop down list Hi all
I have a form, it contain 12
drop down list. Each
drop down has 1 to 5 values,i need to validate this form. the following condition should be true.
1.you can choose only 3 times 5 value.
2
dynamic drop down listdynamic
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
Get values in drop down listGet 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
html menu button drop downhtml 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
Adding checkbox in table using that delete table rowsAdding 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
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
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... into
add the records or
rows to the
table
'Stu_
Table'.
SQL statement
Dependant & dynamic drop down listDependant & 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 databaseDrop 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
dynamic drop down list box - Java Beginnersdynamic
drop down list box hi all ,
I want to
dynamically populate a
drop down box from an sql query in a servlet program,
using only
html... servlet comes under server side code.
if not
using servlet store the all data
Excel Cell Drop Down ListExcel 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
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
Drop-down text selection in jsp/htmlDrop-
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
Select functionality of drop down list - Struts(in struts application) in which if user select HIDE from the
drop down list... have
Drop down list having element Test1,Test2,Test3,HIDE and one Text msg box for entering Age,Now if user select "HIDE" from
drop-
down list the below text
Dependant & dynamic drop down list - Follow upDependant & 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
PHP AJAX DropdownAjax
Drop-
down list:
In this current tutorial we will see how to connect a simple
drop down menu and mysql
table using php and JavaScript (Ajax as whole) and to
display the related data on the screen from the
table.
In this tutorial
creation of drop down menu using ajax in java - Ajaxcreation of
drop down menu
using ajax in java Hi,
Here I want to create a
drop down menu
using ajax in ofbiz framework.
I want to fetch the data from database.I got examples
using asp.net and
php
but I am not getting
Drop Table
Drop Table
Drop Table in SQL get rid of an object or
table from the database.
Using a
drop Query...
The insert into
add the records or
rows to the
table
'Stu_
Table'.
SQL statement
drop downdrop down how can i
add data from choice/dropdown component of java awt to myaql
table