1#@!#!123s

: / home / schoolcampuserp / erp.nationalacademykotwa.com / api / app_apiold /
Filename : authuser.php
back
<?php

class AuthUser{

    // userlogin function accepts username and email and coneection db object
    public static function userLogin($con, $username, $password){

    $sql = "SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1";
	$result = mysqli_query($con, $sql);
    return $result;

    }

    public static function userRegister($con,$name, $username, $email, $phone, $password){
   
        //  $insert = "INSERT INTO `user_info`(`username`,`name`, `email`, `phone`, `passw`, `filename`, `reff_by`, `reff_code`, `wallet`, `date_created`, `register_status`) 
        //  VALUES('$username','$name', '$email', '$phone', '$password','file', 'old_user', 'RANDOM', '0000', current_timestamp(), 'active')";
            $insert ="INSERT INTO `users` (`email`, `username`, `name`, `phone`, `address`, `passw`, `image`, `reff_by`, `reff_code`, `wallet`, `date_created`, `register_status`)
            VALUES('$email', '$username', '$name', '$phone', ' ', '$password', ' ', 'old_user', 'RANDOM', '0', CURRENT_TIMESTAMP, 'active')";
			$query = mysqli_query($con, $insert);
        return $query;

    }
    

}

?>