Send jquery variable back to PHP and use in mySQL

Question

I am a complete newbie in ajax, but I read that Ajax is the only way to store a variable from jQuery and send it back to PHP to use it.

As you can see in this example, I have a drop down list populate from a MySQL database:

$query = "SELECT * FROM my_gallery";
$execute = mysqli_query($link, $query); 

$results = mysqli_num_rows($execute);

if ($results!=0) {
    echo '<label>The galleries are: ';
    echo '<select id="galleries" name="galleries">';
    echo '<option value=""></option>';

    for ($i=0; $i<$results; $i++) {
        $row = mysqli_fetch_array($execute);
        $name = htmlspecialchars($row['galleryName']);

        echo '<option value="' .$name. '">' .$name. '</option>';
    }
   echo '</select>';
   echo '</label>';
}

With jQuery I add the selected attribute:

$('#page').change(function(e) {
    e.preventDefault();
    var selectedOption = $(this).find('option:selected');
    $('#page option').removeAttr('selected');
    $(selectedOption).attr('selected','selected');
    var selectedOptionValue = $(selectedOption).val();
    var selectedOptionText = $(selectedOption).text();


    alert("You selected " + selectedOptionText + " Value: " + selectedOptionValue);
});

jsFiddle to see it in action

How can I store the selected option in a variable and send it back to PHP? Never used ajax, so please be as much detailed as possible and patience! :)

The option value= with the selected="selected"attribute added. — Mark
– Mark, Commented Feb 27, 2014 at 17:07
learn jQuery ajax on here https://api.jquery.com/jQuery.ajax/ — Pranav C Balan
– Pranav C Balan, Commented Feb 27, 2014 at 17:07
change data: {selected : selectedOption}, to data: {selected : selectedOptionValue}, — Pranav C Balan
– Pranav C Balan, Commented Feb 27, 2014 at 17:10

coder29 · Accepted Answer · 2014-02-27 17:15:38Z

2

I updated your jsfiddle

http://jsfiddle.net/sQ7Y9/2/

basically you would need to add this to your code:

$.ajax({
      url: 'your url', //the url that you are sending data to
      type: 'POST', //the method you want to use can change to 'GET'
      data: {data : selectedOptionText}, //the data you want to send as an object , to receive in on the PHP end you would use $_POST['data']
      dataType: 'text', //your PHP can send back data using 'echo' can be HTML, JSON, or TEXT
      success: function(data){
       //do something with the returned data, either put it in html or you don't need to do anything with it
      }
});

answered Feb 27, 2014 at 17:15

coder29

1756 bronze badges

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

Comments

user3165652 · Accepted Answer · 2014-02-27 17:18:00Z

2

With some jquery

$.ajax({
  type: "GET",
  url: "some.php",
  data: "a="+$('#galleries option').filter(':selected').text()+"&b=someval",
  beforeSend: function() {  },
  success: function(html){ 
    $('#content').html(html);
  }
});

..and php

echo "a = ". $_GET['a'];

answered Feb 27, 2014 at 17:18

user3165652

Comments

Pranav C Balan · Accepted Answer · 2014-02-27 17:20:34Z

1

If you want to send ajax request on change event then try

$('#galleries').change(function() {
    var selected = $(this).val(); // getting selected value
    $.ajax({
        url: "upload.php", // url to send ajax request
        type: "POST", // request method
        data: {selected: selected}, // passing selected data
        success: function(data) { // success callback function
            alert(data); // the response data
        }
    });
});

In your upload.php

<?php

$selected=$_POST['selected']; //getting the selected value
//other code    
echo "your result";

?>

edited Feb 27, 2014 at 17:20

answered Feb 27, 2014 at 17:15

Pranav C Balan

115k25 gold badges172 silver badges195 bronze badges

Collectives™ on Stack Overflow

Send jquery variable back to PHP and use in mySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related