我想从Magento通过PHP获取一些数据,它的工作原理,但我需要添加多个集合,现在我卡住了。我只是一个初学者,所以请原谅我:-)
我使用下面的代码来获取客户的详细信息,这工作正常。
现在我需要添加客户/地址以获取地址详细信息以填写邮政编码的最后一列,任何人都知道如何做到这一点?
function getcustomers() {
/* Magento's Mage.php path
* Mage Enabler users may skip these lines
*/
require_once ("app/Mage.php");
umask(0);
Mage::app("nl");
/* Magento's Mage.php path */
/* Get customer model, run a query */
$collection = Mage::getModel('customer/customer')
//$collection = Mage::getModel('customer/address')
->getCollection()
->addAttributeToSelect('*');
$result = array();
foreach ($collection as $customer) {
$result[] = $customer->toArray();
}
return $result;
}
?>
Customerstable {
border-collapse: collapse;
}
td {
padding: 5px;
border: 1px solid #000000;
}
ID | Lastname | Firstname | Is Active? | Date Created | Date Updated | Website ID | Store ID | Zip Code |
$result = getcustomers();
if(count($result) > 0){
foreach($result as $key => $value){
echo "
";echo "
".$value['entity_id']."";echo "
".$value['lastname']."";echo "
".$value['firstname']."";echo "
".$value['email']."";echo "
";echo $value['is_active'] == 1 ? "Yes" : "No";
echo "
";echo "
".$value['created_at']."";echo "
".$value['updated_at']."";echo "
".$value['website_id']."";echo "
".$value['store_id']."";echo "
".$value['zipcode']."";echo "
";}
}else{
echo "
No records found";}
?>