Advertisement
Guest User

Untitled

a guest
Jun 9th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. <?
  2.  
  3. class MySQL
  4. {
  5. var $link;
  6.  
  7. function connect($server, $username, $password) {
  8. $this->link = mysql_connect($server, $username, $password);
  9. }
  10.  
  11. function selectDatabase( $name ) {
  12. mysql_select_db( $name, $this->link );
  13. }
  14.  
  15. function query( $sql ) {
  16. mysql_query( $sql, $this->link) ;
  17. }
  18.  
  19. function close() {
  20. mysql_close( $this->link );
  21. }
  22.  
  23. }
  24.  
  25. class User {
  26.  
  27. function login( $username, $password ) {
  28.  
  29. $username = mysql_real_escape_string( $username );
  30. $password = mysql_real_escape_string( md5( $password ) );
  31.  
  32. $sql = sprintf( "SELECT id FROM user WHERE name = '%s' AND password = '%s' LIMIT 1", $username, $password );
  33. $result = MySQL::query( $sql );
  34.  
  35. if( mysql_num_rows( $result ) == 1 ) {
  36. $row = mysql_fetch_assoc( $result );
  37. $_SESSION['userid'] = $row['id'];
  38.  
  39. return "Succes!";
  40. }
  41. else {
  42. return "Ingen succes!"
  43. }
  44. }
  45.  
  46. function logout() {
  47. session_destroy();
  48.  
  49. return "Du blev logget ud!";
  50. }
  51.  
  52. }
  53.  
  54. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement