MySql

mwood_2k2

Hi guys, I know this post should probably be in the newbies board but there seems to be a quicker response here, and it is to do with coding G

I am experimenting with adapting a forum and on my loguser page I have the following code that checks the mysql data based on form input..


$sql = "SELECT ID FROM " . $Table . " WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']) . "' LIMIT 1"; 

if(!($result = mysql_query($sql))) die(mysql_error());

But what I would like to do is based on the check pull off the users name and email address to be set into a cookie for use throughout the board (automatically filling in name and email address in posts etc)

Can anyone help me with the code I need to do it? I'm rubbish with mysql !!

Cheers in advance

hand

$sql = "SELECT ID, fieldname4usersname, fieldname4email FROM $Table WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']).'"; 
$result = mysql_query($sql)
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";  

if (mysql_num_rows($result) < 1) {
   print "Sorry, userid/password combination is invalid";
} else {
   while ($row = mysql_fetch_array($result)) {
      print $row['ID'] ."<br>";
	  print $row['fieldname4usersname'] ."<br>";
	  print $row['fieldname4email'] ."<br>";
   }
}

mwood_2k2

Huh?

I don't get it,

I don't want them to print I want the variables set for name and email, so I can set the cookie .... heres the full source of the page....


include("vars.php"); 

if(!($link_id = mysql_connect($Host, $User, $Pass))) die(mysql_erorr()); 
mysql_select_db($DB); 

/*This is were the actual log in takes place.  We tell mysql to select the ID where the Name is exactly like the Name from the Form where is Password is exactly like the encryption values of the password from the form.*/ 

$sql = "SELECT ID FROM " . $Table . " WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']) . "' LIMIT 1"; 
if(!($result = mysql_query($sql))) die(mysql_error()); 

/*This is were we check the result.  We check to see how many rows were in the result of the query. If there is 1 one row in the result, that means there is one username with the right information, so that would mean they are logged in.*/ 

if(mysql_num_rows($result) == 1) { 

/*Here we set a cookie that tells if the user has logged in and set it to last for a day.*/ 

setcookie("LoggedIn", TRUE, time()+(3600 * 24)); 

    echo "View the <a href=forum.php>Forum</a>."; 

} else { 

echo "Login failure"; 
}

diego25

Instead of the 3 print $row's that hand posted, you'd use setcookie() instead.

Diego

hand

Because you have to select more than only the ID I changed the select statement to

$sql = "SELECT ID, fieldname4usersname, fieldname4email FROM $Table WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']).'";

Nobody here knows the real names of the SQL fields. Therefore I wrote ...

fieldname4usersname, fieldname4email

You have to alter these names, so that they fit to your sql definitions.

And now tell me your problem. You have my print commands and your setcookie(). The solution depends on your conceptions.
One possibility is:

setcookie("LoggedIn", "ID:$row[ID] fieldname4usersname:$row[fieldname4usersname] fieldname4email:$row[fieldname4email]", time()+(3600 * 24));

But there exists a lot of other possibilities to populate the content of your cookie.

mwood_2k2

so do I just replace the sql query on the code I posted or just parts of it, I don't understand what to keep and what not to

agghhhh

Cheers in advance

hand

You have to replace the SQL Query and the setcookie() statement. But don't forget to alter the names
fieldname4usersname, fieldname4email

mwood_2k2

Ok thanks,

But that naming part wasnt what was confusing me lol, but just for arguments sake, field4username would be name, and field4usersemail, would be email anyways, a natural assumption =]

mwood_2k2

Ok, I have done the following,


<?php 

include("vars.php"); 

if(!($link_id = mysql_connect($Host, $User, $Pass))) die(mysql_erorr()); 
mysql_select_db($DB); 


$sql = "SELECT ID, fieldname4usersname, fieldname4email FROM $Table WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']).'"; 
$result = mysql_query($sql) or echo "&gt;&gt;&gt; MySQL-Error: ".mysql_error()." -&gt; ".mysql_error()."<br>\n";  

if (mysql_num_rows($result) < 1) {
   echo("Sorry, userid/password combination is invalid");

} else {

   while ($row = mysql_fetch_array($result)) {

setcookie("LoggedIn", "ID:$row[ID] Name:$row[Name] Email:$row[Email]", time()+(3600 * 24));

   }
}

 echo "View the <a href=forum.php>Forum</a>."; 

} else { 

echo "Login failure"; 
}

?>

Why am I getting a parse error, unexpected $ in loguser.php on line 31

When line 31 is the end of the php block, which is ?>

And how come the syntax colouring doesnt change after the mysql query?....I don't get it

bleeeh lol

hand

<?
include("vars.php"); 
if(!($link_id = mysql_connect($Host, $User, $Pass))) die(mysql_erorr()); 
mysql_select_db($DB); 

$sql = "SELECT ID,Name,Email FROM " . $Table . " WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']) . "' LIMIT 1"; 
if(!($result = mysql_query($sql))) die(mysql_error()); 

if(mysql_num_rows($result) == 1) {
   while ($row = mysql_fetch_array($result)) {
      setcookie("LoggedIn", "ID:$row[ID] Name:$row[Name] Email:$row[Email]", time()+(3600 * 24));
   }
   echo "View the <a href=forum.php>Forum</a>."; 
} else { 
    echo "Login failure"; 
}
?>

mwood_2k2

thanx hand!

Just one more question, how do I call on the individual variables for name etc, and can that sql query be used for other information universally? Because I'm planning on introducing profiles into my forum later on.

Cheers in advance

mwood_2k2

I'm getting undefined variable for $row too.....

hand

Insert this command at the beginning of your script:

error_reporting (E_ALL & ~E_NOTICE);

http://php3.de/manual/en/function.error-reporting.php

mwood_2k2

Thx hand, okay that last one you haven't answered yet lol....how to retrieve individual variables from the cookie?

Cheers in advance

mwood_2k2

Hand? Where are ya dude lol, anyone else that can answer my q? how do I retrieve individual variables from that cookie?

Pleaassseee??

hand

Sorry,
Cookies names can be set as array names and will be available to your PHP scripts as arrays but seperate cookies are stored on the users system. Consider explode() or serialize() to set one cookie with multiple names and values.
http://www.php3.de/manual/en/function.setcookie.php
http://www.php3.de/manual/en/function.serialize.php
and
http://www.php3.de/manual/en/function.unserialize.php

(Your location is ....... ?)

mwood_2k2

Ok, I don't get it, can you give me an example pertaining to my code?

I know your doing all the work, but I just don't understand it, if I can't understand it theres no point me using it till I do...

Sorry ... can you please provide me with code and explain how it works?

Cheers

mwood_2k2

And I dont understand how 'ID:$row[ID] Name:$row[Name] Email:$row[Email]' allows me to retrieve the variables, thats just one line of text isnt it?

mwood_2k2

I've just noticed, theres nothing for email being pulled off the Db, I changed it to 'Email' which is what the column is in my db, I don't understand....