Questions tagged as 'json'

1
answer

Pick up bigger ID and insert Bank

My doubt is that I need to get the ID with the highest value and enter the information in it. The PHP file is working but I need it to identify the ID with the highest VALUE and insert it into it instead of creating another one. StartReport.p...
asked by 12.11.2018 / 00:38
1
answer

Return JSON infos in MYSQL in SELECT itself

I have a table in the DB called "menu", with a column called STRUCTURE. It was of type text, and it contains a JSON with a menu structure referenced by IDs of another table "category".    Ex: ["id": 1}, {"id": 3}, {"id": 4}, {"id": 131} :   5...
asked by 26.12.2018 / 23:49
0
answers

How to display the result of reading an XML file correctly

Good morning, I came up with the need to read an XML file made available in a URL, however, even following the questions already opened here in the stack as: Query the XML URL the data is returned to me with no information and I have a guar...
asked by 24.10.2018 / 15:14
0
answers

Select 2 information from a json

I have the following select to query in the bank the sum of the values of a given day and group by cardBrand . select SUM (amount::numeric)/100, response ->> 'cardBrand' from fatura where duedate::date ='2018-06-15' group by response -...
asked by 31.10.2018 / 17:54
1
answer

Upload a json into a DropDownList Yii2

I recently migrated to the YII 2 framework. And I have one small question: I have a json that I need to pop a DropDownList. The Json file: [ {"codigo": "05", "descricao" : "Administrador"}, {"codigo": "10", "descricao" : "Diretor"}, {"codigo":...
asked by 01.11.2018 / 20:09
0
answers

Function to return only the requests to the logged-in user in question

I have following code to save the requests: save(pedido: any) { var userId = firebase.auth().currentUser.uid return new Promise((resolve, reject) => { if (pedido.key) { this.db.list("pedidos") .update(pedido.key, { name: pedido....
asked by 21.09.2018 / 13:24
0
answers

How to do a Json_Decode of a file in json format

Hello, I'm currently storing json data in a file using fopen. $json = fopen("$root/apil/Controllers/json/" . $this->getX_id() . ".json", "w+"); $customers_results = $customers->fetchAll(PDO::FETCH_OBJ); foreach ($c...
asked by 25.09.2018 / 16:47
2
answers

Dynamic Fields for Controller - ASP.NET MVC

I have this JavaScript which creates new fields for me when I need it and it makes the call to create JSON . This counter within the adicionarCampos() function is required for something else regardless of what I need, even...
asked by 15.10.2018 / 17:16
1
answer

JSON Regular Expression and Deserialization Dictionary

I'm developing a system that receives JSON from multiple layouts over a single channel, and the Router class must identify which layout is handled by regular expression and perform deserialization for the correct class. In the prototype I use...
asked by 27.09.2018 / 15:45
1
answer

Error authenticating Json with php passing header

I'm having a small problem querying a URL with JSON file. Basically my code returns bool(false) . $usuario = 'root'; $senha = '123'; $header = 'Authorization: Basic ' . base64_encode($usuario . ':' . $senha) . "\r\n"; '...
asked by 11.09.2018 / 16:26