Message: Return type of CI_Session_files_driver::open($save_path, $name) should either be compatible with SessionHandlerInterface::open(string $path, string $name): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::close() should either be compatible with SessionHandlerInterface::close(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::read($session_id) should either be compatible with SessionHandlerInterface::read(string $id): string|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::write($session_id, $session_data) should either be compatible with SessionHandlerInterface::write(string $id, string $data): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::destroy($session_id) should either be compatible with SessionHandlerInterface::destroy(string $id): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::gc($maxlifetime) should either be compatible with SessionHandlerInterface::gc(int $max_lifetime): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Advanced Mysql Exporter/Importer is a simple web application allow users to export or import any tables from or to CSV, Excel, PDF files.
No special installation needed, the admin Login/Password is stored in configuration file and protected with .htaccess file
Advanced Mysql Exporter/Importer able to :
Export Import CSV
Export Import Excel (xlsx, xls), Export PDF
Export to CSV, Excel and PDF with custom queries
Enable update queries
Console command line to export/import huge databases
Advanced Mysql Exporter/Importer using :
Bootstrap style + reponsive version
Simple MCV Application
Easy Installation
You can customise the import or export function to be applied for each recored, you don’t want to use it put them to `none`.
By default they are in config/parameters.ini :
export_encode_function=”utf8_encode”
import_encode_function=”utf8_decode”
For some databases, you need to setup the option database_default_charset in config/parameters.yml, example : `database_default_charset: “utf8”`
Requires
PHP 5.x
Mod_rewrite enabled
Enable the .htaccess rewrites in your vhost
DocumentRoot /var/www/project
<Directory /var/www/project>
AllowOverride All
Order allow,deny
Allow from All
</Directory>
Installation
This is the 2.0 version.
Put the whole application where you want
Change the admin login/password in config/parameters.yml
Change the url in config/parameters.yml
Enjoy !
Console Commande
To import huge databases open file config/console.yml, in import settings section configure table name and import options, next just run : `php bin/console import`
To export huge databases open file config/console.yml, in export settings section configure table name and export options, next just run : `php bin/console export`
Enjoy !
Update : Version 2.1 :
Moving from mysql adapter to mysqli
Update : Version 2.0 :
Command line to export/import huge databases
Enable update queries
Using yml files for application configuration instead of ini
Add database_default_charset option in parameters.yml
Improve performances
Fix minor bugs
Update : Version 1.1 :
Fix minor bugs
Allowing execution with previous version of PHP 5 (like PHP 5.2)
Advanced Mysql Exporter/Importer need PHP5 to work.
Live Demo
If you like this script please take a minute and rate it
