PHP Get Value from Array with Value of Key

Question

following problem: I want to build a mysql based language system.

To decrease loading time and increase performance I thought it would be the best, to first fetch all Language phrases into an array (which happens with mysqli fetch array). Then, if a language term is required, calling a function with the array as global variable.

My function for the array:

$sql       = $db->query('SELECT * FROM lang_phrases WHERE phraseLanguageId = 1');
$phrases   = array();

while($row = $sql->fetch_array()) {
    $phrases[] = $row;
}

Now I've got this array:

array(2) { 
    [0]=> array(8) { 
        [0]=> string(1) "1" 
        ["phraseId"]=> string(1) "1"
        [1]=> string(1) "1" 
        ["phraseLanguageId"]=> string(1) "1" 
        [2]=> string(4) "HOME" 
        ["phraseKey"]=> string(4) "HOME" 
        [3]=> string(10) "Homepage" 
        ["phraseContent"]=> string(10) "Homepage" 
    } 
    [1]=> array(8) { 
        [0]=> string(1) "2" 
        ["phraseId"]=> string(1) "2" 
        [1]=> string(1) "1" 
        ["phraseLanguageId"]=> string(1) "1" 
        [2]=> string(4) "BACK" 
        ["phraseKey"]=> string(4) "BACK" 
        [3]=> string(6) "Back" 
        ["phraseContent"]=> string(6) "Back" 
    } 
}

And thats my function:

function l($key) {
    global $phrases;

    return PLACEHOLDER;
}

I wonder, how can I now search the array for "phraseKey" $key from the function and get the value? Do you have any hints? Or shall I simply select each phrase with each one query (performance problems with 100 quers per load?!)?

Cheers and Thanks!

Just as an aside, this will probably have a much lower overhead to do the same thing, if you've got enough control over your server to use it (probably want a dedicated server as you'll need to soft restart if/when you change the PO files) : php.net/manual/en/book.gettext.php — CD001
– CD001, Commented Jan 6, 2015 at 16:00

Marc B · Accepted Answer · 2015-01-06 15:58:19Z

3

That's a bad structure. Why not key your array with the phrase ID and the language? e.g.

$translations = array(
    'HOME' => array(
       'english' => 'Home',
       'french' => 'Maison',
       'german' => 'Haus"
    etc...

This eliminates the need for ANY searching. You just look up directly by language/phrase ID.

answered Jan 6, 2015 at 15:58

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

2 Comments

cmorrissey Over a year ago

I don't like the idea that you area loading all of the languages into this array

Marc B Over a year ago

6 of this, half-a-dozen of the other. depends entirely on just how many phrases/languages OP has. at some point the overhead of buildnig this array will outweigh the overhead of only having parts of it and doing repeated queries.

Federkun · Accepted Answer · 2015-01-06 16:03:53Z

2

May I suggest to retrive the phrases with

while($row = $sql->fetch_array()) {
    $phrases[$row['phraseKey']] = $row;
}

Then in your function l($key) you can search them with

$t = isset($phrases[$key]) ? $phrases[$key] : null

edited Jan 6, 2015 at 16:03

answered Jan 6, 2015 at 15:58

Federkun

37.2k8 gold badges82 silver badges93 bronze badges

Collectives™ on Stack Overflow

PHP Get Value from Array with Value of Key

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related