<?php  //マスタ設定
if ($_POST[dl] ==""){
	header('pragma: no-cache');
	header("Cache-Control: no-cache, must-revalidate");
}
include "func.cgi";
myopen();

//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();

//１ページ数
$pageset = 20;
$j = $pageset*($_POST[pagenum]  - 1);
//テーブル一覧
$tabledata = dbselect("tablenamej,tablename,key_","mastertable",-1,-1,-1);

//選択しているテーブル
if ($_POST["tablename"] <> "") {
	$strtablename  = $_POST["tablename"];
	$strtablenamej = GetList($tabledata,$strtablename,0);
	//レコード選択時
	if ($_POST["select"] == "yes") {
		For ($i = 0;$i < $pageset;$i++) {
			if($_POST{"edit".($i + $j)} <> "") {
				$strselectdata  = $_POST{"key".($i + $j)};
			}
		}
	}
} else {
	//初回選択時
	For ($i = 0;$i < count($tabledata);$i++) {
		if($_POST{"edit".$i} <> "") {
			$strtablename  = $tabledata[$i][1];
			$strtablenamej = $tabledata[$i][0];
		}
	}
	//初回選択前は空
}


//カラム一覧
$columndata = dbselect("feildnamej,feildname_,ex","tablecolumn",-1,-1,-1);
//レコードの指定
if ($_POST[pagenum] == "") {
	$page = 1;
} else {
	$page = (int)$_POST[pagenum];
}

//データ取得数
$limit = " LIMIT ".($pageset*($page  - 1)).",$pageset";

//表示項目
//該当テーブルの全カラムリストを取得
$column_data = dbselect("columnname,search_column,disp_select,tab_block","tableedit","tablename ='".$strtablename."'","tab_block,disp_order,tableeditid",-1);
Testecho ($strsqldbselect);
$strdcolumn = "1";$j = 0;
For ($i = 0;$i < count($column_data);$i++) {
	if($column_data[$i][2] == "1") {  //disp_select = 1 リスト表示用カラム
		//リスト用SELECT句作成
		$strdcolumn .= ",".$column_data[$i][0];
	}

	//外部キー情報を取得
	$foreignkey = dbselect("honbucompany,foreigntable,foreignname,foreignwhere,foreignkey","tablecolumn","feildname_ ='".$column_data[$i][0]."' and foreigntable is not null",-1,-1);
Testecho($strsqldbselect);

	//外部キーがあればリストを格納
	if(count($foreignkey) == 1) {
		if($foreignkey[0][0] == 1) {$strtablenameplus = $company;} else {$strtablenameplus ="";}  //本部名をテーブルに付加する
		$foreign_key_data{$column_data[$i][0]} = dbselect($foreignkey[0][2].",".$foreignkey[0][4],$strtablenameplus.$foreignkey[0][1],$foreignkey[0][3],-1,-1);
Testecho($strsqldbselect);$j++;
	}

	//検索で使用するカラムリスト
	if($column_data[$i][1] == "1") {  //search_column = 1 検索で使用するカラム
		
		$search_column_data[] = $column_data[$i][0];
		//検索ボックスに値があれば
		if($_POST{$column_data[$i][0]} <> "") {
			$strsqlwhere .= " and ".$column_data[$i][0]." like '%".$_POST{$column_data[$i][0]}."%'" ;
		}
	}
}

//該当テーブルの全カラム情報を取得
$column_info = dbselect("Field_ ,null_,key_,default_ ,extra_ ,char_size ","tableinfo","tablename ='".$strtablename."'","tableinfoid",-1);
//配列に格納
For ($i = 0;$i < count($column_info);$i++) {
	//テキストサイズ
	if ((int)$column_info[$i][5] == 0) {
		$intchar_size = 12;		//ゼロは12を初期値とする
		$intchar_sizemax = 12;		//ゼロは12を初期値とする
	} elseif((int)$column_info[$i][5] > 30) {
		$intchar_size = 30;
		$intchar_sizemax = (int)$column_info[$i][5];
	} else {
		$intchar_size = (int)$column_info[$i][5];
		$intchar_sizemax = (int)$column_info[$i][5];
	}

	$column_info_data{$column_info[$i][0]} = array($column_info[$i][1],$column_info[$i][2],$column_info[$i][3],$column_info[$i][4],$intchar_size,$intchar_sizemax);
}


