php变量通过jquery ajax到外部php

Question

i found a php/jquery/ajax script that has a textfield that is sent after the user clicks the input to an external php script to be written into a mysql database. http://gazpo.com/2011/09/contenteditable/

whats missing is the userid passed into the external php file:

$sql = "UPDATE customer SET comment = '$content' WHERE userid = 12345 ";

here is what i do: i am catching the user id in the main file with:

$s = $_GET['contact'];

from the url parameter.

then i put it in to my db select in the main php:

$sql = "select customer from user where userid = $s";  

then there are some div

<div id="content">
    <div id="editable" contentEditable="true">

followed by the ajax script:

$(document).ready(function() {  
    $("#save").click(function (e) {         
        var content = $('#editable').html();
        var content_two = $('#editable_two').html();            
        $.ajax({
            url: 'save2.php',
            type: 'POST',
            data: {
                content: content
            },  

in the save.php there is this:

$content = $_POST['content']; //get posted data     
$sql = "UPDATE customer SET comment = '$content' WHERE userid = "XXXX" ";

So: how do i get the $s variable from my url parameter into the "XXXX"

Answer 1

Add userid to the data you pass from your ajax call back to save.php.

data: {
    content: content,
    userid: <?= $s ?>
}

This is a guess without seeing the rest of your code and how the code actually renders the page.