update the rows in the database using the same form

Question

flforlife 0 Newbie Poster

16 Years Ago

Ok what I want to do is update rows in MySQL using the same form that I posted. I'm a php mysql noob but I can't read code and figure out what it does.

This is my input form......

<form method='post' enctype='multipart/form-data' action="majoradd.php">
<table>
<tr>
<td>Do not enter in this field.</td>
<td>teamone</td>
<td>teamtwo</td>
<td>teamthree</td>
<td>teamfour</td>
<td>teamfive</td>
<td>teamsix</td>
<td>teamseven</td>
<td>Do not enter in this field.</td>
</tr>
<tr>
<td><input name="entrytwo[7][teamb]" type="text" /></td>
<td><input name="entrytwo[7][team]" type="text" /></td>
<td><input name="entrytwo[7][wl]" type="text" /></td>
<td><input name="entrytwo[7][gb]" type="text" /></td>
<td><input name="entrytwo[7][pcage]" type="text" /></td>
<td><input name="entrytwo[7][rs]" type="text" /></td>
<td><input name="entrytwo[7][ra]" type="text" /></td>
<td><input name="entrytwo[7][ags]" type="text" /></td>
<td><input name="entrytwo[7][records]" type="text" /></td>
</tr>

<!--row one-->
<tr></tr>
<tr></tr>
<tr>
<td>teamone</td>
<td>Win-Lose</td>
<td>Win-Lose</td>
<td>Win-Lose</td>
<td>Win-Lose</td>
<td>Win-Lose</td>
<td>Win-Lose</td>
<td>Win-Lose</td>
<td>record</td>
</tr>
<!--row one-->

<tr>
<td><input name="entrytwo[8][teamb]" type="text" /></td>
<td><input name="entrytwo[8][team]" type="text" /></td>
<td><input name="entrytwo[8][wl]" type="text" /></td>
<td><input name="entrytwo[8][gb]" type="text" /></td>
<td><input name="entrytwo[8][pcage]" type="text" /></td>
<td><input name="entrytwo[8][rs]" type="text" /></td>
<td><input name="entrytwo[8][ra]" type="text" /></td>
<td><input name="entrytwo[8][ags]" type="text" /></td>
<td><input name="entrytwo[8][records]" type="text" /></td>
</tr>
<tr>
<td><input name="entrytwo[9][teamb]" type="text" /></td>
<td><input name="entrytwo[9][team]" type="text" /></td>
<td><input name="entrytwo[9][wl]" type="text" /></td>
<td><input name="entrytwo[9][gb]" type="text" /></td>
<td><input name="entrytwo[9][pcage]" type="text" /></td>
<td><input name="entrytwo[9][rs]" type="text" /></td>
<td><input name="entrytwo[9][ra]" type="text" /></td>
<td><input name="entrytwo[9][ags]" type="text" /></td>
<td><input name="entrytwo[9][records]" type="text" /></td>
</tr>
<tr>
<td><input name="entrytwo[10][teamb]" type="text" /></td>
<td><input name="entrytwo[10][team]" type="text" /></td>
<td><input name="entrytwo[10][wl]" type="text" /></td>
<td><input name="entrytwo[10][gb]" type="text" /></td>
<td><input name="entrytwo[10][pcage]" type="text" /></td>
<td><input name="entrytwo[10][rs]" type="text" /></td>
<td><input name="entrytwo[10][ra]" type="text" /></td>
<td><input name="entrytwo[10][ags]" type="text" /></td>
<td><input name="entrytwo[10][records]" type="text" /></td>
</tr>
<tr>
<td><input name="entrytwo[11][teamb]" type="text" /></td>
<td><input name="entrytwo[11][team]" type="text" /></td>
<td><input name="entrytwo[11][wl]" type="text" /></td>
<td><input name="entrytwo[11][gb]" type="text" /></td>
<td><input name="entrytwo[11][pcage]" type="text" /></td>
<td><input name="entrytwo[11][rs]" type="text" /></td>
<td><input name="entrytwo[11][ra]" type="text" /></td>
<td><input name="entrytwo[11][ags]" type="text" /></td>
<td><input name="entrytwo[11][records]" type="text" /></td>
</tr>
<tr>
<td><input name="entrytwo[12][teamb]" type="text" /></td>
<td><input name="entrytwo[12][team]" type="text" /></td>
<td><input name="entrytwo[12][wl]" type="text" /></td>
<td><input name="entrytwo[12][gb]" type="text" /></td>
<td><input name="entrytwo[12][pcage]" type="text" /></td>
<td><input name="entrytwo[12][rs]" type="text" /></td>
<td><input name="entrytwo[12][ra]" type="text" /></td>
<td><input name="entrytwo[12][ags]" type="text" /></td>
<td><input name="entrytwo[12][records]" type="text" /></td>
</tr>
<tr>
<td><input name="entrytwo[13][teamb]" type="text" /></td>
<td><input name="entrytwo[13][team]" type="text" /></td>
<td><input name="entrytwo[13][wl]" type="text" /></td>
<td><input name="entrytwo[13][gb]" type="text" /></td>
<td><input name="entrytwo[13][pcage]" type="text" /></td>
<td><input name="entrytwo[13][rs]" type="text" /></td>
<td><input name="entrytwo[13][ra]" type="text" /></td>
<td><input name="entrytwo[13][ags]" type="text" /></td>
<td><input name="entrytwo[13][records]" type="text" /></td>
</tr>
<tr>
<td><input name="entrytwo[14][teamb]" type="text" /></td>
<td><input name="entrytwo[14][team]" type="text" /></td>
<td><input name="entrytwo[14][wl]" type="text" /></td>
<td><input name="entrytwo[14][gb]" type="text" /></td>
<td><input name="entrytwo[14][pcage]" type="text" /></td>
<td><input name="entrytwo[14][rs]" type="text" /></td>
<td><input name="entrytwo[14][ra]" type="text" /></td>
<td><input name="entrytwo[14][ags]" type="text" /></td>
<td><input name="entrytwo[14][records]" type="text" /></td>
</tr>
<tr>
<td><input name="entrytwo[15][teamb]" type="text" /></td>
<td><input name="entrytwo[15][team]" type="text" /></td>
<td><input name="entrytwo[15][wl]" type="text" /></td>
<td><input name="entrytwo[15][gb]" type="text" /></td>
<td><input name="entrytwo[15][pcage]" type="text" /></td>
<td><input name="entrytwo[15][rs]" type="text" /></td>
<td><input name="entrytwo[15][ra]" type="text" /></td>
<td><input name="entrytwo[15][ags]" type="text" /></td>
<td><input name="entrytwo[15][records]" type="text" /></td>
</tr>
</table>
<input type='submit' name='btngub' value='Submit'>
</form>

