php import from txt file into the database

Answer 1

The following is a common way to import a txtfile into a database using Python:

First of all, if the amount of data is large, you can consider using MysQL temporary tables to process it. You can use the OUT_END_END_END command to import data at high speed, but if the data file's code is different from character_set_database, you may need to import it line by line. It's best to have a user interaction page to manually confirm the order of import before import.

For example, if you want to import a relatively simple file like serial_number.txt., you can follow these steps:

1. Establishing database connection:
- In Python, you can use codes like `$conn = mysql_connect('127.0.0.1',' root',');`(This is the older mysql connection method. In practice, it may need to be adjusted according to the database extension used, such as mysqli or PDO) to establish a connection to the database. If the connection fails, you can use `die("Failed query: ". myssql_error();`to handle errors.
- Choose the database you want to operate on, such as `mysoul_select_db',$conn) ordie("Failed query: ". mysql_error());`。
2. Read the txt-file contents:
- Use `$content = file_get_contents("serial_number.txt');` to read the contents of the file.
- To process the content, such as splitting it with a specific symbol, for example,`$contents = explode(",",$content);`(Assuming it is separated by commas).
3. Traverse the data and insert it into the database:
- Loop through the split array, such as `foreach($contents as $k=> $v)`.
- Construct and execute the SQL statement inserted into the database in the loop, for example,`mysql-query ("insert into serial_number (`id`,`serial_number`) Values','$id','$v')");`(Suppose you insert into a table named serial_number, and there are two fields, id and serial_number).

In addition, you can write a more general function to handle the import of different structure of the TMT file into the database, like the following:
```php
function loadTxtDataIntoDatabase($splitChar,$file,$table,$conn,$fields = array(),$insertType='INSERT'){
if(empty($fields))
$head = "{$insertType} INTO `{$table}` VALUES('";
else
$head = "{$insertType} INTO `{$table}`(`".implode('`,`',$fields). "`) VALUES('";
$end = "')";
$sqldata = trim(file_get_contents($file));
if(preg_replace('/\s*/i','',$splitChar) == ''){
$splitChar = '/(\w+)(\s+)/i';
$replace = "$1','";
$specialFunc = 'preg_replace';
}else{
$splitChar = $splitChar;
$replace = "','";
$specialFunc = 'str_replace';
}
//The order of the data body cannot be changed, otherwise, there will be an error in the space or Tab separation.
$sqldata = preg_replace('/(\s*)(\n+)(\s*)/i','\'),(\'',$sqldata);
$sqldata = $specialFunc($splitChar,$replace,$sqldata);
$query = $head.$ sqldata.$ end;
if(mysql_query($query,$conn))
return array(true);
else{
return array(false,mysql_error($conn),mysql_errno($conn));
}
}
```
You can call this function according to the actual situation and pass in the corresponding parameters, such as the terminator, file name, table name, database connection, field name array, etc., to import the txt-file into the database.

It should be noted that when processing file upload and import into the database, you should consider the options related to uploading files in the Python configuration file, such as file_uploads (setting whether to accept the upload of the file), memory_limit (setting the maximum amount of memory that can be allocated by the script), upload_max_size (limiting the maximum size of the uploaded file), post_max_size (limiting the maximum size of the information that can be accepted through the post method), and other reasonable settings to prevent problems during the import process.
Read more exciting novels for free