PHP add, update, delete

[nuno.nogueira]

Hello again,

I'm looking at your "Batch editing" example.
Could you please share the PHP code for add, update, delete?
It seems you are using different files for the ajax calls.

Thanks in advance for your support!

[paramvir]

PHP code is same as given in the PHP tab.

Rather there are few differences w.r.t URLs for PHP.

I've added comments in js code relevant to PHP

Enable the lines for PHP and comment out the lines specific to ASP.NET

[nuno.nogueira]

That's easier to understand thanks.

I still can't figure out how the data for new rows data is being sent to PHP.

For example, when adding the last row of the attached image, I can see the #consola has logged:

Code: [Select]

[{"orcamento":"10","atual":"20","desvio":"","data":"2015-01-01","nome_conta":"BBB","nome_categoria":"abc","nome_entidade":"def"}] which is the data I want to insert into the table.

But in PHP, nothing is being posted:

Code: [Select]

if( isset($_POST["addList"]))           
{
$addList = json_decode($_POST["addList"], true);
var_dump ($addList);
echo "test";
exit();
}

This is outputing

NULLtest

How do I get the data in PHP so I can build a query and insert it into mySQL?

[paramvir]

data for new rows is sent from line 38 to 50 in js

Did you remove / comment out all lines specific to ASP.NET e.g.

contentType: "application/json; charset=utf-8",//for ASP.NET

[nuno.nogueira]

I did, here's the code for the ajax call:

Code: [Select]

//send to server
            if (addList.length) {
                $.ajax($.extend({}, ajaxObj, {
                    data: { "addList": JSON.stringify(addList) },
                    success: function (rows) {
                        $grid.pqGrid("commit", { type: 'add', rows: rows });
                       
                    },
                    complete: function () {
                        $grid.pqGrid("hideLoading");
                        $grid.pqGrid("rollback", { type: 'add' });
                        $('#consola').text(JSON.stringify(addList));
                    }
                }));

[paramvir]

Could I have a look at your entire js code or a URL.

Your Ajax Call derives from ajaxObj, so more specifically, what's your code in ajaxObj?

[nuno.nogueira]

You may see the whole code in attachment.

ajaxObj is defined before the ajax call.

[paramvir]

WHat do you get with

if( isset($_POST["addList"]))           
{
   var_dump ($_POST["addList"]);

[nuno.nogueira]

I get

Code: [Select]

NULL
I was expecting to get the changed data, as displayed on

Code: [Select]

"#consola".

So the data isn't being sent to PHP and therefore, I'm not able to build the INSERT query to insert it into mySQL.

[paramvir]

Let's try to narrow down the problem.

Try this

data: { "addList": '[{"UnitPrice":"10","Discontinued":false,"ProductName":"new ","QuantityPerUnit":"1","UnitsInStock":"1"}]'  },

instead of

data: { "addList": JSON.stringify(addList) },

[nuno.nogueira]

Same result: nothing is sent to the PHP script.

[paramvir]

Could you send the whole Header log in Firefox (firebug) or chrome (developer tools).
like this:

Request URL:http://localhost:81/paramquery/products.php
Request Method:POST
Status Code:200 OK
Request Headersview source
Accept:application/json, text/javascript, */*; q=0.01
Accept-Encoding:gzip,deflate,sdch
Accept-Language:en-US,en;q=0.8,es;q=0.6
Connection:keep-alive
Content-Length:182
Content-Type:application/x-www-form-urlencoded; charset=UTF-8
Cookie:PHPSESSID=5c7t0ltct2jto36ppe2stv6875
Host:localhost:81
Origin:http://localhost:81
Referer:http://localhost:81/paramquery/editing_batch.php
User-Agent:Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1700.102 Safari/537.36
X-Requested-With:XMLHttpRequest
Form Dataview sourceview URL encoded
addList:[{"UnitPrice":"10","Discontinued":false,"ProductName":"new ","QuantityPerUnit":"1","UnitsInStock":"1"}]
Response Headersview source
Cache-Control:no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Connection:Keep-Alive
Content-Length:249
Content-Type:text/html; charset=UTF-8
Date:Tue, 04 Feb 2014 12:01:23 GMT
Expires:Thu, 19 Nov 1981 08:52:00 GMT
Keep-Alive:timeout=5, max=100
Pragma:no-cache
Server:Apache/2.4.4 (Win32) PHP/5.4.15
X-Powered-By:PHP/5.4.15

[nuno.nogueira]

Here you go:

Code: [Select]

Request URL:http://www.portal-gestao.com/budget/incluir/json4.php
Request Method:POST
Status Code:200 OK
Request Headersview source
Accept:application/json, text/javascript, */*; q=0.01
Accept-Encoding:gzip,deflate,sdch
Accept-Language:pt-PT,pt;q=0.8,en-US;q=0.6,en;q=0.4,pt-BR;q=0.2
Connection:keep-alive
Content-Length:113
Content-Type:application/x-www-form-urlencoded; charset=UTF-8
Cookie:visitas=5; 0cf3259c57baa4009afba854fca3d67b=dc32f988297cb3c57189ccbcd67c7069; 7a36e8ff9b36e11bfd780a779aebf1f2=4C401412+746+B+3+E55165F145F465B5C165E161413165140104F+94A5746+D1538283B2B74272E225D1618; __zlcmid=NEdVg2JezRIIXT; PHPSESSID=a81316b001465431cab6d3b8a15d118f; __utma=187962025.258322195.1391294013.1391443144.1391507878.8; __utmc=187962025; __utmz=187962025.1391426436.5.2.utmcsr=facebook.com|utmccn=(referral)|utmcmd=referral|utmcct=/; __unam=c61f6f0-143efb22cd0-e2b74ec-8; user_key=1
Host:www.portal-gestao.com
Origin:http://www.portal-gestao.com
Referer:http://www.portal-gestao.com/youbudgetz.html
User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36
X-Requested-With:XMLHttpRequest
Form Dataview sourceview URL encoded
addList:[{"orcamento":0,"atual":0,"desvio":"","data":"11-02-2014"}]
Response Headersview source
Cache-Control:max-age=0, no-cache, no-store
Connection:close
Content-Encoding:gzip
Content-Length:30
Content-Type:text/html
Date:Tue, 04 Feb 2014 13:57:47 GMT
Server:Apache/2.2.24 (Unix) mod_ssl/2.2.24 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_fcgid/2.3.6
Vary:Accept-Encoding
X-Mod-Pagespeed:0.9.17.7-716
X-Powered-By:PHP/5.3.24

[paramvir]

I wonder, how are you testing your application when this URL is not working properly (not loading data).

http://www.portal-gestao.com/youbudgetz.html

I believe it was fixed earlier. Am I missing something.

The below url is also not working. throwing SQL error.....

http://www.portal-gestao.com/budget/incluir/json4.php

Code: [Select]

Erro com o JSON exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10' in /home/portalge/public_html/budget/incluir/json4.php:71 Stack trace: #0 /home/portalge/public_html/budget/incluir/json4.php(71): PDO->query('SELECT DATE_FOR...') #1 {main}

Could you please set it right, so that I could have a look.

[nuno.nogueira]

You need a user account to fetch data.

However, I have enabled data for non-users now, so you can test it.