lightinthebox zencart 多语言设置 在数据库如何查询 在页面如何添加

 

includes/functions/general.php

  function zen_get_languages() {
    global $db;
    $languages = $db->Execute("select languages_id, name, code, image, directory
                               from " . TABLE_LANGUAGES . " order by sort_order");

    while (!$languages->EOF) {
      $languages_array[] = array('id' => $languages->fields['languages_id'],
                                 'name' => $languages->fields['name'],
                                 'code' => $languages->fields['code'],
                                 'image' => $languages->fields['image'],
                                 'directory' => $languages->fields['directory']);
      $languages->MoveNext();
    }

    return $languages_array;
  }

 

如果需要在页面调用

function string2multi_languages_array( $input )
{
 if ( !is_array( $input ) )
 {
  $input_array = array( );
  $languages = zen_get_languages( );
  $i = 0;
  $n = sizeof( $languages );
  for ( ; $i < $n; ++$i )
  {
   $language_id = $languages[$i]['id'];
   $input_array[$language_id] = $input;
  }
  return $input_array;
 }
 return $input;
}

 

 

$products_name = string2multi_languages_array( $products_name );