Editing or updating data from posted tables

flforlife · April 18, 2008

I want to update existing data being posted? I was wondering how can I update an array of data that is posted in the database with different id's or the database creates new id's how can I edit those id's?

here is the code.....

database..............


CREATE TABLE major (
  id INT NOT NULL AUTO_INCREMENT,
  place 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 '',
  PRIMARY KEY(id)
);

CREATE TABLE minor (
  id INT NOT NULL AUTO_INCREMENT,
  place 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 '',
  PRIMARY KEY(id)
);


CREATE TABLE softball (
  id INT NOT NULL AUTO_INCREMENT,
  place 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 '',
  PRIMARY KEY(id)
);

the form is field out.......

 
<form method='post' enctype='multipart/form-data' action="add2.php">
<table>
   
  <tr>
      <td>PLACE</td>
      <td>TEAM</td>
      <td>WIN-LOSE</td>
      <td>GB</td>
      <td>%AGE</td>
      <td>RUNS SCORED</td>
      <td>RUNS ALLOWED</td>
      <td>AVERAGE GAME SCORE</td>
   </tr>
    <tr>
   

<tr>
<td><input name="entry[0][place]" type="text" /></td>
<td><input name="entry[0][team]" type="text" /></td>
<td><input name="entry[0][wl]" type="text" /></td>
<td><input name="entry[0][gb]" type="text" /></td>
<td><input name="entry[0][pcage]" type="text" /></td>
<td><input name="entry[0][rs]" type="text" /></td>
<td><input name="entry[0][ra]" type="text" /></td>
<td><input name="entry[0][ags]" type="text" /></td>
</tr>

<tr>
<td><input name="entry[1][place]" type="text" /></td>
<td><input name="entry[1][team]" type="text" /></td>
<td><input name="entry[1][wl]" type="text" /></td>
<td><input name="entry[1][gb]" type="text" /></td>
<td><input name="entry[1][pcage]" type="text" /></td>
<td><input name="entry[1][rs]" type="text" /></td>
<td><input name="entry[1][ra]" type="text" /></td>
<td><input name="entry[1][ags]" type="text" /></td>
</tr>

<tr>
<td><input name="entry[2][place]" type="text" /></td>
<td><input name="entry[2][team]" type="text" /></td>
<td><input name="entry[2][wl]" type="text" /></td>
<td><input name="entry[2][gb]" type="text" /></td>
<td><input name="entry[2][pcage]" type="text" /></td>
<td><input name="entry[2][rs]" type="text" /></td>
<td><input name="entry[2][ra]" type="text" /></td>
<td><input name="entry[2][ags]" type="text" /></td>
</tr>

<tr>
<td><input name="entry[3][place]" type="text" /></td>
<td><input name="entry[3][team]" type="text" /></td>
<td><input name="entry[3][wl]" type="text" /></td>
<td><input name="entry[3][gb]" type="text" /></td>
<td><input name="entry[3][pcage]" type="text" /></td>
<td><input name="entry[3][rs]" type="text" /></td>
<td><input name="entry[3][ra]" type="text" /></td>
<td><input name="entry[3][ags]" type="text" /></td>
</tr>

<tr>
<td><input name="entry[4][place]" type="text" /></td>
<td><input name="entry[4][team]" type="text" /></td>
<td><input name="entry[4][wl]" type="text" /></td>
<td><input name="entry[4][gb]" type="text" /></td>
<td><input name="entry[4][pcage]" type="text" /></td>
<td><input name="entry[4][rs]" type="text" /></td>
<td><input name="entry[4][ra]" type="text" /></td>
<td><input name="entry[4][ags]" type="text" /></td>
</tr>



   
   </table>
<input type='submit' name='btnSub' value='Submit'>
</form>

the add.php adds code to database....


<?php

$hostname = 'localhost';
$username = 'root';
$password = ''; //add later
$database = 'scores';
//add fourteam data




$mysql = mysql_connect($hostname, $username, $password);
mysql_select_db($database);


//? for php engine
if (isset($_POST['btnSub']))
{
    $sql = "INSERT INTO minor (place,team, wl, gb, pcage, rs, ra, ags) VALUES\n ";

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

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

    /*echo '<pre>', $sql, '</pre>';    */         // view query
    mysql_query($sql) or die(mysql_error());

}



header("location:minadmin.php"); 


mysql_close($mysql)





   


?>

output is.................

 

<?php
/*
$hostname = 'localhost';
$username = 'root';
$password = ''; //add later
$database = 'scores';
//add fourteam data
*/

$mysql = mysql_connect($hostname, $username, $password);
mysql_select_db($database);




$result = mysql_query("SELECT * FROM minor");







mysql_close($mysql);
?>




<html>
<head>
<title>Juniors Silver Baseball</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style4 {font-size: 10px}
.style1 {font-size: 12px}

-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- ImageReady Slices (scoreboard_bg.jpg) -->

<table id="Table_01" width="603" height="821" border="0" cellpadding="0" cellspacing="0">

<tr>
	<td colspan="3">
		<img src="images/scoreboard_bg_01.jpg" width="603" height="148" alt=""></td>
</tr>
<tr>
	<td rowspan="4">
		<img src="images/scoreboard_bg_02.jpg" width="39" height="673" alt=""></td>
	<td width="526" height="231" align="center" background="images/scoreboard_bg_03.jpg">

            
            
            
          <div>
            <h3>2008 Juniors Silver Division<br> Standings & Scores</h3>
	  <?php echo "<table align='center'  border='0' cellpadding='o' cellspacing='6'  class='style1'>
<tr>
	<td>PLACE</td>
	<td>TEAM</td>
	<td>WIN-LOSE</td>
	<td>GB</td>
	<td>%AGE</td>
	<td>RUNS </br> SCORED</td>
	<td>RUNS </br> ALLOWED</td>
	<td>AVERAGE</br>GAME</br> SCORE</td>
</tr>";

while($row = mysql_fetch_array($result))
  {
  
echo" ";



  echo "<tr>";
  echo "<td>" . $row['place'] . "</td>";
  echo "<td>" . $row['team'] . "</td>";
  echo "<td>" . $row['wl'] . "</td>";
  echo "<td>" . $row['gb'] . "</td>";
  echo "<td>" . $row['pcage'] . "</td>";
  echo "<td>" . $row['rs'] . "</td>";
  echo "<td>" . $row['ra'] . "</td>";
  echo "<td>" . $row['ags'] . "</td>";
  echo "</tr>";
  
  
  }
echo "</table>";
?></div>     

</td>
  <td rowspan="4">
		<img src="images/scoreboard_bg_04.jpg" width="38" height="673" alt=""></td>
</tr>
<tr>
	<td>
		<img src="images/scoreboard_bg_05.jpg" width="526" height="273" alt=""></td>
</tr>
<tr>
	<td width="526" height="74" align="center"  background="images/scoreboard_bg_06.jpg">
	  <h3>More Scoreboards</h3>
  <a href="ftoutput.php">Majors Baseball</a>
  |
  <a href="minoutput.php">Juniors Silver Baseball</a>  
  | 
  <a href="softoutput.php">Majors Softball
  </div>
  </a>      </td>
  </tr>
<tr>
	<td>
		<img src="images/scoreboard_bg_07.jpg" width="526" height="95" alt=""></td>
</tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>

I need an update.php for the array..........

Do i need to use the

 $sql = "update * id"

to udpate query?

Sign In

Editing or updating data from posted tables

Recommended Posts

flforlife

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information