访问mysql记录集中的特定行

Question

I have a database table with options that looks like this

I do a SELECT * FROM options and load all records into a recordset.

How do I then access just the optionValue of optionName = SMSactive

[EDIT]

Yes, I could do SELECT * FROM options WHERE optionName ='SMSactive' - I know that.

But as I said, since I have a recordset with a bunch of rows in it (from the SELECT), I want to pull a specific row where optionName = SMSactive

[EDIT] If you are using PHP >= 5.5 you can use array_column() http://php.net/array_column

But if not, the question has already been asked and answered here PHP multidimensional array search by value

Answer 1

To access to all records with optionName = SMSactive the SQL should be:

SELECT * FROM `TableName` WHERE `optionName` = 'SMSactive'

if your array result from the query is something like this:

$array = array(
    0 => array(
        'optionName' => 'lala0',
        'optionDescription' => 'lala01',
        'optionValue' => 'lala03',
    ),
    1 => array(
        'optionName' => 'lala1',
        'optionDescription' => 'ala2',
        'optionValue' => 'SMSactive',
    )
);

You can grab who has 'optionValue' => 'SMSactive', by this way

foreach ($array as $key) {
    if ($key['optionValue'] == 'SMSactive') {
        $filtered[]=$key;
    }
}

echo '<pre>';
print_r($filtered);
echo '</pre>';

Side Note: If the array is very large you have to be careful with the memory...it's advisable just get from the db what you are using in the moment...IMO