KTUGFaq
KTUG FAQ
The person you rejected yesterday could make you happy, if you say yes.
%B9%AE%C7%E5%C0%CE%BF%EB/WordIndex › 占싼깍옙占쏙옙占쏙옙챰肪占쏙옙占 › KC2008/Troubles&value=WinEdtTip/Tree › PDFTeX&value=Yhchoe/WinEdt̵ › EndNotesPackage&value=Yhchoe/WinEdt̵ › MakingDic
: ChoF karnes TeX DataBase ҽϴ.
- Ѱ (PDF ȭϸ ȵ˴ϴ) http://kbrobgy.linuxtop.co.kr/makingDic/main.html site ֽϴ.
- ü Dic data Դϴ. DB ؼ Դϴ.
- ü ۾ Դϴ. main.html Է,,ãƼ(html),PDF Դϴ.
2 mySQL database table ¶
06ObGyDic database 3 table ʿ .
1. Ŀ 06ObGyDic database settingѴ
1. Ŀ tableѴ.
1. OpenOffice.calc data mySQL ֱ.
- Admission_Table : web Ҷ admission id password ִ table
- ObGyDic_main table : ֵ dic table̴. main_disease_id, ȯ, ѱ ȯ, , ȯ code, ȯ õ procedure code ȴ.
- ObGyDic_acce table : ȯ߿ (?) κ óϱ table̴. ObGyDic_main record , main_disease_id ܷŰ(foreign key) ̴.(켱 optional αϰڴ.)
#> /usr/local/mysql/bin/mysql mysql ..... mysql>update user set password=password('******') where user='root'; mysql>flush privileges; mysql>quit
#> /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ****** ..... mysql>create database TeXObGyDic; .... mysql>insert into user (host,user,password) values('localhost','KTUG',password('KTUG1234')); .... mysql>insert into db values ('localhost','TeXObGyDic','KTUG','y','y','y','y','y','y', 'n','y','y','y','y','y','y','y','y','y','y'); .... mysql>flush privileges;
mySQL db̺̳ user̺ Į ٸ , SQL 쿡 desc db; Ͽ Type enum('N','Y') Į ° 'y' Ѵ.
#>/usr/local/mysql/bin/mysql -u KTUG -p TeXObGyDic Enterpassword: KTUG1234 mysql>create table ObGyDic_main ( -> main_disease_id int unsigned not null auto_increment primary key, -> Disease_En char(50) not null, -> Shortended_Word varchar(25) null, -> Disease_Ko char(50) null, -> Definition text null, -> Disease_Code varchar(250) null, -> Procedure_Code varchar(250) null, -> index idx1 (Disease_En) ); mysql>create table Admission_ObGyDic ( -> name char(20) not null primary key, -> password char(20) not null );
ϴٸ 켱 http://www.phpschool.com ϰڽϴ.
켱 openoffice csv(field ; ϰ Ŀ )-> mysql load data infile './test.csv' into table test_table fields terminated by ';' (.....);
openoffice->excel->access->ODBC->mySQL
php queryѴ. ϰԴϴ.
ó Ͽϴ. δ load data infile '/usr/local/apache2/htdocs/0607TeXObGyDic.csv' into table ObGyDic_main fields terminated by ';' (Disease_En,Shortended_Word,Disease_Ko,Definition,Disease_Code,Procedure_Code); Դϴ.
openoffice csv Ҷ mySQL \ ø ϴ ϴ. ¿ \\ ְ ϴ ϴ .
ο ÷ "0603TeXObGyDic.csv" ε
3 Է form form form ¶
Է spreadsheet ̿ؼ ϸ ҵ , ؼ ƹ web ƿ Ƽ php ̿ؼ ߽ϴ.
- DB_insert.php form ƿ data hoze WebTeX Ƽ ġȯĿ ִ Դϴ. DB_insert.txt (1.08 KB) (*wikiƯ php ö ʽϴ.)
- edit_source.php edit_source.txt (1.08 KB) edit_source_ok.php edit_source_ok.txt (1.29 KB)
- mySQL ִ data߿ \command κ htmlȭ ϱ
- mySQL data TeX ̾ƾ ؼ ɹ ִ. ɹ δ
- \prefix{text} ξ --> html ȯ text ~ Դϴ.
- \postfix{text} ̻ --> html ȯ ~ text Դϴ.
- \synonym{text} Ѹ --> html ȯ 비슷한말 text Դϴ.
- \cnm{text} dhucs macro --> html ȯ text
- \dis_ref{text} --> html ȯ 참조 text
- \idxcnt --> html ȯ Ư Ѱ ȯϸ ɰ .
- \ --> ֱ
- ɹ Disease_Ko Definiton field ־ field data printϱ ̸ ѹ phpǥ ̿ؼ óϰ Ŀ html viewش.
- ǥ ǥδ
$search_regex = array ("/\\\prefix{(.*?)}/i","/\\\postfix{(.*?)}/i", "/\\\synonym{(.*?)}/i","/\\\cnm\{(.*?)}/i","/\\\dis_ref\{(.*?)}/i", "/\\\idxcnt/i","/&/i","/\\\/i"); $replace_regex = array ("\\1 ~","~ \\1" ,"Ѹ <span style=text-decoration:underline overline;>\\1</span>" ,"\\1","<span style=text-decoration:underline;> \\1</span>" ,"","&",""); $html_Disease_Ko = preg_replace($search_regex, $replace_regex, $search_result[Disease_Ko]); $search_regex = array ("/\\\prefix{(.*?)}/i","/\\\postfix{(.*?)}/i", "/\\\synonym{(.*?)}/i","/\\\cnm\{(.*?)}/i","/\\\dis_ref\{(.*?)}/i", "/\\\idxcnt/i","/&/i","/\\\/i"); $replace_regex = array ("<span style=\"font-style: italic; font-weight: bold;\">\\1 ~</span>","<span style=\"font-style: italic; font-weight: bold;\">~ \\1</span>", "<br>Ѹ <span style=text-decoration:underline overline;>\\1</span>", "\\1","<br><span style=text-decoration:underline;> \\1</span>", "<br>","&",""); $html_Definition = preg_replace($search_regex, $replace_regex, $search_result[Definition]);
4 LaTeX ϱ ¶
ִ data ؼ ڽϴ.
mySQL ؾ data sorting ϴ Դϴ.
php ٷ tex ȭ
SELECT Disease_En, Shortended_Word, Disease_Ko,Definition,Disease_Code,Procedure_Code INTO OUTFILE 'DicA.txt' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM ObGyDic_main WHERE Disease_En LIKE 'A%' ORDER BY Disease_En asc;
- mySQL root password ˾߾߸ մϴ.
- phpȭԴϴ. 0625makingTeX.txt (1.59 KB)
5 PDFȭ ¶
̾ƹ pdfȭ ߽߰ϴ.
켱 ۾Ѱ ÷ ΰڽϴ. makingPDF.txt (1.86 KB)
۵ϴ PDF ڵ( Z,Y,U غҽϴ.) ϴ. ü ͵ , mySQL dataԷϴµ Ǽ ־ Ƹ ۵ ϴ. ̰̾ ¥ ϳϳ ġ ۿ ̶.. ϴ ̰ Դϴ. ŭ ǥ php ƴϿϴ. 0618makingPDF.txt (3.27 KB)
ġ Ŀ ۵ϴ ȮϿϴ. Ǵµ մϴ. Ѵ ؼ ƻ縮 ϴ. (PDF ȭ directory ۾ ϸ ɰ ϴ.) ٲپϴ. 0619makingPDF.txt (3.4 KB)
7 ü ȭ ¶
- 2006 6 10 ȭ makingDic.tar.gz (90.81 KB)
- 2006 6 13 ȭ 0613makingDic.tar.gz (91.46 KB)
- 2006 6 18 ȭ 0618makingDic.tar.gz (311.01 KB)
- 2006 6 20 ȭ 0620makingDic.tar.gz (20.23 KB)
- 2006 6 21 ȭ 0621makingDic.tar.gz (219.23 KB)
8 ȭ ¶
ɰ Ź帳ϴ. λ̰ ʰ ֽʽÿ.
̰ ְڳ. 밡 Ůϴ. -- Karnes 2006-05-28 16:09:16
忡 ߴ
1. ٹ Էϰ, Ŵ Ͽ װ ϰ Ѵ. ̶ ͺ̽ ڵ带 ̸ ٽ PDF .
2. ȹ Էϰ ̸ PDF .
Ǿ
1.ͺ̽ ڵ ڵ ϰ ؾ Ѵ.
2. ampersand, backslash php escape ڿ ؿ escape ڸ ãƼ óѴ. (̰ ó ʴ.)
߽ϴ. --hoze
մϴ. ֽʽÿ --synapse
Ѱ ϴ. PerlTeX perltex mySQL ߴٰ ߽ϴ. google ƹ , ٸ 뵵 ʱ? ٸ mySQL Ἥ data ʿ䰡 ִ°? Դϴ. mySQL data ֱ , 츮 ؼ ٸ ̱ մϴ. ׳ perl̳ php text ϰ ű⼭ data ̾ƿͼ ۾ ص ɰ ? ƴϸ glossary index database ϴ 찡 ִٰ ϴ, ̰ source ؼ 캼?(source Ѵٰ ϴ.. ̶ ˼ ͱ մϴ.) õ 鼭 ϰ ֽϴ. --synapse
̷ϴ. mySQL ݵ 䱸Ǵ ƴϰ. , ̶ Ư Է¸ ٰ ư ߿ Ʈ *Է*ϴ , ۾ ؼ, 뷮 ϱ ؼ SQL ̶̻ ֽϴ. ϴ 1000 Ѿ ʰڽϱ? TeX mySQL ϴ SQLTeX̶ ǵ ֽϴ. ɴ SQL ϴ ͽϴ. --Karnes2006-05-30 19:11:51
մϴ. ̷ þ±.:) --synapse
TeX MySQL ʿ䰡 ? (?) ִԴϴٸ access.MDB delphi α Ͽ tex ֽϴ. acess.MDB Է, α access Ͽ texȭ , latex compile, dvipdfmx PDF ⸦ Ͽ ִµ, HWP ۾ϴ Ϳ Ͽ ϰ ֽϴ. ( , ٸ е HWP (?) interface ƽ Ͻô. ) -- likesam
php۾ ٴ Դϴ. ʺ Է° ã ϱ?( Ȱ ƴ..) ̷ ʹ php ӹ ִٰ Ϸ ϴ ۾ Ƽ! Ȥö ѹ ϰ http://kbrobgy.nameip.net/main.html ؼ 'ãƼ (html)' Ŭؼ ȯ a óʽÿ. ߿ ϳ ϸ ± ɴϴ. --synapse
ýϴ. մϴ. , ̽ Generate PDF ϳ ̰ ִ ̰ڱ. ϳ ڸ, A, B, C ĺ ں PDF ü PDF ֵ ϴ ڰ, ڵ ؼ *۾* ũƮ óϴ ϴ. ҰϽ url ż ϰ ִµ... --Karnes
ϴ ˼ϴٴ 帮 ڽϴ. computer Ŀƾ Ǵµ, ۾ ʾƼ ѳ ʾҽϴ. Ͻ ѹ غڽϴ... (615) ־ ѳ Դϴ. ѹ 帰 KTUG Ưpage pdfȭ ϴ Ϳ Ͻô?
ּż մϴ. --synapse
ҽϴ. Ǵ ϴ. ϼ̽ϴ. ߿ . -- Karnes 2006-06-19 23:33:09
쿬 ͼ ԵǾϴ. ΰ ϴ. ù° ð ( ̶ ִ°...) ° Ź ̷ Ű ֽô Ϳ ϴ. ð Ͻô? ð ΰ Ͻôµ ϴµ.... ϴ. 帳ϴ. --synapse