//
// DBに接続
//
$pid=pg_connect ($constr);
if (!$pid) {
echo "失敗";
}
else{
$i=0;
$table = "vote_newbase";
$rtn=pg_exec ($pid,"SELECT * FROM $table WHERE flg!='1' ORDER BY turn,id desc;");
$row=pg_numrows($rtn);
if($row == "0"){
echo "
";
echo "
現在、新台は登録されておりません。
";
echo "
";
echo "";
}
else{
while ($i<$row) {
$data=pg_fetch_array ($rtn,$i);
$reviewcount="0";
$table2 = "vote_review";
$rtn2=pg_exec ($pid,"SELECT id FROM $table2 WHERE flg!='1' AND baseid='$data[id]';");
$reviewcount=pg_numrows($rtn2);
pg_freeresult($rtn2);
$imgflg1 ="0";
$imgflg2 ="0";
$imgflg3 ="0";
$j = $i + 1;
$tenpo = split(",", "$data[tenpo]");
$basename = mb_convert_encoding($data[basename], "SJIS", "EUC");
$maker = mb_convert_encoding($data[maker], "SJIS", "EUC");
$comment0 = mb_convert_encoding($data[comment0], "SJIS", "EUC");
print <<
|
|
|

|
現在のレビュー件数 $reviewcount 件
|

|
EOF;
if($data[voteflg] == "1"){
print <<
導入店舗 |
EOF;
if( $tenpo[0] == "1"){
echo " ";
}
if( $tenpo[1] == "1"){
echo " ";
}
if( $tenpo[2] == "1"){
echo " ";
}
if( $tenpo[3] == "1"){
echo " ";
}
if( $tenpo[4] == "1"){
echo " ";
}
if( $tenpo[5] == "1"){
echo " ";
}
if( $tenpo[6] == "1"){
echo " ";
}
if( $tenpo[7] == "1"){
echo " ";
}
if( $tenpo[8] == "1"){
echo " ";
}
print <<
|
|
EOF;
}
/*
elseif($data[voteflg] == "2"){
print <<
 |
EOF;
}
*/
elseif($data[voteflg] == "9"){
print <<
 |
-->
導入店舗 |
EOF;
if( $tenpo[0] == "1"){
echo " ";
}
if( $tenpo[1] == "1"){
echo " ";
}
if( $tenpo[2] == "1"){
echo " ";
}
if( $tenpo[3] == "1"){
echo " ";
}
if( $tenpo[4] == "1"){
echo " ";
}
if( $tenpo[5] == "1"){
echo " ";
}
if( $tenpo[6] == "1"){
echo " ";
}
if( $tenpo[7] == "1"){
echo " ";
}
if( $tenpo[8] == "1"){
echo " ";
}
print <<
|
EOF;
}
/*
elseif($data[voteflg] == "A"){
print <<
導入店舗 |
EOF;
if( $tenpo[0] == "1"){
echo " ";
}
if( $tenpo[1] == "1"){
echo " ";
}
if( $tenpo[2] == "1"){
echo " ";
}
if( $tenpo[3] == "1"){
echo " ";
}
if( $tenpo[4] == "1"){
echo " ";
}
if( $tenpo[5] == "1"){
echo " ";
}
if( $tenpo[6] == "1"){
echo " ";
}
if( $tenpo[7] == "1"){
echo " ";
}
if( $tenpo[8] == "1"){
echo " ";
}
print <<
|
|
EOF;
}
*/
elseif($data[voteflg] == "5"){
print <<
導入店舗 |
EOF;
if( $tenpo[0] == "1"){
echo " ";
}
if( $tenpo[1] == "1"){
echo " ";
}
if( $tenpo[2] == "1"){
echo " ";
}
if( $tenpo[3] == "1"){
echo " ";
}
if( $tenpo[4] == "1"){
echo " ";
}
if( $tenpo[5] == "1"){
echo " ";
}
if( $tenpo[6] == "1"){
echo " ";
}
if( $tenpo[7] == "1"){
echo " ";
}
if( $tenpo[8] == "1"){
echo " ";
}
print <<
|
|
EOF;
}
elseif($data[voteflg] == "8"){
print <<
導入店舗 |
EOF;
if( $tenpo[0] == "1"){
echo " ";
}
if( $tenpo[1] == "1"){
echo " ";
}
if( $tenpo[2] == "1"){
echo " ";
}
if( $tenpo[3] == "1"){
echo " ";
}
if( $tenpo[4] == "1"){
echo " ";
}
if( $tenpo[5] == "1"){
echo " ";
}
if( $tenpo[6] == "1"){
echo " ";
}
if( $tenpo[7] == "1"){
echo " ";
}
if( $tenpo[8] == "1"){
echo " ";
}
print <<
|
|
EOF;
}
/*
elseif($data[voteflg] == "B"){
print <<
 |
EOF;
}
elseif($data[voteflg] == "6"){
print <<
 |
EOF;
}
*/
elseif($data[voteflg] == "7"){
print <<
導入店舗 |
EOF;
if( $tenpo[0] == "1"){
echo " ";
}
if( $tenpo[1] == "1"){
echo " ";
}
if( $tenpo[2] == "1"){
echo " ";
}
if( $tenpo[3] == "1"){
echo " ";
}
if( $tenpo[4] == "1"){
echo " ";
}
if( $tenpo[5] == "1"){
echo " ";
}
if( $tenpo[6] == "1"){
echo " ";
}
if( $tenpo[7] == "1"){
echo " ";
}
if( $tenpo[8] == "1"){
echo " ";
}
print <<
|
|
EOF;
}
elseif($data[voteflg] == "3"){
print <<
導入店舗 |
EOF;
if($tenpo[0] == "1"){
echo " ";
}
if($tenpo[1] == "1"){
echo " ";
}
if($tenpo[2] == "1"){
echo " ";
}
if($tenpo[3] == "1"){
echo " ";
}
if($tenpo[4] == "1"){
echo " ";
}
if($tenpo[5] == "1"){
echo " ";
}
if($tenpo[6] == "1"){
echo " ";
}
if($tenpo[7] == "1"){
echo " ";
}
if($tenpo[8] == "1"){
echo " ";
}
print <<
|
|
EOF;
}
/*
elseif($data[voteflg] == "4"){
print <<
 |
EOF;
}
*/
else{
print <<
EOF;
$i++;
}
pg_freeresult($rtn);
}
pg_close($pid);
}
?>
|
|