Apps $response JSON return only 1 row, PHP, ANDROID

[manuelkoliqi]

When I use json_encode($response), it returns only the first row of the query, how to make it return all the rows? pls Help


main.php

$email = $_POST['email'];
$password = $_POST['password'];

// check for user
$user = $db->getUserByEmailAndPassword($email, $password);
if ($user != false ) {
    // user found
    $response["error"] = FALSE;
    $response["user"]["name"] = $user["name"];
    $response["user"]["email"] = $user["email"];
    $response["user"]["dega"] = $user["dega"];
    $response["user"]["salla"] = $user["salla"];
    $response["user"]["ora"] = $user["ora"];
    $response["user"]["lenda"] = $user["lenda"];
    $response["user"]["dita"] = $user["dita"];
    echo json_encode($response);
}

method.php

publicfunction getUserByEmailAndPassword($email, $password){
$result = mysql_query("SELECT U.name, U.email, U.password, F.dega,
O.salla, o_Ora, O.lenda, O.dita FROM users U
INNER JOIN fakulteti F on U.id = F.studenti
INNER JOIN orari O on F.id = O.fakulteti WHERE email = '$email'")ordie(mysql_error());

$no_of_rows = mysql_num_rows($result);
if($no_of_rows >0){
$result = mysql_fetch_array($result);
$encrypted_password = $result['password']
if($encrypted_password == $password){
return $result;
}
}
}

Android class and this is how I recieve a response on my android:

JSONObject user = jObj.getJSONObject("user");
String name = user.getString("name");
String email = user.getString("email");
String dega = user.getString("dega");
String salla = user.getString("salla");
String ora = user.getString("ora");
String lenda = user.getString("lenda");
String dita = user.getString("dita");

 

[Dylan Rose]

Hello, Id be happy to help you with this issue. It may be easier to discuss over skype or like platform. Please respond here or send me a message if you are interested.