PDO的一个问题 - V2EX
Home Sign Up Sign In
wuxiaolin
V2EX    PHP

PDO的一个问题

  •   
  •   wuxiaolin Nov 21, 2012 3577 views
    This topic created in 4920 days ago, the information mentioned may be changed or developed.
    $a = "狂神";
    $sql = "select acct,login from accounts where login=:login";
    $ptmt = $DB->prepare($sql);
    $ptmt->bindValue(':login', $a);
    $ptmt->execute();

    为何$a为中文时就查不出数据，字母数字就正常
  • login
  • ptmt
  • SQL
    5 replies    1970-01-01 08:00:00 +08:00
    bixuehujin
        1
    bixuehujin  
       Nov 21, 2012
    难道是数据库与PHP脚本编码不匹配？
    wuxiaolin
        2
    wuxiaolin  
    OP
       Nov 21, 2012
    @bixuehujin 肯定一致的
    linlinqi
        3
    linlinqi  
       Nov 21, 2012   1
    创建DB对象的时候得把编码写上，例如

    $DB = new PDO("mysql:dbname=dbname", "user", "password",
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
    wuxiaolin
        4
    wuxiaolin  
    OP
       Nov 21, 2012
    @linlinqi 真的是少了这步呀，唉，感谢你，晕死，类里面居然没有处理，我一直以为有
    itommy
        5
    itommy  
       Nov 23, 2012
    @wuxiaolin 刚刚我也被这个折磨了一会 感谢你已经问过了


    @linlinqi 感谢你的答案！ 问题解决 可以move on了 不然今晚睡不着 :p
    About     Help     Advertise     Blog     API     FAQ     Solana     3604 Online   Highest 6679       Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 94ms UTC 11:09 PVG 19:09 LAX 04:09 JFK 07:09
    Do have faith in what you're doing.
    ubao msn snddm index pchome yahoo rakuten mypaper meadowduck bidyahoo youbao zxmzxm asda bnvcg cvbfg dfscv mmhjk xxddc yybgb zznbn ccubao uaitu acv GXCV ET GDG YH FG BCVB FJFH CBRE CBC GDG ET54 WRWR RWER WREW WRWER RWER SDG EW SF DSFSF fbbs ubao fhd dfg ewr dg df ewwr ewwr et ruyut utut dfg fgd gdfgt etg dfgt dfgd ert4 gd fgg wr 235 wer3 we vsdf sdf gdf ert xcv sdf rwer hfd dfg cvb rwf afb dfh jgh bmn lgh rty gfds cxv xcv xcs vdas fdf fgd cv sdf tert sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf shasha9178 shasha9178 shasha9178 shasha9178 shasha9178 liflif2 liflif2 liflif2 liflif2 liflif2 liblib3 liblib3 liblib3 liblib3 liblib3 zhazha444 zhazha444 zhazha444 zhazha444 zhazha444 dende5 dende denden denden2 denden21 fenfen9 fenf619 fen619 fenfe9 fe619 sdf sdf sdf sdf sdf zhazh90 zhazh0 zhaa50 zha90 zh590 zho zhoz zhozh zhozho zhozho2 lislis lls95 lili95 lils5 liss9 sdf0ty987 sdft876 sdft9876 sdf09876 sd0t9876 sdf0ty98 sdf0976 sdf0ty986 sdf0ty96 sdf0t76 sdf0876 df0ty98 sf0t876 sd0ty76 sdy76 sdf76 sdf0t76 sdf0ty9 sdf0ty98 sdf0ty987 sdf0ty98 sdf6676 sdf876 sd876 sd876 sdf6 sdf6 sdf9876 sdf0t sdf06 sdf0ty9776 sdf0ty9776 sdf0ty76 sdf8876 sdf0t sd6 sdf06 s688876 sd688 sdf86