send a variable to php with AJAX

Question

How I can send rowNumber variable to dataSource php file in this code ?

function getData(dataSource, divID,rowNumber) 
{ 

if(XMLHttpRequestObject)
{
    var obj = document.getElementById(divID); 
    XMLHttpRequestObject.open("GET", dataSource); 
    XMLHttpRequestObject.onreadystatechange = function() 
        { 
            if (XMLHttpRequestObject.readyState == 4 && 
              XMLHttpRequestObject.status == 200) 
            { 
                obj.value = XMLHttpRequestObject.responseText; 
            } 
        } 

        XMLHttpRequestObject.send(null); 
    }
}

PHP File (datasource):

<?php
  //mysql connection
  $result = mysql_query( 'CALL view_polls(`rowNumber`);' );
  $row=mysql_fetch_array($result);
  echo $row['title'];
?>

take a look on JQuery framework...it makes AJAX really easier:) — Paris Liakos
– Paris Liakos, Commented Jul 12, 2011 at 8:30

Sascha Galley · Accepted Answer · 2011-07-12 08:28:17Z

5

in JavaScript:

XMLHttpRequestObject.open("GET", dataSource + '?rowNumber=' + rowNumber);

in PHP:

$result = mysql_query( 'CALL view_polls(`' . $_GET['rowNumber'] . '`);' );

answered Jul 12, 2011 at 8:28

Sascha Galley

16.2k5 gold badges39 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Leonard Over a year ago

Don't forget to sanitize the query and make sure that the query string rowNumber indeed exists: if (isset($_GET['rowNumber']) && is_numeric($_GET['rowNumber'])) { ... }!

Javad Yousefi Over a year ago

Thank You @Sascha Galley very much

Jules · Accepted Answer · 2011-07-12 08:30:58Z

function getData(dataSource, divID,rowNumber) 
{ 

if(XMLHttpRequestObject)
{
    var obj = document.getElementById(divID); 
    XMLHttpRequestObject.open("GET", dataSource + "?rownumber=" + rowNumber); 
    XMLHttpRequestObject.onreadystatechange = function() 
        { 
            if (XMLHttpRequestObject.readyState == 4 && 
              XMLHttpRequestObject.status == 200) 
            { 
                obj.value = XMLHttpRequestObject.responseText; 
            } 
        } 

        XMLHttpRequestObject.send(null); 
    }
}

PHP:

<?php
  if (isset($_GET['rownumber']) && is_numeric($_GET['rownumber'])) {
        $rowNumber = $_GET['rownumber'];
        //mysql connection
        $result = mysql_query( 'CALL view_polls(`' . $rowNumber . '`);' );
        $row=mysql_fetch_array($result);
        echo $row['title'];
  }
  else {
        echo "Error";
  }
?>

Collectives™ on Stack Overflow

send a variable to php with AJAX

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related