求教 PHP PDO 操作 mysql 的语句

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 2717 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 ？请大神指点，谢谢

变量

PHP

info_json

Code

6 replies • 2018-11-20 00:11:40 +08:00

caola

Nov 19, 2018

$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

Nov 19, 2018

$read = $db->query("SELECT json_extract(info_json,'$.$bianliankey') as $bianliankey FROM $bianliangtable WHERE CODE = $code LIMIT 1");
报错，请问这个该怎么写？

echotpq

Nov 19, 2018

报语法不对

echotpq

Nov 19, 2018

@caola 报语法不对

U7Q5tLAex2FI0o0g

Nov 20, 2018

报错不是应该会说哪里出错么？所以你具体报什么错

我觉得 code = 'aaa' （ code = '$code'）需要引号

echotpq

Nov 20, 2018 via Android

@littleylv 是这里报错(info_json,'$.$bianliankey')