Converting PHP Arrays with Key Values to String Statement

Comments (0)

Views (339)

Why we may need this let understand this first. For example when I was writing a database class I was using a method like that.

$params = [
    'ORDER BY' => 'date DESC',
    'LIMIT' => '0, 10'
];
Database::select('messages', $params)

To use them easily i need to combine the array which has key value then convert them into the string. So mysql code should be like this;

SELECT * FROM messages ORDER BY date DESC LIMIT 0, 10

I did this in a easiest way

$params = [
    'ORDER BY' => 'date DESC',
    'GROUP BY' => 'date',
    'LIMIT' => '0, 15'
];
array_walk($params, function(&$i, $k){
    $i = "$k $i";
});
$sql = implode(' ', $params);
echo $sql; // Result: ORDER BY date DESC GROUP BY date LIMIT 0, 15

Instead of assigning one variable and using in foreach loop, we used array_walk() which is one of the array functions. And in anonym function we set our key to key-vaue. We combined the array by using implode() and we got what we want

When you are stuck while you are coding or when you need to relax yourself comment section is waiting for you. Ask what you don't know, answer what you know !

Converting PHP Arrays with Key Values to String Statement

Comments

Popular Articles

Popular Tags