[Resolved] dynamic images

Tim_L

Hi there,

I've got a field in my mySQL DB which is called brands. The field has numerous different brands in the form of the actual brand name - ie. Coca Cola - including the space.

The spaces in the names cause a problem for me. How would I be able to create an image which is called brandimg_[DYNAMIC PHP].jpg without the spaces causing trouble??? I can do it if the spaces weren't there. I can rename the brands without the spaces as there are drop down menus which are generated from the DB field.

Any ideas?

stolzyboy

are these images uploaded by users with a form? and that is why there are spaces?

Tim_L

no, the brand names in the database have spaces in them. What I'd like to do is create an image for each brand like and then call it on the page like so:

brandimage_[$BRAND VARIABLE HERE].jpg

However, with the brand names having spaces in them I'm not sure what to do. I've tried naming the images with spaces like:

brandimage_coca cola.jpg but like I thought it didn't really work.

laserlight

hmm... would rawurlencoding the name help?

e.g.
brandimage_coca%20cola.jpg

Tim_L

tried that but it didn't work. 🙁

laserlight

just wondering, but how does it not work?
do you enclose values in html tags in double quotes?

conversely, you could simply replace whitespace with underscores.

Tim_L

It should work in theory but id doesn't?

Originally posted by laserlight
conversely, you could simply replace whitespace with underscores.

I don't really want underscores in the dynamically generated drop down menus.

Tim_L

I wonder if I could link every brand with a reference no. id?? Not sure how I'd do that tho'...

stolzyboy

you don't need the underscore in the generated part that they see, ie, the part in between the option and close option, put it in the value part only

Tim_L

How would I do that?

The drop down code is:

<select name="txtBrands" class="mnbox">
                    <option value="" selected>Select Brand </option>
                    <?php
do {  

?>
                    <option value="<?php echo $row_rs_brandmenu['Brands']?>"><?php echo $row_rs_brandmenu['Brands']?></option>
                    <?php
} while ($row_rs_brandmenu = mysql_fetch_assoc($rs_brandmenu));
  $rows = mysql_num_rows($rs_brandmenu);
  if($rows > 0) {
      mysql_data_seek($rs_brandmenu, 0);
	  $row_rs_brandmenu = mysql_fetch_assoc($rs_brandmenu);
  }
?>
                  </select>

stolzyboy

do a str_replace on the variable

str_replace(" ", "_", $row_rs_brandmenu['Brands']);

and use that in your value field, but keep the

$row_rs_brandmenu['Brands']

part in between the open and close option tags

then change your images to coca_cola, and it will look from the value of coca_cola after it is replaced, so basically the option will look like this once the browser renders it

then when you use the image, you use Coca_Cola.jpg or whatever

Tim_L

Thanks Stolzyboy!