Adobe PHP Cookbook

Most Popular Recipes

• Upload image to website (PHP)
  • David_Powers 
  •   December 30, 2009
  • Avg. rating 5.00
  
  

  Problem

  I want to insert code so a file field can be used to upload images. Also, is it possible to upload images to an image placeholder?

  Solution

  Uploading images with PHP is relatively easy. For security reasons, you should always check that the file is an image, and that it doesn't exceed a maximum size. The original question posed by Daniel Hogg specified that the image should be uploaded to an image placeholder. As long as the image has the same name as the placeholder, the following solution should work.

• Create nested lists from a recordset (PHP)
  • David_Powers 
  •   January 22, 2010
  • Avg. rating 5.00
  
  

  Problem

  You have a set of database results (recordset) that contains a field with a value that's repeated in each row, but you want to show the value only the first time it appears. At the same time, you want the remaining fields to be displayed. For example, you're building a list with categories and subcategories. Each category should be shown only once.

  Solution

  Before the recordset is displayed in a repeat region, initialize an empty variable to keep track of value of the field with the repeated value(s). Each time the repeat region loop runs, check to see if the value is the same as the current one. If the value is different, display it. Otherwise, skip it.

• Upload images to a MySQL database (PHP)
  • David_Powers 
  •   January 1, 2010
  • Avg. rating 4.86
  
  

  Problem

  I want to upload images directly into my MySQL database, rather than into a folder on my website.

  Solution

  It's normally recommended to store images in the website's file system, rather than in a database, because images bloat the size of database tables and require a proxy script to be displayed. However, if you do want to store images in a database, use the PHP function, file_get_contents(), to store the image data temporarily in a variable, and pass the variable to the SQL query to insert the data into the database.

• Display an image stored in a database (PHP)
  • David_Powers 
  •   January 1, 2010
  • Avg. rating 5.00
  
  

  Problem

  If you display an image directly from a database, your web page is filled with garbage instead of a beautiful photo.

  Solution

  The browser doesn't know how to handle the data stored in the database, so it just dumps raw data onto the screen. You need to store the image's MIME type in the database, and use a proxy script to display the image in your web page.

• Avactis 1.9.0 ecommerce shopping cart customization using Dreamweaver
  • eCommDesign 
  •   January 19, 2010
  • Avg. rating 5.00
  
  

  Problem

  Add Avactis 1.9.0 ecommerce functionality to the existing Dreamweaver site

  Solution

  Avactis 1.9.0 ecommerce shopping cart customization and integration using Dreamweaver