©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Import PHP arrays into MySQL, MariaDB tables

Import PHP arrays into MySQL and MariaDB tables

Data import from PHP arrsy The PHP array import is part of the table editing
PHP array import into MySQL tables
This module imports PHP arrays into tables:
 
PHP field: Fields of the PHP file that can be used for the import.
Table field: Assignment of the table fields.
Values: Preview of the import values.
 
Reload PHP file: Import form is reloaded with the selected import options. If another PHP file is selected, it will be uploaded.
Converting one-dimensional arrays: For one-dimensional PHP arrays, the index of each field is taken as the field header.
Adopt array index as field: Array indices are adopted as an additional field in the new table.
Get data from line: The data from the PHP file is copied to the new table from the specified line.
Accept data rows: The specified number of rows will be imported. The number of lines in the import file is calculated when the form is started.
Store empty strings as NULL: If NULL is allowed for the inherited field, otherwise store empty strings.
REPLACE instead of INSERT: Import option if a UNIQUE index is created for the table. The default is INSERT IGNORE
REPLACE causes the last data record to be used in the case of duplicate values.
Character encoding of the PHP file: Selection of the character encoding of the PHP file if it is to be converted.
Save import scheme: The field mappings are saved. With the next import with the same file format, these are automatically adopted.
This module imports data from PHP arrays into MySQL and MariaDB tables. After selecting a file or entering a data script, the PHP structure and the data it contains are analyzed by the program and an import suggestion is made if there is no saved schema for the PHP array. Field assignments and import settings can then be made here.

You can save the import schema and it will be automatically suggested the next time you import if the array indices of the PHP data are the same.
More information on inserting data into MySQL tables can be found here: mysql.com and mariadb.com
Updated: 2023-09-21ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer