查询wp\\u wpsc\\u purchase\\u logs表,它包含有关以前购买的所有信息。
将此添加到主题功能中。php:
/*********************************************************
Get purchased articles by user_id or for the current user
*********************************************************/
function haet_recently_bought_articles($user_id=0){
if($user_id==0)
$user_id=get_current_user_id();
//only if there is an active user, otherwise we would get all purchased items from unregistered users
if($user_id>0) {
global $wpdb;
$sql = $wpdb->prepare("
SELECT prodid, name, price
FROM `".$wpdb->prefix."wpsc_cart_contents`
INNER JOIN `".$wpdb->prefix."wpsc_purchase_logs` ON purchaseid = ".$wpdb->prefix."wpsc_purchase_logs.id
WHERE user_ID = %d
ORDER BY date DESC"
,$user_id);
$items = $wpdb->get_results($sql,ARRAY_A);
return $items;
}
return null;
}
并在模板中添加以下行以显示产品,例如第页-。php
<ul class="articles">
<?php
$articles = haet_recently_bought_articles();
foreach($articles AS $article){
echo \'<li>\'.$article[\'name\'].\'</li>\';
}
?>
</ul>