我解析xml后出来的网页不是xml的格式 而是只有那一行我要得到的数据 这怎么回事?。。
以下是我写的 请问下哪里有问题? 谢谢了!<?php
$conn=mysql_connect("localhost","root","096751");
mysql_select_db("user");
mysql_query("set names 'gb2312'");
$username=$_POST["_username"];
$userpass=$_POST["_password"];
$pass=mysql_query("select userpass from member where username='$username'");
while($row=mysql_fetch_array($pass,MYSQL_ASSOC))
{
if($userpass!=$row['userpass'])
{
mysql_query("update member set flag='0'");
}
else if($username==NULL)
{
mysql_query("update member set flag='0'");
}
else
{
mysql_query("update member set flag='1'");
}
}
$temp=mysql_query("select id as total from member where username='".$username."'");
$res=mysql_fetch_array($temp);
$count=$res['total'];
$result=mysql_query("select * from member where username='".$username."'");
echo "<?xml version='1.0' encoding='gb2312'?><数据 总记录='".$count."'>";
while($row=mysql_fetch_object($result))
{
echo "<分类 id='".$row->id."' flag='".$row->flag."' person='".$row->person."'/>";
}
echo "</数据>";
mysql_close();
?>
以下是我写的 请问下哪里有问题? 谢谢了!<?php
$conn=mysql_connect("localhost","root","096751");
mysql_select_db("user");
mysql_query("set names 'gb2312'");
$username=$_POST["_username"];
$userpass=$_POST["_password"];
$pass=mysql_query("select userpass from member where username='$username'");
while($row=mysql_fetch_array($pass,MYSQL_ASSOC))
{
if($userpass!=$row['userpass'])
{
mysql_query("update member set flag='0'");
}
else if($username==NULL)
{
mysql_query("update member set flag='0'");
}
else
{
mysql_query("update member set flag='1'");
}
}
$temp=mysql_query("select id as total from member where username='".$username."'");
$res=mysql_fetch_array($temp);
$count=$res['total'];
$result=mysql_query("select * from member where username='".$username."'");
echo "<?xml version='1.0' encoding='gb2312'?><数据 总记录='".$count."'>";
while($row=mysql_fetch_object($result))
{
echo "<分类 id='".$row->id."' flag='".$row->flag."' person='".$row->person."'/>";
}
echo "</数据>";
mysql_close();
?>
应该是:
$temp=mysql_query("select count(id) as total from member where username='".$username."'");试试看
$count = mysql_num_rows($result);
if($count) {
echo "<?xml version='1.0' encoding='gb2312'?><数据 总记录='$count'>";
while($row = mysql_fetch_object($result))
{
echo "<分类 id='{$row->id}' flag='{$row->flag}' person='{$row->person}'/>";
}
echo "</数据>";
}