CGI-BBS > ¥Ç¡¼¥¿¥Ù¡¼¥¹ > ´Ê°×¥Ç¡¼¥¿¥Ù¡¼¥¹ > CSV¤ÎǤ°Õ¤Î°ì¹Ô¤òºï½ü¤·¤¿¤¤¡£


¥«¥ì¥Ã¥Â
¥«¥ì¥Ã¥Â


¼ÁÌä¼Ô TAKA  Åê¹ÆÆü 8/18(Æü) 18:30:11
´Ê°×¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹¤Ç¸¡º÷¤·¡¢¸¡º÷·ë²Ì¤Î°ì¹Ô¤ò¤ò¥Ö¥é¥¦¥¶¡¼¾å¤Çºï½ü¤·¤è¤¦¤È»×¤¤
¸½ºß¶ìÀïÃæ¤Ê¤Î¤Ç¤¹¡£

º£¹Í¤¨¤Æ¤¤¤ë¤Î¤Ï¸¡º÷·ë²Ì¤Ë¥Õ¥©¡¼¥à¤òËä¤á¹þ¤ßºï½üÍÑ¥×¥í¥°¥é¥à¤Ë¥Õ¥©¡¼¥à¤ÇÈô¤Ð¤·¤Æºï½ü¤·¤è¤¦¤«¤Ê¡©
¤Ã¤Æ»×¤Ã¤¿¤ó¤Ç¤¹¤±¤É¡¢¤½¤Îºï½üÍÑ¥×¥í¥°¥é¥à¤¬ºî¤ì¤Ê¤¯¤Ã¤Æ¡¦¡¦½é¿´¼Ô¤Ê¤ê¤Ë¤¤¤í¤¤¤í¤ä¤Ã¤Æ¤ß¤¿¤Î¤Ç¤¹¤¬¡¦¡¦

½ôÀèÇÚÊý¡¢¥¢¥É¥Ð¥¤¥¹¤ò失¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡©

#!/usr/bin/perl

require './jcode.pl';

$file = "./data.csv";

if ($ENV{'REQUEST_METHOD'} eq "POST") { read(STDIN,$buffer,$ENV{'CONTENT_LENGTH'}); }
else { $buffer = $ENV{'QUERY_STRING'}; }

if ($buffer eq "") { &error('¥¨¥é¡¼','»È¤¤Êý¤¬´Ö°ã¤Ã¤Æ¤¤¤Þ¤¹.'); }

@pairs = split(/&/,$buffer);
foreach $pair (@pairs) {

	($name, $value) = split(/=/, $pair);
	$value =~ tr/+/ /;
	$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;
	&jcode'convert(*value,'sjis');

	$value =~ s/</&lt;/g;
	$value =~ s/>/&gt;/g;
	$value =~ s/\n//g;
	$value =~ s/\r//g;
	$value =~ s/\t//g;
	$value =~ s/\,//g;

	$FORM{$name} = $value;
}

#ºï½ü

open DAT, "$file" ;
@dat=<DAT>;
@dat = grep !m/$FORM{'EMAIL'}/, @dat; 
print DAT @dat;

sub error {

	if (-e "$lockfile") { unlink($lockfile); }

	print "Content-type: text/html\n\n";
        print "<html><head><title>$title</title></head>\n";
        print "$body\n";
        print "<h1>$_[0]</h1>\n";
	print "<h3>$_[1]</h3>\n";
	print "¥Ö¥é¥¦¥¶¤Î[Ìá¤ë]¥Ü¥¿¥ó¤ò²¡¤·¤ÆÁ°¤Î²èÌ̤˰ÜÆ°¤·¤Æ¤¯¤À¤µ¤¤.<p>\n";
        print "</body></html>\n";
        exit;
}

¥×¥í¥Ð¥¤¥À»²¾È¡§
¥µ¡¼¥Ð¤Î£Ï£Ó¡§(̤ÁªÂò)
¥Ñ¥½¥³¥ó¤Î£Ï£Ó¡§(̤ÁªÂò)
¥¨¥Ç¥£¥¿¡§
£Æ£Ô£Ð¥½¥Õ¥È¡§
¥µ¡¼¥Ð°Üž¡§¤·¤Æ¤¤¤Ê¤¤
²þ¤¡§(̤ÁªÂò)
£Ã£Ç£É½¬½ÏÅÙ¡§beginner

²óÅú¼Ô ¤ä¤Þ¤À  [ºï½ü]  Åê¹ÆÆü 8/19(·î) 23:18:51
½ñ¤­¹þ¤ß½èÍý¤ÈÆɤ߹þ¤ß½èÍý¤òÊÌ¡¹¤Ë¤·¤Æ¤ß¤Þ¤·¤ç¤¦¡£

ºï½ü½èÍýÁ´ÂΤ˴ؤ·¤Æ¡¢°ì¤ÄÁ°¤ÎÉ®Ìä¤Ç¤Îprimary key¤ÎEMAIL¤ò»È¤Ã¤Æºï½ü¤¹¤ë¤Î¤Ï¥°¥Ã¥È¤Ç¤¹¡£
¸¡º÷·ë²Ì¤«¤é°ì¹Ô¤òºï½ü¤Ç¤¹¤Î¤Ç¡¢¸¡º÷·ë²Ì¤Ëºï½üÍÑ¥Õ¥©¡¼¥à¤òËä¤á¹þ¤à¤Î¤â¤¤¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£

open(DB,'<data.csv') or &error"$!";
@NEW=grep{!/$smaddr/}<DB>;
close DB;

open(DB,'>data.csv') or &error"$!";
print DB @NEW;
close DB;
¼ÁÌä¼Ô TAKA  [ºï½ü]  Åê¹ÆÆü 8/20(²Ð) 12:47:49
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
̵»ö¤Ç¤­¤Þ¤·¤¿¡£¤Ê¤ó¤«¡Ö¥°¥Ã¥È¡×¤Ã¤Æ¸À¤ï¤ì¤Æ¤¹¤²¡¼¤¦¤ì¤·¤¤¤Ç¤¹¡£
¤³¤ì¤«¤é¤â´èÄ¥¤Ã¤ÆÊÙ¶¯¤·¤Æ¤¤¤­¤¿¤¤¤È»×¤¤¤Þ¤¹¤Î¤Ç¡¢¤Þ¤¿¤Ä¤Þ¤º¤¤¤¿¤È¤­¤Ï
¤ªÎϤò¤ª¼Ú¤ê¤¹¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£

¤³¤Î¥Ú¡¼¥¸¤Ï½ªÎ»¤·¤¿¤Î¤ÇÊÖ¿®(²óÅú)¤Ï½ñ¤­¤³¤á¤Þ¤»¤ó

£×£å£â΢µ»