求助:PHP调用数据库数据输出结果总重复一次。
表里有两条内容:
1111111111111111111111111
2222222222222222222222222
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->
<?php
//设置数据库变量
$db_host = 'localhost';
$db_user = 'root';
$db_passw = '123456';
$db_name = 'freebb';
$conn = mysql_connect($db_host,$db_user,$db_passw) or die ('数据库连接失败!');
mysql_query("set names 'utf8'");
mysql_select_db($db_name,$conn) or die('数据库选定失败!');
$sql = "SELECT * FROM `member` ORDER BY `id` DESC LIMIT 0, 16";
$result = mysql_query($sql) or die('数据库查询失败!');
while($mem = mysql_fetch_object($result)) //循环开始
{
$username = $mem->username;
$bbsname = $mem->bbsname;
$bbstype = $mem->bbstype;
?>
<li>
<div class="title"><a href="http://<?php echo $username; ?>.lingd.cn/" target="_blank"><?php echo $bbsname; ?></a></div>
<div class="type">[<?php echo $bbstype; ?>]</div>
</li>
<?php
}
?>
PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号