inc_get_member_info.php

自己实现一个实用的商店应用系统

<?php
////////////////////////////////////////////////////////
// Author by Shuweich
// Date : 2007.07.27
// 2007.11.16 完成了前端界面的开发
// 建站支持: http://www.shuweich.net
// 作者: Shuweich
// QQ: 1502384
// ICQ: 190492112
// MSN: [e-mail]
// E-mail: [e-mail]
// E-mail: [e-mail]
////////////////////////////////////////////////////////
// 回传会员资料的xml结构文件 by mana_accs.php
////////////////////////////////////////////////////////
// Ajax Get customer/member information
include_once '../../mainfile.php';
header('Content-Type:text/xml');
echo "<?xml version='1.0' encoding='gb2312' ?>\n";

$que = "select user_name,user_sex,user_birthday,user_mb,user_tel,user_addr,user_count,user_disc,user_tach,user_card,user_ctach,store_id ";
$que.= " from ".$xoopsDB->prefix("market_member");
$que.= " where user_card='".$_REQUEST['mem_card']."' and auth>=-4 limit 0,1";
$ren = $xoopsDB->query($que);
$row = $xoopsDB->fetchrow($ren);
$que = "select jfxs,s_name from ".$xoopsDB->prefix("market_store");
$que.= " where store_id='".$row[11]."' limit 0,1";
$res = $xoopsDB->query($que);
$rw2 = $xoopsDB->fetchrow($res);

$ren = $xoopsDB->getRowsNum($ren);
if ( $ren == 0 ) {
  echo "<nocard>\n";
  echo "无卡消费<br />\n";
  echo "购物金额达100元可者，<br />免费办理会员卡一张<br />\n";
  echo "<hr />谢谢惠顾<br />\n";
  echo "非本店办卡者，恕不积分\n";
  echo "</nocard>\n";
} else {
  // $row = $xoopsDB->fetchrow($res);
  echo "<members>\n";
  echo "  <minfo>\n";
  echo "    <uname>".$row[0]."</uname>\n";
  echo "    <usex>".$row[1]."</usex>\n";
  echo "    <ubrid>".$row[2]."</ubrid>\n";
  echo "    <umb>".$row[3]."</umb>\n";
  echo "    <utel>".$row[4]."</utel>\n";
  echo "    <uaddr>".$row[5]."</uaddr>\n";
  echo "    <ucot>".$row[6]."</ucot>\n";
  echo "    <udisc>".$row[7]."</udisc>\n";
  echo "    <utach>".$row[8]."</utach>\n";
  echo "    <uctach>".$row[10]."</uctach>\n";
  echo "    <ucardn>".$row[9]."</ucardn>\n";
  echo "    <ustoreid>".$row[11]."</ustoreid>\n";
  echo "    <ujfxs>".$rw2[0]."</ujfxs>\n";
  echo "    <ucstore>".$rw2[1]."</ucstore>\n";
  echo "  </minfo>\n";
  echo "</members>";
}
?>