asked on

$_POST processing PHP page and update MySQL

I have an Array that comes from a Post form that is auto generated by a php script I need to add these into a mysql database but I can't figure out how to loop through the info and store it in a database.

I want a page named process.php that takes the array data and in the end updates the database with a MySQL statement like the one below. It has to use variables so I don't have to hard code everything.

UPDATE `URL` SET `Column`=$Column# WHERE `Group Category` LIKE '$colGroupCat#'

I probably will add more columns.

Array
(
    [colGroupCat1] => Bathroom
    [Column1] => 3
    [colGroupCat2] => Carpet
    [Column2] => 3
    [colGroupCat3] => Organic Pesticides
    [Column3] => 3
    [colGroupCat4] => Organizing
    [Column4] => 3
)

Open in new window

Ray Paseur

So it looks like you want to insert data into four columns of the data base? Please post the CREATE TABLE statement, thanks.

phat_code

ASKER

no I want only one column updated. The where clause is just specifying what to update.

Ray Paseur

Can you please show us the <form> part of things? Thanks.

phat_code

ASKER

<?php

echo '<form name="stack" method="POST" action="stackprocess.php">';
echo '<table bordercolor="#9966FF" align="center" width="734">'; 
echo '<tr>';
echo '<td>Group Category</td>';
echo '<td>Column</td>';
echo $sql;
echo '</tr>'; 
while($row = mysql_fetch_array($result)){  
$i++;
echo '<tr>';
echo "<td><input type='text' value='".$row[$colGroupCat]."' name='colGroupCat".$i."' /></td>";
echo "<td><input type='text' value='".$row[$colNumber]."' name='Column".$i."' /></td>";
echo "</tr>";

}  
echo '<td colspan="2" align="center">'; 
echo '<input type="submit"/>';
echo '<a href="doubledropdown.php">Bookmarks</a>'; 
echo '</td></tr></table></form>'; 

?>

Open in new window

Ray Paseur

I must be missing something. It appears that $sql and $result is undefined in that script.

Please post the CREATE TABLE statement, thanks.

phat_code

ASKER

no you are not missing anything i define them above. I just posted the form.

phat_code

ASKER

CREATE TABLE IF NOT EXISTS `URL` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Top Level Category` varchar(18) DEFAULT NULL,
  `Page Category` varchar(41) DEFAULT NULL,
  `Group Category` varchar(30) DEFAULT NULL,
  `Title` varchar(148) DEFAULT NULL,
  `URL` varchar(2083) DEFAULT NULL,
  `Password Needed` varchar(1) DEFAULT NULL,
  `Column` int(1) NOT NULL,
  `Row` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2554 ;

Open in new window

ASKER CERTIFIED SOLUTION

Duboux

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

phat_code

ASKER

Thank you. I didn't know I could do a SQL statement like that. Great job!