我想创建一个全局函数插入。我有一个类似的代码
function insert_data($table, $field = array(), $data = array())
{
$sql = "INSERT INTO ".$table." (";
$i = 0;
for($f=0; $f < count($field); $f++)
{
$sql .= ++$i === count($field) ? $field[$f] : $field[$f].", ";
}
$sql .= ") VALUES (";
for($d=0; $d < count($data); $d++)
{
$sql .= end($data) === $data[$d] ? (is_string($data[$d]) ? $this->db->escape($data[$d]) : (is_null($data[$d]) ? "NULL" : $data[$d])) : (is_string($data[$d]) ? $this->db->escape($data[$d])."," : (is_null($data[$d]) ? "NULL," : $data[$d].","));
}
$sql .= ")";
$qry = $this->db->query($sql);
return $this->db->affected_rows();
}
这对我来说很好,但我想要的参数只是表的名称,带索引的数据是字段的名称。如何进行这样的创作?感谢回答
这样就可以了。修改函数的开头,其余部分保持不变:
function insert_data($table, $datas = array()){
foreach($datas as $key => $value) {
$field []= $key;
$data []= $value;
}
$sql = "INSERT INTO ".$table." (";
.
.
.