php array between,php 多维数组转sql

题主是想实现，二维数组拼成一个sql语句吗。换一个思路，传参统一为多维数组。

function arrayToSqlStatement( $arrayData = [] )

{

$_temp_string = '';

foreach ($arrayData as $parameterArray) {

foreach ( $parameterArray as $parameter ) {

if ( is_array( $parameter ) && !empty( $parameter ) ) {

$sqlCondition = $parameter[0];

$sqlValue = $parameter[1];

} else {

$sqlCondition = '=';

$sqlValue = trim( $parameter );

}

//根据符号组合值的样式

if ( $sqlCondition == 'LIKE' ) {

$_temp_string .= ' AND ' . $k . ' LIKE "%' . $sqlValue . '%" ';

} elseif ( $sqlCondition == 'IN' ) {

$_temp_string .= ' AND ' . $k . ' IN(' . $sqlValue . ')';

} elseif ( $sqlCondition == 'BETWEEN' ) {

$_between_value = explode( '|', $sqlValue );

$_temp_string .= ' AND ' . $k . '>="' . $_between_value[0] . '" AND ' . $k . '<="' . $_between_value[1] . '" ';

} else {

$_temp_string .= ' AND ' . $k . $sqlCondition . ' "' . $sqlValue . '" ';

}

}

}

return $_temp_string;

}

//第二种情况，出问题了。

$a=[

[

'bbb'=>'222',

'ccc'=>'333',

'ddd'=>['>=','444'],

'eee'=>['BETWEEN','555|666']

],

[

'bbb'=>'222',

'ccc'=>'333',

'ddd'=>['>=','444'],

'eee'=>['BETWEEN','555|666']

]

];

//第一种情况，已经实现了

$b=

[

[

'bbb'=>'222',

'ccc'=>'333',

'ddd'=>['>=','444'],

'eee'=>['BETWEEN','555|666']

]

];

print_r(arrayToSqlStatement($b));

?>