Question

asp代码改成PHP的！

<%
Response.ContentType="text/xml"
search=Trim(request("search"))
sql="select top 10 [compCode] from zongdan where [compCode] like '"&search&"%' order by [ytime]"
rs.open sql,conn,1,1
str="<?xml version=""1.0"" encoding=""gb2312""?>"&vbnewline
str=str&"<root>"&vbnewline
If rs.eof Then
Else
i=1
Do While Not rs.eof
str=str&"<message id="""&i&""">"&vbnewline
str=str&" <text>"&rs("compCode")&"</text>"&vbnewline
str=str&"</message>"&vbnewline
i=i+1
rs.movenext
loop
End If
str=str&"</root>"
rs.close
response.write str
%>
把上面的ASP代码，改成PHP的！谢谢！

Answer 1

<?php
header('Content-type:text/xml');
$search = trim($_REQUEST['search']);
$sql = "select compCode from zongdan where compCode like '".$search."%' order by ytime limit 0,10";
$rs = mssql_query($sql);
$str = "<?xml version=\"1.0\" encoding=\"gb2312\"?>\r\n";
$str .= "<root>\r\n";
if(mssql_num_rows($rs) > 0){
$i = 1;
while($data = mssql_fetch_array($rs)){
$str .= "<message id=\"".$i."\">\r\n";
$str .= " <text>".$data['compCode']."</text>\r\n";
$str .= "</message>\r\n";
$i++;
}
}
$str .= "</root>";
mssql_free_result($rs);
mssql_close();
echo $str;
?>

我估计你用mssql，mssql连接数据库部分自已写。

Answer 2

<?php
header("Content-type: text/html");
$search = trim($_REQUEST['search']);
$sql = "select [compCode] from zongdan where [compCode] like '$search%' order by [ytime] limit 0,10";
$obj = new compService(); //数据库操作类。自己写
$arrs = $obj->getComp($sql);
$str="<?xml version=""1.0"" encoding=""gb2312""?>"&vbnewline;
$str=$str&"<root>"&vbnewline;
$i=0;
foreach($arrs as $a){
$str=$str&"<message id=$i>"&vbnewline ;
$str=$str&" <text>"&$rs("compCode")&"</text>"&vbnewline;
$str=$str&"</message>"&vbnewline;
}
echo $str;

Answer 3

太深奥