Accessing data from column via PHP

Question

I have a website which is running in Joomla 2.5 with MyBlog. I am creating a external application which takes data from MyBlog tables and displays to website users.

In MyBlog comment tables, there is a column name 'comment_author_data'. In this column the data inside looks something like this: {"name":"xxxxx","email":"[email protected]","id":"xxx"}

I want to access the value from the name and Email Id and Id from the data.

How do I access them using PHP ?

Any help will be appreciated.

look at how to import the Joomla framework externally and how to write a query to get data from a Joomla database table. There are more than enough docs for this. If you encounter a specific problem with your code and provide examples of what you've tried, you will more likely get an answer ;) — Lodder
– Lodder, Commented Oct 28, 2013 at 10:14

Darren · Accepted Answer · 2013-10-28 10:15:11Z

2

That looks like a json string. you can access the values of name and email by using json_decode().

<?php 

$string = ' {"name":"xxxxx","email":"[email protected]","id":"xxx"}';

$data = json_decode($string);

print_r($data);

?>

returns

stdClass Object
(
    [name] => xxxxx
    [email] => [email protected]
    [id] => xxx
)

which allows you to access it like so:

print $data->name;

answered Oct 28, 2013 at 10:15

Darren

13.1k4 gold badges44 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mkb Over a year ago

Hi dbh, thank for your solution.... it really worked for me.... really appreciated the quick reply...

Darren Over a year ago

@mkb no worries mate, glad this helped you and solved your issue!

Collectives™ on Stack Overflow

Accessing data from column via PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related