current session user values in mysql

Question

i need the current session user values in mysql pls send me the query

venkatesan srinivasan · Answer

thank u very much

Suraj Sahoo · Answer

HelloCheck this link I hope this helps: http://www.sitepoint.com/users-php-sessions-mysql/ http://stackoverflow.com/questions/17075424/get-the-data-of-specific-user-in-php Accept if helps. Thanks

venkatesan srinivasan · Answer

using php

Francis · Answer

Hope that you are using C#. 1. Hope that you can capture the user name from the text box. Then You can store it session like below: Session[UserName]= txtUserName.Text; 2. Hope that you are using label like control to display the user name. string strUserName = Convert.ToString(Session[txt]); lbl.Text=strUserName; 3.Try the below code to retrieve the info. Here i have used SQL based connection object you should substitute MySQL based connection objects. using (SqlConnection con = new SqlConnection(YourConnectionString)) { SqlCommand cmd = new SqlCommand(String.Concat(Select nousernameexp1exp2exp3total from YourTableName where username='strUserName' ); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt= new DataTable(); da.Fill(dt); } If you have any clarification let me know.

venkatesan srinivasan · Answer

i m a beginner 1. i m log in one user name for eg(emp1) 2.i need the session name to display 3. i extract the data from my sql from the current session user my db fildes (nousernameexp1exp2exp3total)

Francis · Answer

Can you give your problem with little more detail? where you have stored the session variable?

venkatesan srinivasan · Answer

thank u suraj but i need a query for how to extract the data for current session user

Suraj Sahoo · Answer

Hello Venkatesh Please follow the below links. They will surely help you http://stackoverflow.com/questions/5818917/is-it-possible-to-a-create-session-variable-in-javascript http://www.codeproject.com/Articles/633199/Using-MySQL-Session-State-Provider-for-ASP-NET Thanks Accept if this helps anyway.