Home  >  Article  >  Backend Development  >  php MySql function example to insert into array

php MySql function example to insert into array

WBOY
WBOYOriginal
2016-07-25 08:56:281308browse
This article introduces a custom function for inserting arrays into the MySQL database in PHP. Friends in need can refer to it.

php implements the function of inserting an array into the mysql database. The code is as follows:

<?php
/**
* 保存数组数据到mysql
* by bbs.it-home.org
*/
public function insertData($table,$data){
       $field=implode(',', array_keys($data));
       foreach (array_values($data) as $key=>$val){
        $value .="'".$val."'";
        if ($key<count($data)-1)
        $value .=",";
}
 $sql= "INSERT INTO ".$table."(".$field.") values(".$value.")";
        return $this->insert($sql);
}
?>


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn