user summit Record's

[sire]

im working on a user summit Record's and only they can see the Record and no one els

so im wondering is what is the beat way to how make this work i was thinking of using the users "email" or "ID"?? case username can change though i can make it that the username cant change

what is your input?

thanks,
sire

[mudmin]

Definitely id. So every single record should have a column called user_id (associated with that user's id).

So when you are doing your query, it would be something like...

Code:

$query = $db->query("SELECT * FROM records WHERE user_id = ?",array($user->data()->id));

Code:

$results = $query->results();

Then

Code:

$results

would contain a full object/array of all records associated with that user id.