search
HomeBackend DevelopmentPHP Tutorial为什么用WHILE不能遍历输出表

一个很普通查询输出函数现在表中有10条数据调用的时候因为要把结果转成XML所以不能在函数体里做echo但是这样调用只能输出最后一条记录,求能在调用页面输出整表内容的方法调用echo main_shopactive();函数体function main_shopactive(){	//商场活动查询,返回逆向排序的最后一条活动记录	$conn = mysql_connect_conn();	$sql = "SELECT * FROM wx_active order by id desc limit 0,30";	$rs = mysql_db($sql,$conn) or die('查询记录失败!'); 	if(mysql_num_rows($rs) > 0)	{		while($row = mysql_fetch_assoc($rs))		{			$my_active = $row['concent'];		}	}	else	{		$my_active = 'NO ACTIVE';	}	return $my_active;}


回复讨论(解决方案)

while($row = mysql_fetch_assoc($rs))
        {
            $my_active[] = $row['concent'];
        }

楼上正解,。。

返回值是数组,调用呢?

调用怎么一次性读出所有表内值?

foreach(main_shopactive() as $v) echo $v.'
';

你可以 
$my_active .= $row['concent'];
return $my_active;

也可以
$my_active[] = $row['concent'];
return join('', $my_active);

版主大人你的第一种方法和我原代码有什么区别呢?

区别在于多了一个点
不要小看这一点,有了它就有了质的变化

版主老大很奇怪的现象啊。dior 资生堂 这是两个品名后面应该分别有楼层地点分类,现在全都连接到一起了
结果应该是这样的:'?dior一楼化妆品0412-8999960资生堂一楼化妆品0412-89999961'
现在却是这样:'dior资生堂一楼一楼0412-89999600412-89999961化妆品化妆品'
什么原因啊?字段排列顺序完全不对呢。

调用页面

$floor_find = new floor_product_lookfor();echo ($floor_find->floor_product('一楼'));


原来类和函数class floor_product_lookfor{	function floor_product($floor_nunmer)	{		$conn = mysql_connect_conn();		$sql = "SELECT * FROM wx_floor where goods_floor ='$floor_nunmer' order by goods_id desc";		$rs = mysql_db($sql,$conn) or die('查询记录失败!'); 		if(mysql_num_rows($rs) > 0)		{			while($row = mysql_fetch_assoc($rs))			{				$floor .= $row['goods_name'];				$name .= $row['goods_floor'];				$tel .= $row['goods_tel'];				$type .= $row['goods_type'];						}		}		else		{			$floor = 'NO GOODS INFORMATION';		}		return ($floor.$name.$tel.$type);	}	}

是不是因为有2个以上的字段就不能用 . 连接

没有什么可奇怪的
既然你简化了你的代码(没有给出记录间的分隔符)那当然是混在一起的
至少你需要给出你期望的数据格式

其实产生 xml 节点数据是可以在 sql 指令中直接完成的

其实也不算是简化了,只是我以为这个方法可以通用就套进其他的函数里了。因为是微信只能用他固定的接口和代码了~
这样的效果就是我所期望的,麻烦版主大人了
?

dior一楼化妆品0412-8999960资生堂一楼化妆品0412-89999961

while($row = mysql_fetch_assoc($rs))
{
  $value .= $row['goods_name'] . $row['goods_floor'] . $row['goods_tel'] . $type .= $row['goods_type'];            
}
return $value;

 谢谢!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
11 Best PHP URL Shortener Scripts (Free and Premium)11 Best PHP URL Shortener Scripts (Free and Premium)Mar 03, 2025 am 10:49 AM

Long URLs, often cluttered with keywords and tracking parameters, can deter visitors. A URL shortening script offers a solution, creating concise links ideal for social media and other platforms. These scripts are valuable for individual websites a

Working with Flash Session Data in LaravelWorking with Flash Session Data in LaravelMar 12, 2025 pm 05:08 PM

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

Build a React App With a Laravel Back End: Part 2, ReactBuild a React App With a Laravel Back End: Part 2, ReactMar 04, 2025 am 09:33 AM

This is the second and final part of the series on building a React application with a Laravel back-end. In the first part of the series, we created a RESTful API using Laravel for a basic product-listing application. In this tutorial, we will be dev

Simplified HTTP Response Mocking in Laravel TestsSimplified HTTP Response Mocking in Laravel TestsMar 12, 2025 pm 05:09 PM

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

cURL in PHP: How to Use the PHP cURL Extension in REST APIscURL in PHP: How to Use the PHP cURL Extension in REST APIsMar 14, 2025 am 11:42 AM

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

12 Best PHP Chat Scripts on CodeCanyon12 Best PHP Chat Scripts on CodeCanyonMar 13, 2025 pm 12:08 PM

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

Announcement of 2025 PHP Situation SurveyAnnouncement of 2025 PHP Situation SurveyMar 03, 2025 pm 04:20 PM

The 2025 PHP Landscape Survey investigates current PHP development trends. It explores framework usage, deployment methods, and challenges, aiming to provide insights for developers and businesses. The survey anticipates growth in modern PHP versio

Notifications in LaravelNotifications in LaravelMar 04, 2025 am 09:22 AM

In this article, we're going to explore the notification system in the Laravel web framework. The notification system in Laravel allows you to send notifications to users over different channels. Today, we'll discuss how you can send notifications ov

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)