php mysql导入txt数据格式_【PHP】将服务器端存储的TXT、CSV类型的文本数据写入数据库...

$data [0] );

$position = iconv ( "gbk", "utf-8//IGNORE", $data [2] );

$salary = iconv ( "gbk", "utf-8//IGNORE", $data [3] );

$day = iconv ( "gbk", "utf-8//IGNORE", $data [4] );

echo $name . "--" . $mobile . "--" . $position . "--" . $salary . "--" . $day . "
";

$stmt->execute ();

echo "UPDATE " . $name . " Succeed!" . "
";

echo "

---

";

} else {

$sql = "INSERT INTO salary(name,phone,position,base_salary,work_day) VALUES(?,?,?,?,?)";

$stmt = $conn->prepare ( $sql );

$stmt->bindParam ( 1, $name );

$stmt->bindParam ( 2, $phone );

$stmt->bindParam ( 3, $position );

$stmt->bindParam ( 4, $salary );

$stmt->bindParam ( 5, $day );

$name = iconv ( "gbk", "utf-8//IGNORE", $data [0] );

$phone = $mobile;

$position = iconv ( "gbk", "utf-8//IGNORE", $data [2] );

$salary = iconv ( "gbk", "utf-8//IGNORE", $data [3] );

$day = iconv ( "gbk", "utf-8//IGNORE", $data [4] );

echo $name . "--" . $phone . "--" . $position . "--" . $salary . "--" . $day . "
";

$stmt->execute ();

echo "INSERT " . $name . " Succeed!" . "
";

echo "

---

";

}

} catch ( PDOException $e ) {

}

}

}

fclose ( $handle );

}

/**

* 统计下载数

* 根据条件统计

* */

function count_download($conn,$str){

$sql = "SELECT COUNT(ip) FROM download_url WHERE road='".$str."'";

$stmt = $conn->prepare ( $sql );

$stmt->execute ();

$rowNum = $stmt->fetch ();

return $rowNum[0];

}

/*

* pdo链接数据库

*/

function getPDOConn() {

$host = "192.168.0.6";

// 本地IP

$hosttest = "localhost";

$usesrname = "root";

$password = "";

$dbname = "demo";

try {

$conn = new PDO ( "mysql:host=$hosttest;dbname=$dbname", $usesrname, $password );

// 设置编码，防止中文乱码

$conn->exec ( "SET names utf8" );

// 防止sql注入攻击

$conn->setAttribute ( \PDO::ATTR_EMULATE_PREPARES, false );

print "connection succeed!
";

} catch ( PDOException $e ) {

print "connection error!
" . $e->getMessage ();

}

return $conn;

}