|
|
Posted by Dave Nash on 12/15/06 05:58
On Fri, 15 Dec 2006 15:48:41 +1000, "Vince Morgan"
<vinhar@REMOVEoptusnet.com.au> wrote:
>"Dave Nash" <kabooby2004@yahoo.com> wrote in message
>news:42c2o2doksnuc6dr3omeu17u5gtetd97dj@4ax.com...
>> On Thu, 14 Dec 2006 13:47:02 +1000, "Vince Morgan"
>> <vinhar@REMOVEoptusnet.com.au> wrote:
>>
>> >"Dave Nash" <kabooby2004@yahoo.com> wrote in message
>> >news:09d1o2du54l5fh9813evr2htr02udsrj8l@4ax.com...
>> >> I have a login form setup. When a person logs in it verified the user
>> >> name and password and logs them in if the information is correct.
>> >> This script is called auth.php as in included in all of the pages I
>> >> want to secure.
>> >> My problem is how do I get info on that particular logged in user.
>> >> example say Welcome $fullname when the only two fields ive currently
>> >> go are u_name and p_word.
>> >> See auth script below.
>> >>
>> >> And
>> >>
>> >> How to get info from another table?
>> >>
>> >> Example SELECT * FROM messages WHERE userid = $userid ORDER by
>> >> messageid
>> >>
>> >> -------------------------------
>> >> Auth.php
>> >>
>> >> session_start();
>> >> if($_POST){
>> >> $_SESSION['u_name']=$_POST["u_name"];
>> >> $_SESSION['p_word']=$_POST["p_word"];
>> >> }
>> >> $result=mysql_query("select * from users
>> >> where u_name='" . $_SESSION['u_name'] . "' and p_word='" .
>> >> $_SESSION['p_word'] . "'");
>> >> $num=mysql_num_rows($result);
>> >> if($num < 1){
>> >> echo "show login form";
>> >> exit;
>> >> }
>> >> End auth.php
>> >> -------------------------------
>> >> Tables are as follows.
>> >> Users table.
>> >> userid
>> >> u_name
>> >> p_word
>> >> fullname
>> >> PRIMARY KEY (`userid`)
>> >
>> >The above looks like one table named "Users", with five fields.
>> >If so,
>> >"SELECT fullname FROM Users WHERE userid = '".$userid.'"';
>> >If not, I'm lost :)
>> >Vince Morgan
>>
>> But this is the problem. the auth script only retrieves the values
>> u_name and p_word.
>>
>> how do I use the select query like youve said If I cant get the value
>> $userid
>>
>> Example.
>>
>> I need to get all values from the users table that matches the $u_name
>> value used to login.
>>
>>
>>
>Do you have [userid, u_name, p_word, fullname] in one table? Or more than
>one table?
>Vince Morgan
>
here are the tables I have.
<users>
userid
u_name
password
email_address
<messages>
messageid
message
userid
<items>
itemid
itemtitle
item
userid
I would like to get info out of any of these tables based on the
userid.
Navigation:
[Reply to this message]
|