Class that can authenticate users with MySQL database records

Class that can authenticate users with MySQL database records

Class untuk authenticate users with MySQL database Ia akan merujuk sebuah table pangkalan data dan memastikan pengguna wujud atau tidak.


1. Page login_index.php

 <?php
require_once "login_login.php";
$login = new Login("class_senang@gmail.com","123456");
if($login){
    echo "OK";
}else{
    echo "ERROR";
}
?>


2. Page login_login.php


<?php //login_login.php class Login{ private $user; private $password; function __construct($u,$p){ /* setting the private vars */ $this->__set($this->user,$u); $this->__set($this->password,$p); /* do the login action */ $this->doLogin(); } /* Magic methods __get and __set */ function __set($var,$value){ if (property_exists($this, $var)) { /* value passed by reference */ $this->$var &= $value; } } function __get($var){ if (property_exists($this, $var)) { return $this->$var; } } /* === *** === */ private function doLogin(){ /* Connect database */ $link = mysql_connect("127.0.0.1","root","aYhs38H"); /* if Connected select database */ if($link){ /* if selected database check in database the user data */ if(mysql_select_db("booking_bus",$link)){ /* the query happens */ $query = "SELECT * FROM tbl_register where userid = '" . $this->__get($this->user) . "' and password = '" . md5($this->password) . "'"; $resultset = mysql_query($query); /* if have a row in the query the acces is granted */ if(mysql_num_rows($resultset) > 0){ /* your code to logged users here */ return true; }else{ return false; } } } } } ?>
 Oleh : Abd Rahman Sirat