在遍历结果集中判断两次循环的值是不是都为0

在遍历结果集中判断两次循环的值是否都为0
就是说   A表有10条数据，字段为phone，select之后   用while遍历，在while里面进行判断，$i的phone值与$i+1的phone值如果都等于0，那么进行相关操作。  这个循环该怎么写

代码已经写到这：

<br />
$i=0;<br />
while ($row = $db->fetch_array($result)){<br />
	$i++;<br />
	}<br />

分享到：

------解决方案--------------------

$last = array();<br />
while ($row = $db->fetch_array($result)){<br />
  if($last && $row['phone'] == 0 && $last['phone'] == 0) {<br />
    //处理代码<br />
  }<br />
  $last = $row;<br />
}

也可以直接查询

<br />
set @last:='';<br />
select @last as last, phone, @last:=phone from tbl_name

直接对比或读出后处理
------解决方案--------------------

引用:

Quote: 引用:

增加一个计数器，判断这个计数器的连续性，是则执行，否则重置

不然就把结果转数组，用foreach对下标操作

计数器的话该怎么操作，本人菜鸟，万分感谢。

和#4的思路类似，但老徐直接用了缓存数据，比用计数器更简洁了（计数器是缓存下标$i），所以我就不献丑了

Related labels：

array nbsp phone while

source：php.cn

Previous article： php 装配参数 Next article： 操蛋，修复BUG，请教如何修复这个bug

Statement of this Website

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

Latest Articles by Author

• What is a NullPointerException, and how do I fix it?
  2024-10-22 09:46:29
• From Novice to Coder: Your Journey Begins with C Fundamentals
  2024-10-13 13:53:41
• Unlocking Web Development with PHP: A Beginner's Guide
  2024-10-12 12:15:51
• Demystifying C: A Clear and Simple Path for New Programmers
  2024-10-11 22:47:31
• Unlock Your Coding Potential: C Programming for Absolute Beginners
  2024-10-11 19:36:51
• Unleash Your Inner Programmer: C for Absolute Beginners
  2024-10-11 15:50:41
• Automate Your Life with C: Scripts and Tools for Beginners
  2024-10-11 15:07:41
• PHP Made Easy: Your First Steps in Web Development
  2024-10-11 14:21:21
• Build Anything with Python: A Beginner's Guide to Unleashing Your Creativity
  2024-10-11 12:59:11
• The Key to Coding: Unlocking the Power of Python for Beginners
  2024-10-11 12:17:31

Latest Issues

function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...

From 2024-04-29 11:01:01

0

2

1429

There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...

From 2024-04-18 23:52:34

0

1

1284

PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...

From 2024-04-16 09:34:16

0

0

4687

Related Topics

More>

• Usage of while
• The difference between php and js
• Ethereum browser blockchain query
• Check the occupied port status in windows
• How to solve the problem that js code cannot run after formatting
• How to use python for loop
• Check out the top ten cryptocurrencies worth investing in
• Digital currency quantitative trading

Popular Recommendations

• How to set up hosts on Mac computer (steps with pictures and text)
• Quickly build a simple QQ robot with PHP
• API common signature verification methods (PHP implementation)
• Collection of common date and time operations in PHP
• PHP generates graphic verification code (enhanced interference type)

Popular Tutorials

More>

Related Tutorials

Popular Recommendations

Latest courses

• 
  The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)

  1424252
• 
  PHP introductory tutorial one: Learn PHP in one week

  4270527
• 
  JAVA Beginner's Video Tutorial

  2547793
• 
  Little Turtle's zero-based introduction to learning Python video tutorial

  507804
• 
  PHP zero-based introductory tutorial

  863557

• 
  The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)

  1424252 times of learning
• 
  JAVA Beginner's Video Tutorial

  2547793 times of learning
• 
  Little Turtle's zero-based introduction to learning Python video tutorial

  507804 times of learning
• 
  Quick introduction to web front-end development

  215935 times of learning
• 
  Master PS video tutorials from scratch

  892088 times of learning

• 
  [Web front-end] Node.js quick start

  7636 times of learning
• 
  Complete collection of foreign web development full-stack courses

  6115 times of learning
• 
  Go language practical GraphQL

  5061 times of learning
• 
  550W fan master learns JavaScript from scratch step by step

  706 times of learning
• 
  Python master Mosh, a beginner with zero basic knowledge can get started in 6 hours

  25621 times of learning

Latest Downloads

More>

Web Effects

Website Source Code

Website Materials

Front End Template

• [form button] jQuery enterprise message form contact code
• [Player special effects] HTML5 MP3 music box playback effects
• [Menu navigation] HTML5 cool particle animation navigation menu special effects
• [form button] jQuery visual form drag and drop editing code
• [Player special effects] VUE.JS imitation Kugou music player code
• [html5 special effects] Classic html5 pushing box game
• [Picture special effects] jQuery scrolling to add or reduce image effects
• [Photo album effects] CSS3 personal album cover hover zoom effect

• [Front-end template] Home Decor Cleaning and Repair Service Company Website Template
• [Front-end template] Fresh color personal resume guide page template
• [Front-end template] Designer Creative Job Resume Web Template
• [Front-end template] Modern engineering construction company website template
• [Front-end template] Responsive HTML5 template for educational service institutions
• [Front-end template] Online e-book store mall website template
• [Front-end template] IT technology solves Internet company website template
• [Front-end template] Purple style foreign exchange trading service website template

• [PNG material] Cute summer elements vector material (EPS PNG)
• [PNG material] Four red 2023 graduation badges vector material (AI EPS PNG)
• [banner picture] Singing bird and cart filled with flowers design spring banner vector material (AI EPS)
• [PNG material] Golden graduation cap vector material (EPS PNG)
• [PNG material] Black and white style mountain icon vector material (EPS PNG)
• [PNG material] Superhero silhouette vector material (EPS PNG) with different color cloaks and different poses
• [banner picture] Flat style Arbor Day banner vector material (AI+EPS)
• [PNG material] Nine comic-style exploding chat bubbles vector material (EPS+PNG)

• [Front-end template] Home Decor Cleaning and Repair Service Company Website Template
• [Front-end template] Fresh color personal resume guide page template
• [Front-end template] Designer Creative Job Resume Web Template
• [Front-end template] Modern engineering construction company website template
• [Front-end template] Responsive HTML5 template for educational service institutions
• [Front-end template] Online e-book store mall website template
• [Front-end template] IT technology solves Internet company website template
• [Front-end template] Purple style foreign exchange trading service website template