Something like "WHERE" from SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenoli - 23 Nov 2006 14:41 GMT

Is there a way to accomplish something like the "WHERE" syntax from SQL
in php? For example an equivalent to the following, which I know is
not proper php syntax.

foreach ($var as $key => $value WHERE $key != '3') {
echo "$key is $value";
}

or

implode (",", $_POST WHERE $_POST[name] != 'post');

I keep wanting to be able to do things like this.

--Kenoli

Reply to this Message

Captain Paralytic - 23 Nov 2006 14:48 GMT

> Is there a way to accomplish something like the "WHERE" syntax from SQL
> in php? For example an equivalent to the following, which I know is
[quoted text clipped - 11 lines]
>
> --Kenoli

foreach ($var as $key => $value) {
if $key != '3'
echo "$key is $value";

Reply to this Message

Rik - 27 Nov 2006 16:47 GMT

> Is there a way to accomplish something like the "WHERE" syntax from
> SQL in php? For example an equivalent to the following, which I know
[quoted text clipped - 9 lines]
>
> I keep wanting to be able to do things like this.

array_filter();
http://nl3.php.net/manual/en/function.array-filter.php

The problem here is you cannot filter on keys.

On could use array_keys(), array_filter() and then again array_flip() and
array_intersect_keys(). It's hardly better then a foreach loop however, and
a lot less readable.

Signature

Rik Wasmus

Reply to this Message

Webmaster Forum / PHP / Database Access / November 2006

Something like "WHERE" from SQL