Write a Mysql fetchPair() query using Magento standard way for Fetches all SQL result rows as an array of key-value pairs.
You can write direct SQL query fetchPair() without worrying about Model operation using below code snippet.
Return Type: fetchPair() always return as an array with key-value pair as output.
Base Definition of function:
1 2 3 4 5 6 | /** * @param string|\Magento\Framework\DB\Select $sql An SQL SELECT statement. * @param mixed $bind Data to bind into SELECT placeholders. * @return array */ public function fetchPairs($sql, $bind = []); |
Let’s we are writing a query from sales_order table to accomplish fetchPair() query operation.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | <?php namespace Path\To\Class; use Magento\Framework\App\ResourceConnection; class fetchPair { const ORDER_TABLE = 'sales_order'; /** * @var ResourceConnection */ private $resourceConnection; public function __construct( ResourceConnection $resourceConnection ) { $this->resourceConnection = $resourceConnection; } /** * fetchpair Sql Query * * @return string[] */ public function fetchPairQuery() { $connection = $this->resourceConnection->getConnection(); $tableName = $connection->getTableName(self::ORDER_TABLE); $query = $connection->select() ->from($tableName,['entity_id','status']) ->where('status = ?', 'pending'); $fetchData = $connection->fetchPair($query); return $fetchData; } } |
Output:
Here in output, you can see key value is entity_id and value as the status of the order.
1 2 3 4 5 6 7 | Array ( [1] => pending [12] => pending [20] => pending .... ) |
Check for other Direct SQL Query in Magento 2
One Reply to “Write a fetchPair mysql query in Magento 2.”