7FDsdhV4

1<?php
2$servername = "10.12.10.10";
3$username = "dict_user";
4$password = "du_123456";
5$dbname1 = "data_center";
6$dbname2 = "search_word";
7$tname1 = "lexicon_main";
8
9$conn = new mysqli($servername, $username, $password);
10
11if ($conn->connect_error) {
12    die("Connect failed: " . $conn->connect_errno);
13}
14
15$conn->set_charset("utf8");
16
17echo "Connect ok!";
18
19$myfile = fopen("wordfile.txt", "w");
20
21$sql = "SELECT main_id, table_name, field_name, dic_code FROM " . $dbname2.".".$tname1 ;
22$result = $conn->query($sql);
23if ($result->num_rows > 0) {
24    while ($row=$result->fetch_assoc()) {
25        $tname = $row["table_name"];
26        $fname = $row["field_name"];
27        $dic_code = $row["dic_code"];
28        $main_id = $row["main_id"];
29
30        $tsubname = "lexicon_sub_".$dic_code;
31        $sql3 = "create table if not exists " . $dbname2 . "." . $tsubname. "(".
32            "`sub_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '词库id', ".
33            "`main_id` bigint(20) unsigned NOT NULL COMMENT '主表id',".
34            "`dic_code` bigint(20) unsigned NOT NULL COMMENT '词性编码',".
35            "`lexicon_name` varchar(50) NOT NULL DEFAULT '' COMMENT '词库标准名',".
36            "`relative_name` varchar(50) NOT NULL DEFAULT '' COMMENT '相对标准名',".
37            "`ename` varchar(100) NOT NULL DEFAULT '' COMMENT '词库英文名',".
38            "`createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',".
39            "`updatetime` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',".
40            "`status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态',".
41            "`remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',".
42            "`creator` varchar(10) NOT NULL DEFAULT '' COMMENT '创建人',".
43            "`editor` varchar(10) NOT NULL DEFAULT '' COMMENT '编辑人',".
44            "PRIMARY KEY (`sub_id`),".
45            "UNIQUE KEY `uniq_dic_code` (`main_id`,`lexicon_name`)".
46        ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='词库子表'";
47        if( $conn->query($sql3) !== TRUE) {
48            echo "Error : " . $conn->error;
49        }
50
51        $sql2 = "SELECT ". $fname . " from ". $dbname1.".".$tname;
52        $r2 = $conn->query($sql2);
53        if ($r2->num_rows > 0) {
54            while ($row2=$r2->fetch_assoc()) {
55                $word = $row2[$fname];
56                echo "table: " . $tname . " field: ". $fname.  " word: " . $word . "\n";
57                fwrite($myfile, $word."\n");
58
59
60                $sql3 = "insert into ". $dbname2 . ".".$tsubname .  " ( main_id, dic_code, lexicon_name ) values( '" . $main_id . "','" . $dic_code. "','". $word. "')";
61                $conn->query($sql3);
62            }
63        }
64        //echo "<br>table_name. ". $row['table_name'] . " field: " . $row["field_name"];
65    }
66}
67
68fclose(myfile);
69$conn->close();
70
71?>