Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 5th, 2012  |  syntax: None  |  size: 0.87 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <?php
  2. $connection = mysql_connect("localhost","root","");
  3. mysql_select_db("mydb",$connection);
  4.  
  5. $sql="SELECT userid,username,admin FROM users WHERE username='$_POST[lname]' AND password='$_POST[lpass]' ";
  6. $result=mysql_query($sql);
  7.  
  8. if(mysql_num_rows($result) == 0){
  9. echo 'You have supplied a wrong user/password combination. Please try again.'; }
  10.                                        
  11.                                        
  12.                                        
  13. else{
  14. $row = mysql_fetch_assoc($result);
  15.  
  16. //$t=time();
  17. //if(isset($_POST['lchoice']) && $_POST['lchoice']=='1') $t=time()+999999 ;
  18.  
  19. setcookie("a",$row['userid'],time());
  20. echo $_COOKIE["a"];
  21. /*setcookie("userid","userid",time());$_COOKIE["userid"]=$row["userid"];
  22. setcookie("username","username",$t);$_COOKIE["username"]=$row['username'];
  23. setcookie("admin","0",$t);$_COOKIE["admin"]=$row['admin'];
  24. setcookie("signedin","yo",$t);$_COOKIE["signedin"]="yo";*/
  25. //header('location:check.php');
  26.  
  27. }?>