INSERT array into mysql table (only zeros as result)

Question

Hello I have an array ($ar) like the following.

Array
(
    [0] => Array
        (
            [ciao] => 0
        )

    [1] => Array
        (
            [ciao] => 44409
        )

    [2] => Array
        (
            [ciao] => 44428
        )

    [3] => Array
        (
            [ciao] => 44313
        )

    [4] => Array
        (
            [ciao] => 42296
        )

    [5] => Array
        (
            [ciao] => 44429
        )

    [6] => Array
        (
            [ciao] => 42979
        )

    [7] => Array
        (
            [ciao] => 42302
        )

    [8] => Array
        (
            [ciao] => 42301
        )

    [9] => Array
        (
            [ciao] => 43011
 )

    [10] => 
)

I am trying to insert the array into a mysql table but I only get zeros everywhere with the following code.

"mysql connection"
$i = 0;
for ($i = 0; $i <= 10; $i++) {
$sql = " INSERT INTO table(yo) VALUES('".$ar[$i]."') " ;
echo $ar[$i];

    $req = mysql_query($sql) ;  
}
mysql_close($db1);

Could anyone help? If I try to echo the $r[$i] it displays the string "array" instead of the proper numbers in the actual array.

Where are you getting $r from? Isn't the array called $ar? — Mark Miller
– Mark Miller, Commented May 27, 2014 at 18:33

Ricardo Nunes · Accepted Answer · 2014-05-27 18:34:59Z

1

Inside each item in your array $ar there is another array.

So your query should be:

$sql = " INSERT INTO table(yo) VALUES('".$ar[$i]['ciao']."') " ;

answered May 27, 2014 at 18:34

Ricardo Nunes

1314 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fortune · Accepted Answer · 2014-05-27 18:46:00Z

0

You can try also this

$sql = "INSERT INTO table(yo) VALUES('{$ar[$i]['ciao']}') " ;

answered May 27, 2014 at 18:46

fortune

3,3721 gold badge23 silver badges30 bronze badges

Collectives™ on Stack Overflow

INSERT array into mysql table (only zeros as result)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related