I know but you suggestion:
foreach ($resultSet as $row) {}
as I've wrote, will emit mysql out of sync error when another module
(or event) use db driver. To resolve that we must loop at resultSet and
get data,
but not convert all row object to array.
On 26/03/12 17:12, ralphschindler [via
On Mon Mar 26 10:37:14 2012, duke wrote:
I know but you suggestion:
foreach ($resultSet as $row) {}
as I've wrote, will emit mysql out of sync error when another module
(or event) use db driver. To resolve that we must loop at resultSet and
get data,
but not convert all row object to array.
You should be choosing the proper mysql extension based on your needs.
Mysqli is great for scripts that do alot of data-warehouse type of
iterations (due to its forward-only moving cursor by default). PDO on
the other hand is great for object model kind of stuff because by
default, it buffers
Thanks Ralph, It's work.
Additional question: If I use PDO and do second query where will be
store data at sql server memory? If so, otherwise some where it will be
use memory. So which memory will be use better Sql Server or PHP?
On 26/03/12 18:05, ralphschindler [via Zend Framework