This is the code that adds the data to the database....

<?php

if (isset($_POST['btngub']))
{
	//check for records later i
    $sql = "INSERT INTO majortwo (teamb, team, wl, gb, pcage, rs, ra, ags, records) VALUES\n ";
	

    foreach ($_POST['entrytwo'] as $data)
    {
        $dataArray[] = "('" . join ("','", $data) . "')";
    }

    $sql .= join (",\n", $dataArray);
   

    /*echo '<pre>', $sql, '</pre>';    */         // view query
    mysql_query($sql) or die(mysql_error());
	header("location:setup.html"); 
	
}

mysql_close($mysql) 
?>

This is the database.sql ...

CREATE TABLE majortwo (
  id INT NOT NULL AUTO_INCREMENT,
  teamb VARCHAR(65) NOT NULL DEFAULT '', 
  team VARCHAR(65) NOT NULL DEFAULT '',
  wl VARCHAR(65) NOT NULL DEFAULT '',
  gb VARCHAR(65) NOT NULL DEFAULT '',
  pcage VARCHAR(65) NOT NULL DEFAULT '',
  rs VARCHAR(65) NOT NULL DEFAULT '',
  ra VARCHAR(65) NOT NULL DEFAULT '',
  ags VARCHAR(65) NOT NULL DEFAULT '',
  agstwo VARCHAR(65) NOT NULL DEFAULT '',
  records VARCHAR(65) NOT NULL DEFAULT '',
  PRIMARY KEY(id)
);

How can I update the rows in the database using the same form?

php

2 Contributors
1 Reply
93 Views
1 Day Discussion Span
Latest Post 16 Years Ago Latest Post by sDJh

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

sDJh 39 Posting Whiz in Training · Answer 1 · 2008-05-03T23:55:21+00:00

Put a variable in the form-element say

<form action="save.php?mode=edit">

In save.php you just have to distinguish between a new post (mode=="") and an update (mode=="edit").