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 ?
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";