check if a value exist in array from database query

Question

I am trying to build a website that will display the text in multiple languages. I have a table 'text' with all the languages. If the text does not exist in the chosen language it has to display the default language.

query SELECT * FROM text WHERE TextId = 10 results in

Id  TextId  LanguageId  Text
10  10      1           first name
13  10      2           名前

If I r_print this result I get something like this

Array ( [0] => Array ( [0] => 10 [Id] => 10 [1] => 10 [TextId] => 10 [2] => 1 [LanguageId] => 1 [3] => first name [Text] => first name ) 
        [1] => Array ( [0] => 13 [Id] => 13 [1] => 10 [TextId] => 10 [2] => 2 [LanguageId] => 2 [3] => 名前 [Text] => 名前 ) )

How can I check that LanguageId 2 exist in this array ? the problem is that it is possible that TextId 2 and Id 2 can also exist in this array.

Is this possible to do with in_array()?

in_array() is possible.. i have used to same problem..

Vaishu
– Vaishu

2013-12-24 11:19:16 +00:00
Commented Dec 24, 2013 at 11:19 — Vaishu
– Vaishu, Commented Dec 24, 2013 at 11:19

Charaf JRA · Accepted Answer · 2013-12-19 10:00:39Z

2

Here is a function that can check if LanguageId equals a special value .

function isLanguageIdExists($yourArray , $LanguageId){
    $exists=false;
    foreach($yourArray as $array){
     if(isset($array['LanguageId'])&& $array['LanguageId'] == $LanguageId){
        $exists=true;break;
      }

    }
    return $exists;
}

$exist = isLanguageIdExists($yourArray , 2);//return true or false

answered Dec 19, 2013 at 10:00

Charaf JRA

8,3551 gold badge36 silver badges44 bronze badges

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

1 Comment

minas Over a year ago

this function can also be modified to check other keys like textId, Id , just introduce a 3rd paramter in the function for array key , the value you want to check is already being passed

Roopendra · Accepted Answer · 2013-12-19 10:00:58Z

0

You can check by isset the key and match the value in php.

$dataArray =  array(
    0 => array(0 => 10 ,'Id' => 10, 1 => 10, 'TextId' => 10, 2 => 1, 'LanguageId' => 1),1 => array(0 => 10 ,'Id' => 10, 1 => 10, 'TextId' => 10, 2 => 1, 'LanguageId' => 1)

);

foreach($dataArray as $value) {
    if(isset($value['LanguageId']) && $value['LanguageId'] == 2) {
        echo 'language ID 2 is available';
    }
}

Working Demo

edited Dec 19, 2013 at 10:00

answered Dec 19, 2013 at 9:53

Roopendra

7,75716 gold badges72 silver badges95 bronze badges

1 Comment

anatak Over a year ago

I feel like a complete idiot to not have thought about isset(). Thank you so much

anatak · Accepted Answer · 2013-12-24 10:46:14Z

After giving this some more thought I came up with a maybe not so elegant solution. Instead of getting an array back I modified the SQL Query to give one row back with the default language (English) and a user selected language (Japanese). It uses two left joins. This shows that I received (some) training in SQL but am really not at ease with multidimensional arrays.

Query def_text = text in default language usr_text = text in user chosen language

    $table01 = "text";
    $query="SELECT $table01.TextId, 
            text_def.Text as def_text,
            text_usr.Text as usr_text
            FROM $table01 
            LEFT JOIN $table01 as text_def ON $table01.TextId = text_def.TextId AND text_def.LanguageId = $_SESSION[default_language]
            LEFT JOIN $table01 as text_usr ON $table01.TextId = text_usr.TextId AND text_usr.LanguageId = $_SESSION[language]
            WHERE $table01.TextId=$mess;";

after getting back the results it is easy to check with isset() or empty() to see if the text is available in the user selected language

Collectives™ on Stack Overflow

check if a value exist in array from database query

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related