Solved

How do I use jQuery to SEND data to the server?

Posted on 2011-09-27
5
165 Views
Last Modified: 2012-06-27
I'm trying to learn a little jquery. Completely NEW to it. It looks pretty powerful but everything I've seen thus far uses jQuery to GET/LOAD/RETREIVE data FROM the server to poulate/manipulate the HTML page.

I want to use jQuery to PUT data to the server.

Within my HTML code I want to launch jQuery to execute a php script along with a value. The php script will $_POST or $_GET the value and INSERT it INTO the mysql db.

Please provide snipet of code to show jQuery in PUTting data TO a server. Thanks in advance to all who provide comments.
0
Comment
Question by:kbios
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:PranjalShah
ID: 36713820
0
 
LVL 8

Accepted Solution

by:
PranjalShah earned 500 total points
ID: 36713824
0
 

Author Comment

by:kbios
ID: 36713895
Thanks for the links. Being new to this I find them slightly obscure and hard to follow. Does the data being sent HAVE to originate in a form? The data that I want to send will ultimately be retreived from localStorage.

To test I've put together an HTML that has the jQuery and the php script that is trying to receive the data element and update mysql. Please review the snipets and kindly provide additional comments.

HTML  code:

<script type="text/javascript">
   $document.ready(function(){
       $.post("testqitem.php", {item:"3772"});
   });
</script>


php script:

 $item = $_POST['item'];
            
<?php
    $conn = mysql_connect("localhost", "X", "Y") or die(mysql_error());
    mysql_select_db("test");
    mysql_query("INSERT INTO itemdtl (ukey, item)
            VALUES ("XXXX10000", '$item')");
    mysql_close($conn);
?>
0
 

Author Comment

by:kbios
ID: 36714096
**** UPDATED CODE ****

After reviewing and lifting the code from the ryancoughlin link I have the following code that I am testing. To test I'm using the form but I will change later to either use a hidden item or localStorage.

In the meantime please review the code: The mysql table is NOT getting updated. I think it may be related to the success portion of the ajax logic. Please review and comment.

<FORM id=submit method=post>  
   <FIELDSET>  
      <INPUT id=item class=text size=20 type=text name=item>  
      <BUTTON class="button positive" type=submit> Add Item </BUTTON>  
   </FIELDSET>  
</FORM>
            
<script type="text/javascript">
   $(document).ready(function(){  
   $("form#submit").submit(function() {  
          var item = $('#item').attr('value');  
            $.ajax({  
               type: "POST",  
               url: "testjqitem.php",
               data: "item="+item;  
               success: function(){  
               }  
            });  
            return false;  
          });  
        });  
</script>


Here is the php script:


$item = htmlspecialchars(trim($_POST['item']));  

<?php
    $conn = mysql_connect("localhost", "X", "Y") or die(mysql_error());
    mysql_select_db("test");
    mysql_query("INSERT INTO itemdtl (ukey, item)
            VALUES ("XXXX10000", '$item')");
    mysql_close($conn);
?>
0
 

Author Closing Comment

by:kbios
ID: 36716897
Thanks. The link was most helpful. The problem is not resolved but this helped to point me in the right direction.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to Generate log or file on inserting duplicate records in mysql 6 33
Mysql sync between 3-4 mysql db 4 25
html5 auto send email 7 22
Capture logon name 13 37
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
In this tutorial viewers will learn how add a scalable full-width header using CSS3. Create a new HTML document with an internal stylesheet. Set a tiled background.:  Create a new div and name it Header. Position it with position:absolute at the top…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now