CODEWITHSUNDEEP
phploopswhile-loopecho
Arnold Porche Villaluz
Arnold Porche Villaluz

Reputation: 213

PHP looped data will not echo outside the while function OR how can I pass looped data by echoing out of the while function?

I have a loop of data that will only echo the loop inside the while function, but if i call/echo the looped data outside the while function, it only runs the 1st loop.

SAMPLE:

$num = mysql_num_rows($queryFromDB);
$i=0;
while($i < $num)
{
    $field1= mysql_result($queryFromDB,$i,"field1");
    $field2= mysql_result($queryFromDB,$i,"field2");

    $bothFields = $field1 . " " . $field2 "\n";

    // This will show 2 rows of data
    echo $bothFields;

    $i++;

    // This will only show 1 row of data. How can I pass the looped data to another variable?
    echo $bothFields;

}

The output that I wanted to show is:

TITLE/HEADER GOES HERE in the 1st Line

-1st Row of Data from DB

-2nd Row of Data from DB

Here's the actual code: $num = mysql_num_rows($qWoundAssessment);

$i=0; while ($i < $num) { $wndType = mysql_result($qWoundAssessment,$i,"wndType"); $wndNum = mysql_result($qWoundAssessment,$i,"wndNum"); $wndLocation = mysql_result($qWoundAssessment,$i,"wndLocation"); $wndStage = mysql_result($qWoundAssessment,$i,"wndStage"); $wndL = mysql_result($qWoundAssessment,$i,"wndL"); $wndD = mysql_result($qWoundAssessment,$i,"wndD"); $wndW = mysql_result($qWoundAssessment,$i,"wndW"); $wndAseptic = mysql_result($qWoundAssessment,$i,"wndAseptic"); $wndIrrigate = mysql_result($qWoundAssessment,$i,"wndIrrigate"); $wndIrrigateBox = mysql_result($qWoundAssessment,$i,"wndIrrigateBox"); $wndPat = mysql_result($qWoundAssessment,$i,"wndPat"); $wndCover = mysql_result($qWoundAssessment,$i,"wndCover"); $wndCoverBox = mysql_result($qWoundAssessment,$i,"wndCoverBox"); $wndSecure = mysql_result($qWoundAssessment,$i,"wndSecure"); $wndSecureBox = mysql_result($qWoundAssessment,$i,"wndSecureBox"); $wndQvisit = mysql_result($qWoundAssessment,$i,"wndQvisit");

$wnd = "-" . $wndType . " " . "#" . $wndNum . ", " . "LOCATION " . $wndLocation . ", " . "STAGE " . $wndStage; $wndSize = "SIZE " . $wndL . "CM" . " X " . $wndW . "CM" . " X " . $wndD; if($wndAseptic=="1"){$wndAsepticTech = "USING ASEPTIC TECHNIQUE";} if($wndIrrigate=="1"){$wndIrrigateWith = "IRRIGATE WITH " . $wndIrrigateBox;} if($wndPat=="1"){$wndPatDry = "PAT DRY";} if($wndCover=="1"){$wndCoverWith = "COVER WITH " . $wndCoverBox;} if($wndSecure=="1"){$wndSecureWith = "COVER WITH " . $wndSecureBox;} if($wndQvisit=="1"){$wndQv = "Q VISIT";}

if(isset($wnd, $wndSize, $wndAsepticTech, $wndIrrigateWith, $wndPatDry, $wndCoverWith, $wndSecureWith, $wndQv)){ $woundCare = implode(", ",array($wnd, $wndSize, $wndAsepticTech, $wndIrrigateWith, $wndPatDry, $wndCoverWith, $wndSecureWith, $wndQv)) . "\n\n ";}

$wndCare .= $woundCare;

$i++; }

$snWoundCare = "SN TO PROVIDE SKILLED NURSING VISITS FOR WOUND CARE:" . "\n" . $wndCare;

if I echo $wndCare, it shows the "Undefined variable" error with the actual looped data. But if I pass this variable to PDF, it works.

SN TO PROVIDE SKILLED NURSING VISITS FOR WOUND CARE:

-PRESSURE ULCER #1, LOCATION COCCYX, 3, SIZE 2.0CM X 1.5CM X 0.07, USING ASEPTIC TECHNIQUE, IRRIGATE WITH NORMAL SALINE, PAT DRY, COVER WITH AQUACEL AG, COVER WITH MEPILEX BORDER, Q VISIT

-SURGICAL WOUND #2, LOCATION (R) KNEE, , SIZE 29CM X 0CM X 0, USING ASEPTIC TECHNIQUE, IRRIGATE WITH NORMAL SALINE, PAT DRY, COVER WITH AQUACEL AG, COVER WITH MEPILEX BORDER, Q VISIT

