[RESOLVED] array database problem

qphqp

$i=0;
while ($i < 4)
{
if ($chck[$i] == "on")
{
$adress[$i]=$menu[$i];
}
else
{
$adress[$i]=$urr[$i];
}
$sql = "insert into uye (adress1, adress2, adress3, adress4)
values ('$adres[0]', '$adress[1]', '$adress[2]', '$adress[3]')";
}

evertihing is ok until $sql = "insert into uye (adress1, adress2, adress3, adress4).i get no error code i have identify arrays and db correctly but values are not sent to my db table.i tihink there is a problem with syntax but i couldn't find 🙁(

laserlight

There looks like many potential problems with your code snippet:

There is an infinite loop since $i is never changed.
You build an SQL statement but never actually execute it.
$adres looks like a typographical error since you otherwise consistently use $adress (which looks like it is a typo as well, as "address" is probably the right word).
On each iteration of the loop, you assign to $adress[$i]. However, when building your SQL statement, you attempt to use $adress[0] to $adress[3]. It looks like you have a logic error in that the loop is supposed to assign to four elements of $adress and only after the loop is the SQL statement supposed to be constructed.
There is no attempt made to escape the variables used in the SQL statement. This is not a problem if their values are not external to the script or have already been escaped, but with the given context there is no way to be sure.

Incidentally, why name a variable $chck when it looks like $check will be a better name? Why use a while loop when a for loop more accurately expresses the loop mechanism?

rajug

I don't know from where the arrays are filled up with the values $chck, $menu and $urr and i am not sure but try like this:

$sql = "insert into uye (adress1, adress2, adress3, adress4)
values ('{$adres[0]}', '{$adress[1]}', '{$adress[2]}', '{$adress[3]}')";

qphqp

thanks for answers i have solved my problem.

$sql = 'insert into uye (adress1, adress2, adress3, adress4)
values ("' . $adres[0] . '","' . $adress[1] . '", "' . $adress[2] . '","' . $adress[3] . '")';

when inserting an array in a database table with multiple coloumn typing values like this really works!!!