putting form data into a mysql array

[jesushax]

hi i know theres a quick way of doing this ive seen it, ill explain...

 

i ahve a form with many fields in now if i make the forms the same names as the mysql field names

 

how do i make an array from the data to use as a sql statement

 

hope you understand my question :S

 

Thanks

[jeeva]

You can just print the submitted values....

<?php
print_r($_POST);
?>

This will give u like

 

$_POST['<Keys>']="<Values>"...etc

 

That key will be Field Name....

 

 

[jesushax]

could you explain a lilttle more, example maybe?

 

thankyou

[jeeva]

If u have table like

Id    Name

1      xxxxx

2      yyyyy

 

Now we will get submitted data like

 

$_POST['Id']="3"

$_POST['Name']="zzzzz";

 

Here we have table field name and values as well...By using this array u can make sql statement....

[Xurion]

Let's assume you have three fields: field1, field2 and field3.

 

Also, let's assume the MySQL database reflects these and you have three columns: field1, field2 and field3.

 

$sql = "UPDATE your_table SET";
while($_POST as $key => $value){
   $sql .= " $key='$value'";
}
mysql_query($sql);

 

You may want to add a WHERE method to the end of the sql.

[jesushax]

thats the one i was after xurion

 

i know how to collect information using $_POST

 

how are keys and valuse defined how does that work?

 

Cheers

[jesushax]

i cant figure out how to do it

 

can you show an example?

 

<?php

 

switch (@$_GET["action"]) {

 

case "edit":

 

$sql = "UPDATE tblTest SET";

while($_POST as $key => $value){

    $sql .= " $key='$value'";

}

mysql_query($sql);

 

echo "done\n";

 

default

?>

<form method="post" action="?action=edit>

<input type="text" name="field1" />

<input type="text" name="field2" />

<input type="text" name="field3" />

</form>

<?php

break;

}

[jesushax]

this

 

$sql = "UPDATE your_table SET";
while($_POST as $key => $value){
    $sql .= " $key='$value'";
}
$sql = $sql."WHERE CompanyID='$ID'"

 

gives

 

Parse error: syntax error, unexpected T_AS in C:\Websites\admin\trades\edit_mem.php on line 10

 

line ten is

while($_POST as $key => $value){

[DarkWater]

Use foreach($_POST as $key=>$value), not while().

[jesushax]

thankyou very much

[Xurion]

my bad