Login php mysql

Getting Started Newbie Questions
#1

Hello!
Please I need some help.

I’m trying to create a mysql - php login system but I always get nil event.responce instead of “Login Success”!

Just a sidenote. On browser mydomain(dot)com/login.php works fine and I get Login Success message on screen.

lua code (login.lua)

 function networkListenerUL()
   if ( event.isError ) then
     print( "Network error.")
   else
     if event.response == "Login Success" then
       composer.gotoScene("menuscreen")
     else 
       local alert = native.showAlert( "Error Logging In", "There was an error logging in.", { "Try again" } )
      end
    end

function loginFunction()

   local emailV = "the_email" 
   local passwordV = "the_password"

   local credentialsV = "email="..emailV.."&psw="..passwordV                        

   local headers = {}
   headers["Content-Type"] = "application/x-www-form-urlencoded"
   headers["Accept-Language"] = "en-US"
 
   local body = credentialsV

   local params = {}
   params.headers = headers
   params.body = body

   network.request( "https://www.mydomain.com/login.php", "POST", networkListener, params )

end

php code (login.php)

<?php
$db_name = "dbname";
$username = "username";
$password = "password";
$servename = "localhost";
$conn = mysqli_connect($servename ,$username ,$password ,$db_name );
mysqli_set_charset($conn ,"utf-8");

$email = $_POST["email"];
$password = $_POST["psw"];

// for testing reasons
$email = "hello@mail.com"; 
$password = "correct_password";

$isValidEmail = filter_var($email, FILTER_VALIDATE_EMAIL);

if($conn){
   if( $isValidEmail === false){
      echo "This Email is not valid";
   }else{
      $sqlCheckEmail = "SELECT * FROM login WHERE email LIKE '$email'";
      $usernameQuery = mysqli_query($conn,$sqlCheckEmail);
      if(mysqli_num_rows($usernameQuery) > 0){
      $sqlLogin = "SELECT * FROM login WHERE email LIKE '$email' AND password LIKE '$password'";
      $loginQuery = mysqli_query($conn,$sqlLogin);

      if(mysqli_num_rows($loginQuery) > 0){
         echo "Login Success";
      }
      else{
         echo "Wrong Password";
      }
  }else{
    echo "This Email is not registered";
   }
 }
}
else{
   echo "Connection Error";
}

?>
#2

If anyone is interested the code works just fine :slight_smile:

I was calling the wrong function on the widget button!

1 Like