Insert different strings before and after variable in PHP

Question

I have 4 PHP variables, each variable consists of dynamic checkboxes, sometimes it can be one variable sometimes more but not more than 4:

$type = 'type_id = 2';
$color = 'color_id = 3';
$man = 'man_id = 5';
$size = 'size_id = 4 or size_id = 5';

I need to form of these variables Mysql query, the problem is how to add WHERE and AND strings before each variable. In front of first variable I need to add WHERE (it can be $type or $color or other). If first variable is active and other is checked I need to add AND to form proper query. e.g

if checked only "type" checkboxes:

WHERE $type

if checked "size" and "type" checkboxes:

WHERE $size AND $type

and so on... Hope you understand my problem, sorry for bad english.

Sergey Eremin · Accepted Answer · 2012-07-19 20:14:54Z

2

$parts = array();
if (!empty($type)) {
    $parts[] = '(' . $type . ')';
}
if (!empty($color)) {
    $parts[] = '(' . $color . ')';
}
if (!empty($man)) {
    $parts[] = '(' . $man . ')';
}
if (!empty($size)) {
    $parts[] = '(' . $size. ')';
}
$where = '';
if (!empty($parts)) {
    $where = 'WHERE ' . implode(' AND ', $parts);
}
$select .= $where;

answered Jul 19, 2012 at 20:14

Sergey Eremin

11.1k2 gold badges43 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

nickb · Accepted Answer · 2012-07-19 20:13:13Z

2

Put them in an array and join them with implode() like this:

$temp = array( $type, $color, $man, $size);
$string = 'WHERE ' . implode( ' AND ', $temp);

If any of those variables aren't set (i.e. there not submitted from the checkboxes), don't add it to the array:

$temp = array();
if( isset( $_POST['somecheckbox'])) {
    $temp[] = "( something = value )";
}
if( isset( $_POST['someothercheckbox'])) {
    $temp[] = "( somethingelse = value )";
}
...

answered Jul 19, 2012 at 20:13

nickb

59.7k13 gold badges115 silver badges149 bronze badges

Comments

newfurniturey · Accepted Answer · 2012-07-19 20:17:56Z

Assuming your checkboxes are in submitted via POST, you could have an association-array in PHP that is iterated-through and checks-for a corresponding checkbox selection; if selected, it adds it to the string.

A rough sketch could be:

$fields = array(
    'type' => 'type_id = 2',
    'color' => 'color_id = 3',
    'man' => 'man_id = 5',
    'size' => 'size_id = 4 or size_id = 5'
);
$whereClause = '';
foreach ($fields as $field => $value) {
    if (isset($_POST[$field]) && ($_POST['field'] == 1)) {
            // this field is "active"
        if ($whereClause != '') $whereClause .= ' AND ';
        $whereClause .= '(' . $value . ')';
    }
}
if ($whereClause != '') $whereClause = ' WHERE ' . $whereClause;

Note, I have the $value of each field wrapped in parentheses so that and and won't interfere with the or that's in your size variable.

Collectives™ on Stack Overflow

Insert different strings before and after variable in PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related