Enum to Array / SQL to PHP - PHP Snipplr Social Repository

Revision: 4441

at December 12, 2007 08:35 by clapfouine

Initial Code

function LoadTypeValues($table, $column)
{
  global $db;
  // Create a SQL Query to get the Columns Type information,
  // Open a database connection, execute the query, and retrieve
  // the result.

  $sql = "show columns from $table like '$column'";

  // Get the Type information, Remove "xxx(" from the front
  // and ")" from the end.  Split the comma delimited values
  // into an array.
  $requete = mysql_query($sql, $db);
  while($enum = mysql_fetch_array($requete)) {
      $enum = $db->f('Type');
      $off  = strpos($enum,"(");
      $enum = substr($enum, $off+1, strlen($enum)-$off-2);
      $values = explode(",",$enum);
    
      // For each value in the array, remove the leading and trailing
      // single quotes, convert two single quotes to one. Put the result
      // back in the array in the same form as CodeCharge needs.
    
      for( $n = 0; $n < Count($values); $n++) {
        $val = substr( $values[$n], 1,strlen($values[$n])-2);
        $val = str_replace("''","'",$val);
        $values[$n] = array( $val, $val );
      }
  }
  // return the values array to the caller
  return $values;
}

Initial URL

Initial Description

adapted from http://www.gotocode.com/art.asp?art_id=275&

Initial Title

Enum to Array / SQL to PHP

Initial Tags

mysql, php, array

Initial Language

PHP

Choose a language for easy browsing: