Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. // First starts a session
  2. session_start();
  3.  
  4. // Function that registers a user
  5. // This function should be called when a login is performed.
  6. // Returns true if the user was logged in, false otherwise.
  7. function registerUser($username,$password) {
  8. require "config.php";
  9. // Connect to the database and checks if the user / password
  10. // combinaison matches any existing database entry
  11. $mysql_link = mysql_connect($db_hostname,$db_username,$db_password) or die("Failed to connect to MySQL");
  12. mysql_select_db($db_database, $mysql_link) or die ("Unable to select database!");
  13. $query = "SELECT ".$db_fld_users_id." FROM ".$db_tbl_users." WHERE ".$db_fld_users_username." LIKE '".$username."' AND ".$db_fld_users_password." LIKE '".encrypt($password,$enckey)."'";
  14. // $r_query = mysql_query($query, $mysql_link);// or mysql_error() and die("Failed to execute_query");
  15. $r_query = mysql_query($query, $mysql_link) or die("Failed to execute_query");
  16. if (mysql_num_rows($r_query) != 0) {
  17. $query_row = mysql_fetch_array($r_query);
  18. writeSessionUserIds($query_row[$db_fld_users_id], $username);
  19. // Writing connection date into database
  20. writeUserLoginDate($query_row[$db_fld_users_id]);
  21. // Increasing number of connections for this user
  22. writeUserConnection($query_row[$db_fld_users_id]);
  23. return true;
  24. exit;
  25. } else {
  26. return false;
  27. exit;
  28. }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement