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 snippetSELECT 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

51

Best answers

51

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

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql

How the image file have .php extension?
Publish date: 2022-03-01 | Comments: 2

Tag: PHP & Mysql

[solved] #1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
Publish date: 2022-01-09 | Comments: 1

Tag: PHP & Mysql

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql

MySQL - Lost connection to MySQL server during query - Required a solution.
Publish date: 2022-03-03 | Comments: 1

Tag: PHP & Mysql

PHP mail function goes to spam not inbox
Publish date: 2022-02-28 | Comments: 2

Tag: PHP & Mysql