Making a string out of array of arrays

Question

Sorry for asking probably a basic question, but I'm having a blackout.

If I have an array of arrays:

Array
(
    [appsversion] => Array
        (
            [0] => appsversion='6.1.0.33'
            [1] => appsversion='6.1.0.40'
        ),
    [osversion] => Array
        (
            [0] => osversion='6.1.0.53'
            [1] => osversion='6.1.0.42'
        )
)

how do I please construct an SQL condition with OR and AND of it?

I.e. for something like:

    $condition = '';
    foreach ($CONDITIONS as $key => $value) {
        # XXX I'm so lost here XXX
    }

    $sql = sprintf('select %s from mytable where %s', $condition);
    $sth = $pg->prepare($sql);
    $sth->execute();

I need the constructed string

    (appsversion='6.1.0.33' OR appsversion='6.1.0.40') AND
    (osversion='6.1.0.53' OR osversion='6.1.0.42')

or:

    appsversion in ('6.1.0.33', '6.1.0.40') AND
    osversion in ('6.1.0.53', '6.1.0.42')

Please give me few hints - to get my brain started again :-)

netcoder · Accepted Answer · 2011-09-29 15:06:02Z

2

There:

$where = array();
foreach ($conditions as $values) {
    $where[] = '('.implode(' OR ', $values).')';
}
$string = implode(' AND ', $where);

Yields:

(appsversion='6.1.0.33' OR appsversion='6.1.0.40') AND (osversion='6.1.0.53' OR osversion='6.1.0.42')

answered Sep 29, 2011 at 15:06

netcoder

68k19 gold badges129 silver badges142 bronze badges

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

Comments

CodeCaster · Accepted Answer · 2011-09-29 15:02:12Z

1

You mean something like this?

$condition = "(appsversion = '" . implode("' OR appsversion = '", $conditions['appsversion']) . "')";
$condition .= " AND (osversion = '" . implode("' OR osversion = '", $conditions['osversion']) . "')";

Or, cleaner with IN:

$condition = "appsversion IN ('" . implode("', '", $conditions['appsversion']) . "')";
$condition .= " AND osversion IN ('" . implode("', '", $conditions['osversion']) . "')";

answered Sep 29, 2011 at 15:02

CodeCaster

153k24 gold badges237 silver badges287 bronze badges

3 Comments

Alexander Farber Over a year ago

Thanks, but what if I don't know the keys? (I.e. don't know there is "appsversion" and "osversion").

Czechnology Over a year ago

That would produce appsversion = ('6.1.0.33' OR '6.1.0.40'). I don't think that would work correctly.

CodeCaster Over a year ago

I saw my mistake after posting, updated, thanks. @Alex then you're screwed. Why don't you know the keys?

hakre · Accepted Answer · 2011-09-29 15:39:16Z

1

In case your original array does not duplicate the key names and provides values "as-is" (I somehow misread your question, but probably it's useful):

$conditions = array(
    'appsversion' => Array('6.1.0.33', '6.1.0.40'),
    'osversion' => Array('6.1.0.53', '6.1.0.42'),
);

foreach ($conditions as $key => &$values) {
    foreach($values as &$value)
        $value = sprintf("%s='%s'", $key, $value);
    $values = sprintf("(%s)", implode(' OR ', $values));
}
unset($values, $value);
echo implode(" AND \n", $conditions);

Output/Demo:

(appsversion='6.1.0.33' OR appsversion='6.1.0.40') AND (osversion='6.1.0.53' OR osversion='6.1.0.42')

edited Sep 29, 2011 at 15:39

answered Sep 29, 2011 at 15:05

hakre

200k55 gold badges454 silver badges865 bronze badges

Comments

Czechnology · Accepted Answer · 2011-09-29 15:04:35Z

0

$conditions1 = array();
foreach ($CONDITIONS['appsversion'] as $value) {
    $conditions1[] = sprintf("appversion = '%s'", mysql_real_escape_string($value));
}

$conditions2 = array();
foreach ($CONDITIONS['osversion'] as $value) {
    $conditions1[] = sprintf("osversion = '%s'", mysql_real_escape_string($value));
}

$sql = sprintf('select %s from mytable where (%s) AND (%s)', $cols, implode(' OR ', $conditions1), implode(' OR ', $conditions2));
$sth = $pg->prepare($sql);
$sth->execute();

answered Sep 29, 2011 at 15:04

Czechnology

15k10 gold badges65 silver badges88 bronze badges

Comments

Jauzsika · Accepted Answer · 2011-09-29 15:07:29Z

0

foreach($C as $key => $value)
{
    $str .= ($str ? ' AND ' : '') . '(' . implode(' OR ',$value) . ')';
}

answered Sep 29, 2011 at 15:07

Jauzsika

3,2613 gold badges26 silver badges32 bronze badges

Collectives™ on Stack Overflow

Making a string out of array of arrays

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related