添加代码执行后效果,输出5条信息
1.xxxxxxxxxxxxxxxxxxx
2.xxxxxxxxxxxxxxxxxxx
3.xxxxxxxxxxxxxxxxxxx
4.xxxxxxxxxxxxxxxxxxx
5.xxxxxxxxxxxxxxxxxxx
就可以了,在线等,成功后给分。function query_guides_SQLServer(){
$dbbase='test';
$uid='sa';
$pwd='12';
$connectionInfo=array("Database"=>$dbbase,"UID"=>$uid,"PWD"=>$pwd);
$serverName="(local)";
if(!($conn=sqlsrv_connect($serverName,$connectionInfo))){
echo "Connection could not be established. ";
die(print_r(sqlsrv_errors(),true));
}
$tSQL=" SELECT * FROM posts ";
if(!($stmt=sqlsrv_query($conn,$tSQL))){
echo "Error in statement. ";
die(print_r(sqlsrv_errors(),true));
}
if(!(sqlsrv_fetch($stmt))){
echo "Error in retrieving row. ";
die(print_r(sqlsrv_errors(),true));
} sqlsrv_close($conn);
}
直接在方法里面写或者另写方法调用都行,效率可以不考虑。
谢谢了
1.xxxxxxxxxxxxxxxxxxx
2.xxxxxxxxxxxxxxxxxxx
3.xxxxxxxxxxxxxxxxxxx
4.xxxxxxxxxxxxxxxxxxx
5.xxxxxxxxxxxxxxxxxxx
就可以了,在线等,成功后给分。function query_guides_SQLServer(){
$dbbase='test';
$uid='sa';
$pwd='12';
$connectionInfo=array("Database"=>$dbbase,"UID"=>$uid,"PWD"=>$pwd);
$serverName="(local)";
if(!($conn=sqlsrv_connect($serverName,$connectionInfo))){
echo "Connection could not be established. ";
die(print_r(sqlsrv_errors(),true));
}
$tSQL=" SELECT * FROM posts ";
if(!($stmt=sqlsrv_query($conn,$tSQL))){
echo "Error in statement. ";
die(print_r(sqlsrv_errors(),true));
}
if(!(sqlsrv_fetch($stmt))){
echo "Error in retrieving row. ";
die(print_r(sqlsrv_errors(),true));
} sqlsrv_close($conn);
}
直接在方法里面写或者另写方法调用都行,效率可以不考虑。
谢谢了
$rs = sqlsrv_fetch($stmt);//或者还有个sqlsrv_fetchAll();
print_r($rs);
// if(!(sqlsrv_fetch($stmt))){
// echo "Error in retrieving row. ";
// die(print_r(sqlsrv_errors(),true));
// }
sqlsrv_close($conn);
$dbbase='test';
$uid='sa';
$pwd='12';
$conn=mysql_connect('localhost',$uid,$pwd) or die('Connection could not be established. ');
mysql_select_db($dbbase,$conn);
$tSQL="SELECT * FROM posts";
$rs=mysql_query($tSQL);
while($row=mysql_fetch_row($rs)){
print_r($row);
}
mysql_close($conn);
}
用不着吧。最简单的。for($i=0;$i<5;$i++){
$j=$i++;
echo $j."."."xxxxxxxxxxxxxxxxxxx "."<br>";
}
<ul class="related_post">
<li><a href="http://localhost/wordpress/?p=11" title="eee">eee</a></li>
<li><a href="http://localhost/wordpress/?p=28" title="nnn">nnn</a></li>
<li><a href="http://localhost/wordpress/?p=3" title="aaaaa">aaaaa</a></li>
<li><a href="http://localhost/wordpress/?p=22" title="jjj">jjj</a></li>
<li><a href="http://localhost/wordpress/?p=17" title="hhh">hhh</a></li>
</ul>因为是改wordpress要在single页里面加入和related Posts差不多的数据,显示效果是一样的
但是因为是查询sql2005 里面的数据,没有办法用插件,所以在网上找了代码只能到这种程度了,
希望直接调用方法就能显示出这样的效果,URL可以暂时不用考虑。
改完就给分,对不起了,刚才没有说清楚。
function query_guides_SQLServer(){
$dbbase='test';
$uid='sa';
$pwd='12';
$conn=mysql_connect('localhost',$uid,$pwd) or die('Connection could not be established. ');
mysql_select_db($dbbase,$conn);
$tSQL="SELECT * FROM posts";
$rs=mysql_query($tSQL);
while($row=mysql_fetch_row($rs)){
$data[] = $row;
}
mysql_close($conn);
return $data;
}
echo '<h3>related Posts</h3><ul class="related_post">';
$rs = query_guides_SQLServer();
foreach($rs as $row){
echo "<li><a href='url' title='eee'>".$row."</a></li>";
}
echo "</ul>";
?>
echo " <li> <a href='url' title='eee'>".$row." </a> </li>";
}
这显示的是
Array
Array
想要是输出posts表里面的title字段
还希望各位兄弟帮忙吧!!
兄弟我在这里谢谢了!!
最好能把所有字段都显示出来,谢谢!
echo " <li> <a href='url' title='eee'>".$row['title']." </a> </li>";
这行SQL2005应该怎么写
上面的写法是错误的!
$dbbase='test';
$uid='sa';
$pwd='12';
$conn=mysql_connect('localhost',$uid,$pwd) or die('Connection could not be established. ');
mysql_select_db($dbbase,$conn);
return $conn;
}
$con=query_guides_SQLServer();
$tSQL="SELECT * FROM posts";
$rs=mysql_query($tSQL,$conn);
echo ' <h3>related Posts </h3> <ul class="related_post">';
while($rw=mysql_fetch_row($rs))
echo ' <li> <a href="url" title="'.$rw[1].'">'.$rw[2].' </a> </li>';
}
echo " </ul>";
mssql_select_db('test',$con);
$tSQL="SELECT * FROM posts";
$rs=mssql_query($tSQL,$con);
echo ' <h3>related Posts </h3> <ul class="related_post">';
while($rw=mssql_fetch_row($rs)){
echo ' <li> <a href="url" title="'.$rw[1].'">'.$rw[2].' </a> </li>';
}
echo " </ul>";
function query_guides_SQLServer(){
$dbbase='test';
$uid='sa';
$pwd='12';
$connectionInfo=array("Database"=>$dbbase,"UID"=>$uid,"PWD"=>$pwd);
$serverName="(local)";
if(!($conn=sqlsrv_connect($serverName,$connectionInfo))){
echo "Connection could not be established. ";
die(print_r(sqlsrv_errors(),true));
}
$tSQL=" SELECT * FROM posts ";
//$rs=sqlsrv_query($conn,$tSQL);
if(!($rs=sqlsrv_query($conn,$tSQL))){
echo "Error in statement. ";
die(print_r(sqlsrv_errors(),true));
}
while($row=sqlsrv_fetch_array($rs,SQLSRV_FETCH_ASSOC)){
$data[] = $row;
}
sqlsrv_close($conn);
return $data;
} echo ' <h3>related Guides </h3> <ul class="related_post">';
$rs = query_guides_SQLServer();
foreach($rs as $row){
echo " <li> <a href='url' title='".$row['id']."'>".$row['title']." </a> </li>";
}
echo " </ul>";
?>
正确代码
谢了兄弟,没你帮忙弄不出来啦,弄的我很迷茫。