user image

Shilpa
Published in : 2022-03-31

How to read JSON key value from JSON object from Database (In Mysql or Sqlite database)?

PHP & Mysql

//My code snippet
SELECT JSON_EXTRACT('{"id":"A0001","name":"shilpa"}', '$.name');

I want to extract key-value from Json stored in my database table. 

But above statement should return shilpa, In my case it is returning as “shilpa” (Returning value with double quotes)

 

On the UI side, I am using angular and I have to remove/replace double quotes with empty strings all the time! I am using Mysql 8.0 and SQLite DB v3.0

Is there a way to ignore double quotes which are appending in JSON_EXTRACT? 

Comments

Mohamed Atef Date : 2022-03-31

Best answers

46

Best answers

46

I believe you can remove the qoutes in this way

<?php
$s = '"hello"';
$final = str_replace('"', '', $s);
echo $final;
?>

and you can use foreach to extract the object and rebuild it 

OR 

you can use foreach only to get the key of the array like

foreach($arr as $key => $var){
  echo $key . " " . $var;
} 

Good luck

Leave a comment

Join us

Join our community and get the chance to solve your code issues & share your opinion with us

Sign up Now

Related posts

SQL full languages table
Publish date: 2022-02-24 | Comments: 2

Tag: PHP & Mysql

[solved] Storage engine 'InnoDB' does not support system tables
Publish date: 2022-01-09 | Comments: 0

Tag: PHP & Mysql

CodeIgniter route does not work
Publish date: 2022-02-22 | Comments: 4

Tag: PHP & Mysql

php difference between two times in hours
Publish date: 2022-02-25 | Comments: 2

Tag: PHP & Mysql

Warning appears in Zend framework
Publish date: 2022-02-24 | Comments: 1

Tag: PHP & Mysql

Mysql query: How do I count the day streak of particular user?
Publish date: 2022-03-01 | Comments: 4

Tag: PHP & Mysql

mysql service start not exist
Publish date: 2022-02-23 | Comments: 4

Tag: PHP & Mysql

ERROR 1410 (42000): You are not allowed to create a user with GRANT
Publish date: 2022-04-01 | Comments: 2

Tag: PHP & Mysql