INSERT INTO `table` (`name`) VALUES (?)

在一个PHP进程中进行多次插入(在单独的事务中逐个进行)时,它会增加1.

当我通过PHPmyadmin使用相同的SQL查询时,它总是增加1.

在提到的INSERT之前或之后没有其他INSERT或UPDATE语句.之前只有一个SHOW和一些SELECT语句.

我找不到这个问题的原因.造成这种行为的原因是什么？

这里主要代码部分：

<?PHP

class DB
{
    private function __construct($host,$username,$password,$schema,$port,$socket)
    {
        if(is_null(self::$DB))
        {
            self::$DB = new \MysqLi((string) $host,(string) $username,(string) $password,(string) $schema,(int) $port,(string) $socket);
            self::$DB->set_charset('utf8');

        }
    }
    // [...]
    public function __destruct()
    {
        if(!is_null(self::$DB))
            self::$DB->close();
    }
    // [...]
    public static function connect($host = '',$username = '',$password = '',$schema = '',$port = 0,$socket = '')
    {
        if(is_null(self::$instance))
        {
            $MD = new \MysqLi_driver();
            $MD->report_mode = MysqLI_REPORT_ERROR | MysqLI_REPORT_STRICT;
            // [...]
            self::$instance = new self($host,$socket);
        }

        return self::$instance;
    }
    // [...]
    public static function __callStatic($name,$args)
    {
        self::connect();

        switch(true)
        {
            case in_array($name,array('insert','select','update','delete','show','describe','explain')):

            $query = isset($args[0]) ? (string) $args[0] : '';
            $vals = isset($args[1]) ? $args[1] : array();
            $select = isset($args[2]) ? trim((string) $args[2]) : 'array';
            $empty = isset($args[3]) ? $args[3] : array();
            $types = isset($args[4]) ? trim((string) $args[4]) : '';

            return self::dml(in_array($name,array('show','explain')) ? 'select' : $name,$query,$vals,$select,$empty,$types);

            break;
        }
    //[...]
    }

    // [...]
    public static function dml($type,$vals = array(),$select = 'array',$empty = array(),$types = '')
    {
        // [...]
        if(!empty($vals) || mb_strpos($query,'?') !== false)
        {
            if(!$stmt = self::$DB->prepare($query))
                throw new DBException('Failed to prepare statement '.htmlspecialchars($query).PHP_EOL.self::$DB->error.' ('.self::$DB->sqlstate.').');

            $args = array();

            if(empty($types))
            {
                foreach($vals as &$val)
                {
                    $t = gettype($val);

                    if($t == 'string' || $t == 'NULL')
                        $types.= 's';
                    elseif($t == 'integer' || $t == 'boolean')
                        $types.= 'i';
                    elseif($t == 'double' || $t == 'float')
                        $types.= 'd';
                    else
                        throw new DBException('Its not possible to automatically assign a value of type '.$t.'. Please specify the corresponding types manually.');
                    $args[] = $val;
                }
            }
            else
            {
                foreach($vals as &$val)
                    $args[] = $val;
            }

            array_unshift($args,$types);

            $RC = new \ReflectionClass($stmt);

            $RM = $RC->getMethod('bind_param');

            if(!$RM->invokeArgs($stmt,$args))
                throw new DBException('Failed to bind params.'.PHP_EOL.self::$DB->error.' ('.self::$DB->sqlstate.').');

            if(!$stmt->execute())
                throw new DBException('Failed to execute Statement.'.PHP_EOL.self::$DB->error.' ('.self::$DB->sqlstate.').');

            if($type == 'select')
            {
                // [...]
            }
            else
            {
                $return = $type == 'insert' && self::$DB->insert_id > 0 ? self::$DB->insert_id : self::$DB->affected_rows;
                $stmt->close();
                return $return;
            }
        }
        else
        {
            // [...]
        }
    }
}
?>

和：

echo DB::insert("INSERT INTO `table` (`name`) VALUES (?)",["test"]);

Query-Log显示2个插入.这会导致额外的增量.但是,当我将回声放入相应的DB :: dml() – 方法时,它只输出一次,因此调用一次. MysqL-query-log：

151026 12:54:49     3 Connect   XXX@localhost on XXX
 3 Query    SET NAMES utf8
        3 Query SELECT DATABASE() AS `schema`
        3 Query SHOW GRANTS FOR CURRENT_USER
        3 Prepare   INSERT INTO `table` (`name`) VALUES (?)
        3 Execute   INSERT INTO `table` (`name`) VALUES ('testinsert22')
        3 Close stmt    
        3 Quit  
        4 Connect   XXX@localhost on XXX
        4 Query SET NAMES utf8
        4 Query SELECT DATABASE() AS `schema`
        4 Query SHOW GRANTS FOR CURRENT_USER
        4 Prepare   INSERT INTO `table` (`name`) VALUES (?)
        4 Execute   INSERT INTO `table` (`name`) VALUES ('testinsert22')
        4 Close stmt    
        4 Quit