Jquery PHP getting SQL database variables

Question

I've got a link that "toggles" a div to show and hide in a page called "notifications.php". I want to data in the div to be retrieved from a page called "getnotes.php".

I've succeeded is get the div to show and hide, as well as getting the div to echo whatever the getnotes.php file has but when I try to use SQL to get data in the getnotes.php page it won't get the information.

In the code below I'm simply trying to get the username to display. It will be used for more than retrieving a username but for the purposes of this thread, we're retrieving a username.

notifications.php

//allow sessions to be passed so we can see if the user is logged in
session_start();
ob_start();

//connect to the database so we can check, edit, or insert data to our users table
$con = mysql_connect('SERVER',  'NAME', 'PASSWORD') or die(mysql_error());
$db = mysql_select_db('NAME', $con) or die(mysql_error());

//include out functions file giving us access to the protect() function made earlier
include "./functions.php";

//In the header
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script>
<script type="text/javascript">
function toggleDiv(divId) {
   $("#"+divId).toggle();
$(document).ready(function(){
         $("#myContent").load("getnotes.php?name=<? echo $username; ?>");
    });
}
</script>

//In the body
<a href="javascript:toggleDiv('myContent');">Notes</a><br>
<div id="myContent" style="display:none; background-color: #aaa; padding: 5px 10px;"> 
</div>

getnotes.php

//allow sessions to be passed so we can see if the user is logged in
session_start();
ob_start();

//connect to the database so we can check, edit, or insert data to our users table
$con = mysql_connect('SERVER',  'NAME', 'PASSWORD') or die(mysql_error());
$db = mysql_select_db('NAME', $con) or die(mysql_error());

//include out functions file giving us access to the protect() function made earlier
include "./functions.php";

//Look up the username and see if they are logged in.
$userid = $_SESSION['uid'];
$lookupusername = mysql_query("SELECT * FROM users WHERE ID='$userid'");
$row = mysql_fetch_assoc($lookupusername);
$username = $row['username'];

echo "you are $username";

Why won't the SQL queries work in getnotes.php?

There is no more support for mysql_* functions, they are officially deprecated, no longer maintained and will be removed in the future. You should update your code with PDO or MySQLi to ensure the functionality of your project in the future. — Schleis
– Schleis, Commented Apr 30, 2013 at 21:06

nietonfir · Accepted Answer · 2013-04-30 21:15:04Z

1

$lookupusername = mysql_query("SELECT * FROM users WHERE ID=" + $userid);

But please, use prepared statements.

edited Apr 30, 2013 at 21:15

answered Apr 30, 2013 at 21:09

nietonfir

4,8916 gold badges34 silver badges46 bronze badges

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

6 Comments

derekshull Over a year ago

I plugged in the code but didn't fix the issue. It gave the error of mysql_fetch_assoc() expects parameter 1 to be resource, boolean given

nietonfir Over a year ago

@derekshull Then maybe $userid is wrong? Try the query with a hard-coded value and output the value of $userid.

derekshull Over a year ago

I'm not getting a $userid. After hardcoding it, it worked fine. Any ideas?

nietonfir Over a year ago

@derekshull There's eventually nothing in $_SESSION['uid']? From your snippets I can't see where/how/why it's set.

derekshull Over a year ago

is there a way to pass along the userid from the notifications.php page? That would work but I've not got a clue how to do it.

|

Jarek Jakubowski · Accepted Answer · 2013-04-30 21:17:05Z

0

Your code looks ok, you probably have a problem somewhere else. Try to print your session:

print_r($_SESSION);

and look if $_SESSION['uid'] has the right user id.

answered Apr 30, 2013 at 21:17

Jarek Jakubowski

97510 silver badges22 bronze badges

4 Comments

derekshull Over a year ago

Tried it and it just says Array ( ). I really don't know what's wrong with it. so strange.

Jarek Jakubowski Over a year ago

As i said, you have problem in another place. Search for a place where you write user id to session (logging area?).

derekshull Over a year ago

is there a way to pass along the userid from the notifications.php page? That would work but I've not got a clue how to do it.

Jarek Jakubowski Over a year ago

You already pass user name here: ?name=<? echo $username; ?> (assuming you define $username somewhere). You can easily change this to pass user id (remember to control what you pass to sql query...)

Collectives™ on Stack Overflow

Jquery PHP getting SQL database variables

2 Answers 2

6 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related