<div>
Do something like this...<br />
<br />

<pre><code id="code-20-42717186-1">$obj = json_decode($json);</code></pre>
<br />
Then access $obj data as a nested hash... maybe like...<br />
<br />

<pre><code id="code-20-42717186-2">$campaign = $obj-&gt;{&quot;output&quot;}-&gt;{&quot;campaign&quot;};

$obj-&gt;{&quot;output&quot;}-&gt;{&quot;campaign&quot;} = &quot;new-campaign-name&quot;;</code></pre>
</div>


Do something like this...



$obj = json_decode($json);


Then access $obj data as a nested hash... maybe like...



$campaign = $obj->{"output"}->{"campaign"};

$obj->{"output"}->{"campaign"} = "new-campaign-name";

Alex Lord

<div>
<div class="content wysiwyg-content">
How do i work with this data ?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396834/Screen-Shot-2018-10-25-at-14.28.50.png" target="_blank" title="column (6 KB)"><img alt="column" class="file-block lazyload" style="max-width: 270px;" data-src="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396834/Screen-Shot-2018-10-25-at-14.28.50.png" /></a><br />
above is the column<br />
<br />
below is the data structure in this column<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396835/Screen-Shot-2018-10-25-at-14.29.00.png" target="_blank" title="data structure (9 KB)"><img alt="data structure" class="file-block lazyload" style="max-width: 309px;" data-src="https://filedb.experts-exchange.com/incoming/2018/10_w43/1396835/Screen-Shot-2018-10-25-at-14.29.00.png" /></a><br />
i am formatting it as json in the column but how do i access is on php from i pull it from the data and select the values of ids i want ?
</div>
</div>


Screen-Shot-2018-10-25-at-14.28.50.png

Screen-Shot-2018-10-25-at-14.29.00.png

How do i work with this data ?



above is the column

below is the data structure in this column



i am formatting it as json in the column but how do i access is on php from i pull it from the data and select the values of ids i want ?

Pulling json formatted data from table and accessing info within that data

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.

JSON

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.