search
Homephp教程php手册谈谈关于PHP数组合并技巧

谈谈关于PHP数组合并技巧

Jun 13, 2016 am 11:04 AM
phpuseaboutmergeexistusSkillarrayarticleofmeetquestion

我们在使用PHP数组的时候可能遇到PHP数组合并的问题,文章这里介绍了PHP数组合并、PHP数组的排序。PHP数组排序实际上就是将PHP数组进行排序。在1995年 中,PHP2.0发布了。第二版定名为PHP/FI(Form Interpreter)。PHP/FI加入了对mSQL的支持,从此建立了PHP在动态网页开发上的地位。

到了1996年底,有15000个网站使用 PHP/FI;时间到了1997年中,使用PHP/FI的网站数字超过五万个。而在1997年中,开始了第三版的开发计划,开发小组加入了 Zeev Suraski 及 Andi Gutmans,而第三版就定名为PHP3。2000年,PHP4.0又问世了,其中增加了许多新的特性。在本文中也就是对数据库查询出来的结果集进行排序。数据库查询结果有时候不能直接使用,比如mysql等用in语句出来的结果,因此需要对结果进行某种方式的排序。这时候就需要进行PHP数组排序了。对数据库结果进行排序请看下面的示例:本例中data 数组中的每个单元表示一个表中的一行。这是典型的数据库存放数组数据的方式。例子中的数据如下:
<ol class="dp-xml">
<li class="alt"><span><span>volume | edition  </span></span></li>
<li class=""><span>-------+--------  </span></li>
<li class="alt"><span>67 |       2  </span></li>
<li class=""><span>86 |       1  </span></li>
<li class="alt"><span>85 |       6  </span></li>
<li class=""><span>98 |       2  </span></li>
<li class="alt"><span>86 |       6  </span></li>
<li class=""><span>67 |       7 </span></li>
</ol>

数据全都存放在名为 data 的数组中。这通常是通过循环从数据库取得的结果,例如 mysql_fetch_assoc()(实际上这个函数你可以和mysql_fetch_assoc()函数看成一样,具体的差别你可以看PHP的手册里面关于key的差别)。

<ol class="dp-xml">
<li class="alt"><span><span>$data[] = array('volume' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 67, 'edition' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 2);  </span></span></li>
<li class="">
<span>$data[] = array('volume' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 86, 'edition' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 1);  </span>
</li>
<li class="alt">
<span>$data[] = array('volume' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 85, 'edition' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 6);  </span>
</li>
<li class="">
<span>$data[] = array('volume' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 98, 'edition' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 2);  </span>
</li>
<li class="alt">
<span>$data[] = array('volume' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 86, 'edition' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 6);  </span>
</li>
<li class="">
<span>$data[] = array('volume' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 67, 'edition' =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> 7); </span>
</li>
</ol>

本例中将把 volume 降序排列,把 edition 升序排列。

现在有了包含有行的数组,但是 array_multisort() 需要一个包含列的数组,因此用以下代码来取得列,然后排序。

<ol class="dp-xml">
<li class="alt"><span><span>// 取得列的列表  </span></span></li>
<li class="">
<span>foreach ($data as $</span><span class="attribute"><font color="#ff0000">key</font></span><span> =</span><span class="tag"><strong><font color="#006699">></font></strong></span><span> $row) {  </span>
</li>
<li class="alt"><span>$volume[$key]  = $row['volume'];  </span></li>
<li class=""><span>$edition[$key] = $row['edition'];  </span></li>
<li class="alt"><span>}  </span></li>
<li class=""><span> </span></li>
<li class="alt"><span>// 将数据根据 volume 降序排列,根据 edition 升序排列  </span></li>
<li class=""><span>// 把 $data 作为最后一个参数,以通用键排序  </span></li>
<li class="alt"><span>array_multisort($volume, SORT_DESC, $edition, SORT_ASC, $data);  </span></li>
</ol>

PHP数组合并在排好序了,结果如下:

<ol class="dp-xml">
<li class="alt"><span><span>volume | edition  </span></span></li>
<li class=""><span>-------+--------  </span></li>
<li class="alt"><span>98 |       2  </span></li>
<li class=""><span>86 |       1  </span></li>
<li class="alt"><span>86 |       6  </span></li>
<li class=""><span>85 |       6  </span></li>
<li class="alt"><span>67 |       2  </span></li>
<li class=""><span>67 |       7 </span></li>
</ol>

实际上真正在排序的时候还有很多方法可以使用,比如php的array数组自带的 arsort(),asort(),ksort(),krsort(),natsort(),natcasesort(),rsort(),usort(),array_multisort() 和 uksort()。


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

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

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

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.

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)