- 论坛徽章:
- 14
|
本帖最后由 reb00t 于 2014-09-26 19:30 编辑
- <?php
- require('test2.php');
- $test = new Mysql('127.0.0.1','root','xxxxx');
- $test->myconnect();
- $test->createdb("dbtest");
- $test->query($sql);
- $sql = "
- create table IF NOT EXISTS tablename
- (
- id int not null auto_increment primary key,
- code int(6) not null,
- name varchar(40) not null
- )comment='股票代码及名称表' engine=InnoDB;
- ";
- $test->query($sql);
- $tmparr=array();
- $file = file_get_contents('200.txt');
- $newfile = mb_convert_encoding($file, 'UTF-8','GBK');
- $arr = preg_split('/[\n]+/', trim($newfile));
- foreach ($arr as $k => $v) {
- $brr = preg_split('/;/', trim($v));
- $tmparr['code'] = $brr[1];
- $tmparr['name'] = $brr[0];
- $sql= $test->buildInsert('tablename',$tmparr);
- if($test->query($sql)){
- echo "$brr[1] $brr[0] insert OK\n";
- }
- }
- ?>
- 结果:
- 600094 大名城 insert OK
- 600095 哈高科 insert OK
- 600096 云天化 insert OK
- 600097 开创国际 insert OK
- 600098 广州发展 insert OK
- 600099 林海股份 insert OK
- 600100 同方股份 insert OK
- 600101 明星电力 insert OK
- 600102 莱钢股份 insert OK
- 600103 青山纸业 insert OK
复制代码 |
|