compile php online

Language: Layout:

<?php //Title of this code
//php 5.5.12

// **************************************
// 列一覧配列の取得
// **************************************
$row = build_sql( 0, "syain" );
// 値のセット
$row["所属"] = 1;
$row["社員コード"] = "0001";
$row["氏名"] = "山田 太郎";
$row["更新日"] = "@NOW()";

print "\n---------------------------\n";
// insert 取得
print build_sql( 1, "syain", $row, "社員マスタ" );

print "\n---------------------------\n";
// update 取得
print build_sql( 2, "syain", $row, "社員マスタ" );

// **************************************
// 必要な列だけの処理
// **************************************
$row = array();
$row["所属"] = 1;
$row["社員コード"] = "0001";
$row["氏名"] = "山田 太郎";

print "\n---------------------------\n";
// insert 取得
print build_sql( 1, "syain", $row, "社員マスタ" );

print "\n---------------------------\n";
// update 取得
print build_sql( 2, "syain", $row, "社員マスタ" );

// **************************************
// 条件のみ
// **************************************
print "\n---------------------------\n";
print build_sql( 3, "syain", $row );

// **************************************
// SQL更新文字列 ビルド関数
// **************************************
function build_sql( $type, $file_name, $row=null, $table_name="" ) {

global $build_sql_error;

// 更新列一覧情報の取得
	$format1 = <<<FORMAT
{
    "社員コード": "",
    "氏名": "",
    "フリガナ": "",
    "所属": "",
    "性別": "",
    "作成日": "",
    "更新日": "",
    "給与": "",
    "手当": "",
    "管理者": "",
    "生年月日": ""
}
FORMAT;

$format2 = <<<KEY
{
    "所属": "num",
    "社員コード": ""
}
KEY;

// insert sql 文字列作成
	if ( $type == 1 ) {
		if ( $row == null || !is_array( $row ) || count($row) == 0 ) {
			$row = build_sql( 0, $file_name );
		}
        
		$obj1 = json_decode($format1);
		$array1 = get_object_vars( $obj1 );
		$insert = "insert into @TABLE (@FIELDS) values(@VALUES)";

$fields = "";
		foreach( $array1 as $k => $v ) {
			if ( array_key_exists($k,$row) ) {
				if ( $fields != "" ) {
					$fields .= ",";
				}
				$fields .= $k;
			}
		}
		$insert = str_replace("@FIELDS", $fields, $insert );

$values = "";
		foreach( $array1 as $k => $v ) {

if ( array_key_exists($k,$row) ) {
				if ( $values != "" ) {
					$values .= ",";
				}
				if ( $row[$k] == NULL ) {
						$values .= "null";
				}
				else {
					if ( $v == "num" ) {
						$values .= $row[$k];
					}
					else {
						if ( substr( $row[$k], 0, 1 ) == "@" ) {
							$values .= str_replace( "@", "", $row[$k] );
						}
						else {
							$values .= "'{$row[$k]}'";
						}
					}
				}
			}

}
		$insert = str_replace("@VALUES", $values, $insert );
		$insert = str_replace("@TABLE", $table_name, $insert );
		return $insert;
	}

// update sql 文字列作成
	if ( $type == 2 ) {
		if ( $row == null || !is_array( $row ) || count($row) == 0 ) {
			$row = build_sql( 0, $file_name );
		}
        
		$obj1 = json_decode($format1);
		$array1 = get_object_vars( $obj1 );
		$obj2 = json_decode($format2);
		$array2 = get_object_vars( $obj2 );

$update = "update @TABLE set @SETS where @KEYS";
		$sets = "";
		foreach( $array1 as $k => $v ) {

if ( array_key_exists($k,$row) ) {
				// キー項目以外の代入を作成します
				if ( !array_key_exists($k,$array2) ) {

if ( $sets != "" ) {
						$sets .= ",";
					}

if ( $row[$k] == NULL ) {
							$sets .= "{$k} = null";
					}
					else {
						if ( $v == "num" ) {
							$sets .= "{$k} = {$row[$k]}";
						}
						else {
							if ( substr( $row[$k], 0, 1 ) == "@" ) {
								$sets .= "{$k} = " . str_replace( "@", "", $row[$k] );
							}
							else {
								$sets .= "{$k} = '{$row[$k]}'";
							}
						}
					}

}
			}

}

// where 以降の条件を作成します
		$update = str_replace("@SETS", $sets, $update );
		$keys = "";
		foreach( $array2 as $k => $v ) {

if ( $keys != "" ) {
				$keys .= " and ";
			}
			if ( $v == "num" ) {
				$keys .= "{$k} = {$row[$k]}";
			}
			else {
				if ( substr( $row[$k], 0, 1 ) == "@" ) {
					$keys .= "{$k} = " . str_replace( "@", "", $row[$k] );
				}
				else {
					$keys .= "{$k} = '{$row[$k]}'";
				}
			}

}

$update = str_replace("@KEYS", $keys, $update );
		$update = str_replace("@TABLE", $table_name, $update );
		return $update;
	}

// where 以降のみ作成
	if ( $type == 3 ) {
		if ( $row == null || !is_array( $row ) || count($row) == 0 ) {
			$row = build_sql( 0, $file_name );
		}
        
		$obj2 = json_decode($format2);
		$array2 = get_object_vars( $obj2 );

$keys = "";
		foreach( $array2 as $k => $v ) {

}

return $keys;
	}

// 一覧より $row の作成
	if ( $type == 0 ) {
		$obj1 = json_decode($format1);
		$array1 = get_object_vars( $obj1 );
		$obj2 = json_decode($format2);
		$array2 = get_object_vars( $obj2 );
		foreach( $array1 as $k => $v ) {
			$array1[$k] = null;
			if ( array_key_exists($k,$array2) ) {
				$array1[$k] = "key";
			}
		}

return $array1;
	}

}

[ + ] Show input
Absolute running time: 0.14 sec, cpu time: 0.02 sec, memory peak: 9 Mb, absolute service time: 0.15 sec