Mixing
fetching data and trying to create a loop to determine lowest value
This is going to be a newbie question, so bear with me.
I have a database in which I fetch the data, I would like to create a for loop which will loop through the fetched data and will determine what the lowest time is. This is how my loop looks like: (take into consideration I only took the part out that seemed usefull to post, and $row['timePV'] is a time based value such as: 23:00)
$arrayCount = array();
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
array_push($arrayCount,$row['timePV']);
}
echo "</table>";
}
$c = 100000;
for ($i = 0; $i < sizeof($arrayCount); $i++) {
$arrayCount[$i];
if ($arrayCount[$i] < $c) {
$c = $arrayCount[$i];
echo $c;
} else {
//do something else
}
}
So what I want to achieve: Loop through the stored data and take out the lowest value and display that value, but it only displays all the values.
So my question: How can I make the loop in such way that it will take the lowest value and display it to me?
php
|
show 2 more comments
This is going to be a newbie question, so bear with me.
I have a database in which I fetch the data, I would like to create a for loop which will loop through the fetched data and will determine what the lowest time is. This is how my loop looks like: (take into consideration I only took the part out that seemed usefull to post, and $row['timePV'] is a time based value such as: 23:00)
$arrayCount = array();
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
array_push($arrayCount,$row['timePV']);
}
echo "</table>";
}
$c = 100000;
for ($i = 0; $i < sizeof($arrayCount); $i++) {
$arrayCount[$i];
if ($arrayCount[$i] < $c) {
$c = $arrayCount[$i];
echo $c;
} else {
//do something else
}
}
So what I want to achieve: Loop through the stored data and take out the lowest value and display that value, but it only displays all the values.
So my question: How can I make the loop in such way that it will take the lowest value and display it to me?
php
1
Why don't you just use min?
– cmbuckley
Nov 22 '18 at 11:01
1
“This is going to be a newbie question, so bear with me.” - bearing … still bearing … hm, nothing. Where is the actual question?
– misorude
Nov 22 '18 at 11:02
Or at least do the min check as part of the original while loop. No need to write an array and do 2 loops
– RiggsFolly
Nov 22 '18 at 11:03
I did read something about min, but since i'm quite new to php (not very experienced) I decided to take a route that's a bit more familiar.
– user10579402
Nov 22 '18 at 11:03
If you are looping over the whole data set in a while loop already, and only need the minimum value afterwards - then you don’t need a second loop, you can just determine the minimum directly in that first loop.
– misorude
Nov 22 '18 at 11:03
|
show 2 more comments
This is going to be a newbie question, so bear with me.
I have a database in which I fetch the data, I would like to create a for loop which will loop through the fetched data and will determine what the lowest time is. This is how my loop looks like: (take into consideration I only took the part out that seemed usefull to post, and $row['timePV'] is a time based value such as: 23:00)
$arrayCount = array();
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
array_push($arrayCount,$row['timePV']);
}
echo "</table>";
}
$c = 100000;
for ($i = 0; $i < sizeof($arrayCount); $i++) {
$arrayCount[$i];
if ($arrayCount[$i] < $c) {
$c = $arrayCount[$i];
echo $c;
} else {
//do something else
}
}
So what I want to achieve: Loop through the stored data and take out the lowest value and display that value, but it only displays all the values.
So my question: How can I make the loop in such way that it will take the lowest value and display it to me?
php
This is going to be a newbie question, so bear with me.
I have a database in which I fetch the data, I would like to create a for loop which will loop through the fetched data and will determine what the lowest time is. This is how my loop looks like: (take into consideration I only took the part out that seemed usefull to post, and $row['timePV'] is a time based value such as: 23:00)
$arrayCount = array();
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
array_push($arrayCount,$row['timePV']);
}
echo "</table>";
}
$c = 100000;
for ($i = 0; $i < sizeof($arrayCount); $i++) {
$arrayCount[$i];
if ($arrayCount[$i] < $c) {
$c = $arrayCount[$i];
echo $c;
} else {
//do something else
}
}
So what I want to achieve: Loop through the stored data and take out the lowest value and display that value, but it only displays all the values.
So my question: How can I make the loop in such way that it will take the lowest value and display it to me?
php
php
edited Nov 22 '18 at 11:13
asked Nov 22 '18 at 10:58
user10579402
1
Why don't you just use min?
– cmbuckley
Nov 22 '18 at 11:01
1
“This is going to be a newbie question, so bear with me.” - bearing … still bearing … hm, nothing. Where is the actual question?
– misorude
Nov 22 '18 at 11:02
Or at least do the min check as part of the original while loop. No need to write an array and do 2 loops
– RiggsFolly
Nov 22 '18 at 11:03
I did read something about min, but since i'm quite new to php (not very experienced) I decided to take a route that's a bit more familiar.
– user10579402
Nov 22 '18 at 11:03
If you are looping over the whole data set in a while loop already, and only need the minimum value afterwards - then you don’t need a second loop, you can just determine the minimum directly in that first loop.
– misorude
Nov 22 '18 at 11:03
|
show 2 more comments
1
Why don't you just use min?
– cmbuckley
Nov 22 '18 at 11:01
1
“This is going to be a newbie question, so bear with me.” - bearing … still bearing … hm, nothing. Where is the actual question?
– misorude
Nov 22 '18 at 11:02
Or at least do the min check as part of the original while loop. No need to write an array and do 2 loops
– RiggsFolly
Nov 22 '18 at 11:03
I did read something about min, but since i'm quite new to php (not very experienced) I decided to take a route that's a bit more familiar.
– user10579402
Nov 22 '18 at 11:03
If you are looping over the whole data set in a while loop already, and only need the minimum value afterwards - then you don’t need a second loop, you can just determine the minimum directly in that first loop.
– misorude
Nov 22 '18 at 11:03
1
1
Why don't you just use min?
– cmbuckley
Nov 22 '18 at 11:01
Why don't you just use min?
– cmbuckley
Nov 22 '18 at 11:01
1
1
“This is going to be a newbie question, so bear with me.” - bearing … still bearing … hm, nothing. Where is the actual question?
– misorude
Nov 22 '18 at 11:02
“This is going to be a newbie question, so bear with me.” - bearing … still bearing … hm, nothing. Where is the actual question?
– misorude
Nov 22 '18 at 11:02
Or at least do the min check as part of the original while loop. No need to write an array and do 2 loops
– RiggsFolly
Nov 22 '18 at 11:03
Or at least do the min check as part of the original while loop. No need to write an array and do 2 loops
– RiggsFolly
Nov 22 '18 at 11:03
I did read something about min, but since i'm quite new to php (not very experienced) I decided to take a route that's a bit more familiar.
– user10579402
Nov 22 '18 at 11:03
I did read something about min, but since i'm quite new to php (not very experienced) I decided to take a route that's a bit more familiar.
– user10579402
Nov 22 '18 at 11:03
If you are looping over the whole data set in a while loop already, and only need the minimum value afterwards - then you don’t need a second loop, you can just determine the minimum directly in that first loop.
– misorude
Nov 22 '18 at 11:03
If you are looping over the whole data set in a while loop already, and only need the minimum value afterwards - then you don’t need a second loop, you can just determine the minimum directly in that first loop.
– misorude
Nov 22 '18 at 11:03
|
show 2 more comments
1 Answer
1
active
oldest
votes
You don't have to do another loop to calculate lowesttime. You can do it in that while loop with checking previous and present timePv like following
//$timeExample=[["timePV"=>"11:30"],["timePV"=>"11:20"],["timePV"=>"13:30"]];//example of data
$lowestTime = null;//Deault defined it null
while ($row = mysqli_fetch_assoc($result)) {
//foreach($timeExample as $row){ //foreach for run example
if($lowestTime){
$lowestTime=min($lowestTime,strtotime($row['timePV']));//If not null we also get min lowerstTime from previous //and current one
}else{
$lowestTime=strtotime($row['timePV']);//It will work for only first iteration since $lowestTime will null in //first iteration
}
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
}
echo date("h:i",$lowestTime);//11:20 example out
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
Thanks for the help man! appreciate it !
– user10579402
Nov 22 '18 at 11:50
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53429441%2ffetching-data-and-trying-to-create-a-loop-to-determine-lowest-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You don't have to do another loop to calculate lowesttime. You can do it in that while loop with checking previous and present timePv like following
//$timeExample=[["timePV"=>"11:30"],["timePV"=>"11:20"],["timePV"=>"13:30"]];//example of data
$lowestTime = null;//Deault defined it null
while ($row = mysqli_fetch_assoc($result)) {
//foreach($timeExample as $row){ //foreach for run example
if($lowestTime){
$lowestTime=min($lowestTime,strtotime($row['timePV']));//If not null we also get min lowerstTime from previous //and current one
}else{
$lowestTime=strtotime($row['timePV']);//It will work for only first iteration since $lowestTime will null in //first iteration
}
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
}
echo date("h:i",$lowestTime);//11:20 example out
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
Thanks for the help man! appreciate it !
– user10579402
Nov 22 '18 at 11:50
add a comment |
You don't have to do another loop to calculate lowesttime. You can do it in that while loop with checking previous and present timePv like following
//$timeExample=[["timePV"=>"11:30"],["timePV"=>"11:20"],["timePV"=>"13:30"]];//example of data
$lowestTime = null;//Deault defined it null
while ($row = mysqli_fetch_assoc($result)) {
//foreach($timeExample as $row){ //foreach for run example
if($lowestTime){
$lowestTime=min($lowestTime,strtotime($row['timePV']));//If not null we also get min lowerstTime from previous //and current one
}else{
$lowestTime=strtotime($row['timePV']);//It will work for only first iteration since $lowestTime will null in //first iteration
}
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
}
echo date("h:i",$lowestTime);//11:20 example out
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
Thanks for the help man! appreciate it !
– user10579402
Nov 22 '18 at 11:50
add a comment |
You don't have to do another loop to calculate lowesttime. You can do it in that while loop with checking previous and present timePv like following
//$timeExample=[["timePV"=>"11:30"],["timePV"=>"11:20"],["timePV"=>"13:30"]];//example of data
$lowestTime = null;//Deault defined it null
while ($row = mysqli_fetch_assoc($result)) {
//foreach($timeExample as $row){ //foreach for run example
if($lowestTime){
$lowestTime=min($lowestTime,strtotime($row['timePV']));//If not null we also get min lowerstTime from previous //and current one
}else{
$lowestTime=strtotime($row['timePV']);//It will work for only first iteration since $lowestTime will null in //first iteration
}
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
}
echo date("h:i",$lowestTime);//11:20 example out
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
You don't have to do another loop to calculate lowesttime. You can do it in that while loop with checking previous and present timePv like following
//$timeExample=[["timePV"=>"11:30"],["timePV"=>"11:20"],["timePV"=>"13:30"]];//example of data
$lowestTime = null;//Deault defined it null
while ($row = mysqli_fetch_assoc($result)) {
//foreach($timeExample as $row){ //foreach for run example
if($lowestTime){
$lowestTime=min($lowestTime,strtotime($row['timePV']));//If not null we also get min lowerstTime from previous //and current one
}else{
$lowestTime=strtotime($row['timePV']);//It will work for only first iteration since $lowestTime will null in //first iteration
}
echo "<tr>";
echo "<td>";
echo $row['timePV'];
echo "</td>";
echo "</tr>";
}
echo date("h:i",$lowestTime);//11:20 example out
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
answered Nov 22 '18 at 11:28
Mithu CNMithu CN
466310
466310
Thanks for the help man! appreciate it !
– user10579402
Nov 22 '18 at 11:50
add a comment |
Thanks for the help man! appreciate it !
– user10579402
Nov 22 '18 at 11:50
Thanks for the help man! appreciate it !
– user10579402
Nov 22 '18 at 11:50
Thanks for the help man! appreciate it !
– user10579402
Nov 22 '18 at 11:50
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53429441%2ffetching-data-and-trying-to-create-a-loop-to-determine-lowest-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Why don't you just use min?
– cmbuckley
Nov 22 '18 at 11:01
1
“This is going to be a newbie question, so bear with me.” - bearing … still bearing … hm, nothing. Where is the actual question?
– misorude
Nov 22 '18 at 11:02
Or at least do the min check as part of the original while loop. No need to write an array and do 2 loops
– RiggsFolly
Nov 22 '18 at 11:03
I did read something about min, but since i'm quite new to php (not very experienced) I decided to take a route that's a bit more familiar.
– user10579402
Nov 22 '18 at 11:03
If you are looping over the whole data set in a while loop already, and only need the minimum value afterwards - then you don’t need a second loop, you can just determine the minimum directly in that first loop.
– misorude
Nov 22 '18 at 11:03