Menu
Hi,
I need to check for keys and values inside a sub-array. How to do that ?
//Values to check:
$table = 'users';
$column = 'kites';
//Array:
$query_string_params_and_values_white_list = array('table'=>array('users','members'),array('column'=>array('keyword','phrase')));
$query_string_params_and_values_white_list = array('table'=>array('users','members'),array('column'=>array('keyword','phrase')));
$table = 'users';
$column = 'kites';
if(in_array("$table",$query_string_params_and_values_white_list))
{
echo 'exists';
}
else
{
echo 'no exists';
}
if(in_array("$column",$query_string_params_and_values_white_list))
{
echo 'exists';
}
else
{
echo 'no exists';
}
[code=php]in_array($column, $query_string_params_and_values_white_list['column'])[/code]
array_walk_recursive()
$query_string_params_and_values_white_list = array(
'table'=>array('users','members'),
'column'=>array('keyword','phrase')
);
$table = 'users';
$column = 'kites';
foreach ($query_string_params_and_values_white_list as $subarray){
if(in_array($table,$subarray))
{
echo "existsn";
}
else
{
echo "no existsn";
}
}
<i>
</i>$query_string_params_and_values_white_list = array('table'=>array('users','members'),array('column'=>array('keyword','phrase')));
<i>
</i>$query_string_params_and_values_white_list = array(
'table'=>array('users','members'),
array(
'column'=>array('keyword','phrase')
)
);
<i>
</i>array('column'=>
<i>
</i>column'=> array(
<i>
</i>array(
<i>
</i>//Valid list of Mysql Tables.
$table_white_list = array('sale','sold','links');
//Valid list of Mysql Table Columns.
$column_white_list = array('email','domain','url','anchor','description','keyword');
<i>
</i>$query_string_params_and_values_white_list = array('table'=>array('users','members'),array('column'=>array('keyword','phrase')));
<i>
</i>$query_string_params_and_values_white_list = array(
'table'=>array('users','members'),
'column'=>array('keyword','phrase')
);
<i>
</i>$table = 'users';
$column = 'kites';
foreach ($query_string_params_and_values_white_list as $subarray){
if(in_array($table,$subarray))
{
echo "existsn";
}
else
{
echo "no existsn";
}
0.1.9 — BETA 4.26