[niyasali64]

This is my code:

PHP Code:

$prefs = array(
            'tables'        => array(),  
            'ignore'        => array(),         
            'format'        => 'zip',              // gzip, zip, txt
            'filename'      => $filename.'.sql',       
            'add_drop'      => TRUE,      
            'add_insert'    => TRUE,     
            'newline'       => "\n"       
        );

        $backup = $this->dbutil->backup($prefs);        
        $backup_path = 'backups/db/';        
        $backup_file = FCPATH. $backup_path . $filename. "." . $prefs["format"]; 
        $backup_created = write_file( $backup_file, $backup); 


I am writing a backup data to a file , the string are not getting what i expected ;


Example output:

PHP Code:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES 
(9, 16, 127.0.0.1, 16, 2018-07-22 15:21:22, login, 0, ); 


This is what i am expecting:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES (9, 16, '127.0.0.1', 16, '2018-07-22 15:21:22', 'login', 0, '');

Look the value, The invertercomma is missing the output.

 

[php_rocs]

@niyasali64,

Have you tried running your expected query in MySQL workbench to make sure it works properly? Also, are you sure that your input values are formatted correctly?

[InsiteFX]

Why would you have a comma for the last one when you have no value after it?

the comma is an sql delimiter.

[Paradinight]

This is my code:

PHP Code:

$prefs = array(
            'tables'        => array(),  
            'ignore'        => array(),         
            'format'        => 'zip',              // gzip, zip, txt
            'filename'      => $filename.'.sql',       
            'add_drop'      => TRUE,      
            'add_insert'    => TRUE,     
            'newline'       => "\n"       
        );

        $backup = $this->dbutil->backup($prefs);        
        $backup_path = 'backups/db/';        
        $backup_file = FCPATH. $backup_path . $filename. "." . $prefs["format"]; 
        $backup_created = write_file( $backup_file, $backup); 


I am writing a backup data to a file , the string are not getting what i expected ;


Example output:

PHP Code:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES 
(9, 16, 127.0.0.1, 16, 2018-07-22 15:21:22, login, 0, ); 


This is what i am expecting:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES (9, 16, '127.0.0.1', 16, '2018-07-22 15:21:22', 'login', 0, '');

Look the value, The invertercomma is missing the output.

 

It is a bug. Pls update the codeigniter version to the latest. After the update create a new backup and test it.

See: https://github.com/bcit-ci/CodeIgniter/issues/5276