在php中将关联数组插入MySQL数据库

Question

I have an array called $output which contains:

Array
(
    [0] => Array
        (
            [0] => J Arora
            [1] =>  India
        )

    [1] => Array
        (
            [0] => J Ramuj
            [2] =>  Russia
        )

    [2] => Array
        (
            [1] =>  KJ Tris
            [2] =>  Germany
        )

)

How can i insert these data into mysql database table like these

---------------
name   | country
-------|---------
J Arora|India
-------|--------
J Ramuj|Russia
-------|--------
KJ Tris|Germany
-------|--------

I am not able to fetch these values separately from given array as their index are not in sequence.

Answer 1

Just loop it with a foreach, and use PHP native functions like current() and end() to get your elements. Given that you just have two elements in your array at all times, this should work

foreach ($output as $v) {
    echo current($v); // Name
    echo end($v); // Country
}

Adapt this to build your query and execute it inside the loop. Inside the loop you could do

foreach ($output as $v) {
    $sql = "INSERT INTO table (`name`, `country`) VALUES ('".current($v)."', '".end($v)."')";
    // TODO: Execute query
}

You should also note that any query using variables should be using prepared statements with placeholders. Both MySQLi and PDO supports this.

---

Using prepared statements

Build the query before, and execute it as you loop it with the appropriate variables bound.

Example with PDO:

$stmt = $pdo->prepare("INSERT INTO table (`name`, `country`) VALUES (:name, :country)");
foreach ($output as $v) {
    $stmt->execute(array("name" => current($v), "country" => end($v));
}

---

Example with MySQLi:

$stmt = $mysqli->prepare("INSERT INTO table (`name`, `country`) VALUES (?, ?)");
foreach ($output as $v) {
    $name = current($v);
    $country = end($v);
    $stmt->bind_param("ss", $name, $country);
    $stmt->execute();
}