Getting id from sql into php page

[pvtpyro]

Hello,
I've recently learned a script that would write files.
i'm having a problem getting the files named after the users id.

for instance:
2873.txt

how would I get the user id from my sql table?

[cgraz]

$query = mysql_query("SELECT user_id FROM your_table WHERE email='".$email."'") or die(mysql_error());

$row = mysql_fetch_assoc($query);

print "User ID" . $row['user_id'];

If you want to select one specific user id from the table, then you need to know something unique about the user such as their email. If you're just trying to SELECT all users, then loop through the results and grab their user id's, then drop the WHERE clause in the query and use a while loop on $row = mysql_fetch_assoc....

[pvtpyro]

yes, I want the specific user id of the person logged in.
so whoever creates the file it will be named after their id.

[cgraz]

Well then you have to know something about them if they are logged in. Their email? username? If you had their username in a session, you'd just do this:

 $query = mysql_query("SELECT user_id FROM your_table WHERE username='".$_SESSION['username']."'") or die(mysql_error()); 

[pvtpyro]

hmm.. ok.

here's what i have so far.

<?php

// the name of the xml file
$file = "blah.xml";

// the data
$data = "<?xml version=\"1.0\"?>\n";
$data .= "<document>\n";
$data .= "\t<tag>Tag Data</tag>\n";
$data .= "</document>";

// open the file and write the data to it
$p = fopen( $file , 'w' );
$w = fwrite( $p , $data );
$c = fclose( $p );

// a message
echo "The data was sucessfully added to the file $file";

?> 

there is no way to replace blah with their id? heck even user name.
they are already in session when coming to this screen.

I apologize for not explaining in more detail the first time. this is difficult for me.

edit: their user id is already unique.

[RedMaster]

Hmm do you use DB?
If you use, you should use sessions when somebody login in your site 🙂 End the call the DB for the name of the user 😉

[pvtpyro]

hey i'm a newbie remember? lol

i use sessions. that's what i'm getting at. I don't know how to get the persons user id to show up on the page.

[cgraz]

That's what I explained in my previous posts! Here's how you'd get the filename. Just replace the table and field names with yours.

<?php

$query = mysql_query("SELECT user_id FROM yourTable WHERE username='".$_SESSION['username']."'") or die(mysql_error());
$row = mysql_fetch_assoc($query) or die(mysql_error());

// the name of the xml file
$file = $row['user_id'] . '.xml'; 

[pvtpyro]

oh okay! woo i'm making progress.

the only part giving me problems is this:

$query = mysql_query("SELECT uid FROM xoops_users WHERE uname='".$_SESSION['uname']."'") or die(mysql_error());
$row = mysql_fetch_assoc($query) or die(mysql_error());

i'm thinking it's the way i'm set up.

my table is called "xoops_users"
the field under that is called "uid" which is their user id.
should the above code be changed at all now?

[cgraz]

underneath that $row = line add this and copy and paste the results:

print "User ID: " . $row['uid'] . "<br />";
print "SELECT uid FROM xoops_users WHERE uname='".$_SESSION['uname']."'";

[pvtpyro]

i get a blank page

[cgraz]

Then there is something seriously wrong because even if your variables were not set, you'd still see:

User ID:
SELECT uid FROM xoops_users WHERE uname='';

EDIT: What is your error reporting set to? You might have a parse error, but with errors off, you're just seeing a blank page.

[pvtpyro]

my errors are on as far as i can tell.

it doesn't matter that uid and uname are completely different fields directly under xoops_users?

edit: when i add plain text before the <?php the page see's that fine when i refresh. it's like the php just disappears from the page with that little bit of code

[pvtpyro]

ok when i removed this line:

$query = mysql_query("SELECT uname FROM xoops_users WHERE uname='".$_SESSION['uid']."'") or die(mysql_error());
$row = mysql_fetch_assoc($query) or die(mysql_error());

leaving only this:

<?php

print "User ID: " . $row['uid'] . "<br />";
print "SELECT uid FROM xoops_users WHERE uname='".$_SESSION['uname']."'"; 

// the name of the xml file
$file = $row['uid'] . '.xml';


// the data
$data = "<?xml version=\"1.0\"?>\n";
$data .= "<document>\n";
$data .= "\t<tag>Tag Data</tag>\n";
$data .= "</document>";

// open the file and write the data to it
$p = fopen( $file , 'w' );
$w = fwrite( $p , $data );
$c = fclose( $p );

// a message
echo "The data was sucessfully added to the file $file $uid";

?> 

my page loaded this:
User ID:
SELECT uid FROM xoops_users WHERE uname=''The data was sucessfully added to the file .xml

[cgraz]

$_SESSION['uname'] isn't holding anything. is that the variable that is holding your visitor's username? How do you set the username in a session? Also, what does

print_r($_SESSION);

give you? do you have session_start() at the top of all your scripts requring the sessions?

[pvtpyro]

print_r($_SESSION);

gives me this:

Array ( [xoopsUserId] => 1 [xoopsUserGroups] => Array ( [0] => 1 [1] => 2 ) [xoopsUserTheme] => x2t [XOOPS_TOKEN_SESSION] => Array ( [0] => Array ( [id] => 746e89c2bfded413c2c76f196b2cd89e [expire] => 1153943098 ) ) )

[pvtpyro]

does this help any? this is how i'm setup.

http://www.xoopsforge.com/ref/nav.html?index.html

[cgraz]

do you see how $SESSION['user_id'] doesn't exist when you print_r($SESSION)?

$SESSION is an array holding values. You were trying to select a row from the database where someone's user_id = $SESSION['user_id']. But since $_SESSION['user_id'] doesn't even exist, the database couldn't possibly return anything since you're asking it to give you the user whose user_id is NULL (empty), and there are none.

Now look at your print_r. The key in that array that we were looking for is xoopsUserId, not user_id.

Now I don't know what you have your user id column named in the database. You are going to need to figure that out or this will never work. I'm going to assume it's called user_id for the sake of simplicity. Once you figure out what it is, you'll need to replace it in your SELECT statement and when you call $row['user_id'] (replace user_id with your column). Then use this code:

$query = mysql_query("SELECT user_id FROM yourTable WHERE username='".$_SESSION['xoopsUserId']."'") or die(mysql_error());
$row = mysql_fetch_assoc($query) or die(mysql_error());

// the name of the xml file
$file = $row['user_id'] . '.xml';