Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I have a Jquery code that listens for the selection from a user and displays the information that the user needs. The user selects a "folder" and then the content appears after they selected.

There are 2 pages. The first page has the jquery code and the selection box and the div that the information is the be displayed in. Our problem is I got the folder name to pass but I need to pass along the $username as well so that it knows what folders to look up.

This is the first page. It's the selection box and also jquery code.

<script type="text/javascript" src="jquery-1.9.1.min.js">
</script>

<script type="text/javascript">
$(document).ready(function () {
    $("#theselect").change(function() {
var option = $(this).val();
        $.get("selectfolders.php", {select:option},function(data){
            $("#theresult").html(data).hide().fadeIn(1000);
        });
    });
});
</script>




echo "
<select name='thename' id='thename' style='visibility:hidden;' >
<option value='$username'>$username</option>
</select>";
?>
<select name="theselect" id="theselect">
<option value="">Select</option>
<?
$thelistquery = mysql_query("SELECT * FROM folders WHERE username='$username'");
while ($lrows = mysql_fetch_array($thelistquery)) {
$id = $lrows['ID'];
$username = $lrows['username'];
$foldername = $lrows['foldername'];
$newfoldername = mysql_real_escape_string($foldername);

echo "<option value='$newfoldername'>$newfoldername</option>";
}
?>
</select>

This is the second page. It generates the list of folders and displays the folder the user selects on the first page:

$thelistquery = mysql_query("SELECT * FROM folders WHERE username='$username'");
while ($lrows = mysql_fetch_array($thelistquery)) {
$id = $lrows['ID'];
$username = $lrows['username'];
$foldername = $lrows['foldername'];
$newfoldername = mysql_real_escape_string($foldername);

if($_GET['select'] == '$newfoldername') {
echo "This is the $newfoldername folder.";
}
}

We need to add code the the javascript to take the $username from the first page and pass it to the second page so it knows whose folders to look up. Any help?

share|improve this question
@dikirill: Why didn't you make that an answer? – Seth Apr 18 at 19:44
I don't get, how you get from first page to second. – dikirill Apr 18 at 19:54

2 Answers

up vote 0 down vote accepted

I've had a similar problem and this is how i fixed it:

 $("#theselect").change(function() {
    var option = $(this).val();
    var selectedUser = $("#thename").val();
    $.get("selectfolders.php", {select:option,username:selectedUser},function(data){
        $("#theresult").html(data).hide().fadeIn(1000);
    });
 });

For this to work make sure that the username is selected at the moment adding the "selected" HTML attribute to the option. However I think it will be easier if you just use a hidden block:

<input type="hidden" value="$username" name="username" id="username" >
share|improve this answer
if i could up it i would. Thanks everyone! – derekshull Apr 18 at 20:38
up vote 0 down vote 
$.get("selectfolders.php", {select:option, username:username},function(data){});
share|improve this answer
Do I just set the $username as an input type=hidden and it'll send it? – derekshull Apr 18 at 19:52
You can do it like this, or {select:option, username:'<?=$username?>'} – dikirill Apr 18 at 19:54
One more questions. I have this to call the folder name on the second page: '$_GET['select'];' What would be the one to get the username? '$_GET['username']' ? – derekshull Apr 18 at 20:04
You are right, use '$_GET['username']'. – dikirill Apr 18 at 20:06
Still not working. Here's what I have in the script: $.get("selectfolders.php", {select:option, username:'<?=$username?>'},function(data){}); Here's what I have on the second page to call the info: $username = $_GET['username']; – derekshull Apr 18 at 20:12
show 3 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.