mysql:4133

及少毛匹允﹝

漱勻化中月橇須反﹜蟈仁蕙仄中伊戊□玉互綜日木卅中午蛻丹仇午匹允井〝
公木午手﹜啦豭午啜丹犯□正互醣じ今木月午中丹仇午匹允井〝

蕙仄中伊戊□玉互綜日木卅中樺寧﹝
kaimono 氾□皮伙反升及方丹卅厭嶽匹允井〝
kategorii 及職卞市仿丞反丐曰引六氏井〝
公木互 not null 卞卅勻化凶曰允月午﹜巨仿□互粟五月匹仄斤丹﹝

啦豭午啜丹犯□正互醣じ今木月樺寧﹝

Ｖ $sth = $dbh->prepare(qq{insert into kaimono (kategorii)
Ｖvalues("kategorii")});

及朿坌﹜values 及詨互﹜"kategorii" 匹反卅仁﹜"$kategorii" 匹允﹝
仇木反﹜升切日及橇須卞六方膜懇允屯五匹允友﹝

$sth = $dbh->prepare(qq{insert into kaimono (kategorii) values (?)});
$sth->execute($kategorii);

午placeholder毛銀迕允月仇午毛左旦旦丟仄引允﹝




On Fri, 3 Aug 2001 16:26:25 +0900
"tamuzin2" <tamuzin@xxxxxxxxxx> wrote:

Ｖ鼴醱匹允﹝
Ｖ
Ｖ票筏及方丹卅␐���匹及犯□正矛□旦毛醜綜允月皿伕弘仿丞毛綜嶽仄凶及匹允互﹜
Ｖ白巧□丞井日霜耨仄凶犯□正互犯□正矛□旦卞醣じ今木卅仁化漱勻化中引允﹝
Ｖ升卅凶井票筏及皿伕弘仿丞及升仇互鬼仁化犯□正矛□旦卞醣じ今木卅中及井云項尹仁
Ｖ分今中給仄仁云湊中譙仄引允﹝
Ｖ
Ｖ#!perl
Ｖ
Ｖrequire"jcode.pl";
Ｖ
Ｖuse DBI;
Ｖuse CGI_Lite;
Ｖ
Ｖmy($dns) = "DBI:mysql:shopping:localhost";
Ｖmy($username) = "root";
Ｖmy($password) = "aaaa";
Ｖmy($dbh,$sth);
Ｖmy(@ary);
Ｖ
Ｖ$RemoteUser=$ENV{'REMOTE_USER'};
Ｖ
Ｖ$cgi=new CGI_Lite();
Ｖ%in=$cgi->parse_form_data();
Ｖprint"Content-type: text/plain\n\n";
Ｖ
Ｖ#蕙筋瓚狤質咥
Ｖif($in{'mode'} eq 'new'){
Ｖ &Error("筏じ炡木互丐曰引允﹝") unless $in{'kategorii'};
Ｖ
Ｖ #仇仇匹反EUC戊□玉匹犯□正毛醣じ仄化心月儀卞允月﹝刓憎反SJIS毛厙迕
Ｖ $kategorii=$in{'kategorii'};
Ｖ &jcode'convert(*kategorii,"euc");
Ｖ
Ｖ $dbh = DBI -> connect ($dns,$username,$password) or &Error("犯□正矛□旦尺
Ｖ失弁本旦匹五引六氏﹝");
Ｖ
Ｖ $sth = $dbh->prepare(qq{insert into kaimono (kategorii)
Ｖvalues("kategorii")});
Ｖ
Ｖ $sth -> execute() or &Error("MySQL INSERT 戊穴件玉毛撢墊匹五引六氏﹝");
Ｖ
Ｖ $sth -> finish();
Ｖ $dbh -> disconnect();
Ｖ}#蕙筋瓚狤質咥反仇仇引匹
Ｖ
Ｖ  $dbh = DBI -> connect ($dns,$username,$password) or &Error("犯□正矛□旦尺
Ｖ失弁本旦匹五引六氏﹝");
Ｖ
Ｖ  $sth = $dbh->prepare(qq{select * from kaimono});
Ｖ
Ｖ  $sth -> execute() or &Error("select * from kaimono毛撢墊匹五引六氏﹝");
Ｖ
Ｖ  $sth -> finish();
Ｖ  $dbh -> disconnect();
Ｖ
Ｖ
Ｖprint "content-type: text/html\n\n";
Ｖprint<<"__HTML__";
Ｖ<html><head><title>扑亦永疋件弘棟咥矢□斥</title></head>
Ｖ<body text="#44444" bgcolor="#ffffff">
Ｖ<table width="32%" border="0" cellspacing="1" cellpadding="1"
Ｖalign="center">
Ｖ  <tr>
Ｖ    <td>
Ｖ      <h2 align="center">╮扑亦永疋件弘棟咥矢□斥╮</h2>
Ｖ    </td>
Ｖ  </tr>
Ｖ</table>
Ｖ<br>
Ｖ<br>
Ｖ<form method="post" action="kaimono.cgi">
Ｖ  <table width="70%" border="3" cellspacing="4" cellpadding="5"
Ｖalign="center">
Ｖ    <tr>
Ｖ      <td width="21%" bgcolor="#99CCFF">
Ｖ        <div align="center"><font size="3"><b>市氾打伉□</b></font></div>
Ｖ      </td>
Ｖ      <td width="79%" bgcolor="#FDF9C1">
Ｖ        <select name="kategorii">
Ｖ          <option>掏颶窗湛</option>
Ｖ          <option>筏盛隸譆</option>
Ｖ          <option>犯奴旦皿伊奶</option>
Ｖ          <option>生永玄伐□弁窗湛</option>
Ｖ          <option>じ恘隸譆</option>
Ｖ          <option>␐␃呿蟲</option>
Ｖ          <option>皿伉件正□</option>
Ｖ          <option>祥擘窗湛</option>
Ｖ          <option>末白玄</option>
Ｖ          <option>旦平乓瓜□</option>
Ｖ        </select>
Ｖ      </td>
Ｖ    </tr>
Ｖ  <input type="hidden" name="mode" value="new">
Ｖ    <tr>
Ｖ      <td colspan="2">
Ｖ        <div align="center">
Ｖ          <input type="submit" name="Submit" value="齒圴瓚狤">
Ｖ        </div>
Ｖ      </td>
Ｖ    </tr>
Ｖ  </table>
Ｖ</form>
Ｖ__HTML__
Ｖ
Ｖsub Error{
Ｖ#print "content-type: text/html\n\n";
Ｖprint $_[0];
Ｖprint qq(<br><a href="javascript:history.back(1)">枑月</a>);
Ｖexit;
Ｖ}
Ｖ
Ｖ荸曰卞仁中皿伕弘仿丞匹蕭仄沭仍介中引六氏互給仄仁云湊中中凶仄引允﹝
Ｖ