//データ表示
$strsql = "SELECT ".$strdcolumn." FROM `$strtablename` WHERE 1=1 $strsqlwhere ORDER BY 1,2";

//編集データ
$strsqledit = "SELECT * FROM `$strtablename` WHERE ".$search_column_data[0]." = '".$strselectdata."' limit 1";
echo $strsqledit;

//ダウンロード
if ($_POST[dl] <>""){
	
	$strdate = Sjis(GetList($tabledata,$strtablename).date("Ymd-Gi").".csv");
	header("Content-type: application/octet-stream");
	header("Content-Disposition: attachment; filename=$strdate");
	header("Connection: close");
	ob_end_clean();
	$result=@mysql_query($strsql,$my_con);

	$row1 = mysql_num_fields($result);
	//タイトル行の表示
	for ($i=1;$i<$row1;$i++) {
		echo mysql_field_name($result, $i).",";
	}
	echo "\n";
	//タイトル行の表示
	for ($i=0;$i<$row1;$i++) {
		echo Sjis("\"".GetList2($columndata,mysql_field_name($result, $i)))."\",";
	}
	echo "\n";
	while ($row2 = mysql_fetch_array($result)) {
		For ($j=0;$j<$row1;$j++) {
			echo Sprint($row2{$j});
		}
		echo "\n";
	}
	myclose();
	exit;
}
if ($_POST[disp] <>""){
	$result=@mysql_query($strsql,$my_con);
	//カラム行
	$rows = mysql_num_fields($result);
}

