Home >Backend Development >PHP Tutorial >PHP converts txt text into an array and saves it in the database_PHP tutorial
PHP converts txt text into an array and saves it in the database_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:07:251321browse
Today I have a job to do, which is to save the contents of a txt file with 50,000 records to the database. I first thought of using file_get_contents and then I saw that it is easier to use file. Here is what I wrote Program.
include_once('../inc/connect.php');
class fso_getline{
var $filename ='number.txt';
var $content;
var $arr;
function read_line(){
If(file_exists($this->filename) ){
$this->content =file($this->filename);
If(is_array($this->content)){
$this->arr =$this->content;
}else{
$this->error(1);
}
}else{
$this->error(0);
}
}
function array_to_database(){
foreach( $this->arr as $temp ){
echo $temp,'
';
$this->sava_data($temp);
}
}
function sava_data($cd){
$sql="Insert into wk_card(card_id) value('$cd')";
Mysql_query($sql);
}
/*
How to use the file_get_contents() function requires the following conversion
function into_array(){
$temp =str_replace(chr(13),'|',$this->content);
$this->arr =explode('|',$temp);
}
Test output array function
function echo_array(){
Print_r($this->arr);
}
*/
function error($id){
$error_array =array('file not exists','file unload');
echo $error_array[$id];
}
}
Class calling method
$test =new fso_getline();
$test->read_line();
$test->array_to_database();
?>
Finally, please note the original reprint of this site: www.111cn.cn/phper/php.html