Fetch rows from database table android

Question

I'm trying to return the array of rows where the username matches the username in the database table. The JSON result just gives me the last row.

example table:

james 14 [email protected]

mah 12 [email protected]

james 23 [email protected]

result gives me:
23 [email protected]

but i want both james rows not just the last one. so both 14 [email protected] and 23 [email protected] thanks

My php code:

<?php 
    $username = $_POST["username"];

    $con = new mysqli("xx", "xx", "xx", "xx");


    // selects everything 
    $statement = mysqli_prepare($con, "SELECT * FROM `user` WHERE username = ?");
    mysqli_stmt_bind_param($statement, "s", $username);

    mysqli_stmt_execute($statement);
    // Store the result to use
    mysqli_stmt_store_result($statement);
    mysqli_stmt_bind_result($statement, $id, $username, $age, $email);

    // Get results returned and put in array
    $user = array();
    while (mysqli_stmt_fetch($statement)) {
        $user[age] = $age;
        $user[email] = $email;
    }

    // Send array back to phone
    print (json_encode($user));

    mysqli_stmt_close($statement);
    mysqli_close($con);

?>

Mazaka · Accepted Answer · 2015-11-21 07:02:18Z

1

You overwrite the array so try something like this

while (mysqli_stmt_fetch($statement)) {
        $user[] = array( 'age'=>$age, 'email'=>$email);
    }

answered Nov 21, 2015 at 7:02

Mazaka

6341 gold badge6 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Subin Chalil · Accepted Answer · 2015-11-21 07:02:35Z

1

user[] should be a 2 dimensional array.

In your case last element will be there in the array.

while (mysqli_stmt_fetch($statement)) {
        $user[] = array('age'=>$age,'email' =>$email);
    }

Hope this helps.

answered Nov 21, 2015 at 7:02

Subin Chalil

3,7082 gold badges31 silver badges44 bronze badges

Comments

Santosh Patel · Accepted Answer · 2015-11-21 07:06:04Z

1

Your array should be empty not like [age][email] it should be empty so that array create index.

edited Nov 21, 2015 at 7:06

answered Nov 21, 2015 at 6:57

Santosh Patel

5392 silver badges13 bronze badges

Collectives™ on Stack Overflow

Fetch rows from database table android

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related