alert("請選擇5項支持的作品哦! 目前選擇了 '.count($_POST['chkvote']).' 項");'); }else if( $_POST['name'] == "" || $_POST['yy'] == "" || $_POST['tele'] == "" || $_POST['e-mail'] == "" ){ print(''); }else if( !preg_match('/^.+@.+\..{2,3}$/',$_POST['e-mail']) ){ print(''); }else if( strtoupper($_POST['code']) != $_SESSION['verifystr'] ){ print(''); }else{ $qs = 'Select VOTENO From lym_vote '; $qs.= 'Where (VOTENAME = '.$adodb->Quote($_POST['name']).' '; $qs.= 'Or VOTETEL = '.$adodb->Quote($_POST['tele']).' '; $qs.= 'Or VOTEMAIL = '.$adodb->Quote($_POST['e-mail']).') '; $qs.= 'And VOTEDATE Like '.$adodb->Quote(getToday().'%').' '; $rs = $adodb->Execute($qs); if( $rs && !$rs->EOF ){ print(''); }else{ $str_vote = ''; foreach( $_POST['chkvote'] as $key => $value ){ $str_vote .= $value.'、'; $qs = 'Select VOTECOUNT '; $qs.= 'From lym_vote_pic '; $qs.= 'Where SNO='.$adodb->Quote($value); $rs = $adodb->Execute($qs); if( $rs && !$rs->EOF ){ $votecount = $rs->fields[0] + 1; } $qs = 'Update lym_vote_pic Set '; $qs.= 'VOTECOUNT='.$adodb->Quote($votecount).' '; $qs.= 'Where SNO='.$adodb->Quote($value); $adodb->Execute($qs); } $str_vote = substr($str_vote,0,strlen($str_vote)-1); $qs = 'Select VOTENO From lym_vote '; $qs.= 'Order by VOTENO DESC Limit 0,1 '; $rs = $adodb->Execute($qs); if( $rs && !$rs->EOF ){ $voteno = sprintf('%010s',$rs->fields[0]+1); }else{ $voteno = sprintf('%010s',1); } $qs = 'Insert into lym_vote (VOTENO,SNO,VOTENAME,VOTEY,VOTETEL,VOTEMAIL,VOTEDATE) '; $qs.= 'Values ('.$adodb->Quote($voteno).','; $qs.= $adodb->Quote($str_vote).','; $qs.= $adodb->Quote($_POST['name']).','; $qs.= $adodb->Quote($_POST['yy']).','; $qs.= $adodb->Quote($_POST['tele']).','; $qs.= $adodb->Quote($_POST['e-mail']).','; $qs.= $adodb->Quote(getToday()).')'; $adodb->Execute($qs); print(''); print(''); } } //header('Location: '.PAGE_NAME.'_mod.php'); break; } //List $qs = 'Select SNO,VCLASS,IMGURL,IMGURL_S,IMGALT,VOTECOUNT,AUTHOR,TITLE,SIZE,MATERIAL,AMOUNT,DES '; $qs.= 'From lym_vote_pic '; $qs.= 'Order by cast(SNO As Signed) '; //$qs.= 'Limit '.$begrows.','.$getrows; $rs = $adodb->Execute($qs); $sno = array(); $vclass = array(); $imgurl = array(); $imgurl_s = array(); $imgalt = array(); $votecount = array(); $author = array(); $title = array(); $size = array(); $material = array(); $amount = array(); $des = array(); //各分類序號 $aryclass1 = array(); $aryclass2 = array(); $aryclass3 = array(); $i = 0; while( $rs && !$rs->EOF ){ $sno[] = $rs->fields[0]; $vclass[] = $rs->fields[1]; $imgurl[] = $rs->fields[2]; $imgurl_s[] = $rs->fields[3]; $imgalt[] = $rs->fields[4]; $votecount[] = $rs->fields[5]; $author[] = $rs->fields[6]; $title[] = $rs->fields[7]; $size[] = $rs->fields[8]; $material[] = $rs->fields[9]; $amount[] = $rs->fields[10]; $des[] = $rs->fields[11]; //分類 switch($rs->fields[1]){ case 1: $aryclass1[] = $i; break; case 2: $aryclass2[] = $i; break; case 3: $aryclass3[] = $i; break; } $i++; $rs->MoveNext(); } ?> 手創蘭陽 宜蘭生活美學特展
::: 首頁ICON首頁| FACEBOOK ICONFacebook粉絲頁| PLURK ICONPlurk| 蘭陽博物館 ICON蘭陽博物館

:::

::: 作品票選 票選辦法及贈品 得獎名單
::: * 設計師+工藝師
$value){ print('
'); print(''.$imgalt[$value].''); print('
'); print('

作者：'.$author[$value].'

'); print('

 

'); print('

尺寸：'.$size[$value].'

'); print('

材質：'.$material[$value].'

'); print('

數量：'.$amount[$value].'

'); print('

 

'); print('

說明文字：'.$des[$value].'

'); print('
'); $chked = ''; if( count($_POST['chkvote']) > 0 ){ for( $i=0; $i
'); print('
'); } ?>
*

設計師+社區

$value){ print('
'); print(''.$imgalt[$value].''); print('
'); print('

作者：'.$author[$value].'

'); print('

 

'); print('

尺寸：'.$size[$value].'

'); print('

材質：'.$material[$value].'

'); print('

數量：'.$amount[$value].'

'); print('

 

'); print('

說明文字：'.$des[$value].'

'); print('
'); $chked = ''; if( count($_POST['chkvote']) > 0 ){ for( $i=0; $i
'); print('
'); } ?>
*

個人資料填續寫

> >
　
vertify img

宜蘭縣立蘭陽博物館 版權所有
All Right Reservedn