Ad:

PHP Discussion Thread
Marked Solved
Views: 85

Sep 3rd, 2010

accessing specific record using php

Expand Post »

Hi all,

Newbie question;....
I have a database and a table within called 'data'..
I also have a login script that allows users to access it. My question is..how do I make only the user's record viewable/accessible after login. Specifically, how do I access, the a specific record in the database using php code??? ... Some of my variables are $email, $phone, $address.....etc..

I want to display only the users data when they login and I want then to be able to update it...

Hope you can help me a little..

Last edited by lwaterfo; Sep 3rd, 2010 at 3:05 pm.

Similar Threads

Disabling PHP Safe Mode for a specific directory in PHP
Crystal report to get specific record in VB.NET
How to get specific record there in report by passing string parameter from vb.net to in VB.NET
Specific record to make report in VB.NET
Accessing Unicode Data From a MySQL Database With PHP in PHP

lwaterfo

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since Jul 2010

Permalink

Sep 3rd, 2010

Re: accessing specific record using php

When you set up your SQL statement add a WHERE clause to restrict it to the current user.

let's say that the logged on user is in the $user variable. you would code it something like this.

PHP Syntax (Toggle Plain Text)
$sql = 'SELECT * FROM data WHERE userID ='" . $user ."'"
 
$sql = 'SELECT * FROM data WHERE userID ='" . $user ."'"

You should probably substitute the field names you need for the *, but not knowing the layout of your data table this will retrieve everything from that table.

If you are using an MySQL database then you would want to execute the query like this:

PHP Syntax (Toggle Plain Text)
//using mysqli functions
$result = mysqli_query($sql);
 
// using mysql functions
#result = mysql_query($sql);
//using mysqli functions
$result = mysqli_query($sql);

// using mysql functions
#result = mysql_query($sql);

You can find documentation and examples for mysqli functions here.
You can find documentation and examples for mysql functions here.

svilla

Reputation Points: 27

Solved Threads: 27

Junior Poster in Training

Offline

88 posts
since Aug 2010

Permalink

Sep 3rd, 2010

Re: accessing specific record using php

Thanks very much. I think I am beginning to understand a little more...
One question..suppose I named the variable in my 'data' table as 'memberid'...
would I need to make the code read:

PHP Syntax (Toggle Plain Text)
$sql = 'SELECT * FROM data WHERE memberid ='" . $memberid ."'"
 
$sql = 'SELECT * FROM data WHERE memberid ='" . $memberid ."'"

?

or is $user a variable that I can change the name of and have set to user input in the login page?

I am confused with the difference between 'userID' and '$user'...

_________________________________________________________________

Click to Expand / Collapse Quote originally posted by svilla ...

When you set up your SQL statement add a WHERE clause to restrict it to the current user.

let's say that the logged on user is in the $user variable. you would code it something like this.
PHP Syntax (Toggle Plain Text)
$sql = 'SELECT * FROM data WHERE userID ='" . $user ."'"
 
$sql = 'SELECT * FROM data WHERE userID ='" . $user ."'"
You should probably substitute the field names you need for the *, but not knowing the layout of your data table this will retrieve everything from that table.

If you are using an MySQL database then you would want to execute the query like this:
PHP Syntax (Toggle Plain Text)
//using mysqli functions
$result = mysqli_query($sql);
 
// using mysql functions
#result = mysql_query($sql);
//using mysqli functions $result = mysqli_query($sql); // using mysql functions #result = mysql_query($sql);
You can find documentation and examples for mysqli functions here.
You can find documentation and examples for mysql functions here.

lwaterfo

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since Jul 2010

Permalink

Sep 7th, 2010

Re: accessing specific record using php

Your coding example is correct as long as the variable $memberid holds the correct ID number for the current user/member.

In my example the userID is the column name in the database, the $user is a php variable that holds the user/memeber's id.

I am not sure where you are holding the user information once the user has signed in, but in order to have access to this information on every page and eve subsequent requests to the same page you will have to put this information into session or cookie variables. Session variables might make the most sense.

PHP Syntax (Toggle Plain Text)
<?php
session_start();    // required for session variables
 
$_SESSION['memberid'] = $memberid;    // Perform after user has successfully logged in
 
$memberid = $_SESSION['memberid']     // Perform whenever you need access to Member ID
<?php
session_start();    // required for session variables

$_SESSION['memberid'] = $memberid;    // Perform after user has successfully logged in

$memberid = $_SESSION['memberid']     // Perform whenever you need access to Member ID

The session_start function is required to set up a session and access session variables.
The first statement goes into your login script, after the user has provided a good password. You only need this once and you can use unset($_SESSION['memberid']), to remove the session variables when the user logs off.
The second statement is used whenever you need to perform any tests based on the memberid. You can access the $_SESSION['memberid'] variable directly, but if you are going to use it more than once it is best to create a local variable.

svilla

Reputation Points: 27

Solved Threads: 27

Junior Poster in Training

Offline

88 posts
since Aug 2010

Permalink

Sep 22nd, 2010

Re: accessing specific record using php

how would I display the results to the user?
I got the code running but don't know how to display anything..
Here is my entire code:

PHP Syntax (Toggle Plain Text)
 
<?php
session_start();  
 
if (!isset($_SESSION['memberusername'])){  
	header("location:contractorlogin.php");  
	exit();  
}
 
$user = $_SESSION['memberusername'];
$sql = "SELECT Username FROM contractors WHERE Username LIKE'" . $user . "'";
#result = mysql_query($sql);
?>
<?php
session_start();  

if (!isset($_SESSION['memberusername'])){  
	header("location:contractorlogin.php");  
	exit();  
}

$user = $_SESSION['memberusername'];
$sql = "SELECT Username FROM contractors WHERE Username LIKE'" . $user . "'";
#result = mysql_query($sql);
?>

lwaterfo

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since Jul 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: php 5.2 works php 5.3 not working (upload images script)

Next Thread in PHP Forum Timeline: variable query issue

DaniWeb Message

Cancel Changes

User Name
Password