Warning: Illegal string offset PHP Mysqli

Question

i'm trying to fetch data from mysql database using this code :

$con = mysqli_connect('localhost', 'root', '', 'nicu');
    mysqli_query($con, "set NAMES utf8");
    $query = mysqli_query($con, "select * from user");
    while($rows = mysqli_fetch_assoc($query)) :
        $rows = $rows["nicuAddress"];
        $address = $rows["nicuEmail"];
        echo "$rows<br>$address";
    endwhile;

but every time i run this code i get this warning :Warning: Illegal string offset

what changes do i have to do to fix this ?

Not sure if the cause of your error, but you are overwriting $rows on the first line of the loop. That looks wrong. — Alexander O'Mara
– Alexander O'Mara, Commented Jun 12, 2017 at 1:09

Dov Benyomin Sohacheski · Accepted Answer · 2018-01-22 10:54:01Z

2

You are trying to reaches a part of the array that was overwritten. After running $rows = $rows["nicuAddress"] you cannot access $address = $rows["nicuEmail"] as an array.

Solution

$address = $rows["nicuAddress"]; // <-- Change to address
$email = $rows["nicuEmail"]; // <-- Change to email
echo "$address<br>$email";

edited Jan 22, 2018 at 10:54

answered Jun 12, 2017 at 1:08

Dov Benyomin Sohacheski

7,8488 gold badges42 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

Warning: Illegal string offset PHP Mysqli

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related