0

How can I delete the bold object from a Mysql column?

0: {print_ref:289, art_work:, status:New Artwork, supplier:A+A Kumas, customer:New Look, department:915,…}
art_work: ""
colorway_description: "11"
colorway_version: "11"
customer: "New Look"
date_sent_to_supplier: "0000-00-00"
date_strike_off_received: "0000-00-00"
department: "915"
dud: "1"
fabric_base: "11"
fabric_notes: [{notes:admin, user:1}, {notes:admin, user:1}, {notes:andre, user:2}, {notes:andrew, user:2},…]
fullimage: "images/noimage64.jpg"
notes: "[**{"notes":"admin","user":"1"}**

,{"notes":"admin","user":"1"},{"notes":"andre","user":"2"},{"notes":"andrew","user":"2"},{"notes":"andrew","user":"2"},{"notes":"admin","user":"1"}]"

1
Contributor
1
Reply
12
Views
3 Years
Discussion Span
Last Post by psekhon
0
How can I delete the bold object from a Mysql column?



file name del_notes
    $data = file_get_contents("php://input");
    $o = json_decode($data,1);
    $print_ref = $o['print_ref'];
    $notes = $o['notes'];//notes: "[**{"notes":"admin","user":"1"}**
    $index = $o['index'];//1
    $fabric=$o['fabric_notes'];//fabric_notes: [{notes:admin, user:1}, {notes:admin, user:1}, {notes:andre, user:2}, {notes:andrew, user:2},…]

$notes is an object withing a fabric_notes array.

I at the Mysql query.   
I am using PHPand Angular js
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.