PHP/MYSQL Getting only one Column Value by ID

Question

I am new here, and i got a bit of web development skills, and because in my new project I need User information on different bits of application, I was wondering is it all right to put the whole user row in a session array or to get data each time from database if so what is the easiest way to get a column (Cell) data based on ID from MYSQL with PHP ?

Thanks

Update: to be a bit more specific like i need usertype, name , email, msgs and stuff like this.

Do you already have the database that you need to get the usertype etc. from? Are you having trouble getting the data? — Explosion Pills
– Explosion Pills, Commented Dec 4, 2010 at 5:16
Thanks for answer tandu, Yes i got the database I am wondring which way is batter putting the whole raw in session or get them from database when ever in need ? from point of resource and security ? — user529649
– user529649, Commented Dec 4, 2010 at 5:19

Bhanu Prakash Pandey · Accepted Answer · 2010-12-04 05:15:30Z

1

$link = mysql_connect('localhost','root','yourPassword')
mysql_select_db('database',$link);
$sql = 'SELECT id FROM user'
$result = mysql_query($sql,$link);

$row = mysql_fetch_assoc($result);
$_SESSION['id']=$row['id'];

           // put this id in session

answered Dec 4, 2010 at 5:15

Bhanu Prakash Pandey

3,7851 gold badge26 silver badges16 bronze badges

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

2 Comments

user529649 Over a year ago

Thanks Bhanu, but I am wondring what is pros and cons of this over getting every bit ever time its need from database.

Bhanu Prakash Pandey Over a year ago

you use session in other pages where you required

mikelbring · Accepted Answer · 2010-12-04 05:11:23Z

0

Just put whatever you use on every page in the session, and get the other columns when you need them. Id assume the userid and username is what you would user every page.

answered Dec 4, 2010 at 5:11

mikelbring

1,4922 gold badges14 silver badges24 bronze badges

Collectives™ on Stack Overflow

PHP/MYSQL Getting only one Column Value by ID

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related