3x Magento Master
Write a Mysql fetchAssoc() query using Magento standard way for Fetches all the SQL result rows as an associative array as an output.
You can write direct SQL query fetchAssoc() without worrying about Model operation using below code snippet.
Return Type: fetchAssoc() always returns as an array with the first column as the key and the entire row array as the value.
Write a Mysql fetchRow() query using Magento standard way for fetching the first row of the SQL result as an output.
You can get the first row as a result from the list of a resultant array using a query.
Direct SQL query fetchRow() without worrying about the Model operation.
Return Type: fetchRow() always returns as an array based on your query conditions.
Mysql fetchAll() query using Magento standard way for fetch all the records of the custom query.
You can fetch all the selected record from the table using direct SQL query fetchAll() without worry about the Model operation.
Return Type: fetchAll() always return as array based on your query conditions.