Php empty result after execution

Question

    <?php
require_once 'init.php';

if(isset($_POST['username'], $_POST['password'])) {

$extractInfoUser = $db->prepare("
    SELECT * FROM user
    WHERE username = :username
");

$extractInfoUser->execute([
    'username' => $_POST['username']
]);

$users = $extractInfoUser->rowCount() ? $extractInfoUser : [] ;

foreach ($users as $user) {
    if ($user['username'] = null) {
        die("There is no username like this !");
        } else {
            echo "You are not able to register under this username !";
        }
    }
}
?>

The problem is that I get as result nothing ! Please help cuz I can't find this error ! I have no idea what it can be !

First of all check this: http://stackoverflow.com/questions/845021/how-to-get-useful-error-messages-in-php — Mark, Jan 13 '15 at 19:14

score 3 · Answer 1 · answered Jan 13 '15 at 19:13

3

Your IF statement is wrong, you're setting instead of checking.

if ($user['username'] = null) {

While you should do:

if ($user['username'] == null) {

You forgot to put double = operator, instead of checking you were setting $user['username'] to false.

answered Jan 13 '15 at 19:13

@DenisDumitras Do a echo after the `foreach` header and look if you even enter the foreach loop – Rizier123 Jan 13 '15 at 19:22
@Rizier123 I can't even echo sth ! – Denis Dumitras Jan 13 '15 at 19:28
@DenisDumitras Do a echo after the first if statement, i think you don't even enter this – Rizier123 Jan 13 '15 at 19:28
After first statement I can echo $_POST['username'] for example ! – Denis Dumitras Jan 13 '15 at 19:30
@DenisDumitras Then print this: `echo $extractInfoUser->rowCount();` I think this is 0 and you get an empty array – Rizier123 Jan 13 '15 at 19:32
@DenisDumitras There you go! Either your query/connection fails or you just have no entries in your db – Rizier123 Jan 13 '15 at 19:36
@Rizier123 Thanks now I understood the error I'll try to fix it ! – Denis Dumitras Jan 13 '15 at 19:40

score 2 · Accepted Answer · answered Jan 13 '15 at 19:14

2

You did an assignment instead of a comparison so change this if statement:

if ($user['username'] = null)

to this:

if ($user['username'] == null)
                    //^^ See here 2x '='

answered Jan 13 '15 at 19:14

Rizier123

58,877
16
101
156

Php empty result after execution

2 Answers2