µ¡¼ï°Í¸ʸ»ú¤òPostgreSQL¤ËINSERT
¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¤·¤ÆºîÀ®
[
¥È¥Ã¥×
] [
¿·µ¬
|
°ìÍ÷
|
¸¡º÷
|
ºÇ½ª¹¹¿·
|
¥Ø¥ë¥×
]
³«»Ï¹Ô:
Î㤨¤Ð¡Öüâ¡×¤ä¡Öûơפʤɤε¡¼ï°Í¸ʸ»ú¤ò´Þ¤à¥Ç¡¼¥¿¤òPostgre...
¡Ö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}', '{$fie...
pg_query($db, $sql);
}
fclose($fp);
print $i.' done.';
?>
½ªÎ»¹Ô:
Î㤨¤Ð¡Öüâ¡×¤ä¡Öûơפʤɤε¡¼ï°Í¸ʸ»ú¤ò´Þ¤à¥Ç¡¼¥¿¤òPostgre...
¡Ö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}', '{$fie...
pg_query($db, $sql);
}
fclose($fp);
print $i.' done.';
?>
¥Ú¡¼¥¸Ì¾: