Php while array row

Php while row fetch array code example

Probably you losing connection to first query after use second query. Solution 1: $row is not populated until you go through the loop the second time.

Replace while ($row=mysql_fetch_array($res)) loop with for loop

I wouldn’t do it that way. I would do something like this:

$first=true; while ($row=mysql_fetch_array($res)) < if ($first) < //Extra formatting or whatever you need to do can go here >//Other code goes here $first=false; > 

Every time you run mysql_fetch_array it fetches the next row anyway, so you could just run it once outside your loop, and then have the loop go through the remaining rows.

What’s not happening is a mysql_data_seek , which would cause it to restart at the top, but you’re not doing that!

$row = mysql_fetch_array($res); # process first row here while ($row = mysql_fetch_array($res))

for ($i = 1; $row = mysql_fetch_row($result); $i++)

of course it is literal, but totally useless answer.
To show data on your website, you should use a template.
So, you have to get your data into array first anyway

Php — replace while ($row=mysql_fetch_array($res)) loop, mysql_fetch_array fetches one row (or returns false) every time you run it. If you run it outside a loop, it just fetches the next row from the set. The first time, that means it fetches the first row. So if you run it outside the loop at the beginning, it’s fetching the first row. –

Iterating through an array in PHP while loop

Per the docs for sqlsrv_get_field , «Fields must be accessed in order. i.e. If you access field index 1, then field index 0 will not be available.» You may not be able to mix and match this type of access with the array-style access you are using in the previous line. At minimum this access would need to be the first thing you do.

Php — mysql_fetch_array while loop. How does it work?, mysql_fetch_array () is a function that you must call if you want to get a row from the resulted executed query, so you can describe it «mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both». The Scenario is this : It returns an array that corresponds to the …

Fetch Two Arrays in 1 while loop (not working)

Assuming both queries are OK I offer two ways to loop through them depending on your needs. Hopefully one of them will help.

 while($row = mysql_fetch_array($query2)) <$arrayRowB[] = $row;>// Loop through two arrays in a square way (every combination of both arrays) foreach($arrayRowA as $keyA => $objectA) < foreach($arrayRowB as $keyB =>$objectB)< $leaveID = $objectA['leaveID']; $personID = $objectB['personID']; $Person_Type = $objectB['Person_Type']; if($Person_Type == 'Regular') < $Sick_Remaining_Days = 10 - $Sick_Total_Days; >else < $Sick_Remaining_Days = 5 - $Sick_Total_Days; >echo ""; echo ($leaveID == $personID) ? "$Sick_Remaining_Days" : "--"; echo ""; > > // Loop through two arrays in a linear way (one to one) foreach($arrayRowA as $keyA => $objectA)< if(isset($arrayRowB[$keyA]))< $objectB = $arrayRowB[$keyA]; $leaveID = $objectA['leaveID']; $personID = $objectB['personID']; $Person_Type = $objectB['Person_Type']; if($Person_Type == 'Regular') < $Sick_Remaining_Days = 10 - $Sick_Total_Days; >else < $Sick_Remaining_Days = 5 - $Sick_Total_Days; >echo ""; echo ($leaveID == $personID) ? "$Sick_Remaining_Days" : "--"; echo ""; > > ?> 

$query = mysql_query("select p*, l* from person as p left join leave as l on p.personID = l.leaveID"); while(($row = mysql_fetch_array($query))) < $Person_Type = $row['Person_Type']; if ($Person_Type == 'Regular') < $Sick_Remaining_Days = 10 - $Sick_Total_Days; >else < $Sick_Remaining_Days = 5 - $Sick_Total_Days; >echo ""; echo "$Sick_Remaining_Days"; echo ""; > 

You should get array before while:

array f,s while(first) < f = . ; >while(second)

Or try use new http://php.net/manual/en/mysqli-result.fetch-array.php. Probably you losing connection to first query after use second query.

PHP mysqli fetch_array() Function, Definition and Usage. The fetch_array () / mysqli_fetch_array () function fetches a result row as an associative array, a numeric array, or both. Note: Fieldnames returned from this function are case-sensitive.

