Advertisement
Guest User

Untitled

a guest
May 5th, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.36 KB | None | 0 0
  1. Checklogin.php looks like this. <<<<<<<
  2.  
  3. <?php
  4.  $user=$_POST["user"];
  5.  $pass=$_POST["password"];
  6.    
  7.  include("dblogin.php");
  8.  
  9.  $sql="SELECT * FROM login";
  10.  $result=mysql_query($sql);
  11.  
  12. while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  13.     }
  14. if($user==$row["username"]&&$pass==$row["password"])
  15. {
  16. }
  17. $_SESSION["userid"]=$row["id"];
  18. header ('Location: products.php');
  19.  
  20. if ($_SESSION["userid"]=="")
  21. {
  22.     header ('Location: login.php');
  23. }
  24. ?>
  25.  
  26. dblogin.php looks like this. <<<<<<<<
  27.  
  28. <?php
  29. $host="localhost"; // Host name
  30. $username="root"; // Mysql username
  31. $password=""; // Mysql password
  32. $db_name="db01"; // Database name
  33.  
  34. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  35.  
  36. mysql_select_db("$db_name")or die("cannot select DB");
  37.  
  38. session_start();
  39. ?>
  40.  
  41. products.php looks like this. <<<<<<<<
  42.  
  43. <?php
  44. include("dblogin.php");
  45. ?>
  46.  
  47. <?php
  48. if ($_SESSION["userid"]=="")
  49. {
  50.     header ('Location: login.php');
  51. }
  52.  
  53. ?>
  54.  
  55. The form in login.php looks in checklogin, checklogin looks in dblogin. Then directs to products.php if login is true.
  56.  
  57. This doesn't work using xammp, windows. Added user in phpmyadmin. Or maybe I have a mistake in phpmyadmin??? do these scripts look ok???
  58.  
  59.  
  60. Error message at login, none just keep getting directed back to login.php. So maybe these scripts or it is phpmyadmin??? Any help?? Thanks.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement