KTUGFaq
KTUG FAQ
FrontPage › MakingDic
¸ñÀû : ÀÏÀü¿¡ ChoF´Ô°ú karnes´ÔÀÇ ¸»¾¸¿¡ µû¶ó¼ TeX¿Í DataBaseÀÇ ¿¬µ¿À» »ý°¢ÇØ º¸¾Ò½À´Ï´Ù. ÀÌ ÀÛ¾÷Àº ¸¹Àº ÀÛ¾÷ toolsÀÌ ÇÊ¿äÇϹǷΠ¿©±â¿¡ ³Ö°í ³ª¼ Çϳª¾¾ ÇØ ³ª°¥¶§ ¸¶´Ù ä¿ö³ª°¥ »ý°¢ÀÔ´Ï´Ù. ÀÏ´Ü ÀÛ¾÷ ±¸¼ºÀ¸·Î »ý°¢ÇÏ°í Àִ°ÍÀº ´ÙÀ½°ú °°½À´Ï´Ù.
- APM¸¦ ¼³Ä¡ÇÏ°í(in linux)
- ¹®¼ÀÇ ÀÔ·ÂÀº PHPµîÀ» ÀÌ¿ëÇÏ¿©¼ form tagÀ» ÀÌ¿ëÇÏ¿©¼ mySQL¿¡ Áý¾î ³Ö½À´Ï´Ù.
- ÀÔ·ÂµÈ mySQL data¸¦ LaTeX¸¦ ÀÌ¿ëÇÏ¿©¼ Á¶ÆÇÇÕ´Ï´Ù.
- Tex4ht¸¦ ÀÌ¿ëÇÏ¿©¼ html¹®¼¾ç½ÄÀ» ¸¸µì´Ï´Ù.(optional)
- ÀüüÀûÀÎ DicÀÇ dataÀÇ ±¸¼ºµµÀÔ´Ï´Ù. °ü°èÇü DB¸¦ »ç¿ëÇؼ ÇÒ ¿¹Á¤ÀÔ´Ï´Ù.
- ÀüüÀûÀÎ ÀÛ¾÷ÀÇ ¼ø¼µµÀÔ´Ï´Ù.
[ÆíÁý]
1 APM¼³Ä¡(in linux) ¶
ÀÏ´Ü À̶õÀº ºñ¿ö µÎ°Ú½À´Ï´Ù. ¸¹Àº Ã¥µéÀ» È°¿ëÇϰųª http://www.phpschool.com ¿¡ °¡½Ã¸é ¸¹Àº ¹®¼µéÀÌ ÀÖÀ¸¹Ç·Î °Å±â¸¦ ÀûÀýÈ÷ ÂüÁ¶ÇÏ¸é µÉ°Í °°½À´Ï´Ù. ³ªÁß¿¡ ÀÌÀÏÀÌ ³¡³ª°í ³ÈÄ¿¡ ÇÊ¿äÇÏ´Ù°í ÇϽô ºÐµéÀÌ °è½Ã¸é ä¿ö³Ö°Ú½À´Ï´Ù.
- web hosting¾÷ü¿¡°Ô mySQL¸¦ ¿¾î ´Þ¶ó°í Çϱ⿡´Â ³Ê¹«³ª ¹«¸®ÀÏ°Í °°¾Æ¼, À¯µ¿ IP¸¦ °íÁ¤ IP·Î º¯°æ½ÃÄÑ ÁÖ´Â service¸¦ ÀÌ¿ëÇϱâ·Î Çß´Ù. http://www.nameip.co.kr ¿¡ Á¢¼ÓÇؼ °£´ÜÈ÷ ¹«·á id¸¦ ¹Þ°í ³ÈÄ¿¡ ³»ÄÄ¿¡¼ apache daemon¸¦ ½ÇÇà½ÃÄÑ ÁÖ´Ï °£´ÜÈ÷ ³»ÄÄÀÌ server°¡ µÇ¾ú´Ù. ´ÜÁ¡À¸·Î´Â ÁýÀÇ ÄÄÇ»Å͸¦ ÇÏ·ç Á¾ÀÏ Äѳõ¾Æ¾ß ÇÑ´Ù´Â Á¡ÀÌ ÀÖÁö¸¸, Àü±â·á´Â ¾à 700¿øÁ¤µµ ¹Û¿¡ µÇÁö ¾Ê´Â´Ù´Ï, ¿ì¼±Àº ÀÌ·¸°Ô ¾²±â·Î ÇÏ¿´´Ù.
[ÆíÁý]
2 mySQL database¹× table¸¸µé±â ¶
06ObGyDic database¿¡´Â ¾à 3°³ÀÇ tableÀÌ ÇÊ¿äÇÒ °Í °°´Ù.
=== ±× ÈÄ¿¡ 06ObGyDic database¹× »ç¿ëÀÚ settingÇÑ´Ù===
=== ±× ÈÄ¿¡ table»ý¼ºÇÑ´Ù.===
=== ±âÁ¸ÀÇ 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 06ObGyDic; .... mysql>insert into user (host,user,password) values('localhost','ObGyDic',password('ObGyDic1234')); .... mysql>insert into db values ('localhost','06ObGyDic','ObGyDic','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 ObGyDic -p 06ObGyDic Enterpassword: ObGyDic1234 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 ( -> id 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ÇÑ´Ù. Á¤µµÀÏ°ÍÀÔ´Ï´Ù.
Àú´Â óÀ½ÀÇ ¹æ¹ýÀ¸·Î ÇÏ¿´½À´Ï´Ù.