php - How do I insert an array of values into different columns of a mysql table?

Question

I am getting values in an array like this:

 Array
(
    [0] => English
    [1] => Arabic
)

I am having 2 columns in database like below.

lanuage1 language2

I want to insert the first array [0] => English to language1 column and [1] => Arabic to language2 ,can any one suggest how can I do that? Thanks.

I tried like this:

$data = explode( ',', $language ) ;

print_r($data);

INSERT INTO contact(lanuage1 ,language2) VALUES ($data [0], $data [1]);

but its not working...

Answer 1

<?php
$languages = array(
'0' => 'English',
'1' => 'Arabic'
);

mysqli_query($connection,"INSERT INTO contact(lanuage1 ,language2) VALUES ('$languages[0]', '$languages[1]')");
?>