Thinkphp 导出大量数据 csv格式

最新推荐文章于 2024-01-31 18:45:00 发布

pipilang3220119

最新推荐文章于 2024-01-31 18:45:00 发布

阅读量1.1k

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/pipilang3220119/article/details/50897743

版权

PHP 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

public function test2() {
		$user_count = M('department')->count();

		$page = ceil($user_count / 10000);

		$fp = fopen('c:\file.csv', 'w');
		for ($p = 1; $p <= $page; $p++) {

			$user = M('department')->page($p . ',10000')->select();

			foreach ($user as $fields) {

				foreach ($fields as $i => $v) {

					$fields[$i] = iconv('utf-8', 'gbk', $v);
				}

				fputcsv($fp, $fields);
			}

			unset($user);
		}

		fclose($fp);

	}