userheader.php页面:
<link href="/ants/css/globe.css" rel="stylesheet" type="text/css" />
<link href="/ants/css/user.css" rel="stylesheet" type="text/css" />
<div class="top_toolbar">
<div class="top_nav">
<div class="logininfo">浣犲ソ,
<a href="<?php echo $cfg_memberurl; ?>" class="userName"><?php echo $cfg_ml->M_UserName?></a>
<a href='<?php echo $cfg_memberurl; ?>/index_do.php?fmdo=login&dopost=exit#\'>[閫�嚭]</a>
<?php
$pms = $dsql->GetOne("SELECT COUNT(*) AS nums FROM #@__member_pms WHERE toid='{$cfg_ml->M_ID}' AND `hasview`=0 AND folder = 'inbox'");
if($pms['nums'] > 0)
{
echo "銆�a href='$cfg_memberurl/pm.php' target='_blank'>鐭秷鎭�[<font color='#FF0000'>{$pms['nums']}</font>]</a>";
}else if($pms['nums']==0)
{
echo "銆�a href='$cfg_memberurl/pm.php' target='_blank'>鐭秷鎭�/a>";
}
?>
</div>
<div class="quicklink icon">
<ul>
<li class="home"><a href="<?php echo $cfg_basehost;?>" title="棣栭〉">棣栭〉</a></li>
<li><a href="<?php echo $cfg_memberurl;?>" title="浼氬憳涓績">浼氬憳涓績</a></li><li class="custom">
<span></span><a href="<?php echo str_ireplace('passport_client.php',"",PP_API)."thread.php?fid=4";?>">瀹氬埗璁捐</a>
</li><li class="bbs">
<span></span><a href="<?php echo str_ireplace('passport_client.php',"",PP_API);?>">铓傝殎璁哄潧</a></li>
<li class="collect">
<span></span><a id="favBtn" href="#">鏀惰棌鏈珯</a></li>
</ul>
</div>
</div>
</div>
<script src="/ants/js/jfav.js" language="javascript" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
//鏀惰棌鍔熻兘
$('#favBtn').jFav();
});
</script>
index.php页面 :<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
</head>
<body>
<form id="form1" style="height:100%">
<div id="silverlightControlHost">
<object data="data:application/x-silverlight-2," type="application/x-silverlight-2" width="100%" height="100%">
<param name="source" value="ClientBin/SLAppl.xap"/>
<param name="onError" value="onSilverlightError" />
<param name="background" value="white" />
<param name="InitParams" value="username=<?php echo $_GET["UserName"]; ?>,phototext=<?php echo $_GET["tel"]; ?>,faceidtext=<?php echo $_GET["mobile"]; ?>" />
<param name="minRuntimeVersion" value="4.0.50826.0" />
<param name="autoUpgrade" value="true" />
<a href="http://go.microsoft.com/fwlink/?LinkID=149156&v=4.0.50826.0" style="text-decoration:none">
<img src="http://go.microsoft.com/fwlink/?LinkId=161376" alt="获取 Microsoft Silverlight" style="border-style:none"/>
</a>
</object><iframe id="_sl_historyFrame" style="visibility:hidden;height:0px;width:0px;border:0px"></iframe></div>
</form>
</body></html>我要用index.php引用userheader.php得到UserName
<link href="/ants/css/globe.css" rel="stylesheet" type="text/css" />
<link href="/ants/css/user.css" rel="stylesheet" type="text/css" />
<div class="top_toolbar">
<div class="top_nav">
<div class="logininfo">浣犲ソ,
<a href="<?php echo $cfg_memberurl; ?>" class="userName"><?php echo $cfg_ml->M_UserName?></a>
<a href='<?php echo $cfg_memberurl; ?>/index_do.php?fmdo=login&dopost=exit#\'>[閫�嚭]</a>
<?php
$pms = $dsql->GetOne("SELECT COUNT(*) AS nums FROM #@__member_pms WHERE toid='{$cfg_ml->M_ID}' AND `hasview`=0 AND folder = 'inbox'");
if($pms['nums'] > 0)
{
echo "銆�a href='$cfg_memberurl/pm.php' target='_blank'>鐭秷鎭�[<font color='#FF0000'>{$pms['nums']}</font>]</a>";
}else if($pms['nums']==0)
{
echo "銆�a href='$cfg_memberurl/pm.php' target='_blank'>鐭秷鎭�/a>";
}
?>
</div>
<div class="quicklink icon">
<ul>
<li class="home"><a href="<?php echo $cfg_basehost;?>" title="棣栭〉">棣栭〉</a></li>
<li><a href="<?php echo $cfg_memberurl;?>" title="浼氬憳涓績">浼氬憳涓績</a></li><li class="custom">
<span></span><a href="<?php echo str_ireplace('passport_client.php',"",PP_API)."thread.php?fid=4";?>">瀹氬埗璁捐</a>
</li><li class="bbs">
<span></span><a href="<?php echo str_ireplace('passport_client.php',"",PP_API);?>">铓傝殎璁哄潧</a></li>
<li class="collect">
<span></span><a id="favBtn" href="#">鏀惰棌鏈珯</a></li>
</ul>
</div>
</div>
</div>
<script src="/ants/js/jfav.js" language="javascript" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
//鏀惰棌鍔熻兘
$('#favBtn').jFav();
});
</script>
index.php页面 :<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
</head>
<body>
<form id="form1" style="height:100%">
<div id="silverlightControlHost">
<object data="data:application/x-silverlight-2," type="application/x-silverlight-2" width="100%" height="100%">
<param name="source" value="ClientBin/SLAppl.xap"/>
<param name="onError" value="onSilverlightError" />
<param name="background" value="white" />
<param name="InitParams" value="username=<?php echo $_GET["UserName"]; ?>,phototext=<?php echo $_GET["tel"]; ?>,faceidtext=<?php echo $_GET["mobile"]; ?>" />
<param name="minRuntimeVersion" value="4.0.50826.0" />
<param name="autoUpgrade" value="true" />
<a href="http://go.microsoft.com/fwlink/?LinkID=149156&v=4.0.50826.0" style="text-decoration:none">
<img src="http://go.microsoft.com/fwlink/?LinkId=161376" alt="获取 Microsoft Silverlight" style="border-style:none"/>
</a>
</object><iframe id="_sl_historyFrame" style="visibility:hidden;height:0px;width:0px;border:0px"></iframe></div>
</form>
</body></html>我要用index.php引用userheader.php得到UserName
<?php require_once(dirname(__FILE__).'/../../ants/userheader.php') ?>
用了这句话就合并了
翻译下:
然后照这样在给我写2个查询
1个是查询uname 1个是查询 face
翻译下:
然后照这样在给我写2个查询
1个是查询uname 1个是查询 face
如果#@__member_pms这个表里有uname和 face字段就SELECT* FROM #@__member_pms,
--如果只是查询这2个字段 直接查询全部SELECT uname,face FROM #@__member_pms看看数据库知识吧
http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html
$pms = $dsql->GetOne("SELECT * FROM #@__member_pms WHERE toid='{$cfg_ml->M_ID}' AND `hasview`=0 AND folder = 'inbox'");//接下来就看你的了
$pmsUid =$dsql->GetOne("SELECT face FROM #@__member WHERE mid='{$cfg_ml->M_ID}'");GetOne返回式1个结果集 直接$pmsUid[userid]
OK le
$userid = $pmsUid[userid];
$face = $pmsUid[face];