need help in update query
Posted on
16th Feb 2014 07:03 pm by
admin
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic form get pass to php file.
currently when i press submit it displays this and does not update fields
Code: UPDATE contacts SET name='Array', im='Array' WHERE userid='1'
this my code for dynamic form
Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<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 type="text/javascript" src="lib/jquery-1.4.min(Production).js"></script>
<script>
var id = 0;
function addFormField() {
//document.getElementById("id").value;
id++;
$("#divTxt").append(
"<p id='row" + id + "'><label>Relation <select name='relation[]' id='relation" + id + "'><option value='brother'>Brother</option><option value='sister'>Sister</option><option value='father'>Father</option><option value='mother'>Mother</option></select> <input type='text' name='name[]' /> <a href='#' onClick='removeFormField("#row" + id + ""); return false;'>Remove</a></p>"
);
}
function removeFormField(id) {
$(id).remove();
}
</script>
</head>
<body>
<form action="addDynamicFields.php" method="post" id="form1">
<label>Relation</label>
<select name="relation[]" id="relation0">
<option value="brother">Brother</option>
<option value="sister">Sister</option>
<option value="mother">Mother</option>
<option value="father">Father</option>
<option value="daughter">Daughter</option>
<option value="son">Son</option>
</select>
<input type="text" name="name[]" />
<div id="divTxt"></div>
<p><input type="submit" value="Submit" name="submit">
<!-- <input type="reset" value="Reset" name="reset"> --></p>
</form>
<p><a href="#" onClick="addFormField(); return false;">Add</a></p>
</body>
</html>
this is my php file
Code: <?php
$screenname = $_POST['relation'];
$name = $_POST['name'];
$connect = mysql_connect("localhost","user","pass");
mysql_select_db("test");
for($i=1; $i<count($screenname); $i++) {
//$imscreenname = $_POST['screenname'][$i];
//$imname = $_POST['name'][$i];
//echo $imscreename;
//$imscreenname = $screenname[$i];
$screennamesave = "UPDATE contacts SET name='$screenname', im='$name' WHERE userid='1'" or die(mysql_error());
$result = mysql_query($screennamesave);
echo $screennamesave;
}
?>
No comments posted yet
Your Answer:
Login to answer
170 
40 
Other forums
Vertical Alligning - Not working in 1 cell?
<?php
echo "<table id="valign" width="60%" style=
first id from db not showing
I have a php script which displays the content of a mysql table as a html table with sorting, delete
InternetOpenUrl() Invalid cert
Hi all,
Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro
Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora
Developing Ajax-enabled ASP.Net applications for the iPhone
I would like to develop Ajax web applications using Visual Studio that are optimized for the iPhone.
bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error
Do While statement
hi guys,
This may sound trivial but im new to php and as part of an assignmenti have to const
Quick Syntax Question
Hi folks,
I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b
fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw
Changing color in GD via variable?
Hey guys, I'm new here. x)
I'm very much a noob when it comes to PHP, but I'm trying to learn
