日期:2014-05-17 浏览次数:20595 次
//拆分发来的信息得到会员卡号
$arry=explode("+",$form_Content);
$memberid =$arry[1];
//连接数据库
$link=mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL_PASS);
if($link) {
mysql_select_db(SAE_MYSQL_DB,$link);
//查询数据
$result1=mysql_query("select * from numbers where pmcode = '".$memberid."';");
$num_result = mysql_num_rows($result1);
if($num_result==1){
// $row= $result1->fetch_assoc();
$row=mysql_fetch_row($result1);
$result_str="您的会员--信息如下:\n\n卡号:$row[pmcode].\n姓名:.$row[names].\n等级:.$row[4].\n积分:$a[5]";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType,$result_str);
echo $resultStr;
exit;
}else{
$msgType = "text";
$resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType,"--select * from numbers where pmcode = '".$memberid."'");
echo $resultStr;
&