KTUGFaq
KTUG FAQ
: 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Դϴ.
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 ʾҽϴ.(ȵȰ Ƽ, ϳ ϳ ϸ鼭 Դϴ.)
Է form form ¶
Է spreadsheet ̿ؼ ϸ ҵ , ؼ ƹ web ƿ Ƽ 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>
== 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