replacing sql calls

[SLiCK_303]

So I have an old module, that is using oldscool sql calls. How would I replace... mysqliquery mysqlifetchassoc mysqlinumrows like... ``` $GLOBALS['___mysqlist'] = mysqliconnect(DBSERVER, DBUSER_, DBPASSWD_);

$sql2 = mysqliquery($GLOBALS['___mysqlist'], ' SELECT * FROM '._DB_PREFIX_.'product_shop WHERE id_product = '.(int)$idc['idproduct'].' AND id_shop = '.(int)$this->context->shop->id.' '); $result2 = mysqlifetchassoc($sql2); $count2 = mysqlinum_rows($sql2); ```

[yaniv14]

$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS( (new DbQuery()) ->select('*') ->from('product_shop', 'ps') ->where('ps.`id_product` = '.(int) $idc['id_product']) ->where('ps.`id_shop` = '.(int) $this->context->shop->id) );

[SLiCK_303]

I thought.. $result2 = mysqlifetchassoc($sql2); $count2 = mysqlinumrows($sql2);

would be.. $result2 = Db::getInstance(PSUSESQLSLAVE_)->getRow($sql2); count2 = Db::getInstance()->numRows();

but I'm confused on how to change sql2 to a newer style. tb1.0.2 type style....

[yaniv14]

getRow will return only single row (the first one). executeS will return array of all matching rows. To get the count, you can just count the result (count($result))

[SLiCK_303]

I didnt give enough of the code. The key was changing the do/while loop to a foreach loop. Thanks for the help tho...