mysqli_fetch_array not working properly PHP

Question

I've been told that I was using an deprecated version of PHP, mysql_query, instead of the newer version mysqli_query, and soon it will be remove. Knowing that, I quickly tried to update all of my old, deprecated codes into the newer code. Doing that, I quickly ran into a problem, but I'm not sure what I'm doing wrong. Please take a look:

<?php

$connect = mysqli_connect('server','username','password','database');
$fetch = mysqli_query($connect,"SELECT username FROM userLogin");

while($row=mysqli_fetch_array($fetch,MYSQLI_NUM)){

//do something

}

?>

output:

Warning: mysqli_fetch_array() expects parameter 2 to be long, string given in /home/a2056400/public_html/test4.php on line 8

I have a feeling the error message has something to do with the conditional statement inside the while loop, but I'm not sure what is wrong with it. Please help in any way. Thank you.

Have you read the error message? It seems to me that it clearly refers to the 2nd parameter that's being passed to mysqli_fetch_array(). In your code, the 2nd parameter is mysqli_NUM when you probably mean to use the constant MYSQLI_NUM . — Charlie Schliesser
– Charlie Schliesser, Commented May 28, 2015 at 21:01
@CharlieS I'm sorry. In the older version, you're suppose to use mysql_NUM as oppose to MYSQL_NUM, so when I switched over, I thought the same rule applies. I guess I know that it doesn't now. Thanks for your answer. — iscattered
– iscattered, Commented May 28, 2015 at 21:37

Jay Blanchard · Accepted Answer · 2015-05-28 21:32:12Z

2

You are not connecting to the database properly.

$connect = mysqli_connect('server','username','password','database');
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$fetch = mysqli_query($connect,"SELECT username FROM userLogin");
while($row=mysqli_fetch_array($fetch,MYSQLI_NUM)) {

    //do something

}

edited May 28, 2015 at 21:32

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

answered May 28, 2015 at 20:42

OllyBarca

1,5391 gold badge18 silver badges36 bronze badges

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

1 Comment

Jay Blanchard Over a year ago

Why should the OP "try this"? Please add an explanation of what you did and why you did it that way, not only for the OP but for future visitors to SO.

Collectives™ on Stack Overflow

mysqli_fetch_array not working properly PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related