echotpq
V2EX  ›  问与答

求教 PHP PDO 操作 mysql 的语句

  •  
  •   echotpq · Nov 19, 2018 · 1619 views
    This topic created in 2922 days ago, the information mentioned may be changed or developed.

    用 php 操作 mysql8 中的 json 字段 表结构:code,info_json SELECT json_extract(info_json,'$.变量 key') as 变量 key FROM 变量表名 WHERE CODE = 变量 LIMIT 1 如何写成 php ?请大神指点,谢谢

    6 replies  •  2018-11-20 00:11:40 +08:00
    caola
    caola
    Nov 19, 2018
    1
    $db = new PDO('mysql:host=localhost;dbname=dataname', 'root', 'root');
    $db->exec('SET NAMES UTF8MB4');
    $read = $db->query("SELECT json_extract(info_json,'$.变量 key') as 变量 key FROM 变量表名 WHERE CODE = 变量 LIMIT 1");
    $data = $read->fetch(PDO::FETCH_ASSOC);

    var_dump($data);
    echotpq
    echotpq
    OP
    Nov 19, 2018
    2
    $read = $db->query("SELECT json_extract(info_json,'$.$bianliankey') as $bianliankey FROM $bianliangtable WHERE CODE = $code LIMIT 1");
    报错,请问这个该怎么写?
    echotpq
    echotpq
    OP
    Nov 19, 2018
    3
    报语法不对
    echotpq
    echotpq
    OP
    Nov 19, 2018
    4
    @caola 报语法不对
    U7Q5tLAex2FI0o0g
    U7Q5tLAex2FI0o0g
    Nov 20, 2018
    5
    报错不是应该会说哪里出错么?所以你具体报什么错

    我觉得 code = 'aaa' ( code = '$code') 需要引号
    echotpq
    echotpq
    OP
    Nov 20, 2018 via Android
    6
    @littleylv 是这里报错(info_json,'$.$bianliankey')
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   956 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 20:21 · PVG 04:21 · LAX 12:21 · JFK 15:21
    ♥ Do have faith in what you're doing.