Magento – Fix Deprecated mysql_connect() Error: Use mysqli or PDO Instead

databasemagento-1.7magento-1.8magento-1.9sql

I created login form. but I got this error. how can I solve this error.
enter image description here

Best Answer

For custom queries magento has core_read and core_write resources use that one

Example of how to use core_read

$connection = Mage::getSingleton('core/resource')->getConnection('core_read');
$sql        = "Select * from catalog_product_flat_1";
$rows       = $connection->fetchAll($sql); //fetchRow($sql), fetchOne($sql),...
Zend_Debug::dump($rows);

For core_write use below code

$resource = Mage::getSingleton('core/resource');
$writeConnection = $resource->getConnection('core_write');
$table = $resource->getTableName('catalog/product');
$query = "UPDATE {$table} SET {item} = '{value}' WHERE entity_id = 'value'";
$writeConnection->query($query);`
Related Topic