修改此函数的语法以排除多个数组,而不是一个数组


Modify syntax of this function to exclude several arrays instead of one

我是PHP的新手,不知道如何修改这个函数的语法,以便它可以用来排除多个数组,而不是只排除一个数组。这段代码自动插入表单中输入的每个值,而不必指定字段,并排除一个数组(称为"submit"),这是我在http://www.abeautifulsite.net/blog/2007/10/inserting-an-array-into-a-mysql-database-table/

我有几个数组正在发布,我想从INSERT函数中排除这些数组,因为它们要么被单独处理和插入,要么在表单处理后触发用户重定向。

function mysql_insert_array($db, $data, $exclude = array()) { 
$fields = $values = array(); 
if( !is_array($exclude) ) $exclude = array($exclude); 
foreach( array_keys($data) as $key ) {
    if( !in_array($key, $exclude) ) {
        $fields[] = "`$key`";
        $values[] = "'" . mysql_real_escape_string($data[$key]) . "'";
    }
} 
$fields = implode(",", $fields);
$values = implode(",", $values); 
if( mysql_query("INSERT INTO `$db` ($fields) VALUES ($values)") ) {       
} else {
    return array( "mysql_error" => mysql_error() );
} 
}
$result = mysql_insert_array("db", $_POST, "submit");
exclude参数可以是数组的数组:
    function mysql_insert_array($db, $data, $excludes = array()) { 
      $fields = $values = array(); 
      if( !is_array($excludes) ) $excludes = array($excludes); 
      foreach($excludes as $exclude ) {
        $data = array_diff_assoc($data, $exclude);
      } 
      foreach( array_keys($data) as $key ) {
        $fields[] = "`$key`";
        $values[] = "'" . mysql_real_escape_string($data[$key]) . "'";
      }
      $fields = implode(",", $fields);
      $values = implode(",", $values); 
      if( !mysql_query("INSERT INTO `$db` ($fields) VALUES ($values)") ) {       
        return array( "mysql_error" => mysql_error() );
      }
    } 

然后,你可以这样使用它:

$array1 = array('toto', 'titi', 'tata');
$array2 = array('submit', 'foo');
$parent_array = array ($array1, $array2);
$result = mysql_insert_array("db", $_POST, $parent_array);