µ¡¼ï°Í¸ʸ»ú¤òPostgreSQL¤ËINSERT
¤ÎÊÔ½¸
https://yassu.jp/pukiwiki/index.php?%B5%A1%BC%EF%B0%CD%C2%B8%CA%B8%BB%FA%A4%F2PostgreSQL%A4%CBINSERT
[
¥È¥Ã¥×
] [
ÊÔ½¸
|
º¹Ê¬
|
¥Ð¥Ã¥¯¥¢¥Ã¥×
|
źÉÕ
|
¥ê¥í¡¼¥É
] [
¿·µ¬
|
°ìÍ÷
|
¸¡º÷
|
ºÇ½ª¹¹¿·
|
¥Ø¥ë¥×
]
-- ¿÷·Á¤È¤¹¤ë¥Ú¡¼¥¸ --
(no template pages)
Î㤨¤Ð¡Öüâ¡×¤ä¡Öûơפʤɤε¡¼ï°Í¸ʸ»ú¤ò´Þ¤à¥Ç¡¼¥¿¤òPostgreSQL¤ËINSERT¤¹¤ë¤Ë¤Ï¤³¤ó¤Ê´¶¤¸~ ¡ÖSJIS-win¡×¤«¤é¡ÖUTF-8¡×¤ËÊÑ´¹¤¹¤ë¤Î¤¬¥ß¥½ <?php $sjis_file = 'sjis.txt'; // Shift_JIS $db = pg_connect("dbname=DBNAME user=DBUSER"); $i = 0; $fp = fopen($sjis_file, 'r'); while (!feof($fp)) { $buf = rtrim(fgets($fp)); $buf = mb_convert_encoding($buf, 'UTF-8', 'SJIS-win'); list($field1, $field2, $field3) = explode(',', $buf); $i++; $sql = "INSERT INTO table VALUES('{$field1}', '{$field2}', '{$field3}');"; pg_query($db, $sql); } fclose($fp); print $i.' done.'; ?>
¥¿¥¤¥à¥¹¥¿¥ó¥×¤òÊѹ¹¤·¤Ê¤¤
Î㤨¤Ð¡Öüâ¡×¤ä¡Öûơפʤɤε¡¼ï°Í¸ʸ»ú¤ò´Þ¤à¥Ç¡¼¥¿¤òPostgreSQL¤ËINSERT¤¹¤ë¤Ë¤Ï¤³¤ó¤Ê´¶¤¸~ ¡ÖSJIS-win¡×¤«¤é¡ÖUTF-8¡×¤ËÊÑ´¹¤¹¤ë¤Î¤¬¥ß¥½ <?php $sjis_file = 'sjis.txt'; // Shift_JIS $db = pg_connect("dbname=DBNAME user=DBUSER"); $i = 0; $fp = fopen($sjis_file, 'r'); while (!feof($fp)) { $buf = rtrim(fgets($fp)); $buf = mb_convert_encoding($buf, 'UTF-8', 'SJIS-win'); list($field1, $field2, $field3) = explode(',', $buf); $i++; $sql = "INSERT INTO table VALUES('{$field1}', '{$field2}', '{$field3}');"; pg_query($db, $sql); } fclose($fp); print $i.' done.'; ?>
¥Æ¥¥¹¥ÈÀ°·Á¤Î¥ë¡¼¥ë¤òɽ¼¨¤¹¤ë