<?php /** * Created by PhpStorm. * User: master * Date: 2016/3/23 * Time: 20:01 */ require '../sql/mysql_cls.php'; require 'lib.php'; //error_reporting(0); $db = new mysql_cls(); $db->connect(); $db->changeDB('whheadphones'); $oriword = "Inventory"; $id = "5086"; $dicflag = 1; //$result=getManufacturers(); //print_r(QueryInSelfDic($id,$dicflag)); $gtranslation = GetTransLation($oriword, 29, 3); print_r($gtranslation);
function getManufacturers() { $sql = "SELECT id_manufacturer,name FROM manufacturers"; $manufacturer = $GLOBALS['db']->getAll($sql); foreach ($manufacturer as $k => $v) { $manufacturername = $v['name']; $manufacturername = htmlspecialchars($manufacturername); $manufacturerid = $v['id_manufacturer']; $mtranslation = GetTransLation($manufacturername, $manufacturerid, 2); $chn = array(); //$de=array(); //$eng=array(); if (!empty($mtranslation)) { foreach ($mtranslation as $value) { $chn[] = $value['CHN']; //$de[]=$value['De']; //$eng[]=$value['Eng']; } } // if(empty($chn)) // $chn[]="null"; $manufacturer[$k]['CHN'] = $chn; $manufacturer[$k]['Eng'] = "null"; $manufacturer[$k]['De'] = "null"; $results[] = $manufacturer[$k]; } return $results; }