================ CODE NOW WORKS!!! HERE's MY FINAL SOLUTION ====================== $num = mysql_num_rows($qWoundAssessment); $i=0; $storeMyData = array(); while($i < $num) { $wnd= "-" . mysql_result($qWoundAssessment,$i,"wndType") . " #" . mysql_result($qWoundAssessment,$i,"wndNum"). ", LOCATION " . mysql_result($qWoundAssessment,$i,"wndLocation") . ", STAGE " . mysql_result($qWoundAssessment,$i,"wndStage"); $wndSize = "SIZE " . mysql_result($qWoundAssessment,$i,"wndL") . "CM" . " X " . mysql_result($qWoundAssessment,$i,"wndW") . "CM" . " X " . mysql_result($qWoundAssessment,$i,"wndD") . "CM"; if(isset($rowWoundAssessment['wndAseptic'])){$wndAsepticTech = "USING ASEPTIC TECHNIQUE";} if(isset($rowWoundAssessment['wndIrrigate'])){$wndIrrigateWith = "IRRIGATE WITH " . mysql_result($qWoundAssessment,$i,"wndIrrigateBox");} if(isset($rowWoundAssessment['wndPat'])){$wndPatDry = "PAT DRY";} if(isset($rowWoundAssessment['wndCover'])){$wndCoverWith = "COVER WITH " . mysql_result($qWoundAssessment,$i,"wndCoverBox");} if(isset($rowWoundAssessment['wndSecure'])){$wndSecureWith = "SECURE WITH " . mysql_result($qWoundAssessment,$i,"wndSecureBox");} if(isset($rowWoundAssessment['wndQvisit'])){$wndQvisit = "Q VISIT";}

$wndCare = implode (", ", array($wnd, $wndSize, $wndAsepticTech, $wndIrrigateWith, $wndPatDry, $wndCoverWith, $wndSecureWith, $wndQvisit)). "\n\n";

    // This will show 2 rows of data

    $storeMyData[] = $wndCare ;  // store current data in array
    $i++;
}

/* this will echo your storedData of loop */ foreach($storeMyData as $prevData)

/* or join the data using string concatenation / $allFinalData2 = ""; / this will echo your storedData of loop */ foreach($storeMyData as $prevData) { $allFinalData2 = $allFinalData2.$prevData ; // keep on concatenating } echo "SN TO PROVIDE SKILLED NURSING VISITS FOR WOUND CARE:" . "\n" . $allFinalData2;

thanks to DhruvPathak and Antonio Laguna! You guys are the best! Just made my day! jumps around the room

Upvotes: 0

Views: 1031

Answers (2)

DhruvPathak
DhruvPathak

Reputation: 43235

I am not sure what you want to do with your data. It seems you want to store all the data to use it outside the loop, then this is the way to go :

<?php
$num = mysql_num_rows($queryFromDB);
$i=0;
$storeMyData = array();
while($i < $num)
{
    $field1= mysql_result($queryFromDB,$i,"field1");
    $field2= mysql_result($queryFromDB,$i,"field2");

    $bothFields = $field1 . " " . $field2 "\n";

    // This will show 2 rows of data
    echo $bothFields;
    $storeMyData[] = $bothFields ;  // store current data in array
    $i++;


}


/* this will echo your storedData of loop */
foreach($storeMyData as $prevData)
  {
     echo $prevData."\n";
  }

?>

 $allFinalData = implode("",$prevData);  // implode will join all the data as string
 echo $allFinalData."\n" ; 

/* or join the data using string concatenation */
 $allFinalData2 = "";
   /* this will echo your storedData of loop */
foreach($storeMyData as $prevData)
  {
    $allFinalData2 = $allFinalData2.$prevData ;  // keep on concatenating
  }

 echo $allFinalData2,"\n";

?>

Upvotes: 0

Antonio Laguna
Antonio Laguna

Reputation: 9292

This should work:

<?php
$wndCare = '';

while ($row = mysql_fetch_assoc($qWoundAssessment)){
    $wnd = '-'.$row['wndType'].' #'..$row['wndNum'].', LOCATION '.$row['wndLocation'].', STAGE '.$row['wndStage'];
    $wndSize = 'SIZE '.$row['wndL'].'CM X '.$row['wndW'].'CM X '.$row['wndD'];

    $wndAsepticTech = ($row['wndAseptic'] == 1) ? 'USING ASEPTIC TECHNIQUE' : '';
    $wndIrrigateWith = ($row['wndIrrigate'] == 1) ? 'IRRIGATE WITH '.$row['wndIrrigateBox'] : '';
    $wndPatDry = ($row['wndPat'] == 1) ? 'PAT DRY' : '';
    $wndCoverWith = ($row['wndCover'] == 1) ? 'COVER WITH'.$row['wndCoverBox'] : '';
    $wndSecureWith = ($row['wndSecure'] == 1) ? 'COVER WITH'.$row['wndSecureBox'] : '';
    $wndSecureWith = ($row['wndSecure'] == 1) ? 'COVER WITH'.$row['wndSecureBox'] : '';
    $wndQvisit = ($row['wndQvisit'] == 1) ? 'Q VISIT' : '';

    $wndCare .= implode (", ", array($wnd, $wndSize, $wndAsepticTech, $wndIrrigateWith, $wndPatDry, $wndCoverWith, $wndSecureWith, $wndQv)). '\n\n';
}
$snWoundCare = "SN TO PROVIDE SKILLED NURSING VISITS FOR WOUND CARE:" . "\n" . $wndCare;
?>

The issue I see is that you were testing if all variables where previously setted and this could make strange things as you were stablishing them sometimes and sometimes don't.

Upvotes: 1

Related Questions