Saving data with ajax to a database

Question

How can I save info that I have in a div named '#time' to a database?

<div id="time" style="float:right;font-size:15px;">0:00:00</div>

The code above is a jq count up timer. What I'm trying is to save every tick in the database. How can I do this?

$.ajax({
                    type: "POST",
                    url: "setupcounter.php",
                    data: {action: 'save',
                    field: $("#time").val(),},
                    success: function(msg){

                    }
                    error: function(){
                        alert('error');
                    }
                });

edited the post with the ajax i tried, i dont know what i need to write in the php file. — Roy, Feb 01 '16 at 07:56
`$_POST[ 'field' ]` holds the data you are looking for. How to save an entry to a database is an entirely different subject. You should at least try something for yourself first. There's many tutorials to find on the subject. — Rein, Feb 01 '16 at 08:00
Possible duplicate of [jQuery Ajax POST example with PHP](http://stackoverflow.com/questions/5004233/jquery-ajax-post-example-with-php) — Rein, Feb 01 '16 at 08:01
@rein i know how to save it to the database, just asking how do i save it as a variable. — Roy, Feb 01 '16 at 08:12
Where exactly does it go wrong? The data can be accessed from within your javascript by: `$("#time").val()`, once you made a successful post to your PHP script, you can access the posted data by using `$_POST['field']`. — Rein, Feb 01 '16 at 08:19
Thats the php file code: `` all I tried was to echo it to check but i get undefined index. — Roy, Feb 01 '16 at 08:20
on the chrome network i can see that the post was recived and i can see the correct time on the preview, but on the page I cant. — Roy, Feb 01 '16 at 08:21
`Notice: Undefined index: field in C:\xampp\htdocs\comp\setupcounter.php on line 1` — Roy, Feb 01 '16 at 08:22

Amit Rajput · Answer 1 · 2016-02-01T08:03:53.237

1

Actually you want to get text of div. So do this..

Just replace

$("#time").val()

with

$("#time").text()

edited Feb 01 '16 at 08:03

answered Feb 01 '16 at 07:57

Amit Rajput

2,061
1
9
27

and how do i get it from the php file? $_POST what? – Roy Feb 01 '16 at 07:57
Should be: `$_POST["field"]` – erikscandola Feb 01 '16 at 08:00
Yes, you can get it in php as $_POST["field"] – Amit Rajput Feb 01 '16 at 08:01
`Notice: Undefined index: field in C:\xampp\htdocs\***\setupcounter.php on line 3` – Roy Feb 01 '16 at 08:04
and it made my xampp crash :/ – Roy Feb 01 '16 at 08:06
That means your `$_POST` did not contain the value you were trying to get from it. Try to do a `var_dump( $_POST )` to see what's inside of your post. – Rein Feb 01 '16 at 08:20
you arent supposed to actually use $_POST['field'], roy. switch out field with whatever post param you actually use. – Havihavi Feb 02 '16 at 10:38

Havihavi · Answer 2 · 2016-02-02T10:36:22.643

0

        var time = $('#time').val();
        //Just add whatever params you need to the datastring variable.
         var dataString = 'time='+time+'&action=save';
        //Check console that you are sending the right data
        console.log(dataString) 
        $.ajax({
             type: "POST",
             url: "setupcounter.php",
             data: dataString,
             success: function(msg){
              console.log(msg);
              }
     });

In php you would do:

$time = $_POST['time'];
$action = $_POST['action'];
//Db stuff

Fiddle

edited Feb 02 '16 at 10:36

answered Feb 01 '16 at 14:37

Havihavi

652
1
9
26

and i get on the php page undefined index again. – Roy Feb 01 '16 at 14:43
There's not really anything wrong with this. updated it and added a fiddle. mind you, theres no real .php to test it with in jsfiddle. i use this snippet all the time. – Havihavi Feb 02 '16 at 10:37

Saving data with ajax to a database

2 Answers2