Home > Article > Backend Development > php MySql function example to insert into array
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); } ?> |