KTUGFaq
KTUG FAQ
There is no fear in love; but perfect love casteth out fear.
FrontPage › MakingDic
¸ñÀû : ÀÏÀü¿¡ ChoF´Ô°ú karnes´ÔÀÇ ¸»¾¸¿¡ µû¶ó¼ TeX¿Í DataBaseÀÇ ¿¬µ¿À» »ý°¢ÇØ º¸¾Ò½À´Ï´Ù. ÀÌ ÀÛ¾÷Àº ¸¹Àº ÀÛ¾÷ toolsÀÌ ÇÊ¿äÇϹǷΠ¿©±â¿¡ ³Ö°í ³ª¼ Çϳª¾¾ ÇØ ³ª°¥¶§ ¸¶´Ù ä¿ö³ª°¥ »ý°¢ÀÔ´Ï´Ù. ÀÏ´Ü ÀÛ¾÷ ±¸¼ºÀ¸·Î »ý°¢ÇÏ°í Àִ°ÍÀº ´ÙÀ½°ú °°½À´Ï´Ù.
- APM¸¦ ¼³Ä¡ÇÏ°í(in linux)
- ¹®¼ÀÇ ÀÔ·ÂÀº PHPµîÀ» ÀÌ¿ëÇÏ¿©¼ form tagÀ» ÀÌ¿ëÇÏ¿©¼ mySQL¿¡ Áý¾î ³Ö½À´Ï´Ù.
- ÀÔ·ÂµÈ mySQL data¸¦ LaTeX¸¦ ÀÌ¿ëÇÏ¿©¼ Á¶ÆÇÇÕ´Ï´Ù.
- Tex4ht¸¦ ÀÌ¿ëÇÏ¿©¼ html¹®¼¾ç½ÄÀ» ¸¸µì´Ï´Ù.(optional)
- ÀüüÀûÀÎ 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ÀÌ ÇÊ¿äÇÒ °Í °°´Ù.
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ÇÑ´Ù. Á¤µµÀÏ°ÍÀÔ´Ï´Ù.
Àú´Â óÀ½ÀÇ ¹æ¹ýÀ¸·Î ÇÏ¿´½À´Ï´Ù.
»õ·Î¿î ÷ºÎ "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ÀÔ´Ï´Ù.
== ¹®¼ ÀÔ·Â form°ú ¼öÁ¤ form ¹× º¸±â form ¸¸µé±â==
¹®¼ÀÇ ÀÔ·ÂÀº °£´ÜÈ÷ spreadsheet¸¦ ÀÌ¿ëÇؼ ¸¸µé¾î¼ ÇÏ¸é °£´ÜÇÒµí ½ÍÁö¸¸, ³ªÁßÀÇ À¯Áöº¸¼ö¸¦ À§Çؼ´Â ¾Æ¹«·¡µµ web¿¡¼ ¹®¼¸¦ ¹Þ¾Æ¿À´Â °ÍÀÌ ´õ Çö¸íÇÒ °Í °°¾Æ¼ 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´Â ¾ÆÁ÷ ¸¸µéÁö ¾Ê¾Ò½À´Ï´Ù.(¾ÈµÈ°ÍÀÌ ¸¹¾Æ¼, Çϳª Çϳª °øºÎÇÏ¸é¼ ÇØ ³ª°¥ »ý°¢ÀÔ´Ï´Ù.)
- DB_insert.phpÀÔ´Ï´Ù.
<?php extract($_POST); $db = mysql_connect("localhost","KTUG","KTUG1234"); mysql_select_db("TeXObGyDic",$db); $result = mysql_query("insert into ObGyDic_main (Disease_En,Shortended_Word,Disease_Ko,Definition, Disease_Code,Procedure_Code) values('$m_Disease_En','$m_Short_Word','$m_Disease_Ko','$m_Definition', '$m_Disease_Code','$m_Procedure_Code')",$db); mysql_close($db); print "<a href=input.html> go back</a>"; ?>
- mySQL¿¡¼´Â '¸¦ ¾µ¼ö ¾ø´Ù°í ÇÑ´Ù. ±×·¡¼ ±×³É ÀÔ·ÂÇÒ¶§´Â \backshlashdot·Î Çϱâ·ÎÇß´Ù.
- ±×·±µ¥ ¾ÆÁ÷±îÁöµµ ÀÔ·ÂÀÌ ³¡³ª°í ³ª¸é ÀÌÀü ȸéÀ¸·Î µ¹¾Æ°¡´Â ±â´ÉÀ» ¾Ë¼ö°¡ ¾ø½À´Ï´Ù.:-(
- ¼öÁ¤ formÀÔ´Ï´Ù. ±×Áß¿¡ edit_source.phpÀÔ´Ï´Ù.
<?php extract($_POST); $connect=mysql_connect("localhost","KTUG","KTUG1234"); mysql_select_db("TeXObGyDic",$connect); if ($s_main_disease_id == ""){ $result=mysql_query("SELECT * FROM ObGyDic_main WHERE Disease_En='$s_Disease_En'",$connect);} else {$result=mysql_query("SELECT * FROM ObGyDic_main WHERE main_disease_id='$s_main_disease_id'"±â ,$connect);} if(!$result) { echo mysql_errno().":"; echo mysql_error()."<BR>"; } $search_result=mysql_fetch_array($result); mysql_close($connect); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html; charset=utf8" http-equiv="content-type"> <title>edit_source.html</title> </head> <body> <h3 style="text-align: center;"><big><span style="font-weight: bold;"> <span style="font-family: Helvetica,Arial,sans-serif;">¼ö Á¤ Æû</span></span></big>   <a href=main.html>mainÀ¸·Î µ¹¾Æ°¡±â</a><br> </h3> <form method=POST action="edit_source_ok.php"> <center> <input type=hidden name="m_main_disease_id" value=<?php print $search_result[main_disease_id]?> > </center> <table style="text-align: left; width: 100%;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="font-weight: bold; width: 100px;">Áúȯ¸í(En)</td> <td colspan="1" rowspan="1" style="width: 457px;"> <input maxlength="50" size="50" name="m_Disease_En" value="<?php print $search_result['Disease_En']?>"></td> <td style="font-weight:bold; "width: 120px;" colspan="1">ÁÙÀθ»</td> <td style="width: 239px;"> <input maxlength="25" size="20" name="m_Short_Word" value="<?php print $search_result['Shortended_Word']?>"></td> </tr> <tr> <td style="font-weight: bold; width: 100px;">Áúȯ¸í(Ko)</td> <td colspan="3" rowspan="1" style="width: 239px;"> <input maxlength="50" size="50" name="m_Disease_Ko" value="<?php print $search_result['Disease_Ko']?>"><br> </td> </tr> <tr> <td style="height: 296px; font-weight: bold; width: 100px;">Á¤ ÀÇ</td> <td colspan="3" rowspan="1" style="height: 296px; text-align: justify; width: 239px;"> <textarea cols="80" rows="20" name="m_Definition"> <?php print $search_result[Definition]?></textarea><br> </td> </tr> <tr> <td style="height: 1px; font-weight: bold; width: 100px;">Áúȯcode</td> <td colspan="3" rowspan="1" style="height: 1px; width: 239px;"> <input maxlength="250" size="100" name="m_Disease_Code" value="<?php print $search_result['Disease_Code']?>"><br> </td> </tr> <tr> <td style="font-weight: bold; width: 100px;">óġCode</td> <td colspan="3" rowspan="1" style="width: 239px;"> <input maxlength="250" size="100" name="m_Procedure_Code" value="<?php print $search_result['Procedure_Code']?>"><br> </td> </tr> </tbody> </table> <br> <input value="±ÛÀ» ¿Ã¸³´Ï´Ù" type="submit"> <input value="reset" type="reset"> </form> </body> </html>
- ã¾Æ¼ º¸±âÆû ±îÁö ¸¸µé¾ú´Ù. ´ÙÀ½Àº searh_query_view.phpÀÔ´Ï´Ù. ã¾Æ¼ º¸±âÀÇ Æû¿¡¼´Â °ãÄ¡´Â Áúȯ¸íÀÌ ÀÖÀ»¶§µµ °¡´ÉÇÏ°Ô ÇÏ¿´½À´Ï´Ù.
<html> <head> <meta content="text/html; charset=utf-8" http-equiv="content-type"> <title>search_query.php</title> </head> <?php extract($_POST); if ($uppost){ $connect=mysql_connect("localhost","KTUG","KTUG1234"); mysql_select_db("TeXObGyDic",$connect); if($s_Short_Word == ""){ $query=mysql_query("SELECT * FROM ObGyDic_main WHERE Disease_En like '%$s_Disease_En%'"); } else { $query=mysql_query("SELECT * FROM ObGyDic_main WHERE Shortended_Word like '%$s_Short_Word%'"); } if(!$query){ echo mysql_errno().":"; echo mysql_error()."<BR>"; } $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]"; ?> <a href=search_view.php?m_main_disease_id=<?php print "$row[main_disease_id]" ?>> <?php print "$identify_dis" ?> <a><P> <?php } } else { echo "°Ë»ö°á°ú°¡ ¾ø½À´Ï´Ù. ´Ù½Ã °Ë»öÇØ ÁÖ¼¼¿ä"; } } ?> <body> <br> <center> <form method="POST" ACTION=search_query_view.php> <input type=hidden name=uppost value=a> <table style="text-align: left; width: 519px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr style="color: rgb(102, 255, 255);"> <td rowspan="1" colspan="2" style="text-align: center; background-color: rgb(69, 44, 169); width: 376px;"> Search (¿µ¾îÁúȯ¸í¸¸ °¡´ÉÇÔ)</td> </tr> <tr> <td style="width: 123px;">Áúȯ¸í(¿µ¾î)</td> <td style="width: 376px;"><input type=text name="s_Disease_En"></td> </tr> <tr> <td style="width: 123px;">ÁÙÀθ»(¿µ¾î)</td> <td style="width: 376px;"><input type=text name="s_Short_Word"></td> </tr> </tbody> </table> <input type="SUBMIT" value="È®ÀÎ"> <input type="RESET" value="´Ù½Ã¾²±â"> </center> <br> <?php mysql_close(); ?> </body> </html>== web¿¡¼ ÀԷµÈ\command¸¦ ÀûÀýÈ÷ ó¸®Çϱâ==
[ÆíÁý]
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
°¨»çÇÕ´Ï´Ù. hoze´ÔÀÌ °æÇèÇϽŠ³»¿ëÀ» Á» ±¸Ã¼ÀûÀ¸·Î À̾߱â ÇØÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.ÀúÀÇ °æ¿ì¿¡´Â ¿ì¼± mySQL¿¡ ÀÔ·ÂÇÏ°í ³ª¼, ÀÌ ³»¿ëÀ» ±×³É °ð¹Ù·Î TeX·Î »ç¿ëÇÒ°ÍÀÎÁö ¾Æ´Ï¸é text·Î º¯È¯ÇÏ¿© ¾µ°ÍÀÎÁö´Â °í¹ÎÁßÀÔ´Ï´Ù¸¸.. ¾îÂ¥ÇÇ ÀÌ°ÍÀÌ¾ß mySQL°ú TeXÀÇ ¹®Á¦¶ó°í »ý°¢ÀÌ µË´Ï´Ù. ±×·¸Áö¸¸ ÀÌÁ¦ Á¶±Ý´õ ½Ã°£ÀÌ ³²°í ¿©·ÂÀÌ ³²À¸¸é mySQL data¸¦ php·Î ºÒ·¯µé¿©¼ web¿¡¼ list¹× editÇØ¾ß ÇÒ ÀÏÀÌ »ý±æ°Í °°±â¿¡ ±×·³´Ï´Ù. °¨»çÇÕ´Ï´Ù.--synapse