KTUGFaq
KTUG FAQ
The attacker must vanquish; the defender need only survive.
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ÀÌ ÇÊ¿äÇÒ °Í °°´Ù.
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ÇÑ´Ù. Á¤µµÀÏ°ÍÀÔ´Ï´Ù.
Àú´Â óÀ½ÀÇ ¹æ¹ýÀ¸·Î ÇÏ¿´½À´Ï´Ù.
[ÆíÁý]
3 °£´ÜÈ÷ login form¸¸µé±â ¹× dbÀÌ¿ëÇغ¸±â ¶
Á¦°¡ Ãʺ¸¶ó¼ ÀÌÇØÇØ Áֽñ⠹ٶø´Ï´Ù. ±×¾ß¸»·Î Ãʺ¸ÀûÀÌ°í ¿ø½ÃÀûÀ¸·Î ¸¸µé¾ú½À´Ï´Ù. ¿ì¼± ±¸¼ºÀº ÀÌ·¸½À´Ï´Ù. index.html¿¡¼ login¸¦ ¶ç¿öÁÖ°í ³ÈÄ¿¡ °Å±â¼ ¹ÞÀº name°ú pass¸¦ °¡Áö°í mySQLÀÇ data¿Í ºñ±³Çؼ ¸ÂÀ¸¸é main.html·Î °¡°Ô ÇÏ°í Ʋ¸®¸é °Å±â¼ ÁøÇàÇÒ ¼ö ¾ø°ÔÇß½À´Ï´Ù. (¾îÂ¥ÇÇ ´«°¡¸®°í ¾Æ¿õÇÏ´Â °ÍÀ̱â´Â ÇÏÁö¸¸¿ä!) ±×³É ÀÌ°ÍÀº mySQL¸¦ php¿¡¼ »ç¿ëÇغ¼·Á°í ¿¬½À »ï¾Æ ¸¸µç°ÍÀÔ´Ï´Ù.
id´Â KTUG
password´Â KTUG1234ÀÔ´Ï´Ù.
´ÙÀ½ÀÇ site¿¡ µé¾î¿À½Ã¸é º¼¼öÀÖ½À´Ï´Ù.(´Ü Á¦°¡ ÄÄÇ»Å͸¦ ÄÑ°í ÀÖÀ»¶§¸¸ÀÔ´Ï´Ù). http://kbrobgy.nameip.net/ ÀÔ´Ï´Ù. ´ÙÀ½Àº login.phpÀÔ´Ï´Ù.
´ÙÀ½ÀÇ site¿¡ µé¾î¿À½Ã¸é º¼¼öÀÖ½À´Ï´Ù.(´Ü Á¦°¡ ÄÄÇ»Å͸¦ ÄÑ°í ÀÖÀ»¶§¸¸ÀÔ´Ï´Ù). http://kbrobgy.nameip.net/ ÀÔ´Ï´Ù. ´ÙÀ½Àº login.phpÀÔ´Ï´Ù.
<?php extract($_POST); $connect=mysql_connect("localhost","KTUG","KTUG1234"); mysql_select_db("TeXObGyDic",$connect); $query=mysql_query("SELECT password FROM Admission_ObGyDic WHERE name='$name'"); $result=mysql_result($query,0); mysql_close($connect); if ($result == $pass) {print "Good! go to the <a href=main.html> main page</a>";} else {print "$pass are incorrect. Authorization failure";} ?>
±×¸®°í input.php´Â ¾ÆÁ÷ ¸¸µéÁö ¾Ê¾Ò½À´Ï´Ù.(¾ÈµÈ°ÍÀÌ ¸¹¾Æ¼, Çϳª Çϳª °øºÎÇÏ¸é¼ ÇØ ³ª°¥ »ý°¢ÀÔ´Ï´Ù.)
[ÆíÁý]
4 ¹®¼ ÀÔ·Â form ¸¸µé±â ¶
¹®¼ÀÇ ÀÔ·ÂÀº °£´ÜÈ÷ spreadsheet¸¦ ÀÌ¿ëÇؼ ¸¸µé¾î¼ ÇÏ¸é °£´ÜÇÒµí ½ÍÁö¸¸, ³ªÁßÀÇ À¯Áöº¸¼ö¸¦ À§Çؼ´Â ¾Æ¹«·¡µµ web¿¡¼ ¹®¼¸¦ ¹Þ¾Æ¿À´Â °ÍÀÌ ´õ Çö¸íÇÒ °Í °°¾Æ¼ phpµîÀ» ÀÌ¿ëÇؼ ¸¸µé±â·Î Çß½À´Ï´Ù.
[ÆíÁý]
6 TeX4ht¸¦ ÀÌ¿ëÇÏ¿© html¹®¼ ¸¸µé±â(optional) ¶
¸¹Àº °ü½É°ú Áöµµ¸¦ ºÎŹµå¸³´Ï´Ù. ¿ëµÎ»ç¹Ì°¡ µÇÁö ¾Ê°Ô ÇØÁֽʽÿä.
ÀÌ°Å Àç¹ÌÀְڳ׿ä. ±â´ë°¡ Å®´Ï´Ù. -- 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
ÇÒ¼ö¸¸ ÀÖ´Ù¸é, MySQL¸¦ Á÷Á¢¹°°í µé¾î°¡´Â °Íµµ ÁÁÀ»°Í °°±â´Â ÇÕ´Ï´Ù. ½ÇÁ¦·Î web¿¡¼ÀÇ ¹®¼´Â ±×³É printÇؼ º¼ ±âȸ°¡ °¡²û¾¿ Àִµ¥, ÀÌ°Í ±×³É ºÁ¾ßÇؼ º¸´Â °ÅÁö... Á¤¸»·Î º¸±â°¡ ¾î·Æ½À´Ï´Ù. ÇÏÁö¸¸ mySQL¿¡¼ Á÷Á¢(?) ¿¬°áÀÌ °¡´ÉÇÏ´Ù¸é, ÈÙ¾À ÁÁ¾ÆÁú°Í °°±â´Â ÇÕ´Ï´Ù. ƯÈ÷ ¿ì¸® ktug¿¡¼ ¸¸ÀÌ¶óµµ ÀÌ·¯ÇÑ ±â´ÉÀÌ Ã·°¡ µÈ´Ù¸é ¸Å¿ì ÁÁÀ»°Í °°´Ù´Â Á¶±×¸¸ÇÑ ¼Ò¸ÁÀÌ ÀÖ½À´Ï´Ù. ¹¹°¡ ¹º ¸»ÀÎÁö Á¦°¡ ÀоîºÁµµ Á» ±×·¸±â´Â ÇÕ´Ï´Ù¸¸,.. ½±°Ô ¸»Çؼ, practical useÀÇ ¾î´À ƯÁ¤ÇÑ ±ÛŸ·¡¸¦ Á»´õ º¸±â ÁÁ°Ô º¼¼öµµ ÀÖÁö ¾ÊÀ»±î? ÇÏ´Â »ý°¢ÀÔ´Ï´Ù.--synapse