[Resolved] Array / Function

[chriswheat]

Hello,

I am trying to create a mysql function for insert and update:

I want to be able to take an array from the form post and create the correct sql syntax.

So lets say I have a database table named "test"
and in that I have these fields:
client_name
tollfree
phone
fax

so when a user fills out the form this is the $_POST array:

Array ( [client_name] => ChrisCorp [tollfree] => 800 [phone] => 503 [fax] => 555 ) 

So I need to figure out how to take the above array and make it look like this for the update:

$update = "client_name='ChrisCorp', tollfree='800', phone='503', fax='555'";

and look like this for an insert:

$fields = "client_name, tollfree, phone, fax";
$values = "'ChrisCorp','800',503','555'";

Then I could do a update function and an insert function. If this is possible it would prevent having to constantly type sql syntax it would all be done "on the fly"

Any ideas or php functions would be verry helpfull.

Thank You,
Chris Wheat

[marian]

use a foreach loop, somethign like this.

foreach($postArray as $newArray)
{

//do update here
update table set clientName=$newArray['clientName'];
//do insert here

etc
}

[Weedpacket]

Look at [man]array_keys[/man], [man]array_values[/man], and/or [man]foreach[/man]. Using functions like [man]join[/man] can also help. Don't forget to check that the fields and values are genuine before trying to insert them (e.g., keep an array of genuine field names handy and only look at array elements with keys named in that array).

[chriswheat]

Many thanks this is exactly what I needed, I tried looking on php.net first but had a temporary blind moment.

I will post the code I come up with shortly.

Thanks
Chris

[chriswheat]

Here is what I came up with, this so far appears to work good. If any one has suggestions for a cleaner process I am all ears:

// update function
function mysql_update_func($array, $tablename, $wherefield, $wheredata){
$update = "";
foreach ($array as $key => $value) {
   $update .= "$key='$value', ";
}
$update = substr("$update", 0, -2);
mysql_query("UPDATE $tablename SET $update WHERE $wherefield='$wheredata'") or die (mysql_error());
}

// insert function
function mysql_insert_func($array, $tablename){
$fields = "";
$values = "";
foreach ($array as $key => $value) {
   $fields .= "$key, ";
}
$fields = substr("$fields", 0, -2);
foreach ($array as $key => $value) {
   $values .= "'$value',";
}
$values = substr("$values", 0, -1);
mysql_query("INSERT INTO $tablename ($fields)
                   VALUES($values)") or die (mysql_error());
}

// assign the array for testing
$array = array("client_name" => ChrisCorp, "tollfree" => 800, "phone" => 503, "fax" => 555);

// call to the insert function
$tablename = "clients";
mysql_insert_func($array, $tablename);

// call to the update funtion
$tablename = "clients";
$wherefield = "client_name";
$wheredata = "ChrisCorp";
mysql_update_func($array, $tablename, $wherefield, $wheredata);

Many thanks,
Chris