get_results($sqlSerid,'A'); $rows = array(); for($i = 0; $iget_results($sqlSerid,'A'); return $seridRows; } */ function getTopPrices ($limit,$DB_GoCar_Read) { //$sqlSerid = "select distinct serid,name as sname,pic,pserid from `gcar_serise` where isstop!=1 and pserid>0 order by opentime desc limit 0,".$limit; $sqlSerid = "select distinct s.serid,s.name as sname,s.pic,s.pserid,ps.is_koubei from gcar_model as m left join gcar_serise as s on m.serid=s.serid left join gcar_serise_parent as ps on s.pserid=ps.pserid left join gcar_price_manu as p on m.mid=p.mid where s.isstop!=1 and m.isstop!=1 and s.pserid>0 and p.price>0 and status=1 order by s.opentime desc limit 0,".$limit; // echo $sqlSerid; $seridRows = $DB_GoCar_Read->get_results($sqlSerid,'A'); return $seridRows; } function getPricesFromManu($serid,$DB_GoCar_Read){ $sql = "select max(pmanu.price) as maxprice,min(pmanu.price) as minprice from gcar_price_manu as pmanu left join gcar_model as model on pmanu.mid=model.mid where model.serid='".$serid."' and model.isstop!=1 and model.issale!=1 and pmanu.status=1 order by maxprice asc, minprice desc"; $seridRows = $DB_GoCar_Read->get_results($sql,'A'); return $seridRows; } function getNameAndPathBySerid ($serid,$DB_GoCar_Read,$limit_beg=0,$limit_end=16) { $sql = 'SELECT a.name as sname,a.pdate, b.* FROM gcar_serise a, CrazyDance.img_n_info b WHERE a.serid=b.serid' . ' and a.isstop=0 and b.serid = '.$serid.' ORDER BY pdate DESC LIMIT '.$limit_beg.', '.$limit_end; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getAmountBySerid ($serid,$DB_GoCar_Read) { $sql = 'SELECT count( * ) as amount FROM CrazyDance.img_n_info' . ' WHERE serid ='.$serid; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows[0]['amount']; } /** * 取最新进口车报价,主要用于price_import.php页面. * * @param unknown_type $limitBeg * @param unknown_type $limitEnd * @param unknown_type $DB_GoCar_Read * @return unknown */ function getNewImportPrice($limitBeg,$limitEnd,$DB_GoCar_Read) { $sql="select p.id,p.did,p.mid,DATE_FORMAT(p.mdate,'%m-%d') as mdate,p.price,p.num,m.name as mname,d.coname,d.city as dcity,b.name as bname,s.name as sname from gcar_price_newcar as p left join gcar_dealer as d on d.did=p.did left join gcar_model as m on m.mid=p.mid left join gcar_serise as s on m.serid=s.serid left join gcar_brand as b on b.bid=m.bid where 1 and m.country=2 group by p.did order by p.mdate desc limit ".$limitBeg.",".$limitEnd; $rows=$DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getClubidBySerid ($serid,$DB_GoCar_Read){ $sql = 'SELECT b.clubid as fid FROM `gcar_serise` a, gcar_brandclub b WHERE a.serid='.$serid.' and a.bcid=b.bcid '; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows[0]['fid']; } /** * 取最新上市车,包含图片地址. * * @param unknown_type $limitBeg * @param unknown_type $limitEnd * @param unknown_type $DB_GoCar_Read * @return unknown */ function getNewMarket($limitBeg,$limitEnd,$DB_GoCar_Read) { $sql = 'select a.*,b.name as name, c.price from `CrazyDance`.`img_n_info` a,' . ' `gcar_serise` b,' . ' `gcar_price_newcar` c' . ' where a.serid=b.serid and b.serid=c.serid and b.isstop=0 and c.status=1' . ' order by c.mdate desc limit '.$limitBeg.','.$limitEnd; $rows=$DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getNameBySerid($serid,$DB_GoCar_Read) { $sql = "select name from `gcar_serise` where `serid`=".$serid." and isstop=0"; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows[0]['name']; } function getNmaeByBid($bid,$DB_GoCar_Read) { $sql = "select name from `gcar_brand` where `bid`=".$bid; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows[0]['name']; } function getCarInfoByserid($serid,$DB_GoCar_Read){ $sql="select m.mid,m.name,m.isstop,m.m_disl as exhaust,m.m_hecfuel as oiluse,m.m_horsepower as power,m.m_trans as gearbox,m.pic,c.price_d,c.price_g,m.m_disl,m.m_speed,m.m_transtype from gcar_model as m left join gcar_price_count as c on m.mid=c.mid where m.serid='$serid' and m.issale!=1 order by m.isstop asc"; // echo $sql."\r\n"; $rows=$DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getBidBySerid($serid,$DB_GoCar_Read){ $sql = 'select bid from `gcar_serise` where serid='.$serid." and isstop=0"; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows[0]['bid']; } function getSerisesInfoByBid($bid,$country,$DB_GoCar_Read) { $sql = "select serid,name from `gcar_serise` where `country`=".$country." and bid=".$bid." and isstop=0"; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getTidById($id,$DB_GoCar_Read) { $sql = 'select type_id from CrazyDance.img_n_info where id='.$id; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows[0]['type_id']; } /**********************************************************************************/ //1微型车、2小型车、3紧凑型车、4中型车、5大型车、6豪华车、7跑车、8紧凑型SUV、9中型SUV、10全尺寸SUV、11小MPV、12大MPV //微型车 小型车 紧凑型车 中型车4 中大型车5 豪华车 6 MPV11,12 SUV8,9,10 跑车7 function getSeridByType2($cty,$type2,$DB_GoCar_Read){ $sql = "select name,serid from `gcar_serise` where type2 in (".$type2.") and country=".$cty." and isstop=0"; // echo $sql."
"; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getAllSer($DB_GoCar_Read){ $sql = "select name,serid,country from `gcar_serise` where isstop=0"; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getAllBidInfoByCty($country,$DB_GoCar_Read){ // $sql = "select name,bid ,country from `gcar_brand` where `country`=".$country; $sql = "select a.name,a.bid,a.country from `gcar_brand` a,`gcar_serise` b where a.bid=b.bid and b.isstop=0 and a.country=".$country." group by a.bid"; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows; } function getAllSerInfoByCtyAndBid ($bid,$country,$DB_GoCar_Read){ $sql = "select serid,name from `gcar_serise` where `country`=".$country." and bid=".$bid." and isstop=0"; $rows = $DB_GoCar_Read->get_results($sql,'A'); return $rows; } function g($num){ global $d; if($num>0&&$num<160){ return chr($num); }elseif($num<-20319||$num>-10247){ return ""; }else{ for($i=count($d)-1;$i>=0;$i--){if($d[$i][1]<=$num)break;} return $d[$i][0]; } } function getPinyin($str){ $ret=""; for($i=0;$i160){ $q=ord(substr($str,++$i,1)); $p=$p*256+$q-65536; } $ret.=g($p); } return $ret; } $d=array( array("a",-20319), array("ai",-20317), array("an",-20304), array("ang",-20295), array("ao",-20292), array("ba",-20283), array("bai",-20265), array("ban",-20257), array("bang",-20242), array("bao",-20230), array("bei",-20051), array("ben",-20036), array("beng",-20032), array("bi",-20026), array("bian",-20002), array("biao",-19990), array("bie",-19986), array("bin",-19982), array("bing",-19976), array("bo",-19805), array("bu",-19784), array("ca",-19775), array("cai",-19774), array("can",-19763), array("cang",-19756), array("cao",-19751), array("ce",-19746), array("ceng",-19741), array("cha",-19739), array("chai",-19728), array("chan",-19725), array("chang",-19715), array("chao",-19540), array("che",-19531), array("chen",-19525), array("cheng",-19515), array("chi",-19500), array("chong",-19484), array("chou",-19479), array("chu",-19467), array("chuai",-19289), array("chuan",-19288), array("chuang",-19281), array("chui",-19275), array("chun",-19270), array("chuo",-19263), array("ci",-19261), array("cong",-19249), array("cou",-19243), array("cu",-19242), array("cuan",-19238), array("cui",-19235), array("cun",-19227), array("cuo",-19224), array("da",-19218), array("dai",-19212), array("dan",-19038), array("dang",-19023), array("dao",-19018), array("de",-19006), array("deng",-19003), array("di",-18996), array("dian",-18977), array("diao",-18961), array("die",-18952), array("ding",-18783), array("diu",-18774), array("dong",-18773), array("dou",-18763), array("du",-18756), array("duan",-18741), array("dui",-18735), array("dun",-18731), array("duo",-18722), array("e",-18710), array("en",-18697), array("er",-18696), array("fa",-18526), array("fan",-18518), array("fang",-18501), array("fei",-18490), array("fen",-18478), array("feng",-18463), array("fo",-18448), array("fou",-18447), array("fu",-18446), array("ga",-18239), array("gai",-18237), array("gan",-18231), array("gang",-18220), array("gao",-18211), array("ge",-18201), array("gei",-18184), array("gen",-18183), array("geng",-18181), array("gong",-18012), array("gou",-17997), array("gu",-17988), array("gua",-17970), array("guai",-17964), array("guan",-17961), array("guang",-17950), array("gui",-17947), array("gun",-17931), array("guo",-17928), array("ha",-17922), array("hai",-17759), array("han",-17752), array("hang",-17733), array("hao",-17730), array("he",-17721), array("hei",-17703), array("hen",-17701), array("heng",-17697), array("hong",-17692), array("hou",-17683), array("hu",-17676), array("hua",-17496), array("huai",-17487), array("huan",-17482), array("huang",-17468), array("hui",-17454), array("hun",-17433), array("huo",-17427), array("ji",-17417), array("jia",-17202), array("jian",-17185), array("jiang",-16983), array("jiao",-16970), array("jie",-16942), array("jin",-16915), array("jing",-16733), array("jiong",-16708), array("jiu",-16706), array("ju",-16689), array("juan",-16664), array("jue",-16657), array("jun",-16647), array("ka",-16474), array("kai",-16470), array("kan",-16465), array("kang",-16459), array("kao",-16452), array("ke",-16448), array("ken",-16433), array("keng",-16429), array("kong",-16427), array("kou",-16423), array("ku",-16419), array("kua",-16412), array("kuai",-16407), array("kuan",-16403), array("kuang",-16401), array("kui",-16393), array("kun",-16220), array("kuo",-16216), array("la",-16212), array("lai",-16205), array("lan",-16202), array("lang",-16187), array("lao",-16180), array("le",-16171), array("lei",-16169), array("leng",-16158), array("li",-16155), array("lia",-15959), array("lian",-15958), array("liang",-15944), array("liao",-15933), array("lie",-15920), array("lin",-15915), array("ling",-15903), array("liu",-15889), array("long",-15878), array("lou",-15707), array("lu",-15701), array("lv",-15681), array("luan",-15667), array("lue",-15661), array("lun",-15659), array("luo",-15652), array("ma",-15640), array("mai",-15631), array("man",-15625), array("mang",-15454), array("mao",-15448), array("me",-15436), array("mei",-15435), array("men",-15419), array("meng",-15416), array("mi",-15408), array("mian",-15394), array("miao",-15385), array("mie",-15377), array("min",-15375), array("ming",-15369), array("miu",-15363), array("mo",-15362), array("mou",-15183), array("mu",-15180), array("na",-15165), array("nai",-15158), array("nan",-15153), array("nang",-15150), array("nao",-15149), array("ne",-15144), array("nei",-15143), array("nen",-15141), array("neng",-15140), array("ni",-15139), array("nian",-15128), array("niang",-15121), array("niao",-15119), array("nie",-15117), array("nin",-15110), array("ning",-15109), array("niu",-14941), array("nong",-14937), array("nu",-14933), array("nv",-14930), array("nuan",-14929), array("nue",-14928), array("nuo",-14926), array("o",-14922), array("ou",-14921), array("pa",-14914), array("pai",-14908), array("pan",-14902), array("pang",-14894), array("pao",-14889), array("pei",-14882), array("pen",-14873), array("peng",-14871), array("pi",-14857), array("pian",-14678), array("piao",-14674), array("pie",-14670), array("pin",-14668), array("ping",-14663), array("po",-14654), array("pu",-14645), array("qi",-14630), array("qia",-14594), array("qian",-14429), array("qiang",-14407), array("qiao",-14399), array("qie",-14384), array("qin",-14379), array("qing",-14368), array("qiong",-14355), array("qiu",-14353), array("qu",-14345), array("quan",-14170), array("que",-14159), array("qun",-14151), array("ran",-14149), array("rang",-14145), array("rao",-14140), array("re",-14137), array("ren",-14135), array("reng",-14125), array("ri",-14123), array("rong",-14122), array("rou",-14112), array("ru",-14109), array("ruan",-14099), array("rui",-14097), array("run",-14094), array("ruo",-14092), array("sa",-14090), array("sai",-14087), array("san",-14083), array("sang",-13917), array("sao",-13914), array("se",-13910), array("sen",-13907), array("seng",-13906), array("sha",-13905), array("shai",-13896), array("shan",-13894), array("shang",-13878), array("shao",-13870), array("she",-13859), array("shen",-13847), array("sheng",-13831), array("shi",-13658), array("shou",-13611), array("shu",-13601), array("shua",-13406), array("shuai",-13404), array("shuan",-13400), array("shuang",-13398), array("shui",-13395), array("shun",-13391), array("shuo",-13387), array("si",-13383), array("song",-13367), array("sou",-13359), array("su",-13356), array("suan",-13343), array("sui",-13340), array("sun",-13329), array("suo",-13326), array("ta",-13318), array("tai",-13147), array("tan",-13138), array("tang",-13120), array("tao",-13107), array("te",-13096), array("teng",-13095), array("ti",-13091), array("tian",-13076), array("tiao",-13068), array("tie",-13063), array("ting",-13060), array("tong",-12888), array("tou",-12875), array("tu",-12871), array("tuan",-12860), array("tui",-12858), array("tun",-12852), array("tuo",-12849), array("wa",-12838), array("wai",-12831), array("wan",-12829), array("wang",-12812), array("wei",-12802), array("wen",-12607), array("weng",-12597), array("wo",-12594), array("wu",-12585), array("xi",-12556), array("xia",-12359), array("xian",-12346), array("xiang",-12320), array("xiao",-12300), array("xie",-12120), array("xin",-12099), array("xing",-12089), array("xiong",-12074), array("xiu",-12067), array("xu",-12058), array("xuan",-12039), array("xue",-11867), array("xun",-11861), array("ya",-11847), array("yan",-11831), array("yang",-11798), array("yao",-11781), array("ye",-11604), array("yi",-11589), array("yin",-11536), array("ying",-11358), array("yo",-11340), array("yong",-11339), array("you",-11324), array("yu",-11303), array("yuan",-11097), array("yue",-11077), array("yun",-11067), array("za",-11055), array("zai",-11052), array("zan",-11045), array("zang",-11041), array("zao",-11038), array("ze",-11024), array("zei",-11020), array("zen",-11019), array("zeng",-11018), array("zha",-11014), array("zhai",-10838), array("zhan",-10832), array("zhang",-10815), array("zhao",-10800), array("zhe",-10790), array("zhen",-10780), array("zheng",-10764), array("zhi",-10587), array("zhong",-10544), array("zhou",-10533), array("zhu",-10519), array("zhua",-10331), array("zhuai",-10329), array("zhuan",-10328), array("zhuang",-10322), array("zhui",-10315), array("zhun",-10309), array("zhuo",-10307), array("zi",-10296), array("zong",-10281), array("zou",-10274), array("zu",-10270), array("zuan",-10262), array("zui",-10260), array("zun",-10256), array("zuo",-10254) ); ?> 黑龙江时时彩走势图
购车网
热门搜索:比亚迪e6POLO沃蓝达新君威奥迪A6L宝来
关于我们|联系我们|友情链接|汽车报价|品牌大全|级别大全|最新资讯|选车中心|上市新车
联系地址:北京市海淀区知春路113号银网中心B座16层 邮编:100086 电话:010-82616677-1000 传真:010-62556006
COPYRIGHT gocar.cn All Right Reserved 版权所有:购车网 京ICP备09041801号-127京ICP号010391 隐私权声明
重庆时时彩骗局