PHP While loop adding blank row to repeating region

$row is not populated until you go through the loop the second time.

do< . >while($row = mysql_fetch_array($sql2)) 

while($row = mysql_fetch_array($sql2))

The problem is that with a do-while the expression in the while-clause is not executed in the first run. The consequence of this is that the $row array is not set and will thus not contain any values to print.

The code should be modified to this:

while($row = mysql_fetch_array($sql2))

Here’s an example to illustrate how do-while works:

Whereas a standard while loop would output:

Php pdo while fetch Code Example, prepare(«SELECT name, colour FROM fruit»); $sth->execute(); /* Exercise PDOStatement::fetch styles */ print(«PDO::FETCH_ASSOC: «); print(«Return

Источник

6 ways to loop through an array in php

Today, we will learn how to loop through an array in PHP using while ****loop, for loop, & various PHP Array functions.

PHP is one of the easiest language and traversing through an array in php is very easy. Infact, most popular way to access items in array in php is using loops : while, for & do..while

1. While loop

The while loop is very common loop among all languages and PHP is not different. In fact, while loop is one of the most popular method to iterate over PHP array.

while(expression) // Code to be executed >

It means that, while the given expression (or condition) is true, execute the code inside the curly brackets, and check the expression again. Keep doing it, until expression becomes false.

How to Iterate over PHP array using while loop

The PHP arrays have elements which can be accessed via its index position, right?

So, we can use the while loop to change the index position incrementally or decrementally therefore accessing every element (or selective elements as per the condition).

Here, we will create an index position variable and start with 0th position which is first in an array.

The condition will be to continue fetching element from an array til our index values is less than the count of array (or length of the given array).

Since, while loop will not increment our index variable automatically, we need to increment it inside the loop. Therefore, with each iteration, variable will move to next index position.

 $users = ['john', 'dave', 'tim']; $i = 0; while($i  count($users))  echo $users[$i]."\n"; $i++; > ?>

2. do while Loop

Well, personally it’s my least favorite loop in every programming language, so I’d probably say less.

The do while is another type of loop in php (and mostly all programming languages . except some functional languages .. Yes, I am looking at you Smalltalk )

It is mostly similar to while loop, except the ordering is reverse.

• In while loop, condition or expression is checked first & if true, then the code inside the loop gets executed
• In do while loop, code inside the loop gets executed first & then the condition is checked. If condition is true, then it will execute the code again and so on.

do  // Code to be executed > while(expression);

It means that, while the given expression (or condition) is true, execute the code inside the curly brackets, and check the expression again. Keep doing it, until expression becomes false.

Note: Don’t miss the semicolon at the end. I always forget that.

Without further ado, let’s recrete previous example using do while loop

How to loop through php array using do while loop

We will iterate over an array of users using do while loop.

 $users = ['john', 'dave', 'tim']; $i = 0; do  echo $users[$i]."\n"; $i++; > while($i  count($users)); ?>

3. For Loop

Let’s talk about the MOST popular loop. The for loop.

The for loop is my most favorite general loop (next one I use often for this particular usecase) for any general iterative usecase. It does the exactly same as while loop but it has different, more compact syntax.

for (expr1; expr2; expr3)  //Code to be executed > 

It looks very complex at first, but when you get bit experience, believe me, you will prefer this most of the time.

It has placeholder for three expressions (each are optional, so you can still use this loop just like while)

• Expr1 — It gets executed once at the beginning of the loop, so normally it is used to initialize any counters to be used.
• Expr2 — This is the condition part. At the beginning of each iteration, this expression gets evaluated and if true then only it will continue.
• Expr3 — It gets execute at the end of the iteration. Normally used to increment/decrement our counters.

Let’s recreate our example using for loop.

How to loop through array using for loop in PHP

As shown below, it is exactly same as while loop, except it’s condensed and better syntax. Also, for one line statements, you can omit curly brackets 😉

 $users = ['john', 'dave', 'tim']; for($i = 0;$i  count($users);$i++) echo $users[$i]."\n"; ?> 

4. Foreach Loop

Talking about condensed syntax, let’s talk about another great and special loop — Foreach loop.

This loop is only helpful when you want to iterate over each item. If for example — you want to access only even position items, then sadly this loop is not for you, you need to use above loops.

But, for the particular use of accessing each item (see the pun?), foreach is my favorite and infact would be everyone’s favorite. It is very simply and easy to use.

//without key foreach (iterable_expression as $value) statement //with key foreach (iterable_expression as $key => $value) statement

Let’s checkout the example:

How to loop over array using foreach loop in PHP

Let’s recreate our example. We won’t need the keys (position) therefore we will use foreach without keys.

 $users = ['john', 'dave', 'tim']; foreach($users as $user) echo $user."\n"; ?>

5. array_walk

The array_walk is an array function provided by PHP which applies the given function to each element in the array, hence the name «array_walk».

array_walk(array|object &$array, callable $callback, mixed $arg = null): bool

• array — It is the input array to iterate over.
• callback — It is a function passed to this function which will act on each item one by one. This function takes two parameters — 1. Item value 2. Index position of the item
• args — It is the optional arguments which if supplied, will be passed as third parameter to callback function.

It returns true when executed successfully.

Let’s recreate our example:

 $users = ['john', 'dave', 'tim']; function print_item($item, $key)  echo $item."\n"; > array_walk($users, 'print_item'); ?>

6. Array Iterator

This is quite advanced and complex way to iterate over an array. Honestly, I don’t see the reason why you would need to use this over other methods, but for the purpose of fun & learning, let’s explore this.

Here, we will create ArrayIterator object using ArrayObject function and use it to iterate over an array. It is based on pointer mechanism just like C++.

 $users = ['john', 'dave', 'tim']; $array_object = new ArrayObject($users); $array_iterator = $array_object->getIterator(); while( $array_iterator->valid() )  echo $array_iterator->current() . "\n"; $array_iterator->next(); > ?>

Conclusion

We saw 6 ways to loop over an array in PHP so far. Personally, I like to use foreach because it is very simple but you can use any of the above method. Hope, this helped.

Источник

Использование циклов в PHP

PHP имеет четыре вида циклов и операторы управления ими, рассмотрим поподробнее.

Foreach – перебор массива

Предназначен для перебора элементов массива.

$array = array( 1 => 'Значение 1', 2 => 'Значение 2', 3 => 'Значение 3', 4 => 'Значение 4', ); // Вывод ключей foreach ($array as $key => $val) < echo $key . '
'; > // Вывод значений foreach ($array as $key => $val) < echo $val . '
'; > 

Результат:

1 2 3 4 Значение 1 Значение 2 Значение 3 Значение 4

Альтернативный синтаксис foreach

For – цикл с счетчиком

Цикл работает пока выполняется заданное условие. Обычно применяется в качестве счетчика.

// Счетчик от 0 до 5 for ($n = 0; $n // Счетчик от 5 до 0 for ($n = 5; $n >= 0; $n--)

Результат:

Альтернативный синтаксис

$array = array( 'Значение 1', 'Значение 2', 'Значение 3', 'Значение 4', ); for ($n = 0; $n < count($array); $n++) < echo $array[$n] . '
'; >

Результат:

Значение 1 Значение 2 Значение 3 Значение 4

Альтернативный синтаксис for

While – цикл с предусловием

Т.е. если перед началом итерации условие выполняется, то цикл продолжает свою работу.

Результат:

Альтернативный синтаксис while

Do-while – цикл с постусловием

В отличии от while этот цикл проверяет выполнения условия после каждой итерации. Do-while не имеет альтернативного синтаксиса.

Результат:

Управление циклами

Break

Вызов break или break 1 в цикле останавливает его.

Для вложенных циклов используется break 2 и т.д.

Continue

Используется для пропуска итерации.

Результат:

Для вложенных циклов по аналогии с break 2 , break 3 – continue 2 , continue 3 .

Источник