doujiao7325
2016-12-23 10:51
浏览 158
已采纳

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

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.

图片转代码服务由CSDN问答提供 功能建议

我有一个名为 $ output 的数组,其中包含: \ n

  Array 
(
 [0] =>数组
(
 [0] => J Arora 
 [1] =>印度
)
 
 [  1] =>数组
(
 [0] => J Ramuj 
 [2] =>俄罗斯
)
 
 [2] =>数组
(
 [1]  => KJ Tris 
 [2] =>德国
)
 
)
   
 
 

如何将这些数据插入到mysql数据库表中 这些

  --------------- 
name |  country 
 ------- | --------- 
J Arora | India 
 ------- | -------- 
J Ramuj | Russia 
  ------- | -------- 
KJ Tris |德国
 ------- | -------- 
   \  n 
 

我无法从给定数组中分别获取这些值,因为它们的索引不是按顺序排列的。

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

5条回答 默认 最新

  • duanhuan2301 2016-12-23 10:58
    已采纳

    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();
    }
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报
  • duanmi3476 2016-12-23 10:57

    Let's call your array user_details

    foreach($user_detail as $single_user){
           $i = 0;
           foreach($single_user as $user){
               if($i==0){
                 $name = $user;
               } else {
                $country = $user;
               } $i++;
           }
         $sql_query = INSERT into 'Table'($name, $country);
         //Execute this query as per mysqli or or mysql
    
    }
    

    //Considering that first value is always the name and 2nd values is always a country name

    评论
    解决 无用
    打赏 举报
  • dongpo9071 2016-12-23 10:57
    $sql = "INSERT INTO tablename(name,country) VALUES";
    
    for($i=0;$i<sizeof($myarray);$i++){
      $sql.="(".$myarray[0].",".$myarray[1].")";
    }
    

    now execute $sql

    评论
    解决 无用
    打赏 举报
  • dqy27359 2016-12-23 11:00
    for ($a=0; $a<count($array); $i++) {
        $dataArray=array_values($array[$i]);
        for ($j=0; $j<count($dataArray); $j++) {
    
            $name=$dataArray[0];
            $country=$dataArray[1];
            $insert_query="insert into tablename set name='$name', country='$country'";
            $res_query=mysql_query($insert_query);
        }
    }
    

    Hope this will works for you.

    评论
    解决 无用
    打赏 举报
  • duanji1924 2016-12-23 11:01

    Might be this can help. Its not tested.

    $query = "INSERT into 'your table name' ('name', 'country') VALUES ";
    foreach($yourArray as $data) {
        foreach($data as $d) {
           $query .= "('.$d[0].','.$d[1]),";
       }
    }
    
    $query = substr($query, 0, -1); // To remove last comma from query string
    

    Then you can execute this query.

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题