'.trim($txt[$x1]).' ' ;
$s=wf_to_nf(trim($txt[$x1]));
mysql_select_db($database_BE2, $BE2);
$query_Rt3 = sprintf("select * from address WHERE county='%s' AND street='%s' ",$_POST['city'],$s) ;
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);
// echo $query_Rt3 .'
';
if($totalRows_Rt3>0){
echo 'PASS
';
$maddress_id=$row_Rt3['address_id'];
$maddress_name=$row_Rt3['county'].','.$row_Rt3['district'].','.$row_Rt3['street'];
//$row_Rt2['maddress_name'] //台北市,南港區,市民大道8段
$vimg=sprintf("%04d",$x1+1).'_'.date('Ymdhis',time()).'_1.png' ;
$vimg2=sprintf("%04d",$x1+1).'_'.date('Ymdhis',time()).'_2.png' ;
$savepath = '/www2/skybni/submarket/images/';
$background="/www2/skybni/test007/bb.png";
$myfont="/www2/skybni/fonts/wt009.ttf";
$im = imagecreatefrompng($background);
$im2 = imagecreatefrompng($background);
$white = ImageColorAllocate($im, 255,255,255);
$point_y=array(105,165,225,285);//high
$point_4x=40;
$doc1=explode(",",$maddress_name);
$str01='';
$str02='';
$doc1[2]= wf_to_nfp2($doc1[2]); //台北市 南港區 南港路1段 單號
$str02n = $str02.'單號' ;//$row_Rt2['mside']; //1段單號
$str03 ='網店商城';
if(mb_strlen($str01)==5){ //五谷王 南街單號
if(mb_strlen($str02n)==2){
$str02n=mb_substr($str01,3,2,"utf-8").$str02n;
$str01=mb_substr($str01,0,3,"utf-8");
}
}
$drawstr=array($str01,$str02n,'網店商城');
for ($i=0;$i<3;$i++){
$l=mb_strlen($drawstr[$i]);
if($l==2){
$word=mb_substr( $drawstr[$i],0,1,"utf-8");
ImageTTFText($im,40,0,40,$point_y[$i], $white,$myfont,$word);
$word=mb_substr( $drawstr[$i],1,1,"utf-8") ;
ImageTTFText($im,40,0,200,$point_y[$i], $white,$myfont,$word);
}else if($l==3){
$word=mb_substr( $drawstr[$i],0,1,"utf-8"); ;
ImageTTFText($im,40,0,40,$point_y[$i], $white,$myfont,$word);
$word=mb_substr( $drawstr[$i],1,1,"utf-8") ;
ImageTTFText($im,40,0,120,$point_y[$i], $white,$myfont,$word);
$word=mb_substr( $drawstr[$i],2,1,"utf-8") ;
ImageTTFText($im,40,0,200,$point_y[$i], $white,$myfont,$word);
}else if($l==4){
$word=$drawstr[$i];
ImageTTFText($im,40,0,40,$point_y[$i], $white,$myfont,$word);
}
}
ImagePNG($im, $savepath.$vimg);
ImageDestroy($im);
$str02n = $str02.'雙號';
if(mb_strlen($str01)==5){ //五谷王 南街單號
if(mb_strlen($str02n)==2){
$str02n=mb_substr($str01,3,2,"utf-8").$str02n;
$str01=mb_substr($str01,0,3,"utf-8");
}
}
$drawstr=array($str01,$str02n,'網店商城');
for ($i=0;$i<3;$i++){
$l=mb_strlen($drawstr[$i]);
if($l==2){
$word=mb_substr( $drawstr[$i],0,1,"utf-8"); ;//'南港路' ;//substr($authnum,$c,1);
ImageTTFText($im2,40,0,40,$point_y[$i], $white,$myfont,$word);
$word=mb_substr( $drawstr[$i],1,1,"utf-8") ;//'南港路' ;//substr($authnum,$c,1);
ImageTTFText($im2,40,0,200,$point_y[$i], $white,$myfont,$word);
}else if($l==3){
$word=mb_substr( $drawstr[$i],0,1,"utf-8"); ;//'南港路' ;//substr($authnum,$c,1);
ImageTTFText($im2,40,0,40,$point_y[$i], $white,$myfont,$word);
$word=mb_substr( $drawstr[$i],1,1,"utf-8") ;//'南港路' ;//substr($authnum,$c,1);
ImageTTFText($im2,40,0,120,$point_y[$i], $white,$myfont,$word);
$word=mb_substr( $drawstr[$i],2,1,"utf-8") ;//'南港路' ;//substr($authnum,$c,1);
ImageTTFText($im2,40,0,200,$point_y[$i], $white,$myfont,$word);
}else if($l==4){
$word=$drawstr[$i];
ImageTTFText($im2,40,0,40,$point_y[$i], $white,$myfont,$word);
}
}
ImagePNG($im2, $savepath.$vimg2);
ImageDestroy($im2);
$ind +=50;
$insertSQL = sprintf("INSERT INTO marketstreet(mname,mcounty,maddress_id,mside,maddress_name,mind,mpic,fcc)VALUES('%s','%s','%s','%s','%s','%s','%s',1)",
$_POST['mname'],$_POST['city'],$maddress_id,'單號',$maddress_name,$ind,$vimg);
mysql_query($insertSQL, $BE2) or die(mysql_error());
$ind +=50;
$insertSQL = sprintf("INSERT INTO marketstreet(mname,mcounty,maddress_id,mside,maddress_name,mind,mpic,fcc)VALUES('%s','%s','%s','%s','%s','%s','%s',1)",
$_POST['mname'],$_POST['city'],$maddress_id,'雙號',$maddress_name,$ind,$vimg2);
mysql_query($insertSQL, $BE2) or die(mysql_error());
}else { echo ' not Found
' ; }
// $mname=$_POST['mname'];
$_GET['mname']=$_POST['mname'];
}
} else{ echo ""; }
if($wmaster){
$insertSQL2 = sprintf("INSERT INTO marketmaster(msname,mslink)VALUES(%s,%s)",
GetSQLValueString($_POST['mname'], "text"),
GetSQLValueString('/'.$_POST['mname'].'介紹.html', "text"));
mysql_query($insertSQL2, $BE2) or die(mysql_error());
}
}
$city='-1';
if (isset($_GET['city'])) {
$city = $_GET['city'];
}
$mname='-1';
if (isset($_GET['mname'])) {
$mname = $_GET['mname'];
}
mysql_select_db($database_BE2, $BE2);
// address_id county district street
$query_Rot2 = "SELECT distinct(county) FROM address where 1 order by address_id";
$Rot2 = mysql_query($query_Rot2, $BE2) or die(mysql_error());
$row_Rot2 = mysql_fetch_assoc($Rot2);
$totalRows_Rot2 = mysql_num_rows($Rot2);
?>