//更新
if($_POST[insert]<>"") {
	$strsqlupdate = "insert into  `".$strtablename."` values( ";
//	for ($i=0;$i<$rows;$i++) {
	for ($i=0;$i<2;$i++) {
		if($_POST{"input".$i} == "") {
			$strsqlupdate .= "null ";
		} else {
			$strsqlupdate .= "'".$_POST{"input".$i}."' ";
		}
		if ($i<($rows - 1)) $strsqlupdate .= ",";
	}
	$strsqlupdate .= ") ";

	$strsqlupdate = "insert into `".$strtablename."` (".mysql_field_name($result, 0).") values('".$_POST{"input0"}."') ";
echo $strsqlupdate ;
	$result2=mysql_query($strsqlupdate,$my_con);
	$errcode =mysql_errno();if ($errcode==0) $okcount++;
	Testecho ($y."  $errcode ".$strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

} else {
	for ($h=0;$h<$pageset;$h++) {
		$j = $pageset*($page  - 1) + $h;
		if($_POST{"update".($j+1)}<>"") {
			$strsqlupdate = "update `".$strtablename."` set ";
			for ($i=1;$i<$rows;$i++) {
				if($_POST{"input".$i} == "") {
					$strsqlupdate .= "`".mysql_field_name($result, $i)."` = null ";
				} else {
					$strsqlupdate .= "`".mysql_field_name($result, $i)."` = '".eucjp($_POST{"input".$i})."' ";
				}
				if ($i<($rows - 1)) $strsqlupdate .= ",";
			}
			$strsqlupdate .= " where ".GetListData($tabledata,$strtablename,2)."='".$_POST{"key".($j+1)}."' limit 1";
			$result2=mysql_query($strsqlupdate,$my_con);
			$errcode =mysql_errno();if ($errcode==0) $okcount++;
			Testecho ($y."  $errcode ".$strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		}
		if($_POST{"delete".($j+1)}<>"") {
			$strsqlupdate = "delete from `".$strtablename."`";
			$strsqlupdate .= " where ".GetListData($tabledata,$strtablename,2)."='".$_POST{"key".($j+1)}."' limit 1";
			$result2=mysql_query($strsqlupdate,$my_con);
			$errcode =mysql_errno();if ($errcode==0) $okcount++;
			Testecho ($y."  $errcode ".$strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
		}
	}
}
//検索用語格納・商品所属マスタ
Switch($_POST[tablenamexxxxxx]) {
	case $company."shohinmasterx":
		$strsqlsw = "SELECT shohincd,shohinmei FROM `".$company."shohinmaster`";
		$result=@mysql_query($strsqlsw,$my_con);
		while ($data = mysql_fetch_array($result)) {
			//検索用語
			$sw = mb_convert_kana($data['shohinmei'],'KV', "UTF-8"); //名
			$sw = mb_convert_encoding($sw, "UTF-8", "UTF-8").trim($data['shohincd']);  //UTF-8に変換して入れる
			$strsqlsw="update `".$company."shohinmaster` set searchword='$sw' where shohincd='".$data['shohincd']."' limit 1";
			$result2=mysql_query($strsqlsw,$my_con);
			$errcode =mysql_errno();if ($errcode==0) ;
			Testecho ($y."  $errcode ".$strsqlsw);  #debug
		}
		//商品マスタより紐付けテーブルを作成する。
		if(($company == "marusho_") or ($company == "body_")) {
			$strsqlx = "TRUNCATE TABLE `".$company."shozokushohin`;";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."紐付けテーブル削除".$strsqlx);  #debug
			$strsqlx = "INSERT INTO `".$company."shozokushohin`(shozokuid,shohincd,nohinprice ,poplevel2) SELECT shozokuid,shohincd,price_sell ,0 FROM `".$company."shohinmaster` INNER JOIN `".$company."shozokumaster` USING(gyotaiid) where zaiko = 1";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."紐付けテーブルIMPORT".$strsqlx);  #debug

			$strsqlx = "TRUNCATE TABLE `".$company."shohinlocation`;";
			$result=mysql_query($strsqlx,$my_con);
			$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT shohincd,1,'c101',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster`";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."商品ロケーション作成T".$strsqlx);  #debug
		} elseif($company == "tsukuba_") {
			$strsqlx = "TRUNCATE TABLE `".$company."shohinlocation`;";
			$result=mysql_query($strsqlx,$my_con);
			$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT      '-',1,'c101',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster`";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."商品ロケーション作成T".$strsqlx);  #debug
		}
		UpdateShohinLevel($company,1);
		break;
	case $company."shozokumaster":
		$strsqlsw = "SELECT shozokuid,shozokuname FROM `".$company."shozokumaster`";
		$result=@mysql_query($strsqlsw,$my_con);
		while ($data = mysql_fetch_array($result)) {
			//検索用語
			$sw = mb_convert_kana($data['shozokuname'],'KV', "UTF-8");//名
			$sw = $sw.trim($data['shozokuid']); 
			$strsqlsw="update `".$company."shozokumaster` set search='".$sw."' where shozokuid='".$data['shozokuid']."' limit 1";
			$result2=mysql_query($strsqlsw,$my_con);
			$errcode =mysql_errno();if ($errcode==0) ;
			Testecho ($y."  $errcode ".$strsqlsw);  #debug
		}
		//商品マスタより紐付けテーブルを作成する。
		if($company == "marusho_") {
			$strsqlx = "TRUNCATE TABLE `".$company."shozokushohin`;";
			$result=mysql_query($strsqlx,$my_con);
			$strsqlx = "INSERT INTO `".$company."shozokushohin`(shozokuid,shohincd,nohinprice ,poplevel2) SELECT shozokuid,shohincd,price_sell ,1 FROM `".$company."shohinmaster` INNER JOIN `".$company."shozokumaster` USING(gyotaiid) where zaiko = 1";
			$result=mysql_query($strsqlx,$my_con);
			UpdateShohinLevel($company,1);
		}
		break;
	default:
}

//モード
if(($_POST[insertnew] <> "") or ($_POST[copy] <> "")){
	$strbutton1 = " disabled";//新規登録
	$strbutton2 = " disabled";//複写
	$strbutton3 = "";//登録
	$strbutton4 = " disabled";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = "";//キャンセル
} elseif($_POST[select] == "yes") { //mode=3表示
 	$strbutton1 = " disabled";//新規登録
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = "";//更新
	$strbutton5 = "";//削除
	$strbutton6 = "";//キャンセル
} else { //mode=1未選択
	$strbutton1 = "";//新規登録、キャンセル
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = " disabled";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = " disabled";//キャンセル
}

?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css.css" rel="stylesheet" type="text/css">
<style type="text/css">
#tabblock1,#1510a {
	border: 2px solid darkkhaki ;
	background:palegoldenrod ;
}
#tabblock2,#1510b {
	border: 2px solid deepskyblue;
	background:paleturquoise ;
}
#tabblock3,#1510c {
	border: 2px solid palevioletred;
	background:#ffdddd ;
}
#tabblock1,#tabblock2,#tabblock3 {
	margin: 0 auto;
	text-align: left;
	height: 270px; overflow: auto !important; clear: left;
}
#1510a,#1510b,#1510c {
	font-size: 16px;
	padding: 3px;
	margin:3px;
}
.col1{width:240px;height:27px;padding:2px;margin:0px;border-top:1px solid #a9a9a9;border-left:1px solid #a9a9a9;float:left; }
.col2{width:240px;height:27px;padding:2px;margin:0px;border-top:1px solid #a9a9a9;border-right:1px solid #a9a9a9;float:none;}
</style>
<?php title(); ?>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function submitForm( page ,order ) {
  form = document.FormGetSubmit
  form.pagenum.value= page
  FormGetSubmit.submit()
}
-->
</SCRIPT>
<body>
<?php
if ($strtablename == "") {
	$strPHPtitle = "マスター編集";
} else {
	$strPHPtitle = $strtablenamej."編集";
}
Honbutitle3($strPHPtitle,$_SERVER['PHP_SELF']); 

if($strtablename == "") {
?>
<form action="1510.php#fragment-6" method="post" name="DSP" target="_top">
<div id ="masterediter0">
閲覧・編集するテーブルを選択してください。<br>
<?php
For ($i = 0;$i < count($tabledata);$i++) {
	echo "<input type=\"submit\" value=\"".$tabledata[$i][0]."\" name=\"edit".$i."\" class=\"box1\"></BR>\n";
}
?>
</form>
</div>
<?php
} else {
?>
<div id ="masterediter3">
<form action="1510.php#fragment-6" method="post" name="EDIT" target="_top">
<?php 		
echo "<input type=\"hidden\" value=\"".$strtablename."\" name=\"tablename\">\n"; 
?>
<input type="submit" value="新規登録開始" name="insertnew"    class="box1" <?php echo $strbutton1; ?> >
<input type="submit" value="新規登録"   name="insert" class="box1" <?php echo $strbutton3; ?> >
<input type="submit" value="更　新"   name="update" class="box1" <?php echo $strbutton4; ?> >
<input type="submit" value="削　除"   name="delete" class="box1" <?php echo $strbutton5; ?> >
<input type="submit" value="編集取消"   name="clear"  class="box1" <?php echo $strbutton6; ?> >
<input type="submit" value="複　写"   name="copy"   class="box1" <?php echo $strbutton2; ?> >
<input type="button" onClick="location.href='1510.php'" value="<?php echo $strtablenamej ?>編集終了" name="button" class="box1">
</form>
<?php
if(($_POST[insertnew] <> "") or ($_POST[copy] <> "") or ($_POST[select] == "yes")) {
?>
<!-- TABS CODE -->
	<a onClick="i.display=(this.checked?'':'block');j.display=(this.checked?'':'none');k.display=(this.checked?'':'none');" id="1510a">基本</a>
	<a onClick="i.display=(this.checked?'':'none');j.display=(this.checked?'':'block');k.display=(this.checked?'':'none');" id="1510b">詳細１</a>
	<a onClick="i.display=(this.checked?'':'none');j.display=(this.checked?'':'none');k.display=(this.checked?'':'block');" id="1510c">詳細２</a>
	<DIV id="tabblock1" style="display:block">
<?php
$result=@mysql_query($strsqledit,$my_con);
$data = mysql_fetch_array($result);
$maxrow=@mysql_num_rows($result);
For ($i = 0;$i < count($column_data);$i++) {
//	echo $column_data[$i][0];
//	echo $data{$column_data[$i][0]};

	if($_POST[insertnew] <> "") { $data{$column_data[$i][0]} = $column_info_data{$column_data[$i][0]}[2];} //新規登録は初期値を入れる
	switch ($column_data[$i][3]) {  //tab_block
		case 1:
			echo "<div class=\"col1\">";
			echo GetList2($columndata,$column_data[$i][0]);
			echo "<input type=\"hidden\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."_old\"></div>\n";
			if(count($foreign_key_data{$column_data[$i][0]}) > 0){
				echo "<div class=\"col2\"><SELECT NAME=\"".$column_data[$i][0]."\">";
				PrintSelectList($foreign_key_data{$column_data[$i][0]},$data{$column_data[$i][0]},0);
				echo "</SELECT></div>\n";
			} else {
				echo "<div class=\"col2\"><input type=\"text\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."\" size = \"".$column_info_data{$column_data[$i][0]}[4]."\" maxlength = \"".$column_info_data{$column_data[$i][0]}[5]."\" ></div>\n";
			}

			break;
		case 2:
			$strcase2 .= "<div class=\"col1\">";
			$strcase2 .= GetList2($columndata,$column_data[$i][0]);
			$strcase2 .= "<input type=\"hidden\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."_old\"></div>\n";
			$strcase2 .= "<div class=\"col2\"><input type=\"text\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."\" size = \"".$column_info_data{$column_data[$i][0]}[4]."\" maxlength = \"".$column_info_data{$column_data[$i][0]}[5]."\" ></div>\n";
			break;
		case 3:
			$strcase3 .= "<div class=\"col1\">";
			$strcase3 .= GetList2($columndata,$column_data[$i][0]);
			$strcase3 .= "<input type=\"hidden\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."_old\"></div>\n";
			$strcase3 .= "<div class=\"col2\"><input type=\"text\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."\" size = \"".$column_info_data{$column_data[$i][0]}[4]."\" maxlength = \"".$column_info_data{$column_data[$i][0]}[5]."\" ></div>\n";
			break;
		default:
			break;
	}
}
?>
	</DIV>
	<DIV id="tabblock2" style="display:none">
<?php echo $strcase2; ?>
	</DIV>
	<DIV id="tabblock3" style="display:none">
<?php echo $strcase3; ?>
	</DIV>
<!-- TABS CODE -->
<?php
}
?>
</div>
<div id ="masterediter1">
<form action="1510.php#fragment-6" method="post" name="EDIT" target="_top" STYLE="margin: 0px;">
<?php
//更新情報
	if (($okcount+$errcount)>0) {
		if ($okcount > 0 ){
			$msgok = "$okcount 件のデータを処理しました。";
		}
		if ($errcount > 0 ){
			$msgerr = "処理エラーが $errcount 件有りました。<br>".$errmsg;
		}
		PrintMsg($msgerr,$msgok,650);
	}

	For ($i = 0;$i < count($search_column_data);$i++) {
		echo GetList2($columndata,$search_column_data[$i]);
		echo "<input type=\"hidden\" value=\"".$strtablename."\" name=\"tablename\">\n";
		echo "<input type=\"text\" value=\"".$_POST{$search_column_data[$i]}."\" name=\"".$search_column_data[$i]."\" size = \"12\">\n";
	}
?><input type="submit" name="disp2" value="検索" class="box1">
</form>
</div>
<div id ="masterediter2">
<?php 
}

//テーブル選択時
if ($strtablename <> ""){
	$result=@mysql_query($strsql,$my_con);
	$maxrow=@mysql_num_rows($result);
	//１ページ分
	$strsql .= $limit;
	$result=@mysql_query($strsql,$my_con);

	echo "該当件数 ".$maxrow." 件";
?>
<table id="data-table">
<form action="1510.php#fragment-6" method="post" name="EDIT" target="_top">
<INPUT type="hidden" name="disp2"        value="page">
<?php 
	//カラム行
	$crows = mysql_num_fields($result);
	echo "<input type=\"hidden\" value=\"".$strtablename."\" name=\"tablename\">\n";
	echo "<input type=\"hidden\" value=\"yes\" name=\"select\">\n";
	echo "<input type=\"hidden\" value=\"".$page."\" name=\"pagenum\">\n";
	echo "<input type=\"hidden\" value=\"".GetListData($tabledata,$strtablename,2)."\" name=\"key\">\n";
	//タイトル行の表示
	$strhead ="	<tr>\n	<th colspan=\"2\">No.</th>\n";
	for ($i = 1;$i<$crows;$i++) {
		$strhead .="	<th>".GetList2($columndata,mysql_field_name($result, $i))."</th>\n";
	}
	echo "	</tr>";
	$strhead .="	</tr>\n";

	//日本語変換
	echo $strhead;

	$j = $pageset*($page  - 1);
	while ($data = mysql_fetch_array($result)) {
?>
	<tr> 
		<td><?php echo ($j+1);// ?></td>
		<input type="hidden" value="<?php echo $data[1]; ?>" name="key<?php echo ($j+1); ?>">
		<td><input type="submit" value="表示" name="edit<?php echo ($j+1); ?>"></td>
<?php
		for ($i = 1 ;$i < $crows;$i++) {
			if(count($foreign_key_data[mysql_field_name($result, $i)]) > 0) {
				echo "<td >".GetList($foreign_key_data{mysql_field_name($result, $i)},$data[$i])."</td>\n";
			} else {
				echo "<td >".$data[$i]."</td>\n";
			}
		}
?>
	</tr>
<?php 
		$j++;
	}
?>
</form>
</table>
<?php 
	ShowNavBar2($maxrow,$pageset,$page,"75%",1);
?>
</div>


<?php
} //END リストを表示する
?>
<SCRIPT LANGUAGE="JavaScript">
<!--
i=document.getElementById('tabblock1').style;
j=document.getElementById('tabblock2').style;
k=document.getElementById('tabblock3').style;
-->
</SCRIPT>

<FORM METHOD="POST" name="FormGetSubmit" action="1510.php#fragment-6">
<INPUT type="hidden" name="pagenum"        value="">
<INPUT type="hidden" name="tablename"        value="<?php echo $strtablename; ?>">
<INPUT type="hidden" name="disp"        value="page">
</FORM>
</DIV>

<?php Menu4($_SERVER['PHP_SELF']); ?>
</body>
</html>
<?php 
Function Sprint($str) {
	echo "\"".Sjis($str)."\",";
}
//スマートフォンのユーザーエージェント
$ua_list = array(
  'iPhone',    // Apple iPhone
  'iPod',    // Apple iPod touch
  'iPad',    // Apple iPod touch
  'Android',    // Android
  'dream',    // Pre 1.5 Android
  'CUPCAKE',    // 1.5+ Android
  'blackberry',    // blackberry
  'webOS',    // Palm Pre Experimental
  'incognito',    // Other iPhone browser
  'webmate'    // Other iPhone browser
  );

// 結果を初期化
$ua = "スマホではありません。";

for($i=0; $i<sizeof($ua_list); $i++) {
	
  $str = "/".$ua_list[$i]."/i";
  $ret = preg_match($str, $_SERVER['HTTP_USER_AGENT']);

    if($ret != 0 ){
	
      // 結果をセット
      $ua = "スマホの ".$ua_list[$i]. "です。";
      break;
    }
}
echo $ua.$_SERVER['HTTP_USER_AGENT'];

myclose();
Testecho($strsql);
?>