Блог

это данные полей wpforms в json, но я хочу искать данные по назначению столбцу, но я не запрашиваю в mysql, я не настолько профессионален.

 {
   "41":{
      "name":"Quote No",
      "value":1,
      "id":41,
      "type":"hidden"
   },
   "51":{
      "name":"Quote Reference",
      "value":"Q1_Test",
      "id":51,
      "type":"hidden"
   },
   "43":{
      "name":"Quote Date",
      "value":"23 September 2021 5:07 pm",
      "id":43,
      "type":"hidden"
   },
   "93":{
      "name":"Pricing",
      "value":"",
      "id":93,
      "type":"hidden"
   },
   "49":{
      "name":"Quote Status",
      "value":"Processing",
      "value_raw":"Processing",
      "id":49,
      "type":"select"
   },
   "52":{
      "name":"Status",
      "value":"New",
      "id":52,
      "type":"hidden"
   },
   "47":{
      "name":"Customer Name",
      "value":"Ethan Wayne",
      "id":47,
      "type":"hidden"
   },
   "6":{
      "name":"Design Name",
      "value":"Test",
      "id":6,
      "type":"text"
   },
   "7":{
      "name":"File Upload 1",
      "value":"https://wow-embroidery-collection-4c3353.ingress-erytho.easywp.com/wp-content/uploads/2021/09/CITGO-693bdd733d7cb7d323db727ea542003d.jpg",
      "value_raw":[
         {
            "name":"CITGO.jpg",
            "value":"https://wow-embroidery-collection-4c3353.ingress-erytho.easywp.com/wp-content/uploads/2021/09/CITGO-693bdd733d7cb7d323db727ea542003d.jpg",
            "file":"CITGO-693bdd733d7cb7d323db727ea542003d.jpg",
            "file_original":"CITGO.jpg",
            "file_user_name":"CITGO.jpg",
            "ext":"jpg",
            "attachment_id":7513,
            "id":7,
            "type":"image/jpeg"
         }
      ],
      "id":7,
      "type":"file-upload",
      "style":"modern"
   },
   "57":{
      "name":"Reference Number",
      "value":"",
      "id":57,
      "type":"hidden"
   },
   "8":{
      "name":"Instructions",
      "value":"",
      "id":8,
      "type":"textarea"
   },
   "14":{
      "name":"",
      "value":"",
      "value_raw":"",
      "id":14,
      "type":"checkbox"
   },
   "27":{
      "name":"Required Format",
      "value":"",
      "value_raw":"",
      "id":27,
      "type":"select"
   },
   "17":{
      "name":"Other Format",
      "value":"",
      "id":17,
      "type":"text"
   },
   "32":{
      "name":"Fabric",
      "value":"",
      "value_raw":"",
      "id":32,
      "type":"select"
   },
   "33":{
      "name":"Placement",
      "value":"",
      "value_raw":"",
      "id":33,
      "type":"select"
   },
   "20":{
      "name":"Width",
      "value":"",
      "id":20,
      "type":"text"
   },
   "21":{
      "name":"Height",
      "value":"",
      "id":21,
      "type":"text"
   },
   "28":{
      "name":"Measurement",
      "value":"",
      "value_raw":"",
      "id":28,
      "type":"select"
   },
   "22":{
      "name":"Number of Colors",
      "value":"",
      "id":22,
      "type":"text"
   },
   "23":{
      "name":"Fabric Color",
      "value":"",
      "id":23,
      "type":"text"
   },
   "29":{
      "name":"Color Blending?",
      "value":"",
      "value_raw":"",
      "id":29,
      "type":"radio"
   },
   "30":{
      "name":"Background Fill?",
      "value":"",
      "value_raw":"",
      "id":30,
      "type":"radio"
   },
   "31":{
      "name":"Picture Embroidery?",
      "value":"",
      "value_raw":"",
      "id":31,
      "type":"radio"
   },
   "37":{
      "name":"CC- Email",
      "value":"",
      "id":37,
      "type":"email"
   },
   "76":{
      "name":"Customer Email",
      "value":"ethanwaynedx@gmail.com",
      "id":76,
      "type":"email"
   },
   "48":{
      "name":"Super Urgent",
      "value":"No",
      "value_raw":"No",
      "id":48,
      "type":"radio"
   },
   "77":{
      "name":"Company Name",
      "value":"WOW Embroidery Collection",
      "id":77,
      "type":"hidden"
   },
   "92":{
      "name":"Customer First Name",
      "value":"Ethan",
      "id":92,
      "type":"hidden"
   },
   "91":{
      "name":"Customer Last Name",
      "value":"Wayne",
      "id":91,
      "type":"hidden"
   },
   "78":{
      "name":"User ID",
      "value":"1",
      "id":78,
      "type":"hidden"
   },
   "79":{
      "name":"Customer billing Currency",
      "value":"GBP",
      "id":79,
      "type":"hidden"
   },
   "80":{
      "name":"Website URL",
      "value":"",
      "id":80,
      "type":"hidden"
   },
   "81":{
      "name":"Customer Billing Address",
      "value":"International House 12 Constance Street",
      "id":81,
      "type":"hidden"
   },
   "85":{
      "name":"Customer Billing Country",
      "value":"Pakistan",
      "id":85,
      "type":"hidden"
   },
   "86":{
      "name":"Customer Billing City",
      "value":"London",
      "id":86,
      "type":"hidden"
   },
   "87":{
      "name":"Customer Billing Zip code",
      "value":"aE16 2DQ",
      "id":87,
      "type":"hidden"
   },
   "88":{
      "name":"Customer Billing State",
      "value":"",
      "id":88,
      "type":"hidden"
   },
   "89":{
      "name":"Customer Username",
      "value":"admin",
      "id":89,
      "type":"hidden"
   },
   "90":{
      "name":"Customer Billing Phone",
      "value":"(447) 927-7530",
      "id":90,
      "type":"hidden"
   },
   "94":{
      "name":"admin assign",
      "value":"admin",
      "id":94,
      "type":"hidden"
   },
   "95":{
      "name":"Assign To",
      "value":"M.Junaid",
      "value_raw":"51",
      "id":95,
      "type":"select",
      "dynamic":"taxonomy",
      "dynamic_items":"51",
      "dynamic_taxonomy":"Assigned Worker"
   },
   "96":{
      "name":"Additional",
      "value":"",
      "id":96,
      "type":"textarea"
   },
   "97":{
      "name":"Additional image address",
      "value":"https://wow-embroidery-collection-4c3353.ingress-erytho.easywp.com/wp-content/uploads/2021/09/CITGO-693bdd733d7cb7d323db727ea542003d.jpg",
      "id":97,
      "type":"textarea"
   }
}