StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhy would an html text input name cause a submit input not to set?
primarykey
Id
14134622
data
AcceptedAnswerId
14171417
AnswerCount
3
ClosedDate
CommentCount
9
CommunityOwnedDate
CreationDate
2013-01-03T07:19:09.243
FavoriteCount
0
LastActivityDate
2013-01-05T11:42:34.717
LastEditDate
2013-01-04T10:42:39.280
LastEditorUserId
1728650
OwnerUserId
1728650
ParentId
0
PostTypeId
1
Score
0
ViewCount
96
LastEditorDisplayName
text
Body
<p>I have an <code>html</code> form, with 13 <code><input></code> fields and approx. 92 different rows, created using <code>php</code> which pulls the records from a <code>mySQL</code> database. For some reason when I have a name assigned to this one field, it causes my <code><input type="submit" name="update_submit"></code> button not to set. If I change the name, it doesn't matter, but if I remove the name it will allow the other fields to update just fine.</p> <p>Here is a snippet of my form code( <code>$i</code> is auto incremented):</p> <p>Up Top...</p> <pre><code><form method="post" action="process_form.php"> <table> <tr> </code></pre> <p>Further down...</p> <pre><code>echo "<td align=\"center\" class=\"edit_emp_comp_exp_cell\"><input type=\"text\" maxlength=\"10\" size=\"10\" id=\"Lic_Comp_Exp$i\" name=\"Lic_Comp_Exp[]\" value=\"" . $emp_query['Lic_Comp_Exp'] . "\">"; <input type="submit" name="update_submit" style="width:100px;" value="UPDATE"> </code></pre> <p>Further down...</p> <pre><code></tr> </table> </form> </code></pre> <p>Here is my process_form:</p> <pre><code>if(isset($_POST['update_submit'])) { $id = $_POST['Emp_ID']; $name = $_POST['Emp_Name']; $phone = $_POST['Emp_Phone']; $start = $_POST['Start_Date']; $leave = $_POST['Paid_Leave']; $aca = $_POST['Emp_ACA']; $licauth = $_POST['Lic_Auth_ID']; $authexp = $_POST['Lic_Auth_Exp']; $liccomp = $_POST['Lic_Comp_ID']; $compexp = $_POST['Lic_Comp_Exp']; $miscp = $_POST['MiscP_ID']; $position = $_POST['Pos_ID']; $active = $_POST['activeBox']; $i = 0; foreach($id as $update) { if (!isset($active[$i])) { $active[$i] = 0; } $sql = ("UPDATE employee SET Emp_Name = '$name[$i]', Emp_Phone = '$phone[$i]', Emp_Start_Date = '$start[$i]', Paid_Leave = '$leave[$i]', Emp_ACA = '$aca[$i]', Lic_Auth_ID = '$licauth[$i]', Lic_Auth_Exp = '$authexp[$i]', Lic_Comp_ID = '$liccomp[$i]', Lic_Comp_Exp = '$compexp[$i]', MiscP_ID = '$miscp[$i]', Pos_ID = '$position[$i]', Emp_Active = '$active[$i]' WHERE Emp_ID = '$update'"); echo "SQL: " . $sql . "<br>"; if(!$result_employee_update = $mysqli->query($sql)) { $errors[] = "There was an error updating the employee table. MySqli Error Number: " . $mysqli->errno . ""; goto end; } $i++; } goto redirect; } </code></pre> <p>I am at a total loss and have been troubleshooting this all morning, I would really appreciate some help.</p> <p><strong>UPDATE:</strong> When I change <code>if(isset($_POST['update_submit']))</code> to <code>if(!isset($_POST['update_submit']))</code> and run it, I get an error: </p> <pre><code>"Notice: Undefined offset: 83 ... on line 31" </code></pre> <p>and line 31 is my </p> <pre><code>`$sql = ("UPDATE employee SET Emp_Name = '$name[$i]', Emp_Phone = '$phone[$i]', Emp_Start_Date = '$start[$i]', Paid_Leave = '$leave[$i]', Emp_ACA = '$aca[$i]', Lic_Auth_ID = '$licauth[$i]', Lic_Auth_Exp = '$authexp[$i]', Lic_Comp_ID = '$liccomp[$i]', Lic_Comp_Exp = '$compexp[$i]', MiscP_ID = '$miscp[$i]', Pos_ID = '$position[$i]', Emp_Active = '$active[$i]' WHERE Emp_ID = '$update'");` </code></pre> <p>I think that means that one of my <code><input></code> is not an <code>array</code>, right? If that is so, I don't know how that can be, the <code>table</code> is there and its created dynamically from the <code>database</code>.</p> <p><strong>UPDATE2:</strong> I think I've got something figured out, but I don't know how to fix it. I tried leaving the <code>name="Lic_Auth_Exp"</code> and <code>name="Lic_Comp_Exp"</code> and then removing two different <code>name</code> attributes from other <code>input</code> fields. After doing that it seemed to run the code. So the problem isn't because of these specific fields, but it seems to be because of there being more than 11 <code>$_POST</code> values being passed. I looked through the <code>php.ini</code> file to see if there were any limits on such a thing, but I didn't see anything. Does anyone know what could be causing this??</p>
Tags
<php><html><mysql>
Title
Why would an html text input name cause a submit input not to set?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAndrew Fox
UserOwnerUserId
1. USAndrew Fox
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.