Is there an alternative code to this?

Bbob

I have a form with 6 textfields that will be used to edit data in the database.

When a value is entered in one of the text field I want that value to be only updated in the database.

Ex.

[]id
[]name
[]age
[]address
[]number
[]gender

if name was edited, only the name field would be updated in the database.

As of now heres the code of what Im currently thinking


if($name)
{
   UPDATE customer
   SET name=value
   WHERE id=id
}

elseif ($age)
{
   UPDATE age
   SET age = age
   WHERE id = id
}

....and so on

Is there an easier way to do this? Or am I stuck with these codes?

dagon

create an array

$things=array('id','name'); // ..etc

then a foreach() loop through the array checking the values

foreach($things as $t){
if !empty($_POST[$t]){
//sql
}
}

hope that points you in the right direction

Bbob

dagon;10960882 wrote:
create an array
$things=array('id','name'); // ..etc
then a foreach() loop through the array checking the values
foreach($things as $t){
if !empty($_POST[$t]){
//sql
}
}
hope that points you in the right direction

Thanks so much for the reply.

What does $things as $t mean?

laserlight

It is part of the syntax of a foreach loop. $t becomes the name of the current element of the array/sequence (or rather, a copy of the current element of the array), as the foreach loop iterates.

nevvermind

dagon;10960882 wrote:
create an array
$things=array('id','name'); // ..etc
then a foreach() loop through the array checking the values
foreach($things as $t){
if !empty($_POST[$t]){
//sql
}
}

That foreach loops works on generic terms, whereas op has specific queries depending on which textedit has been transferred through POST.
He'll end up using "if" loops once more:

foreach($things as $t){
  if !empty($_POST[$t]){
    if $t = "name" {
      // do a specific sql query
    };
    if $t = "age" {
      // do a specific sql query
    };    

}
}

A think you should change the form behavior/layout, or modify the db layout to better manipulate specific values.

dagon

no the only difference between each will be the value $t fron the foreach.

UPDATE customer
set $t =$_POST[$t]
etc..

mrbaseball34

I would build my SQL based on the parameters passed and that way, you'd be able to update multiple fields at once.