CODEWITHSUNDEEP
phpmysqlcsv
Rocco The Taco
Rocco The Taco

Reputation: 3777

PHP Loop not working for CSV output using MySQL variable

I created a variable from a MySQL query that gives a total number value of photos available for a record. This along with a few other variables from the query I can use to construct a dynamic URL in a CSV file I am exporting.

This works great:

  foreach($rowr as $name => $value)

  {
      if($name=='MatrixImage') {$jpg_name=$value;}
      if($name=='PhotoCount') {$count_name=$value;}     
      if($name != 'estate_property_gallery')
            $csv_output .= $value."|";


      if($name == 'estate_property_gallery')
    {
      $csv_output .= "http://url/feeds/".$value."/rets_images/".$jpg_name."_".$count_name.".jpg";
    }               

  }

I need to be able to loop through and create multiple URLs using this PhotoCount variable starting from 1 to the final value found in PhotoCount seperated by a comma but I can't seem to get it right.

Not working:

  foreach($rowr as $name => $value)

  {
      if($name=='MatrixImage') {$jpg_name=$value;}
      if($name=='PhotoCount') {$count_name=$value;}     
      if($name != 'estate_property_gallery')
            $csv_output .= $value."|";


      if($name == 'estate_property_gallery')
    {
      //$csv_output .= "http://url/feeds/".$value."/rets_images/".$jpg_name."_".$count_name.".jpg";
      for( $pic_start=1; $pic_start<=$count_name; $pic_start++ ){
    echo '$csv_output .= "http://url/feeds/' . $value . '/rets_images/' . $jpg_name . '_' . $pic_start . '.jpg,"';
}
    }               

  }

The example above outputs the entire line including the $csv_output to the screen instead of putting each URL into the column of the CSV and delimiting with a comma.

To clarify: I need to be able to write this echo into the $csv_output .= portion of the code successfully so I can write multiple URLs separated by a comma within that column in my csv output:

echo 'http://www.myagentsbuddy.com/feeds/' . $value . '/rets_images/' . $jpg_name . '_' . $count_name . '.jpg';

Upvotes: 0

Views: 147

Answers (1)

Don&#39;t Panic
Don&#39;t Panic

Reputation: 41810

If the first example you showed works great, and does not include an echo, and the second example you showed (with an echo) does not work, it seems like it could be fixed by removing the echo and going back to just appending the URLs to the $csv_output like you're doing in the working example.

if($name == 'estate_property_gallery') {
    $comma = '';
    for( $pic_start=1; $pic_start<=$count_name; $pic_start++ ) {
        $csv_output .= $comma.'http://url/feeds/'.$value.'/rets_images/'
                      .$jpg_name.'_'.$pic_start.'.jpg';
        // doing the comma like this will prevent a trailing comma after the last entry
        $comma = ',';
    }
}

Upvotes: 1

Related Questions