CODEWITHSUNDEEP
phpjavascriptajaxxmlhttprequest
Javad Yousefi
Javad Yousefi

Reputation: 2300

send a variable to php with AJAX

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'];
?>

Upvotes: 0

Views: 297

Answers (2)

Jules
Jules

Reputation: 7213

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";
  }
?>

Upvotes: 2

Sascha Galley
Sascha Galley

Reputation: 16091

in JavaScript:

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

in PHP:

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

Upvotes: 5

Related Questions