php pdo json encode array

Question

hello I want to print "title" in the menu content data in the database, but I get an error. I do not know much about json, but as a result of my research, something like this came out and the error code is below

Warning: Illegal string offset 'title' in menu.php on line 59

mysql database data menu_content

[{"title":"HelloWord","address":"HelloAdres","phone":"HelloPhone","submenu":[{"email":"HelloSubmenuEmail","phone":"HelloSubmenuPhone","fax":"HelloSubmenuFax"}]}]

pdo

$query = $db->prepare('SELECT * FROM menu ORDER BY menu_id DESC');
$query->execute();
$rows = $query->fetchAll(PDO::FETCH_ASSOC);

table

<tbody>
<?php foreach ($rows as $row): ?>
<tr data-id="<?= $row['menu_id'] ?>">
<td width="90"><?= $row['menu_id'] ?></td>
<td width="90"><?= $row['menu_title'] ?></td>
<td><?php json_decode($row['menu_content']['title'],true) ?></td>
<td><?= $row['menu_date'] ?></td>
</tr>
<?php endforeach; ?>
</tbody>

$row['menu_content'] has the JSON, not title. Also return that to a variable, otherwise it won't do anything for you. — user3783243
– user3783243, Commented Jun 29, 2020 at 15:39

RiggsFolly · Accepted Answer · 2020-06-29 15:57:07Z

2

You should convert the JSON column before attempting to make use of its parts.

<tbody>
<?php 
foreach ($rows as $row): 
    $menu = json_decode($row['menu_content']);
?>
    <tr data-id="<?= $row['menu_id'] ?>">
        <td width="90"><?= $row['menu_id'] ?></td>
        <td width="90"><?= $row['menu_title'] ?></td>
        <td><?= $menu[0]->title ?></td>
        <td><?= $row['menu_date'] ?></td>
    </tr>
<?php 
endforeach; 
?>
</tbody>

edited Jun 29, 2020 at 15:57

answered Jun 29, 2020 at 15:48

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

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

4 Comments

Mesut Over a year ago

so how do i get a submenu email ?

RiggsFolly Over a year ago

For example $menu[0]->submenu[0]->email But as its an array I assume you may have more than one so another foreach loop would be in order

Mesut Over a year ago

RiggsFolly are you there?

user3783243 Over a year ago

@Mesut If you have a different question you should make a new post.

user3783243 · Accepted Answer · 2020-06-29 17:45:30Z

0

Try is code :

 <tbody>
    <?php foreach ($rows as $row)
    {
        $menu_content=json_decode($row['menu_content'],true)
        ?>
    <tr data-id="<?= $row['menu_id'] ?>">
    <td width="90"><?= $row['menu_id'] ?></td>
    <td width="90"><?= $row['menu_title'] ?></td>
    <td><?= $menu_content[0]['title'];?></td>
    <td><?= $row['menu_date'] ?></td>
    </tr>
    <?php 
    } 
    ?>
    </tbody>

edited Jun 29, 2020 at 17:45

user3783243

5,2125 gold badges27 silver badges45 bronze badges

answered Jun 29, 2020 at 15:49

Balamurugan M

6306 silver badges11 bronze badges

3 Comments

M. Eriksson Over a year ago

A good answer includes an explanation of what problem the code solves and why and not just "try this".

Mesut Over a year ago

Inventor Bala are you there?

Balamurugan M Over a year ago

Yes, Mesut. Tell me what you want.

Collectives™ on Stack Overflow

php pdo json encode array

2 Answers 2

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related