upload data to server from javascript to php using ajax

Question

I need to upload websql table to the server using ajax. when I use indexed array or simple variable code works fine. I cant figure out what problem is? plz help me. thanks in advance... here is javascript:

function upload()
{

var db = cropsap.webdb.db;

 db.transaction(function (tx) {

                tx.executeSql('SELECT * from survey', [],function(tx, results) {
                    var data = "";
                    var survey=[];
                    for(var i=0; i < results.rows.length; i++) {
                        var row = results.rows.item(i); 
                        var result = [];


                        for(var key in row) 
                        {         
                            result[key] = row[key];  
                        }     
                        survey.push(result);
                    }
                    //alert(survey[0]['srno']);//here i get output

               var url = "";
                url = document.getElementById("url").value;
                $.ajax({
                    type: "POST",
                    url: url,
                    async: true,

                    data: { "data": JSON.stringify(survey) },
                    error: function () { alert("error occured");},
                    success: function (data) {

                        alert("sucess");
                        alert(data);

                    }
                });
            });
        });
}

php code:

<?php
$survey= json_decode(stripslashes($_POST['data']));

        $len = sizeof($crop_insect_survey_details);
        print(" len: ".$len);

            for($i=0;$i<$len;$i++)
        {
            $srno = $crop_insect_survey_details[$i]['srno'];//here cant get output
            $name = $crop_insect_survey_details[$i]['name'];
            print("srno:".$srno);
            print("name:".$name);
        }

    ?>

I changed var result = []; to var result = {}; now i can echo 'data' but in php file $len value giving wrong — SysAdmin, Apr 20 '16 at 10:35
`Object` doe not have `.length` property! You must have `[]` — Rayon, Apr 20 '16 at 10:40
Check what data is being transmitted over network... Use `Developers tools!` — Rayon, Apr 20 '16 at 11:03
I got reason of my problem there is one field in database which holds date and time .when I skip that field code works fine but I need that field also — SysAdmin, Apr 21 '16 at 09:26
Can you share `data` object being sent ? Also share the `schema` of your database! — Rayon, Apr 21 '16 at 10:08
here is my create table query CREATE TABLE if not exists survey( srno integer primary key autoincrement, survey_code bigint NOT NULL, cir_code integer NOT NULL, ins_code integer NOT NULL, updatedby bigint NOT NULL, updateddatetime timestamp without time zone NOT NULL)///updateddatetime gives problem — SysAdmin, Apr 21 '16 at 10:17
I set as datetime but still facing same problem. actually it takes date but not taking time — SysAdmin, Apr 21 '16 at 13:04

score 0 · Answer 1 · answered Apr 20 '16 at 06:26

0

Instead of using data: { "data": JSON.stringify(survey) }, You can pass your data inside data key itself.

data:JSON.stringify(survey)
dataType: "json",
contentType: "application/json; charset=utf-8",

answered Apr 20 '16 at 06:26

Afshan Shujat

541
4
9

it prints "error occured" message, what changes i have to do in php code? – SysAdmin Apr 20 '16 at 06:38
where it's printing "error occured" in js file or php? You can user php php://input to receive data at php file. – Afshan Shujat Apr 20 '16 at 08:31
file_get_contents("php://input"), use this syntax it will help you. – Afshan Shujat Apr 20 '16 at 08:35
after including file_get_contents("php://input") still it gives same message.it calls error function declared in ajax – SysAdmin Apr 20 '16 at 10:27
You can see in the console what is actual error there and can print the error in comsole see this for debugging http://stackoverflow.com/questions/36758922/how-to-post-data-to-php-file-using-ajax/36759072#36759072 – Afshan Shujat Apr 21 '16 at 05:20
I used error: function (xhr, status, error) { alert(error); }..it gives alert like-- syntaxError:Unexpected token l – SysAdmin Apr 21 '16 at 06:35
It happens sometimes for malformed json, try the same request after removing contentType from ajax request. – Afshan Shujat Apr 21 '16 at 06:41

upload data to server from javascript to php using ajax

1 Answers1