'''¸ñÀû''' : ÀÏÀü¿¡ ChoF´Ô°ú karnes´ÔÀÇ ¸»¾¸¿¡ µû¶ó¼ TeX¿Í DataBaseÀÇ ¿¬µ¿À» »ý°¢ÇØ º¸¾Ò½À´Ï´Ù. ÀÌ ÀÛ¾÷Àº ¸¹Àº ÀÛ¾÷ toolsÀÌ ÇÊ¿äÇϹǷΠ¿©±â¿¡ ³Ö°í ³ª¼ Çϳª¾¾ ÇØ ³ª°¥¶§ ¸¶´Ù ä¿ö³ª°¥ »ý°¢ÀÔ´Ï´Ù. ÀÏ´Ü ÀÛ¾÷ ±¸¼ºÀ¸·Î »ý°¢ÇÏ°í Àִ°ÍÀº ´ÙÀ½°ú °°½À´Ï´Ù.
1. APM¸¦ ¼³Ä¡ÇÏ°í(in linux)
2. ¹®¼ÀÇ ÀÔ·ÂÀº PHPµîÀ» ÀÌ¿ëÇÏ¿©¼ form tagÀ» ÀÌ¿ëÇÏ¿©¼ mySQL¿¡ Áý¾î ³Ö½À´Ï´Ù.
3. ÀÔ·ÂµÈ mySQL data¸¦ LaTeX¸¦ ÀÌ¿ëÇÏ¿©¼ Á¶ÆÇÇÕ´Ï´Ù.
4. Tex4ht¸¦ ÀÌ¿ëÇÏ¿©¼ html¹®¼¾ç½ÄÀ» ¸¸µì´Ï´Ù.(optional)
¸î°¡Áö ¹®Á¦µéÀÌ ÀÖ¾î¼(Á¦°¡ °®°í ÀÖ´Â webhosting¾÷ü¿¡¼´Â ¿ÜºÎ¿¡¼ mySQLÁ¢¼ÓÀ» Â÷´ÜÇÏ°í ÀÖ¾î¼) ´ÜÁö Áý¿¡¼¸¸ ÀÛ¾÷À» ÇØ¾ß ÇϹǷΠÀÛ¾÷¼Óµµ ¸Å¿ì ´À¸±°Í °°´Ù´Â »ý°¢À» ÇÏ°í ÀÖ½À´Ï´Ù. ÇÏÁö¸¸ Çϳª¾¿ ÇØ ³ª°¡¸é¼ ä¿ö³ª°¥¼ö ÀÖÀ¸¸é ÁÁ°Ú½À´Ï´Ù.
* ÀüüÀûÀÎ DicÀÇ dataÀÇ ±¸¼ºµµÀÔ´Ï´Ù. °ü°èÇü DB¸¦ »ç¿ëÇؼ ÇÒ ¿¹Á¤ÀÔ´Ï´Ù.
* ÀüüÀûÀÎ ÀÛ¾÷ÀÇ ¼ø¼µµÀÔ´Ï´Ù.
== APM¼³Ä¡(in linux) ==
ÀÏ´Ü À̶õÀº ºñ¿ö µÎ°Ú½À´Ï´Ù. ¸¹Àº Ã¥µéÀ» È°¿ëÇϰųª http://www.phpschool.com ¿¡ °¡½Ã¸é ¸¹Àº ¹®¼µéÀÌ ÀÖÀ¸¹Ç·Î °Å±â¸¦ ÀûÀýÈ÷ ÂüÁ¶ÇÏ¸é µÉ°Í °°½À´Ï´Ù. ³ªÁß¿¡ ÀÌÀÏÀÌ ³¡³ª°í ³ÈÄ¿¡ ÇÊ¿äÇÏ´Ù°í ÇϽô ºÐµéÀÌ °è½Ã¸é ä¿ö³Ö°Ú½À´Ï´Ù.
* web hosting¾÷ü¿¡°Ô mySQL¸¦ ¿¾î ´Þ¶ó°í Çϱ⿡´Â ³Ê¹«³ª ¹«¸®ÀÏ°Í °°¾Æ¼, À¯µ¿ IP¸¦ °íÁ¤ IP·Î º¯°æ½ÃÄÑ ÁÖ´Â service¸¦ ÀÌ¿ëÇϱâ·Î Çß´Ù. http://www.nameip.co.kr ¿¡ Á¢¼ÓÇؼ °£´ÜÈ÷ ¹«·á id¸¦ ¹Þ°í ³ÈÄ¿¡ ³»ÄÄ¿¡¼ apache daemon¸¦ ½ÇÇà½ÃÄÑ ÁÖ´Ï °£´ÜÈ÷ ³»ÄÄÀÌ server°¡ µÇ¾ú´Ù. ´ÜÁ¡À¸·Î´Â ÁýÀÇ ÄÄÇ»Å͸¦ ÇÏ·ç Á¾ÀÏ Äѳõ¾Æ¾ß ÇÑ´Ù´Â Á¡ÀÌ ÀÖÁö¸¸, Àü±â·á´Â ¾à 700¿øÁ¤µµ ¹Û¿¡ µÇÁö ¾Ê´Â´Ù´Ï, ¿ì¼±Àº ÀÌ·¸°Ô ¾²±â·Î ÇÏ¿´´Ù.
== mySQL database¹× table¸¸µé±â ==
06ObGyDic database¿¡´Â ¾à 3°³ÀÇ tableÀÌ ÇÊ¿äÇÒ °Í °°´Ù.
* 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·Î µÎ±â·ÎÇÏ°Ú´Ù.)
1.¿ì¼± root»ç¿ëÀÚÀÇ ºñ¹Ð¹øÈ£¸¦ ¸¸µç´Ù.
{{{#> /usr/local/mysql/bin/mysql mysql
.....
mysql>update user set password=password('******') where user='root';
mysql>flush privileges;
mysql>quit
}}}
1.±× ÈÄ¿¡ 06ObGyDic database¹× »ç¿ëÀÚ settingÇÑ´Ù
{{{#> /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'ÀÇ °¹¼ö¸¦ Á¶Á¤ÇÑ´Ù.
1. ±× ÈÄ¿¡ table»ý¼ºÇÑ´Ù.
{{{#>/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 );
}}}
1. ±âÁ¸ÀÇ OpenOffice.calc·Î ¸¸µé¾îÁø data¸¦ mySQL·Î Áý¾î³Ö±â.
¿©·¯ °¡Áö ¹æ¹ýÀÌ ÀÖÀ»°Í °°½À´Ï´Ù¸¸ ¿ì¼± 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¿¡ Áý¾î³ÖÀ»¶§µµ ±×·¸°í \´Â ¹«½Ã¸¦ ÇÏ´Â °Í °°½À´Ï´Ù. ±×·¡¼ ¾î¿¼ö ¾øÀÌ \\Áý¾î ³Ö°í ÇÏ´Ï ¿øÇÏ´Â °á°ú´Â ³ª¿À´Â ±º¿ä.
attachment:0603TeXObGyDic.csv
== °£´ÜÈ÷ 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ÀÔ´Ï´Ù.
{{{ main page";}
else {print "$pass are incorrect. Authorization failure";}
?>}}}
== ¹®¼ ÀÔ·Â form°ú ¼öÁ¤ form ¹× º¸±â form ¸¸µé±â ==
¹®¼ÀÇ ÀÔ·ÂÀº °£´ÜÈ÷ spreadsheet¸¦ ÀÌ¿ëÇؼ ¸¸µé¾î¼ ÇÏ¸é °£´ÜÇÒµí ½ÍÁö¸¸, ³ªÁßÀÇ À¯Áöº¸¼ö¸¦ À§Çؼ´Â ¾Æ¹«·¡µµ web¿¡¼ ¹®¼¸¦ ¹Þ¾Æ¿À´Â °ÍÀÌ ´õ Çö¸íÇÒ °Í °°¾Æ¼ phpµîÀ» ÀÌ¿ëÇؼ ¸¸µé±â·Î Çß½À´Ï´Ù.
* DB_insert.phpÀÔ´Ï´Ù.
{{{ go back";
?>}}}
*mySQL¿¡¼´Â '¸¦ ¾µ¼ö ¾ø´Ù°í ÇÑ´Ù. ±×·¡¼ ±×³É ÀÔ·ÂÇÒ¶§´Â \backshlashdot·Î Çϱâ·ÎÇß´Ù.
*±×·±µ¥ ¾ÆÁ÷±îÁöµµ ÀÔ·ÂÀÌ ³¡³ª°í ³ª¸é ÀÌÀü ȸéÀ¸·Î µ¹¾Æ°¡´Â ±â´ÉÀ» ¾Ë¼ö°¡ ¾ø½À´Ï´Ù.:-(
*¼öÁ¤ formÀÔ´Ï´Ù. ±×Áß¿¡ edit_source.phpÀÔ´Ï´Ù.
{{{";
}
$search_result=mysql_fetch_array($result);
mysql_close($connect);
?>
edit_source.html
}}}
*ã¾Æ¼ º¸±âÆû ±îÁö ¸¸µé¾ú´Ù. ´ÙÀ½Àº searh_query_view.phpÀÔ´Ï´Ù. ã¾Æ¼ º¸±âÀÇ Æû¿¡¼´Â °ãÄ¡´Â Áúȯ¸íÀÌ ÀÖÀ»¶§µµ °¡´ÉÇÏ°Ô ÇÏ¿´½À´Ï´Ù.
{{{
search_query.php
";
}
$list=mysql_num_rows($query);
if($list)
{
while ($row=mysql_fetch_array($query)){
$identify_dis="$row[main_disease_id] $row[Disease_En] $row[Disease_Ko]";
?>
>
}}}== 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ÇØÁØ´Ù.
*Á¤±ÔÇ¥Çö½ÄÀÇ Ç¥ÇöÀ¸·Î´Â
== LaTeX·Î Á¶ÆÇÇϱâ ==
ÇöÀç±îÁö µé¾î°¡ ÀÖ´Â data¸¦ ±âÁØÀ¸·Î Çؼ ¾à½ÄÀ¸·Î ¸¸µé¾î º¸°Ú½À´Ï´Ù.
* ¿ì¼± mySQL¿¡¼ ÇØ¾ß ÇÒÀÏÀº dataÀÇ sortingÀÔ´Ï´Ù. ÀÇÇпë¾îÁýÀ̶ó Ưº°ÇÑ ±âÈ£°¡ µé¾î°¡Áö ¾Ê´Â°ÍÀÌ ´ÙÇàÀÔ´Ï´Ù.
* data¸¦ sortinÈÄ¿¡ A,B,C,....¼øÀ¸·Î ÃßÃâÇÏ´Â °ÍÀÔ´Ï´Ù.
* À§ÀÇ µÑÀ» ÇÔ²² Çϱâ À§ÇÑ mySQL¸í·É¹®Àº SELECT * FROM ObGyDic_main WHERE Disease_En LIKE 'a%' ORDER BY Disease_En ascÀÓ
* ÀÌ°ÍÀ» À§ÇÑ SQLTeXÀÇ ¸í·É¹®À¸·Î »ý°¢ÇÒ ¼ö ÀÖ´Â °ÍÀº \sqlrow[fldsep=}{,rowsep=} \n(?) \dicentry{] {SELECT * FROM ObGYDic_main WHERE Disease_En LIKE 'a%' ORDER BY Disease_En asc}·Î ÇÏ¸é µÉ°Í °°´Ù.
* ±×¸®°í ³ª¼ output file¿¡¼ ù field¿¡ \dicentry¸¦ Áý¾î ³Ö°í ¸¶Áö¸· fieldÀÇ \dicentry{¸¦ Áö¿ì´Âµî ¸î¹øÀÇ ¼öÀÛ¾÷Àº ¾î¿¼ö ¾ø´Âµí ÇÏ´Ù. ¾Æ´Ï¸é ´Ù¸¥ ¹æ¹ýÀÌ ÀÖÀ»±î¿ä? µµ¿ÍÁÖ¼¼¿ä.
DeleteMe. sql µ¥ÀÌÅ͸¦ comma-separated-plain-text·Î ¾òÀ» ¼ö ÀÖ´Â °ÅÁö¿ä? ÀÌ raw µ¥ÀÌÅ͸¦ Á» ¿Ã·Áº¸¾Æ ÁֽðڽÀ´Ï±î? sql¿¡¼ ¸· ÃßÃâµÈ µ¥ÀÌÅÍ ÇüŸ¦ º¸°í ½Í½À´Ï´Ù.
°¨»çÇÕ´Ï´Ù. Á¦°¡ mySQL¸¦ Àß ¾µÁÙ ¸ô¶ó¼¿ä... ±×³É Á¦°¡ openoffice¿¡¼ ÀÛ¾÷Çß´ø csv¸¦ ¿Ã·Áµå¸®°Ú½À´Ï´Ù.(¿ì¼±Àº¿ä) http://kbrobgy.linuxtop.co.kr/0607TeXObGyDic.csv ÀÔ´Ï´Ù. ÀÌÁß¿¡ \\ÀÌ µÎ¹ø µé¾î°¡ ÀÖ´Â °ÍÀº mySQL¿¡ µé¾î°¡¸é Á¦´ë·Î µÇ¾îÀÖ½À´Ï´Ù. ¶ÇÇÑ , seperationÀÌ ¾Æ´Ï°í ; seperationÀÔ´Ï´Ù. Á¦°¡ Á¶±Ý´õ °øºÎÇؼ raw data´Â ¿Ã·Áµå¸®°Ú½À´Ï´Ù.
¹æ¹ýÀ» ã¾Ò½À´Ï´Ù.
SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;
* ±× ÈÄ¿¡ °¡Áö°í ¿Â data¸¦ tex¸¦ ÀÌ¿ëÇؼ Ãâ·ÂÇÏ¸é µË´Ï´Ù. ÀÌÀü¿¡ »ç¿ëÇß´ø http://www.ktug.or.kr/jsboard/read.php?table=operate&no=17525&page=1&o[sc]=a&o[ss]=dic&o[st]=a&o[at]=s&o[sct]=s&o[stt]=s »ç¿ëÇؼ¿ä.
== TeX4ht¸¦ ÀÌ¿ëÇÏ¿© html¹®¼ ¸¸µé±â(optional) ==
----
¸¹Àº °ü½É°ú Áöµµ¸¦ ºÎŹµå¸³´Ï´Ù. ¿ëµÎ»ç¹Ì°¡ µÇÁö ¾Ê°Ô ÇØÁֽʽÿä.
ÀÌ°Å Àç¹ÌÀְڳ׿ä. ±â´ë°¡ Å®´Ï´Ù. -- [Karnes] [[DateTime(2006-05-28T07:09:16)]]
°¨»çÇÕ´Ï´Ù. ¸¹ÀÌ µµ¿ÍÁֽʽÿä --[synapse]
ÇÑ°¡Áö °í¹ÎÀÌ »ý°å½À´Ï´Ù. PerlTeX¿¹Á¦¿¡¼ º¸µíÀÌ perltex¿¡¼ mySQL·Î Á÷Á¢¿¬°áÀº ½ÇÆÐÇß´Ù°í Çß½À´Ï´Ù. google¿¡°Ô ¾Æ¹«¸® ¹°¾îºÁµµ, º°´Ù¸¥ ³»¿ëµµ ³ª¿ÀÁö ¾Ê±¸¿ä? ±×·¸´Ù¸é ±»È÷ mySQL¸¦ ½á¼ data¸¦ Áý¾î ³ÖÀ» ÇÊ¿ä°¡ Àִ°¡? ¶ó´Â °ÍÀÔ´Ï´Ù. ¹°·Ð mySQL¿¡ data¸¦ Áý¾î ³ÖÀ¸¸é ¿©·¯¸ð·Î Æí¸®ÇÑ Á¡ÀÌ ÀÖ±â´Â ÇÏÁö¸¸, ¿ì¸®ÀÇ ÁÖÁ¦¿Í °ü·ÃÇؼ´Â º°´Ù¸¥ ÀåÁ¡ÀÌ ¾ø¾î º¸À̱â´Â ÇÕ´Ï´Ù. ±×³É perlÀ̳ª php¿¡¼ °£´ÜÈ÷ text ¹®¼·Î ÀúÀåÇÏ°í °Å±â¼ data¸¦ »Ì¾Æ¿Í¼ ÀÛ¾÷À» Çصµ µÉ°Í °°Àºµ¥¿ä? ¾Æ´Ï¸é glossary¿Í index¿¡¼ °¡²û¾¿ database¸¦ »ç¿ëÇÏ´Â °æ¿ì°¡ ÀÖ´Ù°í ÇÏ´øµ¥, ÀÌ°ÍÀ» source¸¦ Á» ±¸Çؼ »ìÆ캼±î¿ä?(source¸¦ ±¸ÇÑ´Ù°í ÇÏ´õ¶óµµ.. ±î¸·´«À̶ó ¾Ë¼ö³ª ÀÖÀ»Áö ½Í±â´Â ÇÕ´Ï´Ù.) ¿À´Ãµµ ¹«¾ùÀÎÁö Àß ¸ð¸£¸é¼ ¿½ÉÈ÷ »ðÁúÇÏ°í ÀÖ½À´Ï´Ù. --[synapse]
Á¦ »ý°¢Àº ÀÌ·¸½À´Ï´Ù. ¸»¾¸´ë·Î ±»ÀÌ mySQL±îÁö ¾²´Â °ÍÀÌ ¹Ýµå½Ã ¿ä±¸µÇ´Â °ÍÀº ¾Æ´Ï°ÚÁö¿ä. ±×·¯³ª, »çÀüÀ̶ó´Â ¹°°ÇÀÇ Æ¯¼º»ó ÇÑ »ç¶÷ÀÇ ÀԷ¸¸À¸·Î ¸ðµç ÀÏÀÌ ³¡³´Ù°í º¸±â´Â ¾î·Æ°í »çÀü¿¡¼ °¡Àå Áß¿äÇÑ °ÍÀÌ ¿£Æ®¸®µéÀ» *ÀÔ·Â*ÇÏ´Â °ÍÀÓÀ» »ý°¢ÇÒ ¶§, °øµ¿ÀÛ¾÷À» À§Çؼ, ±×¸®°í ¹æ´ëÇÑ ´ë¿ë·® µ¥ÀÌÅ͸¦ Ãë±ÞÇϱâ À§Çؼ SQLÀÌ ÀÌ»óÀûÀ̶ó°í º¸°í ÀÖ½À´Ï´Ù. ÀÏ´Ü »çÀüÀº 1000ÆäÀÌÁö°¡ ³Ñ¾î°¡´Â °ÍÀº ¿ì½ÀÁö ¾Ê°Ú½À´Ï±î? TeX ³»¿¡¼ mySQLÀ» Á¦¾îÇÏ´Â [http://ftp.ktug.or.kr/tex-archive/support/SQLTeX/ SQLTeX]À̶ó´Â ¹°°Çµµ ÀÖ½À´Ï´Ù. ¾ó¸¶³ª µµ¿òÀÌ µÉ´ÂÁö´Â ¸ð¸£°ÚÁö¸¸ °£´ÜÇÑ SQL¸í·ÉÀ» ¿¬µ¿ÇÏ´Â °ÍÀº °¡´ÉÇÑ µíµµ ½Í½À´Ï´Ù. --[Karnes][[DateTime(2006-05-30T10:11:51)]]
°¨»çÇÕ´Ï´Ù. ÀÌ·¡Àú·¡ °øºÎÇÒ °Í¸¸ ´Ã¾î°¡´Â±º¿ä.:) --[synapse]
²À TeX¿¡¼ MySQLÀ» Á÷Á¢ ¹°°í µé¾î°¥ ÇÊ¿ä°¡ ÀÖÀ»±î¿ä? Àúµµ »çÀü(?)°ú ºñ½ÁÇÑ °ÍÀ» ¸¸µé¾î º¸°í ÀÖ´ÂÁßÀÔ´Ï´Ù¸¸ access.MDB¸¦ delphi·Î ¸¸µç °£´ÜÇÑ ÇÁ·Î±×·¥À¸·Î ÃßÃâÇÏ¿© texÀ» ¸¸µé°í ÀÖ½À´Ï´Ù. ÇöÀç acess.MDB¿¡ ÀÔ·Â, °£´ÜÇÑ ÇÁ·Î±×·¥À» µ¹·Á access¿¡¼ ³»¿ëÀ» ÃßÃâÇÏ¿© texÈÀÏ ¸¸µê, latexÀ¸·Î compile, dvipdfmxÀ¸·Î PDF·Î ¸¸µé±â¸¦ ÇÏ¿©º¸°í Àִµ¥, HWP·Î ÀÛ¾÷ÇÏ´Â °Í¿¡ ºñÇÏ¿© ¸¸Á·ÇÏ°í ÀÖ½À´Ï´Ù. (Àú´Â ¸¸Á·ÇÏÁö¸¸, ´Ù¸¥ ºÐµéÀº HWPÀÇ Á÷°üÀû(?) interface¸¦ ¾Æ½¬¿ö ÇϽôõ±º¿ä. X-( ) -- [likesam]
ÇÒ¼ö¸¸ ÀÖ´Ù¸é, MySQL¸¦ Á÷Á¢¹°°í µé¾î°¡´Â °Íµµ ÁÁÀ»°Í °°±â´Â ÇÕ´Ï´Ù. ½ÇÁ¦·Î web¿¡¼ÀÇ ¹®¼´Â ±×³É printÇؼ º¼ ±âȸ°¡ °¡²û¾¿ Àִµ¥, ÀÌ°Í ±×³É ºÁ¾ßÇؼ º¸´Â °ÅÁö... Á¤¸»·Î º¸±â°¡ ¾î·Æ½À´Ï´Ù. ÇÏÁö¸¸ mySQL¿¡¼ Á÷Á¢(?) ¿¬°áÀÌ °¡´ÉÇÏ´Ù¸é, ÈÙ¾À ÁÁ¾ÆÁú°Í °°±â´Â ÇÕ´Ï´Ù. ƯÈ÷ ¿ì¸® ktug¿¡¼ ¸¸ÀÌ¶óµµ ÀÌ·¯ÇÑ ±â´ÉÀÌ Ã·°¡ µÈ´Ù¸é ¸Å¿ì ÁÁÀ»°Í °°´Ù´Â Á¶±×¸¸ÇÑ ¼Ò¸ÁÀÌ ÀÖ½À´Ï´Ù. ¹¹°¡ ¹º ¸»ÀÎÁö Á¦°¡ ÀоîºÁµµ Á» ±×·¸±â´Â ÇÕ´Ï´Ù¸¸,.. ½±°Ô ¸»Çؼ, practical useÀÇ ¾î´À ƯÁ¤ÇÑ ±ÛŸ·¡¸¦ Á»´õ º¸±â ÁÁ°Ô º¼¼öµµ ÀÖÁö ¾ÊÀ»±î? ÇÏ´Â »ý°¢ÀÔ´Ï´Ù.--[synapse]
¿¹Àü Á÷Àå¿¡¼ Á¦°¡ Çß´ø °ÍÀº
1. ±Ù¹« ÀÏÁö¸¦ ¸ÅÀÏ ÀÔ·ÂÇÏ°í, ¸Å´Þ ¸»ÀÏ¿¡ ±×°ÍÀ» Ãâ·ÂÇÏ°Ô ÇÑ´Ù. À̶§ µ¥ÀÌÅͺ£À̽º ·¹Äڵ带 ÅØÀ¸·Î ¸¸µé°í À̸¦ ´Ù½Ã PDF·Î ¸¸µç´Ù.
2. »ç¾÷ °èȹ¼ µûÀ§¸¦ ÀÔ·ÂÇÏ°í À̸¦ PDF·Î ¸¸µç´Ù.
ÀÌ ¶§ ¹®Á¦°¡ µÇ¾ú´ø °ÍÀº
1.µ¥ÀÌÅͺ£À̽ºÀÇ ÀÎÄÚµù°ú ÅØ ÀÎÄÚµùÀ» µ¿ÀÏÇÏ°Ô ÇØ¾ß ÇÑ´Ù.
2. ampersand, backslash µî php¿¡¼ÀÇ escape ¹®ÀÚ¿Í ÅØ¿¡¼ÀÇ escape ¹®ÀÚ¸¦ ã¾Æ¼ ó¸®ÇÑ´Ù. (ÀÌ°Å »ý°¢Ã³·³ ½±Áö ¾Ê´õ±º¿ä.)
±×·°Àú·° Àß ½è°í ²Ï ÆíÇß½À´Ï´Ù. --[hoze]
°¨»çÇÕ´Ï´Ù. hoze´ÔÀÌ °æÇèÇϽŠ³»¿ëÀ» Á» ±¸Ã¼ÀûÀ¸·Î À̾߱â ÇØÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.ÀúÀÇ °æ¿ì¿¡´Â ¿ì¼± mySQL¿¡ ÀÔ·ÂÇÏ°í ³ª¼, ÀÌ ³»¿ëÀ» ±×³É °ð¹Ù·Î TeX·Î »ç¿ëÇÒ°ÍÀÎÁö ¾Æ´Ï¸é text·Î º¯È¯ÇÏ¿© ¾µ°ÍÀÎÁö´Â °í¹ÎÁßÀÔ´Ï´Ù¸¸.. ¾îÂ¥ÇÇ ÀÌ°ÍÀÌ¾ß mySQL°ú TeXÀÇ ¹®Á¦¶ó°í »ý°¢ÀÌ µË´Ï´Ù. ±×·¸Áö¸¸ ÀÌÁ¦ Á¶±Ý´õ ½Ã°£ÀÌ ³²°í ¿©·ÂÀÌ ³²À¸¸é mySQL data¸¦ php·Î ºÒ·¯µé¿©¼ web¿¡¼ list¹× editÇØ¾ß ÇÒ ÀÏÀÌ »ý±æ°Í °°±â¿¡ ±×·³´Ï´Ù. °¨»çÇÕ´Ï´Ù.--[synapse]
----
ÀÌÁ¦ ¾î´À Á¤µµÀÇ phpÀÛ¾÷Àº ³¡³°Í °°´Ù´Â »ý°¢ÀÔ´Ï´Ù. ¾ÆÁÖ Ãʺ¸ÀûÀÌÁö¸¸ ÀԷ°ú ã±â º¸±â ±â´ÉÀÌ °¡´ÉÇØÁ³À¸´Ï±î¿ä?(¾ÆÁ÷±îÁö´Â ´Ù µÈ°ÍÀº ¾Æ´ÏÁö¸¸..) ÀÌ·¸°Ô ³Ê¹« php¿¡¸¸ ¸Ó¹°·¯ ÀÖ´Ù°¡´Â Á¦°¡ ÇÏ·Á°í ÇÏ´Â ÀÛ¾÷À» ¼ÕÀ» ¸ø´î°Í °°¾Æ¼¿ä! Ȥ½Ã¶óµµ Çѹø ±¸°æÀ» ÇÏ°í ½ÍÀº½Å ºÐÀº http://kbrobgy.nameip.net ¿¡ Á¢¼ÓÇؼ óÀ½ id¿Í password¿¡¼´Â KTUG, KTUG1234¸¦ Áý¾î ³Ö°í µé¾î¿Í¼ 'ã¾Æ¼ º¸±â' ¶õÀ» Ŭ¸¯Çؼ ¿µ¾î Áúȯ¸í¿¡¼ a¸¦ 󺸽ʽÿä. ±×Áß¿¡ Çϳª¸¦ ¼±ÅÃÇÏ¸é ¿©Å±îÁö ÇÑ °á°ú°¡ ³ª¿É´Ï´Ù. ³»ÀϺÎÅÍ´Â ÀÌÁ¦ ºÎÅÍ mySQL¿¡¼ ¾î¶°ÇÑ ¹®ÀÚ¸¦ ¾²¸é ¾ÈµÇ´ÂÁö... mySQL¿¡¼ ¾î¶»°Ô data¸¦ »Ì¾Æ¿Í¼ tex¿¡ Áý¾î ³Ö¾î¾ß ÇÏ´ÂÁö¿¡ ´ëÇؼ ÇØ¾ß Çϱ⠶§¹®¿¡... °¥±æÀº ¸Ö±â´Â ÇÑ°Í °°½À´Ï´Ù. --[synapse]
attachment:WebTeX.zip ÀÌ°ÍÀº ÀÔ·Â ÆûÀ¸·ÎºÎÅÍ ¹ÞÀº ÅØÀ» PDF·Î ¸¸µå´Â °£´ÜÇÑ ÇÁ·Î±×·¥ÀÔ´Ï´Ù. µµ¿òÀÌ µÇ±æ ¹Ù¶ø´Ï´Ù. --[hoze]
°¨»çÇÕ´Ï´Ù. --[synapse]
----
CategoryGraphicTools