require_once('app/Mage.php');
Mage::app('default');
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$writeConnection = $resource->getConnection('core_write');
1.读数据
Varien_Db_Select::fetchAll //return array
$query = 'SELECT * FROM ' . $resource->getTableName('catalog/product');
$results = $readConnection->fetchAll($query);
foreach($results as $row){
echo $row['xxx']
}
Varien_Db_Select::fetchCol //return array
和fetchAll不同,仅返回第一列的所有值
$skus = $readConnection->fetchCol('SELECT sku FROM ' . $resource->getTableName('catalog/product') . ');
foreach($skus as $sku){
echo $sku;
}
Varien_Db_Select::fetchOne //return string
返回第一行第一列的值
$sku = $readConnection->fetchOne('SELECT sku FROM ' . $resource->getTableName('catalog/product') . ');
echo $sku;
2.写数据
$query = "update ...";
$writeConnection->query($query);